Keyword Cannibalization Looker Studio Template

Description

How can you use the template to check the keyword cannibalization and find internal linking opportunities?

Working with the table and looking at the keywords that have 2 or more ranking pages, you need to make a decision:

1. Change the content of some pages if you think they are ranking incorrectly for this keyword.

Usually, you need to edit your title, and h1 tags and replace or delete a few keywords from the body content.

2. Link pages that rank for the same keyword among themselves if you think they should all rank together for that keyword, but in different positions.

You can see all landing pages that receive Impressions in Google SERP by specific keywords.

Receiving Impressions already means that Google considers this page relevant to such a search query, which means an internal link from such a page or to such a page will help Google better understand your content and the connections between it. Usually, you should place backlinks from the less relevant pages to the one target landing page.

You also use a filter above the table to look for all search queries that contain or don’t contain some specific words. In this way, you can find even more landing pages that should be connected with internal links.

3. Create a separate page if all pages are ranked in 50+ positions and do not solve the user’s intent for this search query.

The stronger your site, the more often Google will rank site pages for many related keywords for which you do not yet have separate pages created.

As a rule, you will be ranked in 50-100 positions for such words.

Creating separate pages for such search queries can help you start attracting traffic for such requests quickly enough.

How to copy the template?

Copy the report as in the screenshot below. The first dataset is the Site Impression, and the second dataset is the URL Impression. After copying it will appear on the page of your files in Looker Studio.

That’s it. If you have any questions about the template you can write it to chat or via personal messages on my Twitter and LinkedIn.