How to find keyword cannibalization with Search Console data
Keyword cannibalization means two or more of your pages compete for the same query, and Google switches between them. Search Console has the data to find it, but the Performance report shows queries and pages in separate tabs. You need both together.
1. Export query × page
In aska GSC tick Query and Page, choose the last 3 months and export to Excel. Open the Query x Page sheet: one row per query and URL with totals for the period.
aska GSC is a browser extension for exactly this: sign in with Google (read-only), pick a site, press Export, get every row as CSV or Excel. Get aska GSC · Pricing
2. Find queries with several pages
- Sort by Query.
- Add a column that counts how many rows have the same query, e.g.
=COUNTIF(A:A, A2). - Filter that column to 2 or more, and ignore pairs where one page has almost no impressions.
3. Decide what to do
| What you see | Usual fix |
|---|---|
| Two similar articles split clicks for one query | Merge them and redirect the weaker URL. |
| A category page and a product page compete | Make intent clear in titles and internal links. |
| The homepage ranks instead of a landing page | Link to the landing page with the query as anchor text; tighten the homepage title. |
| Different URLs win in different countries or devices | Often fine; check with the country and device dimensions. |
4. Check after the change
Export the same query × page view a month later and compare. With the daily split you can chart the switch-over date.