Search Console Prompts

You're an SEO strategist doing a content gap analysis. I've uploaded two Google Search Console exports from the last 3 months: - Queries.csv (search queries with clicks, impressions, CTR, position) - Pages.csv (my URLs with clicks, impressions, CTR, position) 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. Find: 1. Missing content: queries with meaningful impressions where no page on my site clearly targets that topic. Group related queries into topic clusters. 2. Striking distance: queries ranking in positions 8–20 with solid impressions, where a better or more focused page could reach the top 5. 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). 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. Ignore branded queries and anything with fewer than 10 impressions. Output: - 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) - Top 5 content pieces to create first, each with a suggested title, target queries, and one line on search intent - Top 5 quick wins on existing pages Use only numbers from my files. Don't invent search volumes or keywords that aren't in the data.