Act as a senior SEO strategist, Google Search Console analyst, topical authority planner, and content gap researcher.
I am uploading my Google Search Console data for the last 3 months. Your job is to analyze queries, pages, clicks, impressions, CTR, and average position to find content opportunities where my website is already getting signals, but I have not created enough supporting articles, related articles, subtopic pages, or topical coverage.
Do not give generic SEO advice. Work only from the GSC data first, then use your SEO understanding to suggest missing content opportunities.
My goal:
Find which queries need new articles, supporting articles, related topic coverage, or content expansion so I can build stronger topical authority and capture more rankings.
Analyze the data in this order:
- Query Opportunity Analysis
Find queries that have:
- High impressions but low clicks
- Good average position but low CTR
- Position between 4 to 20 where improvement is possible
- Informational intent signals
- Long-tail query patterns
- Repeated subtopics appearing across multiple queries
- Queries that suggest users need more detailed answers
- Queries where my current page may not fully satisfy the intent
For each query, explain:
- Why this query is an opportunity
- Whether I should create a new article or update an existing page
- What user intent is behind this query
- What type of content is needed: guide, comparison, listicle, FAQ, tutorial, review, data page, checklist, case study, or glossary page
- Missing Related Articles
For every important query cluster, identify related articles that should exist on my site but are missing.
Example:
If the query is “best microphone for YouTube under 5000”, then find related article ideas like:
- Best USB microphone for YouTube beginners
- Best microphone for noisy room recording
- Condenser vs dynamic mic for YouTube
- Best microphone setup for small creators
- How to reduce background noise while recording YouTube videos
For each missing article idea, provide:
- Suggested article title
- Primary keyword
- Secondary keywords
- Search intent
- Why this article is needed
- Which existing query/page from GSC triggered this idea
- Priority: High / Medium / Low
- Whether it supports an existing ranking page or should become a standalone page
- Topic Cluster Creation
Group all opportunities into topic clusters.
For each cluster, give:
- Main pillar topic
- Supporting article ideas
- Queries from GSC connected to this cluster
- Existing page URL if available
- Missing subtopics
- Internal linking plan
- Suggested anchor texts
- Priority order for publishing
- Content Gap From Query Intent
Check if my current ranking page is likely incomplete based on the queries it is receiving.
For each page, tell me:
- What the page is currently ranking for
- What extra topics users are asking through GSC queries
- Which sections should be added to the existing page
- Which queries deserve separate articles
- Which queries should only be added as FAQ sections
- Which queries suggest comparison tables, examples, pros/cons, images, or calculators
- Competitor Research Guidance
For each high-priority article idea, tell me what I should check in competitors.
Give me a competitor research checklist:
- What headings competitors are using
- What examples they include
- What entities/products/tools/brands they mention
- What questions they answer
- What proof, data, screenshots, tables, or tests they show
- What is missing in their content that I can do better
- What unique evidence I should add so my page becomes more useful and citable
Do not invent competitor facts unless you actually have browsing access. If browsing is not available, give me a clear competitor research framework and tell me exactly what to check manually.
- Recommended Article Structure
For every high-priority new article, create a proper structure.
Include:
- SEO title
- H1
- Intro angle
- H2/H3 outline
- FAQ section
- Comparison table ideas if needed
- Examples needed
- Images or screenshots needed
- Schema recommendation
- Internal links to add
- CTA recommendation
- E-E-A-T elements to add
- Unique information that will make this article better than normal AI content
- Priority Score
Give every opportunity a score out of 100 based on:
- Impressions
- Current position
- CTR gap
- Business value
- Topical authority value
- Ease of ranking
- Whether it supports an existing page
- Whether it can bring affiliate clicks/leads/conversions
Create a table with:
Query / Topic
Current URL
Clicks
Impressions
CTR
Average Position
Opportunity Type
New Article or Update Existing Page
Suggested Article Title
Priority Score
Reason
Next Action
- Final Action Plan
At the end, give me a 30-day content execution plan.
Divide it like this:
Week 1: Highest priority updates to existing pages
Week 2: New supporting articles
Week 3: Internal linking and FAQ expansion
Week 4: Competitor gap improvement and content refresh
Important rules:
- Do not give generic advice.
- Use my GSC data as the main source.
- Think like a senior SEO strategist.
- Focus on actual article opportunities.
- Clearly separate “new article needed” and “existing article update needed”.
- Avoid keyword stuffing.
- Prioritize topics that can increase clicks, topical authority, and conversions.
- Give practical output that my content writer can directly use.
- If data is missing, mention what extra data is needed instead of guessing.
