Skip to content
ToolsLLM ready file

GA4 + GSC SEO Analysis Prompts

AI For Newsroom

A practical prompt library for using an LLM with Google Analytics 4 (GA4) and Google Search Console (GSC) data to identify the best and worst-performing articles, uncover patterns, find opportunities, and build an SEO improvement roadmap.

Published Sep 16, 2026

GA4 + GSC SEO Analysis Prompts

A practical prompt library for using an LLM with Google Analytics 4 (GA4) and Google Search Console (GSC) data to identify the best and worst-performing articles, uncover patterns, find opportunities, and build an SEO improvement roadmap.

Recommended Data

GA4

Ideally provide:

  • Landing Page
  • Users
  • Sessions
  • Engaged Sessions
  • Engagement Rate
  • Average Engagement Time
  • Conversions
  • Revenue (if applicable)

Google Search Console

Ideally provide:

  • Page
  • Query
  • Clicks
  • Impressions
  • CTR
  • Average Position

A 90–180 day period is generally useful for identifying meaningful patterns.


1. Master Prompt — SEO Content Analyst

You are an expert SEO strategist with 15 years of experience.

I'll provide exports from:

• Google Analytics 4
• Google Search Console

Your job is NOT to summarize the data.

Your job is to identify:

1. Best-performing articles
2. Worst-performing articles
3. Hidden opportunities
4. Common success patterns
5. Common failure patterns
6. Pages that can grow quickly
7. Pages that should be merged or removed

For every insight:

• Explain WHY
• Show supporting metrics
• Estimate impact
• Suggest exactly what to change

Avoid generic SEO advice.

Only make recommendations supported by the data.

Always prioritize actions by expected traffic gain.

2. Find the Best Articles

Analyze every article.

Rank the top 20 pages based on:

• Organic clicks
• Organic impressions
• CTR
• Average position
• Engagement rate
• Engaged sessions
• Average engagement time
• Conversions (if available)

For each page explain:

Why it performs well.

Identify:

• search intent
• title quality
• ranking strength
• topic depth
• keyword breadth
• traffic consistency

Then identify common characteristics shared among the best-performing pages.

3. Find the Worst Articles

Find the 20 weakest pages.

Ignore pages with very little age.

Instead identify pages that should be performing much better.

Look for:

• High impressions
• Low CTR

or

• Good rankings
• Poor engagement

or

• High bounce
• Low conversions

For every page explain:

• why it is underperforming
• what is likely wrong
• priority score (1-10)
• estimated traffic upside

Recommend specific fixes.

4. Find Quick Wins

Identify pages with the biggest upside.

Specifically look for pages that:

• Rank positions 5-20
• Have high impressions
• Have low CTR
• Have strong engagement

These pages are likely close to page one dominance.

Rank opportunities by estimated additional monthly clicks.

Suggest:

• title rewrite
• meta description
• FAQ additions
• internal linking
• schema
• content expansion
• keyword additions

5. Find CTR Problems

Identify pages where CTR is significantly below average for their ranking.

Compare expected CTR against actual CTR.

Explain possible causes such as:

• weak title
• poor meta description
• search intent mismatch
• SERP competition

Write three improved titles for every page.

6. Find Ranking Opportunities

Analyze keyword rankings.

Find:

• keywords ranking 8-20
• pages ranking for many keywords without strong clicks

Recommend:

• additional sections
• semantic keywords
• FAQs
• supporting content

Estimate expected ranking improvement.

7. Content Pattern Analysis

Study all successful articles.

Identify patterns including:

• average word count
• topic type
• search intent
• title structure
• H2 usage
• question usage
• lists
• tables
• images
• internal links
• freshness

Determine which characteristics most strongly correlate with:

• high clicks
• high engagement
• high conversions

Create a checklist that future articles should follow.

8. Content Decay Detection

Compare historical GSC performance.

Identify pages losing:

• clicks
• rankings
• CTR
• impressions

Determine whether decline is caused by:

• competitors
• content freshness
• search intent changes
• seasonality
• technical issues

Recommend recovery actions ranked by impact.

9. Internal Linking Opportunities

Analyze all URLs.

Identify:

