Find split queries
Runs in your browser. Use 3 months of data so short-term swaps do not dominate.
Keyword cannibalization is when two or more of your URLs share the impressions for the same query and keep trading places. Find it with a query-by-page table: group rows by query and look for a second URL holding a large share. Fix it by merging pages that answer the same question, or by making the difference between them obvious when they do not.
Getting a query + page export
The finder needs one row per query and page. Three ways to get it, from easiest to most complete:
| Method | How | Limits |
|---|---|---|
| Search Console UI, one query at a time | Performance → filter Query (exact) → Pages tab → export | Fine for checking a few queries; slow for a whole site |
| Looker Studio | Search Console connector, URL impression table, dimensions Query and Landing Page, export to CSV | Easy once set up; large sites may need date filters |
| Search Console API | searchAnalytics.query with dimensions query and page | Up to 25,000 rows per request, paged with startRow; Google returns the top rows, not every row |
# Search Console API request body (searchanalytics.query)
{
"startDate": "2026-08-01",
"endDate": "2026-10-31",
"dimensions": ["query", "page"],
"rowLimit": 25000,
"startRow": 0
}
Reading the result
| Pattern in the result | Usually means | Action |
|---|---|---|
| Two blog posts on the same topic, similar positions | True duplication of intent | Merge, redirect, update internal links to the survivor |
| Product page and a guide | Different jobs (buy vs learn) | Leave both; link the guide to the product page |
| Same page with and without a parameter or trailing slash | A duplicate URL, not two pages | Fix canonicals and internal links; see the canonical fix guide |
| A category page and one of its articles | Category page is thin for the query | Let the article own the query; give the category its own purpose |
Merging without losing what worked
- Pick the survivor: usually the URL with more clicks and links, not the newer one.
- Move anything useful from the weaker page into it: unique examples, data, answers to questions only that page covered.
- 301-redirect the weaker URL to the survivor. Google says it uses a permanent redirect as a signal that the target should be canonical, and that server-side redirects have the highest chance of being read correctly.
- Update internal links and the sitemap to point at the survivor directly.
- Recheck the query a month later. If one URL now holds the impressions at a steadier position, the merge worked.
If the merged page then earns impressions but few clicks, its title is the next lever. The low-CTR finder shows whether it is below your own typical CTR at that position.
Questions people ask
Why can't I use the normal Search Console download?
The CSV download from the Performance report gives queries and pages in separate files, so you cannot see which page earned which query. You need one table with both columns, which the Search Console API, Looker Studio or a filtered view can give you.
Is two URLs ranking for one query always bad?
No. A pricing page and a guide can both appear for a broad query because they serve different intents. It is a problem when both pages answer the same question and swap positions, so neither builds a stable ranking.
What threshold does the tool use?
A query is listed when its second URL gets at least 20% of that query's impressions, among URLs above your impression minimum. Lower the minimum on small sites, raise it on large ones to cut noise.
Should I always merge competing pages?
Merge when they target the same intent and one is clearly weaker: move the useful parts into the stronger page and 301 the weaker URL to it. When intents differ, sharpen each page's title and content instead so the difference is obvious.
Related
Sources
- Google Search Console API: Search Analytics query (dimensions, row limits), accessed 2026-11-12.
- Search Console Help: Performance report (Search results), accessed 2026-11-12.
- Google Search Central: Redirects and Google Search, accessed 2026-11-12.
- Google Search Central: Consolidate duplicate URLs, accessed 2026-11-12.