What is the GSC Data Analyzer?
Search Console gives you thousands of rows of data and very little help in reading them. This tool takes your export and shows you three things worth acting on: keywords that are close to page one, queries that get impressions but few clicks, and pages that compete with each other for the same search.
Upload the file, pick your filters, and you get sorted lists you can download as CSV. Your file stays in your browser. Nothing is uploaded to my server.
What the tool finds
Striking distance keywords
These are queries where your page ranks between position 8 and 20. Google already shows you for them, so a better title, a stronger section in the content or two internal links can be enough to move them up. The tool lists them by estimated extra clicks, so you start with the ones that matter most.
Low CTR queries
A page in the top 10 with a weak click-through rate is usually losing to a better title or description. The tool compares each query’s CTR with the typical CTR for its position and flags the ones that fall well below. Start by rewriting the title tag and meta description. My on-page SEO guide covers how.
Keyword cannibalization
When two of your pages show up for the same query, Google may switch between them and neither ranks well. The tool lists queries that have two or more pages getting impressions and marks the risk as Low, Medium or High. For High risk, merge the pages, redirect one to the other, or change the intent of one page.
How to use the GSC Data Analyzer
- Open Google Search Console and go to Performance, then Search results.
- Set the date range. The last 3 months works for most sites.
- Click Export and download the CSV or Excel file. If you get a zip, unzip it first.
- Upload Queries.csv in the tool above, or drag it into the box.
- Set the minimum impressions, add your brand name under excluded terms, and go through the tabs.
For the cannibalization check, the file needs both a Query and a Page column. The standard Search Console export does not include both together. Looker Studio or the Search Analytics for Sheets add-on can give you that file. If your file has no Page column, the tool tells you instead of showing wrong results.
How to read the results
- Position is the average position for the date range. A query at 9.2 does not always show at 9.2, so treat it as a guide.
- Estimated extra clicks is a rough figure based on typical CTR by position. It helps you rank the work, but it is not a forecast.
- Minimum impressions removes very small queries. Keep it at 50 for smaller sites and raise it to 200 or more for large ones.
- Branded terms should usually be excluded. Branded queries rank first and click well, so they push the averages up and hide the real gaps.
Who this tool is for
Bloggers who want to know which old posts to update first. In-house marketers who need a quick list before a content meeting. Agencies who want to go through a client’s Search Console without building a spreadsheet each time.
Frequently asked questions
Is the GSC Data Analyzer free?
Yes. There is no signup and no limit on how many files you upload.
Is my Search Console data safe?
The file is read in your browser and is not sent to any server. Closing the tab clears it.
How many rows can it handle?
The Search Console export is limited to 1,000 rows in the interface. The tool handles much larger files, such as API exports, without trouble.
What counts as a striking distance keyword?
A query ranking roughly between position 8 and 20. You can change the range in the tool.
Why does it show no cannibalization results?
Your file probably has no Page column. Upload an export that includes both Query and Page.
Can I use it with Excel files?
Yes. Both .csv and .xlsx files work.
What should I fix first?
Start with striking distance keywords that have high impressions, then fix low CTR titles. Do cannibalization last, since it needs the most work.
Want a second pair of eyes on your data?
I can go through your Search Console data and tell you what to fix first. Get a free SEO audit.