Skip to content
MrKeyword

Google Search Console opportunity finder

Paste a Search Console Performance CSV and this tool lists queries ranking roughly positions 8 to 20, high-impression low-CTR rows, and pages whose clicks or impressions fell between two periods. It calculates only from the data you supply.

What does the Search Console opportunity finder do?

It turns a Search Console Performance CSV into three short opportunity lists, using only the rows you paste. It finds queries and pages ranking roughly positions 8 to 20, rows with high impressions but low CTR, and pages whose clicks or impressions fell between two periods. Every number comes from your file, and the column mapping and row count are shown so you can check the result.

Use it before you plan content or title changes. For the wider workflow, see SEO opportunities, track the keywords you pick with the free rank tracker, and read the Google Search Console guide for how the report is built.

How do I load my Search Console data?

Export a Performance CSV from Search Console, or paste rows with a header line. Paste period 1 first. Add period 2 only when you want the falling-pages comparison. The tool detects the query or page, clicks, impressions, CTR and position columns and shows the mapping above the results.

Everything runs in your browser. Your CSV is never uploaded or stored.

Paste a Search Console CSV or rows to see opportunities.

Which queries are almost on page one?

The first list keeps rows whose average position is between 8 and 20 inclusive. These queries already appear on page one or two, so they are the closest to a top result. The list is sorted by impressions, because a query with more impressions has more to gain from the same position change.

Position is the average position Search Console reports for the date range. It is not a fixed rank, and it can move with device, country and query mix. Check the date range before you compare two exports.

Which queries have high impressions but low CTR?

The second list keeps rows with at least the minimum impressions you set and a CTR below the maximum CTR you set. The defaults are 100 impressions and 2% CTR. A high-impression, low-CTR row is worth a title or description review, because the page is seen but not clicked. The free CTR calculator shows the click-through rate you can expect at each position, so you can tell which queries are below par.

Both thresholds are inputs, not benchmarks. The tool does not compare your CTR with an industry average or invent a target. If the CTR column is missing, CTR is calculated as clicks divided by impressions, multiplied by 100.

Which pages are falling between two periods?

Paste a second CSV for a later period. The tool matches pages by URL, subtracts period 1 from period 2, and lists only pages where clicks or impressions decreased. A page with fewer clicks or fewer impressions in period 2 is a falling page; pages that grew are left out.

The change columns show period 1, period 2 and the difference. A negative difference is a drop. Pages that appear in only one period are not compared, because there is no like-for-like change to report.

How are the opportunity formulas calculated?

Formulas used by the Search Console opportunity finder
OpportunityFormula
Almost page oneAverage position is greater than or equal to 8 and less than or equal to 20
High impression, low CTRImpressions are greater than or equal to your minimum, and CTR is less than your maximum
CTR when the column is missingClicks divided by impressions, multiplied by 100
Falling pagePeriod 2 clicks minus period 1 clicks is below 0, or period 2 impressions minus period 1 impressions is below 0

What does the column mapping and row count show?

The column mapping names the column the tool used for the query or page, clicks, impressions, CTR and position. If a column is missing, the mapping says so. The row count shows how many data rows were read from each period, so you can confirm the whole export was pasted.

Search Console exports use headers such as Top queries, Top pages, Clicks, Impressions, CTR and Position. The tool also accepts common variants such as Query, Page, URL and Average position. If the mapping is wrong, rename the header in your CSV and run it again.

What is the workflow from CSV to a fix?

Compact workflow for using the opportunity finder
StepWhat to doWhat the tool shows
1Export Performance data from Search ConsoleNothing yet; you have a CSV
2Paste period 1 and set your thresholdsColumn mapping, row count, near-page-one and low-CTR lists
3Paste period 2 for the same pagesPages with falling clicks or impressions
4Pick the rows worth a title, description or content changeThe exact query or page and its supplied metrics

Does my Search Console data leave my browser?

No. The CSV is parsed and calculated in your browser. The page loads one JavaScript file and does not send your rows to a server, an API or an analytics endpoint. Nothing is stored after you close the tab. You can run the tool offline once the page has loaded.

What are the frequently asked questions?

What counts as an almost-page-one query?

Any row whose average position is between 8 and 20 inclusive. Those queries already rank on page one or two, so a small improvement can move them into the top results. The tool sorts them by impressions so the biggest opportunities appear first.

What is a high-impression, low-CTR opportunity?

A row with at least the minimum impressions you set and a CTR below the maximum CTR you set. The defaults are 100 impressions and 2% CTR. Both thresholds are yours to change; the tool does not supply benchmark CTRs.

How does the two-period comparison work?

Paste a second Search Console CSV for a later period. The tool matches pages by URL, subtracts period 1 from period 2, and lists only pages where clicks or impressions decreased. Increases are left out because the goal is to find falling pages.

Does the tool invent search volume, difficulty or traffic?

No. It only reads the clicks, impressions, CTR and position in the CSV you paste. It does not call an API, estimate missing metrics or add search volume, keyword difficulty or traffic numbers.

Which Search Console export should I use?

In Search Console, open Performance, choose Search results, set the date range, then use Export to download a CSV. Use the Queries tab for query opportunities and the Pages tab for the two-period page comparison.

Does my Search Console data leave my browser?

No. The CSV is parsed and calculated in your browser with JavaScript. Nothing is uploaded, stored or sent to a server.