Question

Any google sheets template to identify kw cannibalization from search console data? I remember someone sharing the template before, just can't find it now. Thanks.  

Answer 1

And this is the source :

Comments

@aiello946 this uses ahrefs to pull data. Anything that takes data from search console?  

---

@joann nothing but if i find i'll share

---

@aiello946 thank you

Answer 2

Good luck with that.  

Comments

@narcotize why?  

---

@joann I don't believe in the concept of "keyword cannibalization". It has been defined many different ways (thus underscoring the biggest problem with SEO - no real standards). Are you afraid to list 2 URLs from the same site in a single query's results? That's an irrational fear. On the other hand, if you've published dozens or hundreds of articles about the same exact thing then a little cleanup and consolidation should help. But I wouldn't call that "cannibalization".  

---

@narcotize thank you. That helps. :)