Search Console export analyzer.
Drop in a Google Search Console export and see what to fix first: searches that get seen but not clicked for where they rank, and the queries or pages losing clicks since the period before. It runs in your browser; your data is never uploaded.
How to use it
- Export from Search Console
For the Losing clicks view, turn on Compare in the date filter first, for example the last 3 months against the 3 before.
Performance›Date›Compare›Export›Download CSV - Drop in Queries.csv or Pages.csv
Unzip the download and drop one file below. The impressions floor sets itself to fit your site.
- Fix what it finds
Rewrite titles for searches seen but not clicked. Check pages losing clicks: lower impressions means less demand, a lower position means a ranking drop.
What the analyzer finds
- Seen, not clickedSearches whose click rate is less than half of your own average for that position. The page ranks, but the title or description does not win the click. Rewriting them is often the quickest gain in Search Console.
- Losing clicksWith a Compare export, the queries or pages that lost the most clicks between the two periods, with what happened to their impressions and position, so you can tell a ranking drop from a demand drop.
- Measured against youClick rates are compared with your own site's rates at each position, from the same export, not with an industry chart that may not fit your searches.
Looking for searches just off page one instead? The striking distance keywords finder takes the same export.
Search Console analyzer questions
Something else? Email us.
How do I find keywords with high impressions and low clicks?
Drop your Queries.csv above. The Seen, not clicked view lists searches whose click rate is under half of your site's own average at that position, sorted by impressions. Those are the titles and descriptions to rewrite first.
How do I find pages losing traffic in Search Console?
Export the Pages report with Compare dates turned on, then drop Pages.csv above. The Losing clicks view sorts pages by clicks lost, and shows whether impressions or position fell too.
Why compare with my own click rates instead of a CTR curve?
Published CTR curves average many sites and many kinds of search. Your own rate at each position, from the same export, is a fairer bar for your pages.
Is my Search Console data uploaded?
No. The file is read in your browser and never sent anywhere.
Can I get this every week without exporting?
LopeBase reads Search Console and Bing for every site you run and shows the searches and pages to work on, with alerts when something drops. It is free for one product.
What is a good click-through rate in Search Console?
It depends on position, the search, and what else is on the results page, so there is no single good number. Comparing each search with your own site's rate at the same position, as the analyzer does, is a fairer test.
Why are my impressions high but clicks low?
Usually one of three things: you rank low on the page, your title and description do not match what people searched, or the results page answers the question itself. The Seen, not clicked view shows the ones where your position is not the reason.
Why did my Search Console clicks drop?
Check impressions and position for the pages that lost clicks. Fewer impressions at the same position means fewer people searched. A lower position means the page lost ground. The Losing clicks view puts both side by side.
How do I export Search Console data to CSV?
In Performance, Search results, choose Export at the top right, then Download CSV. The zip holds Queries.csv, Pages.csv, and more, each with up to 1,000 rows.