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

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

At a glanceStriking-distance queries by total score9 queries kept from 212 rows, scored out of 30
  • wide toe box running shoes: 26
  • best trail shoes for beginners: 25
  • zero drop running shoes women: 21
  • how to clean running shoes: 19
  • wide running shoes men: 17
  • carbon plate marathon shoes: 16
  • trail running shoes beginners: 14
  • running shoe size chart: 9

Example for: an online running shoe store, Search Console export for the last 28 days, 212 rows pasted.

Kept 9 rows. Dropped 203: 141 below 100 impressions, 48 above position 20, 14 above position 8.

1. Scored table
QueryURLPositionImpressionsCTRPos/Impr/CTR-gapTotal
wide toe box running shoes/collections/wide-running-shoes11.24,8500.6%8/10/826
best trail shoes for beginners/blog/trail-shoe-guide9.43,1201.1%9/8/825
zero drop running shoes women/collections/zero-drop13.82,6400.4%6/7/821
how to clean running shoes/blog/clean-running-shoes12.52,2100.9%7/6/619
wide running shoes men/collections/wide-running-shoes14.11,6300.5%6/5/617
carbon plate marathon shoes/collections/racing-shoes16.11,9800.2%4/5/716
trail running shoes beginners/collections/trail-shoes14.71,0400.3%5/3/614
running shoe size chart/pages/size-guide18.97600.1%2/2/59
recovery sandals/collections/recovery19.44100.0%1/1/57
2. Top 5 fixes to ship first
  1. /collections/wide-running-shoes: Change the H1 from "Wide Fit" to "Wide Toe Box Running Shoes" and add a 120-word intro naming men's and women's options. Targets: wide toe box running shoes, wide running shoes men. Reason: highest impressions plus two queries on one URL.
  2. /blog/trail-shoe-guide: Rewrite the title tag to "Best Trail Shoes for Beginners (2024 Picks)" and add a comparison table near the top. Targets: best trail shoes for beginners. Reason: already position 9.4; a CTR lift pays off fastest.
  3. /collections/zero-drop: Add a "Women's zero drop" filter link and an H2 with the exact query. Targets: zero drop running shoes women. Reason: strong CTR gap, no gendered section exists.
  4. /blog/clean-running-shoes: Add a numbered 6-step section with HowTo-style headings in the first screen. Targets: how to clean running shoes. Reason: informational intent rewards a direct answer.
  5. /collections/racing-shoes: Rename the meta title to include "Carbon Plate Marathon Shoes". Targets: carbon plate marathon shoes. Reason: 0.2% CTR at 1,980 impressions suggests a snippet mismatch.
3. Cannibalization flags
  • "best trail shoes for beginners" (/blog/trail-shoe-guide) and "trail running shoes beginners" (/collections/trail-shoes). Link the blog to the collection with exact anchor text and keep the collection focused on products.
4. Watch list (recheck in 28 days)
  • running shoe size chart
  • recovery sandals
  • trail running shoes beginners

Data limits: positions are averages across devices and locations, this covers 28 days only, and CTR benchmarks are general estimates, not your site's baseline.

Written by AI from this prompt. Your results will vary.

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.

Keep exploring

More in SEO
SEO

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.