Keyword opportunity finder

What this tool does

Search Console tells you how many impressions and clicks each query brings, but it never tells you where to start. Spotting real opportunities by eye in a table with thousands of rows is slow and unreliable. The opportunity finder sorts those rows into three groups:

• High impressions, low CTR: You appear in results but people don't click. Often the title or description misses the intent behind the search, or other features on the results page draw attention away.
• Queries in positions 4–20: You're at the bottom of page one or on page two. Moving up a few places here tends to add far more clicks than polishing queries where you already lead.
• Content refresh candidates: Pages that earn impressions for several queries but have slipped in position or have a weak CTR.

Results are sorted by priority, and the whole table can be downloaded as CSV.

How to use it

If you're signed in: Pick a site you've connected to SEOLOK. The tool uses its query and page data directly; no upload needed.

If you're not signed in: Open the Performance report in Search Console, choose a date range (at least the last three months is a good default) and export as CSV. The download contains separate CSV files for queries and pages; upload the one you want to analyse. Short date ranges are noisy, and for seasonal businesses comparing like-for-like periods gives a truer picture.

Reading the results

Average position is an average. Search Console reports the average of your topmost position across every search where the query appeared. A value of 8.4 doesn't mean you sat in eighth place each time; you may have been third in some searches and fifteenth in others. Google's deep dive into performance data explains the calculation, and also why some queries are withheld for privacy reasons.

Low CTR isn't always a title problem. If the results page carries images, videos, a featured snippet or an AI overview, your organic listing sits lower on the screen and CTR drops naturally. Run the search yourself before rewriting anything. When you do draft a new title and description, test them in the SERP preview tool.

Priority tells you where to begin. Rows at the top combine high impression volume with room to improve. For each one, first check whether the page genuinely answers the query, then work on the title, the opening paragraph and the subheadings. If two of your pages appear for the same query, look at the overlap with the keyword cannibalization checker.

Limitations

• The tool only analyses the data it's given. Search Console withholds some rare queries for privacy, so they won't appear here either.
• Exports from the Search Console interface are capped in row count. On large sites you get the rows with the most clicks and part of the long tail may be missing.
• Priority is an ordering, not a click forecast. Demand, competitors and results-page layouts all change.
• It's a one-off analysis and keeps no history. If you'd like the data refreshed daily, kept beyond Google's 16-month window, and turned into a monthly report that estimates extra clicks if those queries reached the top 3, see Search Console analytics.