Keyword Cannibalization Checker Template

Content SEO Toolkit, template 4 of 6

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.

Keyword Cannibalization Checker Template.xlsx
L13fx=IF(I13="","",IF(I13<>"Ready","n.a.",IF(B13=C13,"Duplicate URL pair",IF(F13=1,"Review consolidation","Distinct intent or uncertain"))))

Start HereDashboardWorkspaceDelivery QAField Guide

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.

Setup steps

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

KeywordLanding page ALanding page BClicks to AClicks to BIntent overlap confirmedPreferred destinationSource reference
3 of 8 input columns come straight from DataForSEO

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.

Workspace. The working table. 8 input columns, 4 calculated columns, room for 250 rows. Dropdowns, Yes/No fields and range checks catch bad inputs as you paste.
Start Here. What it decides, a four-step setup and the colour key.
Dashboard. KPI cards, charts, a ranked Top 10 and an automatic action list.
Delivery QA. Pass, fail or exclude each validation step with evidence, owner and date.
Field Guide. Every field explained, plus each formula in plain English.

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

  1. Export query × page dataFrom Search Console, export queries with the pages that received clicks. Keep pairs where two URLs share a query.
  2. Enter clicks per URLOne row per query with both URLs and their clicks.
  3. Judge intent overlapLook at both pages and the SERP. Mark 1 only if they serve the same need.
  4. 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.

  1. 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 } ]
  2. Save the full JSON responseSave the complete response, not just the task ID, next to the template folder.
  3. 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
  4. Add what the API can't knowLanding page B, Clicks to A, Clicks to B, Intent overlap confirmed, Preferred destination
  5. 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.

10Records
0Rows with input issues
5Pairs with intent overlap
12,130Clicks in overlapping pairs

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

Merging pages with different intentsA category page and a how-to guide can share a query and both deserve to exist.
Deciding on one week of dataUse 90 days or more; Google rotates URLs during tests.
Consolidating without redirectsWhen you merge, 301 the loser to the winner and update internal links.

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.

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.

Download the Content SEO Toolkit

See the complete SEO & GEO toolkit

Jourdan Rombough

Built by Jourdan Rombough, technical SEO and GEO consultant with 15+ years in search. About Jourdan or get an SEO plan.

More on digital marketing in our blog

See all posts