# 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 ```text 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 ```text 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 ```text 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 ```text 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 ```text 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 ```text 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 ```text 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 ```text 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 ```text 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 ```text 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 ```text 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 ```text 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 ```text 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.