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:
- Master Prompt — establish the overall picture.
- Find the Best Articles — identify success patterns.
- Find the Worst Articles — identify problems.
- Find Quick Wins — locate pages with near-term upside.
- Find CTR Problems — identify SERP snippet opportunities.
- Find Ranking Opportunities — identify keywords close to stronger rankings.
- Content Pattern Analysis — discover what successful content has in common.
- Content Decay Detection — find previously successful content losing momentum.
- Internal Linking Opportunities — improve the site's internal authority flow.
- Content Gap Analysis — identify missing coverage.
- Discover What Makes Articles Win — turn observations into repeatable rules.
- Build an Editorial Roadmap — convert findings into prioritized work.
- 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.