Content
Find the queries you are close to ranking for
Google already recorded every query you nearly won. This reads that file properly: the near misses, the impressions with no clicks, and the pages whose CTR does not match their position.
How The Rank Checker Reads Search Console
What This Actually Reads
A Search Console queries export. That is your own impression, click and position data, downloaded from Google, pasted into a box. There is no API key, no account and no live crawl, which is also why it stays free.
It is a performance report, not a rank tracker. Position is the average across every search, device and location in the period you exported.
How To Get The File
- Open Search Console, then Performance, then Search results.
- Click the Queries tab. Export the pages tab by mistake and this tool will say so.
- Export, then CSV. Google's own file has Query, Clicks, Impressions, CTR and Position.
- Pasting straight from a spreadsheet works too. Tabs and commas are both accepted.
What Striking Distance Means
A query between positions 4 and 20 already has Google's attention and not enough of its traffic. It is the cheapest place to work: the page is already relevant, so the gap is usually the snippet, the depth or the internal links rather than the topic.
- Positions 1 to 3: won. Leave them alone.
- Positions 4 to 10: page one. One improvement, usually the title, moves real traffic.
- Positions 11 to 20: page two. Usually depth or internal links, sometimes the snippet.
- Past 20: a different problem, often intent or authority.
Why There Is No Expected CTR Curve
Every published CTR curve disagrees with the others, and all of them disagree with your site. A position 3 result with a weak title can be beaten by a position 6 result with a good one.
So the table shows your real CTR next to your real position. Compare rows with each other: two queries at similar positions with very different CTR means the difference is the snippet, not the ranking.
Reading Position Correctly
Position 12 is an average. The same query might sit at 4 on desktop and 30 on a phone, or at 2 in one country and 40 in another. Before rewriting a page, filter the export by device or country and check the number is stable.
Search Console also excludes anything it treats as a feature rather than a result. A featured snippet or an AI Overview does not appear as a separate row.
What The Export Cannot Tell You
- Queries Google withholds for privacy are absent, so the totals never quite add up.
- The interface export stops at 1,000 rows. Bigger sites need the API or a bulk export tool.
- Impressions are sampled, so small differences between two periods mean nothing.
- There is no competitor data here. For that, use the backlink gap or content gap tools.
What To Do With The List
- Take three queries with real impressions and a poor CTR for their position.
- Rewrite the title and description to answer the query more directly than the current one does.
- Add two or three internal links from pages that already rank for related queries.
- Wait two weeks, export again, and compare the same rows rather than the totals.
Common Questions
Does This Track Live Rankings?
No. It reads the positions Google already recorded for your site. Live positions for any domain need a paid SERP feed, and a free version of that would be guessing.
Why Do The Totals Differ From Search Console?
Google withholds queries it considers private, samples impressions, and applies whichever filters were active when you exported. A small gap is normal, a large one usually means the export was filtered.
Can I Check A Competitor?
No. Search Console only holds data for properties you have verified. For competitors, use the backlink gap or content gap tools, which read their pages directly.
How Often Should I Export?
Fortnightly is enough. Export the same date range each time so the comparison is between pages rather than between seasons.
Is Position Affected By SERP Features?
No. Featured snippets, AI Overviews and other features do not appear as separate rows, and the position shown is a plain web result average.

