Cluster Your Search Console Queries Into Page Opportunities

Google Search Console shows you a thousand queries and zero structure. Cluster your GSC export by live SERP overlap to see which queries belong to the same page, which pages are cannibalizing each other, and which clusters deserve a page you have not written yet.

Upload Your GSC Export - Group 100 Queries Free

100 free creditsNo credit card requiredCredits never expire

What Your Export Looks Like

In Search Console, the Performance report's Queries tab exports as CSV with Query, Clicks, Impressions, CTR, and Position. Rename the 'Top queries' column header to 'Keyword' and the file is ready for Optiwing. Impressions data makes the clusters especially valuable: it is demand Google has already shown you.

Keyword	Clicks	Impressions	CTR	Position
invoice template word	320	18,400	1.7%	8.2
free invoice template	290	22,100	1.3%	9.6
how to write an invoice	45	6,800	0.7%	14.3
invoice example	12	4,200	0.3%	21.5

Export via the Export button in the Performance report (CSV or Google Sheets). Rename the query column to 'Keyword' before uploading; the metric columns can stay in the file and will simply be ignored.

The Workflow, Step by Step

Export queries from the Performance report

In Search Console, open Performance, set a 3 to 12 month date range, and export the Queries table as CSV. Longer ranges surface more long-tail queries, which is exactly what clustering feeds on.

Rename the query column to 'Keyword'

Open the CSV and change the 'Top queries' header to 'Keyword'. That is the only edit needed. Keep Clicks, Impressions, CTR, and Position in the file for your own reference; Optiwing ignores them during clustering.

Upload to Optiwing and launch the job

Sign up free (100 credits, no credit card), click +New, upload the file, and choose the location and device where most of your traffic comes from. Optiwing checks the live top 10 results for every query and groups queries sharing 3 or more URLs.

Map clusters to your existing pages

For each cluster, check which of your URLs currently ranks for its queries (the Pages tab in GSC, or Optiwing's SERP data). One cluster, one ranking page: that is the healthy state.

Flag cannibalization

If queries inside a single cluster are answered by two or three different pages on your site, those pages are competing for one intent. Consolidate them: merge the content, pick a canonical page, and redirect the rest. Clusters make these collisions obvious in a way the flat GSC report never does.

Turn orphan clusters into new pages

Clusters with real impressions but a weak average position and no dedicated page are content gaps Google has already validated. Export them as CSV or generate a content brief (25 credits) and write the page the cluster is asking for.

What You Get Back

SERP-Backed Clusters

Your queries grouped by shared top 10 results, revealing the page structure hidden inside the flat GSC report.

A Cannibalization Map

Clusters that span multiple of your URLs show exactly where your own pages compete, and which page should win.

CSV Export

Download clusters with your GSC metrics intact to prioritize fixes and new pages by clicks and impressions.

Optional Content Briefs

For clusters without a dedicated page, generate a brief built from the pages currently winning that SERP.

What It Costs

1 credit per query, pay-as-you-go. A full cannibalization audit of your GSC data usually costs less than a coffee order, and credits never expire.

Job Size	Credits Needed	Cost	Notes
100 queries	100	Free	Signup credits cover a small site's top queries
1,000 queries	1,000	$10	The standard GSC UI export size
2,500 queries	2,500	$19	Multiple exports, filtered by page or country
5,000 queries	5,000	$35 one-time, or $20/month subscription	Quarterly audits for a larger site

Rerunning the audit each quarter keeps the map current; buy once and the unused credits wait for the next run.

See full pricing

Frequently Asked Questions

What format does my Search Console export need to be in?

A CSV where the query column is headed 'Keyword'. Export the Queries table from the Performance report, rename the 'Top queries' header, and upload. Clicks, Impressions, CTR, and Position columns can stay in the file; they are ignored during clustering but useful when you review the exported results.

GSC only exports 1,000 rows in the UI. Is that enough?

Usually, yes: 1,000 queries cluster into a very actionable page map, and it costs just $10 (or free for your first 100). If you need more depth, export several times with page, country, or query filters applied and combine the files, or pull more rows via the GSC API or Looker Studio - Optiwing handles files up to 100MB.

How does clustering find keyword cannibalization?

Clustering groups queries that share 3 or more of the same live top 10 results, meaning Google treats them as one intent. If GSC then shows two or more of your URLs receiving impressions for queries inside one cluster, your pages are splitting that single intent. That is cannibalization, made visible at the cluster level instead of query by query.

How is this different from just sorting my GSC report?

Sorting shows individual queries; it cannot tell you that 'invoice template word', 'free invoice template', and 'invoice example' are one page while 'how to write an invoice' is another. SERP-backed clusters give you page-level structure, so decisions become 'consolidate these two URLs' or 'write this missing page' instead of staring at 1,000 rows.

Does Optiwing connect to my Search Console account?

No, and by design: there is no GSC integration or OAuth access to your property. You export the CSV yourself and upload it, so nothing about your site is shared beyond the query list you choose to cluster.

What does it cost to audit my whole site this way?

1 credit per query. Your first 100 queries are free at signup with no credit card, a 1,000-row export costs $10, and 5,000 queries cost $35 one-time (or fit inside the $20/month Starter subscription's 5,000 credits). Purchased credits never expire between audits.

What should I do with the clusters after the job runs?

Three passes: first, consolidate clusters where multiple of your pages compete (merge and redirect). Second, strengthen clusters where one page ranks but sits at position 8 to 20, using the cluster's variations in your content. Third, create pages for clusters with impressions but no dedicated URL, ideally starting from a generated content brief.