Free Search Console CTR Analyzer
Paste or upload a Search Console Performance export to review overall click-through rate and find queries or pages with high impressions and a lower CTR than similar positions in the same file. The comparison stays inside your export. This tool does not invent industry benchmark CTR numbers.
This is a reader for a CSV you already have, not a live connection to Search Console and not a Google ranking score.
Performance CSV
Or drop a CSV file here, or choose a file. Nothing is uploaded.
The example data button loads a fictional Queries table so you can see the layout. It is not a live Search Console export and not a target.
Filters
CTR calculator
This is a simple clicks divided by impressions calculator. It does not use the CSV and it is not a forecast.
Checks
Report
What the analyzer reviews
This page is a reader for a Search Console Performance export you already have. Paste the table or upload a CSV of queries or pages that includes clicks, impressions, CTR, and position. The tool calculates overall click-through rate from the rows in the file, groups those rows by average position, and highlights queries or pages with high impressions and a lower CTR than other rows in the same position band in that same export.
That comparison is deliberate. Official Search Console help defines CTR as the click count divided by the impression count. It also notes that the query dimension can help you find queries with high impressions and low CTR, which may be opportunities to improve a page title and description. What the help pages do not give you is a single typical CTR for position 1, position 5, or any other rank. This analyzer therefore does not invent industry benchmark numbers. Opportunity is estimated only against this file's own leave-one-out average in the same position band.
The totals you see are sums of the parsed rows. They can differ from the Performance chart in Search Console, because the chart is aggregated by property, while a Pages table is aggregated by URL. A direct export from the report can also be limited to 1,000 representative rows, and totals in the live report can include truncated data.
A simple calculator is included for clicks and impressions on their own. It is the same official ratio, and it is not a forecast of future clicks or a Google score.
How to use it
In Search Console, open the Performance report, choose the search type and date range you care about, and apply any filters you need. Export the report. Official help says you can download Google Sheets, Excel, or CSV, and that a CSV download from this report can arrive as a zip file that contains more than one table. If you receive a zip file, open it on your computer and use the Queries or Pages CSV. This page cannot unpack a zip file in a reliable way, and it will tell you so if you try to upload one.
Paste the table, including the header row, or upload the CSV. Quoted fields and commas inside quotes are supported. Set a minimum impression count if you want to ignore thin rows. Analyze file reads the text in your browser. Load example data fills a fictional Queries table so you can see the layout; it is not a live Search Console export and not a target. Reset clears the form.
Use the filters to narrow the table by text, position band, row type, or opportunity rows only. Sort a column heading if you want a different order. The default sort puts the largest opportunity first. Copy report and Download report give you a short text record of the totals. Nothing is saved on this page after you leave.
After you pick a query or page to improve, rewrite the title and the meta description so they match the search and the page, then check how the result may appear. The Free SERP Snippet Preview Tool on this site can help you review length and layout. Give Google time to recrawl and reprocess the page before you judge the next export. Official title-link documentation notes that this may take a few days to a few weeks. The newest days in Search Console can also be preliminary.
How to read the result
Start with overall CTR, total clicks, total impressions, and the impression-weighted average position. These numbers only describe the rows that were parsed. If the file is a 1,000-row extract, treat it as a sample of the most important rows Search Console included, not as a complete property history.
An opportunity row has enough impressions to be worth a look, and a lower CTR than the other rows in the same position band in this file. The peer CTR column shows that leave-one-out average, so a large row is not compared with an average it dominates. Estimated extra clicks are what that row would have added if it had matched that peer average. That figure is a comparison, not a promise, and it will change if you export a different date range or filter set.
A lower CTR is not always a problem. A very specific query can attract the right click even when the percentage looks modest. A branded query can look strong because people already know the site. Use the table to decide where a clearer title or snippet might help, then confirm the change in Search Console later.
The checks list explains how the file was read, which kind of export it looks like, and the limits of the comparison. Warnings about a zip file, a missing header, or an unclosed quote mean the text could not be used as a Performance table yet.
What this tool cannot do
It cannot log into Search Console, refresh a property, or fetch more rows than you pasted. It cannot tell you a typical CTR for a given position, and it cannot prove that a title change will raise clicks. It also does not treat CTR as a ranking score. The practical use of this page is to find high-impression rows in your own data and to do the arithmetic of clicks divided by impressions without sending the file anywhere. Keep the export on your computer if it contains query text you do not want to share, and remember that anonymized queries in Search Console are omitted from the query table to protect user privacy, even though they can still be included in chart totals when no query filter is applied.