Hi hunters! We made this very simple very lightweight spreadsheet to fix one of the biggest problem imo when it comes to keyword cannibalization: finding it.
There are a lot of great ressources out there to drill down on a specific keyword, assess possible cannibalization, and fix it – but I find it hard to know what keywords to investigate in the first place
This spreadsheet takes in your GSC data (with tens of thousands of keywords) and spits out only keywords with possible issues.
The way it works is pretty basic: for each keyword, it goes and check whether several URLs are ranking (in real life – we're using GSC data) on that keyword.
It then goes on to check whether those URLs take up a significant portion of your impressions on that keyword. And if they do, the spreadsheet adds the keyword to the output sheet so you can investigate in more detail
We were already mentioned on Qode magazine's complete guide on keyword cannibalization and we're hoping to make it as useful and straightforward as possible!
Looking forward to getting your feedback, please break it! 😃
Cheers!
Widgets by reviewflowz