Keyword Cannibalization Checker Template
Keyword Cannibalization Checker Template
Find queries splitting clicks across two URLs, check whether intent really overlaps and decide whether to consolidate.
Which query and URL pairs are true cannibalization worth consolidating, which are distinct intents to leave alone, and which page should win.
- Excel workbook (.xlsx), opens in Google Sheets
- PDF field guide, 9 to 11 pages
- Blank and worked CSV templates
- DataForSEO import script
Free, no email required. Version 3.0, updated November 2026.
=IF(I13="","",IF(I13<>"Ready","n.a.",IF(B13=C13,"Duplicate URL pair",IF(F13=1,"Review consolidation","Distinct intent or uncertain"))))The formula above is the real one from cell L13. Scroll it sideways to read the whole rule.
Connected to the DataForSEO API
This template is designed around one DataForSEO endpoint. Pull the data, convert it with one command, and the workbook does the rest.
DataForSEO Labs: Ranked KeywordsEvery keyword a domain ranks for, with its ranking URL, position and volumedataforseo_labs/google/ranked_keywords/live
Save the JSON responseThe full API response, kept as your source of truth.response.json
Run the import scriptOffline. No API calls, no credentials.dataforseo_import.py import --template 22
Paste at A13Dashboard, checks and action list update instantly.Keyword Cannibalization Checker Template.xlsx
Column map for this template:Filled by the APIAudit trail (automatic)You add
What the keyword cannibalization checker template decides
Keyword cannibalization is one of the most over-diagnosed problems in SEO. Two pages ranking for the same query isn't automatically bad; sometimes it's two different intents, sometimes it's Google testing, and sometimes you own two results on page one.
This keyword cannibalization template quantifies the split. For each query and URL pair it totals clicks, measures the smaller page's share, and asks you to confirm whether the intent truly overlaps. Only pairs with confirmed overlap are flagged Review consolidation, and you record the preferred URL so the fix is clear.
Who it's for
- SEOs investigating unstable rankings
- Content teams with overlapping blog posts
- Ecommerce sites where guides compete with categories
- Teams preparing a content audit or merge
Where it fits in your workflow
The keyword cannibalization checker template answers one question. These three templates answer the questions around it:
- Keyword Mapping Template: which single URL should own each keyword, and where your map assigns the same query to two different pages.
- SERP Overlap Keyword Clustering Template: whether two queries should be targeted by one page or separate pages, based on how many ranking URLs their SERPs share.
- Content Audit Template: what to do with each existing page (keep, refresh, merge or retire) and which decisions would throw away conversions, links or a merge destination.
What's inside the download
One ZIP with the workbook, an 8-column input template (blank and filled), the PDF field guide and an offline script that converts saved DataForSEO responses into the input CSV. The workbook has five tabs.
How the keyword cannibalization calculation works
Pair clicks = clicks A + clicks B. Smaller-page share = the smaller of the two ÷ pair clicks. Review = Duplicate URL pair if both URLs are the same, Review consolidation if intent overlap is 1, otherwise Distinct intent or uncertain.
The key formula, exactly as it appears in the workbook
=IF(I13="","",IF(I13<>"Ready","n.a.",IF(B13=C13,"Duplicate URL pair",IF(F13=1,"Review consolidation","Distinct intent or uncertain"))))
| Result column | Plain-English formula | What it tells you |
|---|---|---|
| Pair clicks | Clicks to A+Clicks to B | Observed clicks to these two URLs for this query. |
| Smaller-page click share | IF(Pair clicks=0,"n.a.",MIN(Clicks to A,Clicks to B) ÷ Pair clicks) | Smaller share within this pair only. |
| Cannibalization review | IF(Landing page A=Landing page B,"Duplicate URL pair",IF(Intent overlap confirmed=1,"Review consolidation","Distinct intent or uncertain")) | Requires confirmed intent overlap before suggesting consolidation review. |
The results you will see
Duplicate URL pairReview consolidationDistinct intent or uncertain
Green meets the checks, red needs fixing first, amber needs a human decision and blue marks an opportunity. Rows with missing or out-of-range inputs are held back in the Input check column until they're fixed, so a half-filled row never sneaks into a total.
How to use the keyword cannibalization checker template
- Export query × page dataFrom Search Console, export queries with the pages that received clicks. Keep pairs where two URLs share a query.
- Enter clicks per URLOne row per query with both URLs and their clicks.
- Judge intent overlapLook at both pages and the SERP. Mark 1 only if they serve the same need.
- Pick a winner and actSet the preferred URL. Consolidate, re-target or add internal links pointing to the winner.
The worked example in the Workspace tab. Clear the lime input cells, paste your CSV at A13 (values only) and every result recalculates.
Fill the keyword cannibalization checker template with DataForSEO
Every template in this library is built to run on DataForSEO data. This one uses DataForSEO Labs: Ranked Keywords: every keyword a domain ranks for, with its ranking URL, position and volume.
Most of the data columns fill automatically. Add the business inputs listed below, then paste.
- Request the dataSend this request with your DataForSEO API login (HTTP Basic auth).
POST https://api.dataforseo.com/v3/dataforseo_labs/google/ranked_keywords/live [ { "target": "yourdomain.com", "location_code": 2840, "language_code": "en", "limit": 1000 } ]
- Save the full JSON responseSave the complete response, not just the task ID, next to the template folder.
- Convert it with the included scriptIt runs offline, makes no API calls and never sees your credentials.
python3 Automation/dataforseo_import.py import --template 22 --input response.json --output my-inputs.csv
- Add what the API can't knowLanding page B, Clicks to A, Clicks to B, Intent overlap confirmed, Preferred destination
- Paste at A13Clear the demo rows, paste the CSV values at Workspace cell A13 and the dashboard updates.
| Fills automatically from DataForSEO | You add |
|---|---|
| Keyword, Landing page A | Landing page B, Clicks to A, Clicks to B, Intent overlap confirmed, Preferred destination |
Source reference fills automatically with the task ID, endpoint, location, language, device and snapshot time, so every row is traceable. Before a big pull, estimate the cost with the DataForSEO pricing calculator. The same steps, plus an example request file, are in the download's Automation folder.
Worked example: Northbeam Outdoor
Every template ships filled with data from Northbeam Outdoor, a fictional outdoor-gear retailer that appears across all 40 workbooks, so you can see what useful output looks like before you add your own. This workbook has 10 example rows.
Five example pairs have real overlap, like three separate layering posts. The 'waterproof hiking boots' pair is a product category and a care guide: different intents, leave them alone.
Top 10 by pair clicks
| # | Keyword | Pair clicks |
|---|---|---|
| 1 | trail running shoes | 6,900 |
| 2 | down jacket | 5,300 |
| 3 | waterproof hiking boots | 5,000 |
| 4 | best backpacking tent | 4,800 |
| 5 | sleeping bag temperature rating | 4,480 |
Input fields
Keep the columns in this order when you prepare a CSV. A missing observation stays blank; use 0 only for a measured zero or a verified No. Fields marked DataForSEO can be filled automatically by the included script.
| CSV field | Column | Meaning and rule | Source |
|---|---|---|---|
| keyword | Keyword | Exact query in the selected country and language. | DataForSEO: keyword |
| url_a | Landing page A | First URL observed for this query. | DataForSEO: url |
| url_b | Landing page B | Second URL observed for the same query and window. | Your records |
| clicks_a | Clicks to A | GSC query-page clicks for URL A. | Your records |
| clicks_b | Clicks to B | GSC query-page clicks for URL B. | Your records |
| intent_overlap | Intent overlap confirmed | 1 only after reviewing both pages and the actual SERP. 1 = Yes, 0 = No. | Your records |
| preferred_url | Preferred destination | Human choice after intent review. Enter UNDECIDED when unresolved. | Your records |
| source_ref | Source reference | Task ID, export filename and observation scope. Retain the untouched source response separately. Optional. | DataForSEO: source_ref |
Reading the result honestly
Two ranking URLs can be beneficial. Pair split is a diagnostic, not proof that either page harms the other.
Limits. Do not sum pair clicks across overlapping pairs or queries with privacy-limited GSC data.
Keyword cannibalization mistakes to avoid
Tips from practice
- Run the SERP overlap template on the query to confirm intent.
- Fix the keyword map so the conflict doesn't reappear.
- Watch the merged page for 4 to 8 weeks before judging.
Frequently asked questions
What is keyword cannibalization?
When two or more pages on your site compete for the same query and intent, splitting clicks and signals so neither performs as well as one strong page would.
How do I check for keyword cannibalization?
Export Search Console query and page data, find queries where multiple URLs get clicks, and check whether those pages serve the same intent.
Is keyword cannibalization always bad?
No. If the pages serve different intents, or you hold two strong positions, it may be fine.
How do I fix keyword cannibalization?
Merge and redirect, re-target one page to a different intent, or use internal links and the keyword map to make the preferred page clear.
Use it with these templates
Each template answers one decision. These are the ones that feed into, or follow from, the keyword cannibalization checker template.
02Keyword Mapping TemplateLabs: Ranked Keywords
Assign every keyword to exactly one URL and catch conflicting assignments before they become cannibalization.
03SERP Overlap Keyword Clustering TemplateSERP API: Google Organic
Decide whether two keywords belong on one page or two by measuring how much their Google results overlap.
20Content Audit TemplateOn-Page API
Score every URL by lost clicks, conversions and links, choose keep, refresh, merge or retire, and catch the risky calls.
16Internal Linking Opportunity TemplateOn-Page API
Score each source-to-target internal link by expected visits and contribution per hour, then verify it went live.
21Content Decay Analysis TemplateLabs: Ranked Keywords
Separate lost impressions, lower CTR and falling demand, so you refresh the pages that really decayed.
08Redirect Mapping TemplateOn-Page API
Map every old URL to its new home and verify each redirect: one permanent hop, a 200 page, no noindex, matching canonical.
Part of the Content SEO Toolkit
Get all 6 Content SEO templates in one ZIP, or the complete set of 40 SEO and GEO templates with the 401-page field handbook.
Further reading on Optimization Theory
Built by Jourdan Rombough, technical SEO and GEO consultant with 15+ years in search. About Jourdan or get an SEO plan.






