Keyword Cannibalization Checker
Nobody ever sets out to shoot themselves in the foot. But if you inherited a site from someone else, you may be also inheriting a keyword strategy that’s lacking focus.
This template checks for keyword cannibalization on a site, and helps you unshoot yourself in the foot.
How it works?
It pulls data from the Search Console API into Sheets, and identifies keywords that are picking up traffic from multiple pages on your site.
The goal is to consolidate your focus around what Nick Eubanks calls Bigfoot Pages, which rank for a large number of keywords (his process for handing keyword cannibalization inspired this template).
After importing data from Search Console, you’ll be armed with two reports:
All of the cannibalized keywords your site is ranking for, including their impressions, clicks, best and worst pages.
Your site’s worst offenders: the cannibalized keywords with largest number of search impressions, and the top 10 pages ranking for them.
Having this data in hand is most helpful when doing a keyword research push or sitemap redesign.