• related topics
• orphan pages
• pages with high authority
• pages needing authority

Recommend:

• internal links
• anchor text
• link placement
• hub pages
• content clusters

10. Content Gap Analysis

Compare high-performing pages with low-performing pages.

Identify missing:

• headings
• entities
• keywords
• questions
• topics
• examples
• media
• statistics

Generate a prioritized content gap report.

11. Build an Editorial Roadmap

Using all available GA4 and GSC data:

Prioritize the next 50 content improvements.

For each recommendation provide:

• Page
• Reason
• Expected impact
• Estimated effort
• Priority score
• Traffic gain estimate

Sort by ROI.

12. Discover What Makes Articles Win

You are a data scientist specializing in SEO.

Using all available metrics, determine which characteristics most strongly predict high-performing articles.

Look for relationships between:

• CTR
• Position
• Impressions
• Word count
• Title length
• Topic category
• Publishing date
• Update frequency
• Internal links
• Backlinks (if available)
• Engagement rate
• Average engagement time
• Conversions
• Scroll depth (if available)

Do not assume correlations.

Explain:

• strongest positive patterns
• strongest negative patterns
• surprising findings
• actionable rules for future content

End with:

"The 10 rules every future article should follow."

13. Weekly SEO Executive Report

Act as an SEO director.

Review this week's GA4 and GSC exports.

Produce an executive report containing:

## Wins

• Largest traffic gains
• Largest ranking gains
• Highest CTR improvements
• Best new content

## Losses

• Traffic declines
• CTR declines
• Ranking losses
• Content decay

## Opportunities

• Top 10 pages to improve
• Top 10 keywords to target
• Pages needing title updates
• Pages needing more content
• Pages needing internal links

## Action Plan

• High impact
• Medium impact
• Low impact

Estimate total traffic gain if all recommendations are implemented.

Suggested Analysis Workflow

For the strongest results, run the prompts in this order:

  1. Master Prompt — establish the overall picture.
  2. Find the Best Articles — identify success patterns.
  3. Find the Worst Articles — identify problems.
  4. Find Quick Wins — locate pages with near-term upside.
  5. Find CTR Problems — identify SERP snippet opportunities.
  6. Find Ranking Opportunities — identify keywords close to stronger rankings.
  7. Content Pattern Analysis — discover what successful content has in common.
  8. Content Decay Detection — find previously successful content losing momentum.
  9. Internal Linking Opportunities — improve the site's internal authority flow.
  10. Content Gap Analysis — identify missing coverage.
  11. Discover What Makes Articles Win — turn observations into repeatable rules.
  12. Build an Editorial Roadmap — convert findings into prioritized work.
  13. Weekly SEO Executive Report — monitor progress over time.

Important Instructions for the LLM

Use these rules when analyzing the data:

  • Do not invent metrics that are not provided.
  • Clearly distinguish measured data from hypotheses.
  • Do not treat correlation as causation.
  • Account for sample size when comparing pages.
  • Separate brand queries from non-brand queries when possible.
  • Account for seasonality when historical data is available.
  • Consider page age before judging newly published content.
  • Avoid judging pages solely by traffic volume.
  • Consider clicks, impressions, CTR, rankings, engagement, and conversions together.
  • Flag data-quality issues before drawing conclusions.
  • When estimating traffic upside, show the assumptions behind the estimate.
  • Prioritize recommendations by potential impact relative to effort.
  • Give specific recommendations rather than generic SEO advice.

Ideal Output Format

For major analyses, use this structure:

Executive Summary

3–7 most important findings.

Best Opportunities

| Page | Evidence | Problem/Opportunity | Recommended Action | Estimated Impact | |---|---|---|---|---|

Biggest Problems

| Page | Evidence | Likely Cause | Recommended Action | Estimated Impact | |---|---|---|---|---|

Patterns

What successful articles have in common

  • Pattern
  • Evidence
  • How to replicate it

What underperforming articles have in common

  • Pattern
  • Evidence
  • How to fix it

Action Plan

This Week

Highest-impact, lowest-effort actions.

This Month

Larger content and optimization projects.

Later

Lower-priority opportunities.

Measurement Plan

Define the metrics that should be monitored after implementing the recommendations.