Search Console Opportunity Finder: quick wins from your own data
Find near-page-one searches, low CTR, questions and no-click searches in your Search Console export.
- Free to use
- Runs in your browser
- No sign-up
Your opportunity lists appear here
Upload or paste a Search Console Performance export, or try the example: a dental clinic in Kothrud, Pune.
Want an expert to check this result?
Send it to us in one click. We read it and reply within one business day with what we would fix first.
Embed this tool on your websiteFree. Paste one code; it runs in your visitors' browsers.
Copy this code into a page of your site. The tool sets no cookies and sends nothing your visitors type to us. Change height="760" if it needs more room.
About the Search Console Opportunity Finder
Upload or paste the Queries or Pages table from the Search Console Performance report. The tool sorts it into four lists: searches near page one, searches with a low CTR compared with your own searches at about the same position, questions in English, Hinglish and Hindi, and searches with impressions but no clicks. Each row gets one suggested action: improve the title and snippet, improve the page, add a section or write a new page. Add your brand words to see brand and non-brand totals. Every threshold is our own measure, worked out with fixed rules and arithmetic, not AI. It runs in your browser: the export is not uploaded, and the tool does not sign in to Search Console.
How it works
-
01
In Search Console, open Performance › Search results, pick a date range and export the Queries table (or Pages) as CSV, Excel or Google Sheets.
-
02
Upload the CSV or paste the table, add your brand words, and choose the minimum impressions a row needs.
-
03
Work through the lists from the "Start with these" box, then download the CSV or copy the to-do list.
How the lists are made
Near page one means an average position of 8 to 20. Low CTR means a click-through rate below half the median of your other searches at about the same position, so each search is compared with your own site, not with a general benchmark. Questions are found by question words such as how, what, kya, kaise, kitna and कैसे. All of these are our measures, not Google's.
Reading Search Console numbers
Average position is the topmost position your link held, averaged across the searches it appeared in, and CTR is clicks divided by impressions. Searches made by only a few dozen people over two to three months are left out of the table to protect privacy, so your rows add up to less than the chart totals. Search Console keeps 16 months of data.
What this tool cannot do
It only sees the rows in your export. The table and its export hold up to 1,000 rows, so long-tail searches on bigger sites may be missing; the Search Console API or the bulk data export gives more. It does not know which of your pages shows for each search, what else is on the results page, or why a page ranks where it does. The extra clicks figure is our arithmetic, not a forecast.
Frequently asked questions
Which Search Console export should I use?
The Performance report for Search results, on the Queries tab, over the last 3 months is a good start. Export it as CSV, or open it in Google Sheets and copy the table. The Pages table works too, but the question list and brand totals need queries.
What is a good CTR?
Google does not publish a target, and CTR changes with the position, the kind of search and what else shows on the results page. That is why this tool compares each search with your own searches at about the same position instead of a general figure.
Why do the totals differ from the Search Console chart?
The chart counts every search, but the table leaves out anonymised queries, which are searches made by only a few dozen people over two to three months, and it holds at most 1,000 rows. Our totals add up the rows in your export only.
Should I write a new page or improve the one that ranks?
For searches near page one, improve the page that already shows: answer the search fully and make a heading match it. A new page makes more sense when you show beyond position 20 and no page answers the search, as long as it fits your business. This is our suggestion, not a Google rule.
How do I improve a low CTR?
Rewrite the title so it describes the page clearly and concisely, without stuffing keywords, and write a meta description that answers the search. Google builds the title link mainly from your title element and the snippet mainly from the page itself, using the meta description when it describes the page better, so neither is sure to show exactly as written.
Related reading
Want help with your content?
Tell us about your site and what your articles and pages should bring in. We reply within one business day.
Talk to us Our service: Content and blog SEOMore content writing tools
All content writing tools- Content Brief Builder Turn a keyword and the top pages' headings into a writer's brief with an outline, questions and links.
- Topic Cluster and Pillar Page Planner Group keywords into a pillar page and cluster pages, with URLs and the internal links between them.
- Content Refresh Planner Find pages losing clicks in Search Console, ranked by clicks lost, with an action and a refresh checklist.
- SEO Keyword Cannibalization Checker Find searches where two or more of your pages compete, and whether to merge, redirect or link them.
Want us to fix what the tool found?
Tell us about your business and what you want to grow. We reply within one business day with next steps, not a sales script.
- A reply within one business day
- A quick look at your site and search visibility before we talk
- Your details are only used to answer your enquiry