Search Console Performance Export Analyzer (Quick Wins, CTR Gaps, Brand Split)

Turn a Search Console performance export into a prioritised list of quick wins.

Use the tool

Why this tool exists

Search Console gives rows of clicks, impressions, CTR and position; the useful questions are which queries sit just off page one, which rank well but get few clicks, and how much traffic depends on the brand name. This analyzer answers them from the CSV you export: totals and weighted position, position buckets, striking-distance rows (positions 8 to 20 with enough impressions), rows whose CTR is far below a typical curve for their position, and a brand split from terms you enter.

The expected-CTR curve is a generic rounded industry average, not Google data, and SERP features change CTR a lot. Positions are averages, so export by device and country before acting. Nothing is uploaded.

How to use it

  1. Export Queries or Pages from Search Console (Performance > Export > CSV) and paste it.
  2. Enter your brand terms and a minimum impression threshold.
  3. Work through striking-distance rows and low-CTR rows.

Frequently asked questions

Is the CTR benchmark accurate?

It is a rough generic curve (28%, 15%, 11%, 8%...). Use it to rank candidates, not as a target.

Does it need the API?

No. A pasted export is enough, so nothing leaves your browser.

Why do totals differ from the Overview?

Exports are limited to 1000 rows and anonymised queries are missing.