Back to prompts
✦ClaudeResearch
GSC content gap analysis (Opus 5.5)
Turns two Google Search Console exports into a prioritized content gap and quick-win plan using only your data.
Loading the original X post…
Open original on XTurns two Google Search Console exports into a prioritized content gap and quick-win plan using only your data.
The prompt
✦Claude Opus 5.5
| 1 | You're an SEO strategist doing a content gap analysis. I've uploaded two Google Search Console exports from the last 3 months: |
| 2 | - Queries.csv (search queries with clicks, impressions, CTR, position) |
| 3 | - Pages.csv (my URLs with clicks, impressions, CTR, position) |
| 4 | |
| 5 | Note: these files aren't linked, so match queries to pages by comparing query topics to URL slugs and page themes. Tell me when a match is a guess. |
| 6 | |
| 7 | Find: |
| 8 | |
| 9 | 1. Missing content: queries with meaningful impressions where no page on my site clearly targets that topic. Group related queries into topic clusters. |
| 10 | 2. Striking distance: queries ranking in positions 8–20 with solid impressions, where a better or more focused page could reach the top 5. |
| 11 | 3. Underperforming visibility: queries or pages with high impressions but CTR well below what their position should get. Suggest why (title mismatch, wrong intent, weak snippet). |
| 12 | 4. Question and comparison queries (how, what, best, vs, alternatives) that deserve a dedicated answer-style page. These are also the ones most likely to get cited in AI search. |
| 13 | |
| 14 | Ignore branded queries and anything with fewer than 10 impressions. |
| 15 | |
| 16 | Output: |
| 17 | - A prioritized table: Topic/Query cluster | Total impressions | Avg position | Gap type | Recommended action (new page / update existing URL / rewrite title) | Priority (High/Med/Low) |
| 18 | - Top 5 content pieces to create first, each with a suggested title, target queries, and one line on search intent |
| 19 | - Top 5 quick wins on existing pages |
| 20 | |
| 21 | Use only numbers from my files. Don't invent search volumes or keywords that aren't in the data. |
What this prompt is good for
Visual direction
Moodboards, style guides, and design briefs
Marketing creative
Hero artwork and high-converting visual assets
Brand identity
Consistent aesthetics across typography and form
Rapid prototyping
Iterate variations in seconds with precision
