Find the SEO wins hiding in Search Console
Upload your Google Search Console export. See keywords sitting just off page one, pages that are seen but not clicked, question ideas for new content and pages competing for the same search.
- Free, no sign-up
- Your data stays in your browser
- CSV download
Drop Queries.csv / Pages.csv here
or click to choose · you can also drop the whole unzipped export
Your opportunities
Expected CTR uses a rough industry benchmark by position. Real click-through rates vary with SERP features, brand and intent — treat gaps as a prompt to review, not a verdict.
How to use the Search Console Opportunity Finder
- Open PerformanceIn Search Console, go to Performance, then Search results.
- Choose 3 monthsPick the last 3 months and turn on Impressions, CTR and Position.
- Export and unzipClick Export, then Download CSV, and unzip the file.
- Drop the files hereQueries.csv and Pages.csv are read automatically. A query + page CSV also shows cannibalisation.
Why use this search console opportunity finder
Search Console already knows where your quick wins are; they are just hard to see in a long table. This tool sorts your export into lists you can act on today: improve pages that rank 8 to 20, rewrite titles that get seen but not clicked, answer questions people already find you for, and fix pages that compete with each other.
- Almost on page oneQueries at positions 8 to 20 with real impressions, with the extra clicks a top-3 spot could bring.
- Low click-throughQueries and pages clicked well below what their position usually gets.
- Question ideasWho, what, how and why searches to answer as FAQs or new articles.
- CannibalisationSearches where two of your pages split the impressions.
Questions people ask
What is a striking distance keyword?
A search where a page already ranks around positions 8 to 20. Improving that page is often faster than writing a new one.
How do I see cannibalisation?
The standard export lists queries and pages separately. Upload a CSV with both a query and a page column, from the Search Console API or Looker Studio.
How is expected CTR worked out?
From a rough industry benchmark by position. Real click-through varies with search features, brand and intent, so treat gaps as a prompt to review.
Is my data uploaded?
No. Your files are read in your browser and never sent to H View.
More free tools
All 36 tools- Keyword Clustering ToolGroup keywords into topics with search intent
- Indexability and Sitemap CheckerWhich pages Google may index, and why not
- SEO Page AnalyzerTitle, meta, H1 to H6, keywords and a score
- Website SEO CrawlerAudit up to 500 pages, export to Excel
- Website Keyword FinderFind every page that mentions a word
- Website Technology DetectorWordPress, PHP, React, CDN and more
The Search Console Opportunity Finder reads your files in your browser; nothing is sent to H View or stored. Expected CTR is a rough benchmark, not a prediction.
Our best stories, in your inbox.
The week’s best Her View, His Insight reading in one short, useful note.
Free. We only use your email to send The H View Brief. Unsubscribe any time.