Search Console export analyser

What the chart is showing you

A Search Console export has thousands of rows and about four things in it worth acting on. A table hides all of them. The plot doesn't.

Every bubble is one query. Its position on the horizontal axis is where you rank; its height is the click-through you actually get; its size is how many people saw it. The dashed line is the click-through that position normally earns.

Everything sitting below the line is a query that ranks and doesn't get clicked. That is the single most actionable thing in the file, and it is invisible in a spreadsheet because it only exists as a relationship between three columns.

The three lists underneath

Closest to page one. Queries ranking 8–20 with real impressions. They are already close, so a title rewrite, an extra section, or a couple of internal links moves them further than a new page would. The bars show what each would add in clicks at position five, so you can start with the biggest one.

Ranking well, barely clicked. Top-ten positions earning less than half the click-through of that position. That is almost never a ranking problem — it is a title and description problem, and it is the fastest fix in search because you keep the position you already have.

Branded vs non-branded. Put your brand terms in and it splits the export. If most of your clicks are people typing your name, your search traffic is a reflection of your other marketing rather than a channel of its own.

Getting the file

In Search Console, open Performance → Search results, set the date range you care about, then Export → Download CSV. You will get a zip; the file you want is Queries.csv.

The tool reads the header itself, so it also works with exports that carry an extra title row above the columns, or that use slightly different column names.

Nothing is uploaded

The file is read in your browser with the standard FileReader API and parsed in memory. It is never sent anywhere, there is no account, and nothing persists once you close the tab. Open the network panel and watch nothing happen.

That is not a gimmick for this one tool. It is how the main product works: the analysis produces a process that can run wherever the data already is, so confidential files stay on the machine that already has them.

The honest limits

The expected click-through curve is a blended average, not your industry's. Treat the under-clicked list as a starting point rather than a verdict — a query where you rank third but everyone wants a video, or where an AI overview answers it above you, will look like it is underperforming when it isn't.

Position is also an average across every impression in the range. A query that sat at 4 for a week and 30 for a month averages to something misleading. Shorter ranges give sharper numbers.