Marketing AnalystSEO and Content Analytics4 promptsBeginner → Advanced4 single promptsFree to use

SEO and Content Analytics AI Prompts

4 Marketing Analyst prompts in SEO and Content Analytics. Copy ready-to-use templates and run them in your AI workflow. Covers beginner → advanced levels and 4 single prompts.

AI prompts in SEO and Content Analytics

4 prompts
AdvancedSingle prompt
01

Content Calendar Data Strategy

Build a data-driven content calendar strategy for the next quarter. Business goals: {{goals}} Current content performance data: {{performance_data}} Keyword research: {{keyword_...

Prompt text
Build a data-driven content calendar strategy for the next quarter. Business goals: {{goals}} Current content performance data: {{performance_data}} Keyword research: {{keyword_data}} Budget and capacity: {{capacity}} content pieces per month 1. Content audit and baseline: - Total content inventory: how many pieces exist? - Distribution by type: blog, video, infographic, case study, guide, etc. - Performance distribution: top 20% of content drives what % of traffic? - Underperformers: content with < 100 organic sessions per month despite 90+ days live 2. Opportunity prioritization matrix: Score each content opportunity on: - Search volume: how many monthly searches for the target keyword? - Keyword difficulty: how competitive is ranking for this keyword? - Business relevance: how closely does this keyword relate to our product/service? - Content gap: is there a piece already ranking well for this? (Avoid cannibalization) Priority score = (Search Volume x Business Relevance) / Keyword Difficulty 3. Content type strategy: Based on funnel stage goals: - Awareness (top of funnel): educational blog posts, infographics, videos - Consideration (middle): comparison guides, case studies, how-tos, webinars - Decision (bottom): testimonials, ROI calculators, free trials, demos What % of capacity should go to each stage? 4. Content calendar structure: - Month 1: focus on top 3 quick-win keyword opportunities - Month 2: focus on top 3 competitor gap opportunities - Month 3: focus on top 3 brand / thought leadership pieces For each piece: keyword target, content type, author, publish date, promotion plan 5. Distribution plan per piece: - SEO: internal linking to new content from existing high-traffic pages - Email: segment of subscribers most relevant to each topic - Social: platform and format most appropriate for each content type - Paid amplification: boost pieces with high conversion potential 6. Measurement plan: - 30-day: social shares, initial traffic - 90-day: organic ranking position, organic traffic - 180-day: conversions attributed, backlinks earned Return: content audit summary, priority scoring table, type strategy, quarterly calendar, distribution plan, and measurement framework.
IntermediateSingle prompt
02

Content Performance Analysis

Analyze the performance of content assets and identify the content strategy that drives the most business value. Content data: {{content_data}} (URL, traffic, engagement, conver...

Prompt text
Analyze the performance of content assets and identify the content strategy that drives the most business value. Content data: {{content_data}} (URL, traffic, engagement, conversions, publication date, content type) Business goals: {{goals}} (lead generation, organic traffic, brand awareness) 1. Content performance metrics: For each content piece: - Organic sessions (and YoY trend) - Average time on page - Bounce rate - Conversion rate to {{goal_action}} (CTA click, form submit, sign-up) - Backlinks acquired - Social shares 2. Content ROI: - Organic traffic value: (monthly organic sessions) x (CPC equivalent for those keywords) - Conversion value: conversions x average order value or LTV - Cost to produce: estimated hours x fully-loaded cost per hour - Content ROI = (traffic value + conversion value - production cost) / production cost 3. Content categorization analysis: Group content by type (how-to, comparison, case study, thought leadership, etc.): - Which content type drives the most traffic? - Which content type has the highest conversion rate? - Which content type earns the most backlinks? - Recommendation: what type to produce more of? 4. Content decay analysis: - For posts older than 12 months: is traffic growing, stable, or declining? - High-traffic posts with declining trend: prioritize for refresh - Low-traffic posts despite strong keyword intent: SEO or content quality issue 5. Content gap analysis: - Which target keywords have no content? - Which content pieces rank for keywords outside their intended topic? (Keyword cannibalization risk) 6. Top 10 content pieces to invest in: - Ranked by: potential traffic uplift if refreshed or expanded - Each with: current status, recommended action, and expected traffic gain Return: content performance table, content ROI estimates, type analysis, decay list, gap analysis, and top 10 investment priorities.
IntermediateSingle prompt
03

Keyword Opportunity Analysis

Identify and prioritize keyword opportunities for organic growth. Current keyword rankings: {{current_rankings}} Keyword research data: {{keyword_research}} (from Semrush, Ahref...

Prompt text
Identify and prioritize keyword opportunities for organic growth. Current keyword rankings: {{current_rankings}} Keyword research data: {{keyword_research}} (from Semrush, Ahrefs, or similar) Competitor domains: {{competitors}} Business focus: {{business_focus}} 1. Keyword opportunity matrix: Segment all target keywords by: - Current position: ranking (1-3), ranking (4-10), ranking (11-20), not ranking - Search volume: high (> 1000/month), medium (100-1000), low (< 100) - Keyword difficulty: easy (< 30), medium (30-60), hard (> 60) - Business relevance: core (direct product/service match), adjacent (related problem), awareness (broad topic) 2. Quick win keywords: - Currently ranking 4-10 for high-volume, high-relevance keywords - Small position improvements (e.g. from 7 to 3) can double traffic - For each: current page, specific optimization needed, expected traffic gain from top-3 3. Competitor gap analysis: - Keywords where competitors rank in top 10 but we have no content - Filter by: high volume + medium difficulty + high business relevance - These are the highest-priority new content creation opportunities 4. Long-tail keyword clusters: - Group related keywords by topic cluster (not just individual keywords) - A single piece of comprehensive content can rank for multiple related long-tail terms - Identify the 5 most valuable topic clusters we are not yet covering 5. Search intent classification: For the top 50 opportunity keywords, classify intent: - Informational: user wants to learn (blog, guide content) - Commercial investigation: user is comparing options (comparison, review content) - Transactional: user is ready to buy (product page, landing page) - Match content type to search intent: mismatched content will not rank 6. Prioritized keyword roadmap: Quarter 1: quick wins (optimize existing content for 4-10 position keywords) Quarter 2: new content for the top 5 competitor gap opportunities Quarter 3: build topic authority clusters for the highest-value themes Return: keyword opportunity matrix, quick win list, competitor gap analysis, topic clusters, and quarterly roadmap.
BeginnerSingle prompt
04

SEO Performance Audit

Conduct a data-driven SEO performance audit for {{website}}. Search Console data: {{search_console_data}} GA4 data: {{ga4_data}} Audit period: {{period}} 1. Overall organic perf...

Prompt text
Conduct a data-driven SEO performance audit for {{website}}. Search Console data: {{search_console_data}} GA4 data: {{ga4_data}} Audit period: {{period}} 1. Overall organic performance: - Total organic sessions: trend over {{period}} - Total impressions, clicks, average CTR, average position (from Search Console) - YoY change in organic sessions - Organic share of total traffic mix 2. Top pages analysis: - Top 20 pages by organic sessions - For each: impressions, clicks, CTR, average position - Pages with high impressions but low CTR (< 2%): title/meta description optimization opportunity - Pages with good CTR but low position (4-10): close to page 1, worth optimizing content - Pages with declining sessions YoY: potential ranking drops or content decay 3. Keyword analysis: - Top 50 keywords by clicks - Keyword categorization: branded vs non-branded - Non-branded keyword performance: positions 1-3, 4-10, 11-20 - Keyword opportunities: high impression, low click keywords (position 4-10) = quick win optimization targets 4. Technical SEO signals: - Core Web Vitals: LCP, FID/INP, CLS from Search Console - Mobile vs desktop impressions and CTR comparison - Index coverage: excluded pages and their reasons - Any manual actions or security issues flagged 5. Content decay identification: - Pages where organic traffic has declined > 20% YoY - Likely causes: algorithm update, increased competition, outdated content - Priority for content refresh based on traffic loss volume 6. Opportunity matrix: - Quick wins (1-4 weeks): CTR optimization, internal linking, title tag updates - Medium term (1-3 months): content expansion for position 4-10 keywords - Long term (3-12 months): new content creation for strategic keyword gaps Return: performance summary, top page and keyword analysis, technical issues, content decay list, and opportunity matrix.

Recommended SEO and Content Analytics workflow

1

Content Calendar Data Strategy

Start with a focused prompt in SEO and Content Analytics so you establish the first reliable signal before doing broader work.

Jump to this prompt
2

Content Performance Analysis

Review the output and identify what needs follow-up, cleanup, explanation, or deeper analysis.

Jump to this prompt
3

Keyword Opportunity Analysis

Continue with the next prompt in the category to turn the result into a more complete workflow.

Jump to this prompt
4

SEO Performance Audit

When the category has done its job, move into the next adjacent category or role-specific workflow.

Jump to this prompt

Frequently asked questions

What is seo and content analytics in marketing analyst work?+

SEO and Content Analytics is a practical workflow area inside the Marketing Analyst prompt library. It groups prompts that solve closely related tasks instead of leaving users to search through one flat list.

Which prompt should I start with?+

Start with the most general prompt in the list, then move toward the more specific or advanced prompts once you have initial output.

What is the difference between a prompt and a chain?+

A single prompt gives you one instruction and one output. A chain is a multi-step sequence designed to build on earlier results and produce a more complete workflow.

Can I use these prompts outside MLJAR Studio?+

Yes. They work in other AI tools too. MLJAR Studio is still the best fit when you want local execution, visible code, and notebook-based reproducibility.

Where should I go next after this category?+

Good next stops are Campaign Analytics, Attribution, Audience Segmentation depending on what the current output reveals.

Explore other AI prompt roles

🧱
Analytics Engineer (dbt)
20 prompts
Browse Analytics Engineer (dbt) prompts
💼
Business Analyst
50 prompts
Browse Business Analyst prompts
🧩
Citizen Data Scientist
24 prompts
Browse Citizen Data Scientist prompts
☁️
Cloud Data Engineer
20 prompts
Browse Cloud Data Engineer prompts
🛡️
Compliance & Privacy Analyst
12 prompts
Browse Compliance & Privacy Analyst prompts
📊
Data Analyst
72 prompts
Browse Data Analyst prompts
🏗️
Data Engineer
35 prompts
Browse Data Engineer prompts
🧠
Data Scientist
50 prompts
Browse Data Scientist prompts
📈
Data Visualization Specialist
23 prompts
Browse Data Visualization Specialist prompts
🗃️
Database Engineer
18 prompts
Browse Database Engineer prompts
🔧
DataOps Engineer
16 prompts
Browse DataOps Engineer prompts
🛒
Ecommerce Analyst
20 prompts
Browse Ecommerce Analyst prompts
💹
Financial Analyst
22 prompts
Browse Financial Analyst prompts
🩺
Healthcare Data Analyst
25 prompts
Browse Healthcare Data Analyst prompts
🤖
LLM Engineer
20 prompts
Browse LLM Engineer prompts
🤖
ML Engineer
42 prompts
Browse ML Engineer prompts
⚙️
MLOps
35 prompts
Browse MLOps prompts
🧭
Product Analyst
16 prompts
Browse Product Analyst prompts
🧪
Prompt Engineer
18 prompts
Browse Prompt Engineer prompts
🧪
Prompts Engineer
18 prompts
Browse Prompts Engineer prompts
📉
Quantitative Analyst
27 prompts
Browse Quantitative Analyst prompts
🔬
Research Scientist
32 prompts
Browse Research Scientist prompts
🧮
SQL Developer
16 prompts
Browse SQL Developer prompts
📐
Statistician
17 prompts
Browse Statistician prompts