Upload your own Google Search Console CSV and get a prioritized action plan from your real data: striking-distance keywords to push to page one, low-CTR pages to rewrite, and your top performers. Your file is parsed in your browser and never uploaded.
Google Search Console is full of signal, but the raw export is overwhelming. This tool reads your own Performance CSV right in your browser and pulls out the moves that actually grow traffic: keywords you can push to page one, pages bleeding clicks because of weak titles, and the pages already winning that deserve more support. Nothing is invented. Every number comes straight from your file.
Export the Performance report from Search Console (Queries and/or Pages), unzip the download, and upload the CSV here. The tool detects whether it is a query or page export, computes clicks, impressions, average CTR, and average position, then groups the results into four prioritized reports. The math is standard arithmetic on your real data, so it is fully transparent and repeatable.
The most valuable report flags queries sitting at roughly average position 8 to 20 with meaningful impressions. You already rank, just barely off page one, where most clicks happen. A better title, a few paragraphs of supporting content, an internal link or two, and these often jump to the first page. Because you are already relevant, the effort-to-reward ratio beats chasing brand-new keywords.
SEMrush and Ahrefs bolt Search Console dashboards onto plans that start north of one hundred dollars a month. SEO Gets and Keyword Hero charge twenty to fifty dollars a month for similar views. This tool is free, runs on your own real Google data so there is zero fabrication, and the striking-distance report is more directly actionable than most paid dashboards. The optional AI summary just explains your priorities in plain English. It never invents numbers.
The Pro version connects to your Search Console and alerts you to new quick-win keywords and pages losing clicks every week.
Get early access, book a free call →We turn your Search Console wins into pages that actually rank and convert. Free audit or mockup, no obligation.
Get a free mockup or audit →Or call/text: (407) 694-2055You export the Performance report from your own Search Console property and upload the Queries.csv or Pages.csv from the unzipped download. Parsing happens in your browser. The script reads the header row, works out whether it is looking at queries or pages, locates clicks, impressions, CTR, and average position, and handles quoted fields and embedded commas. If the CTR column is missing it recomputes CTR as clicks divided by impressions.
Next it sorts your rows into four lists using fixed cut-offs. Striking distance: average position 8 to 20 with at least 10 impressions. Low CTR: at least 50 impressions and a CTR below whichever is higher, 2 percent or 70 percent of your own file's average. High impressions, almost no clicks: at least 100 impressions with clicks at or under 1 percent of them, or two clicks, whichever is higher. Top performers: your highest-click rows. Each list is capped and ordered by impressions or clicks, and the action plan names the biggest item in each. All of it is arithmetic on numbers Google gave you. Nothing is modeled, scored, or predicted.
Those cut-offs are working conventions, not rules from Google, so a row that misses one by a hair is no different from one that clears it. Average position is averaged across every impression, which hides a wide spread. The export covers your property alone, minus the rare queries Google withholds, and shows nothing about your competitors. One part does leave your browser: the optional AI summary sends the top eight rows of each list, query or page text included, plus your totals, and the model is told to use only those numbers. Skip that button and the report stays on your machine. The fixes it points at are ordinary SEO work, covered across the 361 in-depth guides in the learning library at kellywm.com/blog.
Not by the report. The CSV is parsed in your browser and the tables are built there, so your full list of queries and URLs stays on your computer. The only thing that reaches a server is the optional AI summary, and it sends the top eight rows of each report with the query or page text included. If you would rather not share that, do not press the button.
It is a common convention, not something Google publishes. Rows in that band already rank on the edge of page one, so improving a page you already have can move them instead of starting from nothing. That is a reason to look there first, not a promise that they will move. Check the rows just outside the band too, since the line is arbitrary.