Turn Search Console Page-2 Queries into a Prioritized Striking-Distance Fix List
Paste a Search Console export and get every page-2 query scored by position, impressions and CTR gap, plus one concrete on-page fix per URL and the top 5 to ship first.
You getScored table, top 5 fixes to ship first and cannibalization flags
Prompt
You are an SEO analyst who works daily in Google Search Console data. I will paste a Search Console export (query, page, clicks, impressions, CTR, average position) right after this prompt. Turn it into a prioritized striking-distance action list.
Rules:
1. Keep only queries with average position 8 to 20 and at least 100 impressions. State how many rows you dropped and why.
2. Score each query out of 30 using three sub-scores of 0-10: position (closer to 8 scores higher), impressions (relative to the rest of the list), and CTR gap versus a typical CTR for that position. Show all three sub-scores.
3. Group queries by URL and give each URL exactly one on-page action, written concretely (for example, add an H2 with the exact query wording and a 60-word answer below it). Never write vague advice like improve content.
4. Flag cannibalization when two URLs rank for the same or near-identical query.
5. Use only the data I paste. Do not invent search volumes, competitors or traffic forecasts.
Output format:
1. Scored table: Query | URL | Position | Impressions | CTR | Pos/Impr/CTR-gap | Total
2. Top 5 fixes to ship first: URL, action, queries targeted, reason for its rank
3. Cannibalization flags
4. Watch list: queries to recheck in 28 days
End with one line on data limits, such as averaged positions, the date range and that CTR benchmarks are estimates.Example output
Tips and common edits
Why this works
- Hard filters (position 8-20, 100+ impressions) cut noise so only queries that can realistically reach page one get attention.
- Showing three sub-scores makes the ranking auditable, so you can see whether a query ranks high for volume or for a CTR problem.
- One concrete action per URL with the exact query wording stops vague advice and gives you a fix you can ship in an afternoon.
Use after exporting the Queries and Pages report from Search Console (last 28 or 90 days). Paste the rows into ChatGPT, Claude or Gemini right after the prompt; 50-500 rows works best.
Common edits
- Widen the range to positions 5-30 or lower the impression floor to 50 for smaller sites.
- Ask for the top 10 fixes instead of 5, or add a column estimating effort as low, medium or high.
Make it repeatable
Keep using this prompt without pasting it in every time.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Find the Search Intent Mismatch Between Your Page and Its Target Query
Compares the format, angle and depth of the top search results with your page, gives a match verdict, and lists the exact heading, format and intro changes needed.
Mine search query exports to uncover high-intent FAQ gaps
Filter Search Console exports down to user question queries, group them by intent, and identify unaddressed topics to add to your site.
Clean up messy URL slugs before site launch
Turn auto-generated, cluttered URL paths into clean, search-friendly slugs. Use this before launching new pages or publishing blog posts.
Score page copy for E-E-A-T gaps
Evaluate your article against search quality guidelines to locate weak trust markers, missing evidence, and thin experience signals.
Turn comparison search intent into buyer tables
Turn comparison notes into a structured table that answers buyer intent at a glance. Use it for vs pages and review guides.
Turn People Also Ask questions into snippets
Draft concise, snippet-ready answers to target People Also Ask questions and earn position-zero real estate.
- Audit a Competitor Article and Build a Section-by-Section Outrank Brief
- Rewrite an E-commerce Product Description Around Buyer Search Intent
- Write SEO Category Page Intro and Buying Guide Copy for a Store Collection
- Find Keyword Cannibalization in Your URL and Ranking Data with Fix Actions
- Plan Internal Links Between Your Pages with Exact Anchor Text and Placement
- Write a Product or Service Page That Ranks and Converts Buyers