Keyword Cannibalization Checker

No longer available to new RankTank Pro members

By David Krevitt from CIFL

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.

Subscribe to RankTank Pro!
Step 1:
Step 2:
Get the Pro Sheet SEO tool!
Subscribe and get access to this Google Sheet as well as many other Pro Sheet SEO tools!

No longer available to new RankTank Pro members from 31 December 2018

Current Version: 1

Note: The free version of this template requires Supermetrics, a paid Sheets Add-on. The Pro version pulls data via Google Apps Script and requires no additional tools.

Not sure where to start your keyword research?

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.

10 Million Marketers Can't Be Wrong!

When you join the RankTank mailing list, you'll be better than 9.9 million of them. You'll also get first access to cool new tools, tutorials and other neat stuff.

SPAM? Naw. Ain't nobody got time for that.