SuperSEOPlus

Website Tracking Tools

Search Console Export Analyzer

Open or paste a Performance export from Google Search Console and get three lists to work from: queries or pages sitting at average positions 8 to 20 with real impressions (striking distance), rows whose click-through rate is well below what other rows at the same position achieve in your own file, and queries that appear for more than one page. Every threshold is shown and can be changed, and every figure is calculated from the rows you provide. The tool does not connect to Search Console, and average position can hide a wide spread of positions, so treat the lists as places to look, not conclusions.

How to use it

  1. In Search Console, open Performance, choose the Queries or Pages tab (or filter to get both dimensions) and use Export, then Download CSV.
  2. Open the CSV here, or paste its contents.
  3. Adjust the thresholds if you want, review each list and download the ones you need as CSV.

Example

A query at average position 9.4 with 640 impressions and 12 clicks is listed as striking distance. If other rows around position 9 average a 2.1% CTR and this one is at 0.8%, it also appears in the low-CTR list.

Using the lists

  • Striking distance: check the page against the query, improve content and internal links, then re-export in a few weeks.
  • Low CTR: review the title and description in the SERP snippet preview; also check whether a search feature is taking the click.
  • Several pages per query: decide whether the pages serve different intents or compete, and consolidate only if they overlap.

Questions

What is striking distance?

Queries or pages whose average position is just off the first page, here 8 to 20 by default, and which have enough impressions to matter. Improving the page may move them onto page one, but nothing is guaranteed.

How is “low CTR” decided?

The tool averages CTR for rows at each rounded position in your file (impression-weighted, using rows above the minimum impressions) and flags rows below a set share of that, 50% by default. It needs at least five comparable rows. It is a comparison with your own data, not an industry benchmark.

Why might average position mislead?

A query can appear at position 2 for some searches and position 40 for others and average out at 21. Check the query in Search Console before acting.

Which export columns does it need?

Clicks, Impressions and Position, plus a Query or Page column. CTR is used if present and calculated otherwise. Column names must be in English.

Is my Search Console data uploaded?

No. The file is read in your browser and nothing is sent anywhere.

Get practical SEO tips by email

Occasional emails with new guides and tools. Confirm by email first; unsubscribe in one click.