Skip to content
Join the waitlist

Free tool

Keyword Cannibalization Finder See which queries your own pages compete for.

Drop a Search Console export. The finder lists the queries where two or more of your pages share impressions or clicks, with the numbers behind each one. It runs in your browser: your file is never uploaded.

  • Runs in your browser
  • Sends nothing
  • Free, no sign-up

Find the queries your pages share

How it works

  1. Export from Search ConsoleOne page or one query at a time from the Performance report, or a CSV with a query and a page on every row.
  2. Drop the files hereZIP or CSV, up to 20 MB each. Several files are joined, and nothing leaves your browser.
  3. Read the findingsEach query with the pages that compete for it and the evidence, then download them as a CSV.
Keyword Cannibalization Finder

ZIP or CSV, up to 20 MB each, up to 200,000 rows.

Your file is read in this browser tab. Nothing is uploaded, sent or stored, and it is gone when you close the tab.

Queries your pages share

Example

Example: an invented site at example.com, not anybody’s results. Drop your own export and this panel shows yours.

3 of 4 queries checked have two or more pages competing.

Queries flagged

3

Queries checked

4

Pages in the file

12

  • standing desk

    4,009 impressions · 117 clicks · 4 pages

    • https://example.com/guides/standing-desk

      45% Share of impressions
      Impressions
      1,800
      Clicks
      60
      Avg. position
      6.1

    • https://example.com/blog/best-standing-desks

      37% Share of impressions
      Impressions
      1,500
      Clicks
      45
      Avg. position
      7.4

    • https://example.com/products/standing-desks

      17% Share of impressions
      Impressions
      700
      Clicks
      12
      Avg. position
      9.8

    1 more page has the query without competing.

    • Clicks SplitThe leading page takes 51% of the query’s clicks.
    • Positions CloseTwo competing pages sit 1.3 positions apart.

  • ergonomic chair

    1,670 impressions · 74 clicks · 2 pages

    • https://example.com/products/ergonomic-chairs

      75% Share of impressions
      Impressions
      1,250
      Clicks
      70
      Avg. position
      4.2

    • https://example.com/blog/chair-buying-guide

      25% Share of impressions
      Impressions
      420
      Clicks
      4
      Avg. position
      14.6

    The pages share the query; nothing else in the export stands out.

  • home office setup

    1,660 impressions · 39 clicks · 2 pages

    • http://www.example.com/blog/home-office

      54% Share of impressions
      Impressions
      900
      Clicks
      21
      Avg. position
      8.2

    • https://example.com/blog/home-office/

      46% Share of impressions
      Impressions
      760
      Clicks
      18
      Avg. position
      8.9
    • Clicks SplitThe leading page takes 54% of the query’s clicks.
    • Positions CloseTwo competing pages sit 0.7 positions apart.
    • Same Path, Different Form2 addresses differ only in the trailing slash, the protocol or www.

The file is made on your device and lists every finding in full.

Each finding is a candidate to read, not a verdict. Open the pages and check what they are for before you change anything.

What keyword cannibalization is

Keyword cannibalization is two or more pages of one site competing for the same search query. The impressions and clicks one page could collect are split between them, and which page appears can change from one day to the next.

It is not always a problem. A product page and a guide that answers a question about the product can both appear for one query and both earn clicks. It becomes a problem when the pages are interchangeable, when a page and its own duplicate share the query, or when the split leaves both pages lower than one stronger page would be.

How the finder reads your export

It runs the same steps on every query in the file, in your browser, with plain arithmetic and no model.

  1. Join the rows. Rows for the same query and page are merged: clicks and impressions add up, and the position is averaged with impressions as the weight. A #fragment is dropped from every address.

  2. Check the queries. A query is checked when it has at least 100 impressions across all its pages.

  3. Find the competing pages. A page competes when it has at least 20 impressions and 10% of the query’s impressions, or at least 3 clicks and 10% of its clicks. A query with 2 or more competing pages is a finding.

  4. Add the evidence. Clicks Split, Positions Close and Same Path, Different Form are shown where they hold. There is no score: the numbers are the evidence.

How to export from Search Console

The Performance report lists queries and pages separately, so a query-by-page view needs one of these.

  1. One page at a time. In the Performance report, add a Page filter set to Exact URL, open Export and choose Download CSV. The ZIP lists the queries that page appears for. Repeat for each page you want to compare and drop the files together.

  2. One query at a time. Add a Query filter set to Exact query and export. The ZIP lists the pages that appear for that query.

  3. A CSV with both columns. A Looker Studio table, the Search Console API or the BigQuery bulk export can give a query and a page on every row, for the whole site at once. Column names such as query, page, clicks, impressions and position are recognised.

What the finder cannot see

It reads one export. These things decide whether a finding is worth acting on, and none of them is in the file.

What the pages are for
Two pages that serve different intents can share a query without hurting each other. Open the pages and read the query’s results before you merge or redirect anything.
Revenue
Clicks are not money. Which of two competing pages earns more depends on your analytics and orders, which an export does not hold.
Change over time
An export covers one period. A page that took over a query last month looks the same as one that has shared it for a year.
Rows beyond the cap
A table stops at 1,000 rows. On a large site, filtering by directory or exporting page by page shows more.

In the QueryRev App

The finder reads one export once. The app keeps the data connected and goes on to the decision.

  • In the App

    Search Console Connected

    The same findings from your live property, for every page and query, with no export to download.

    See Integrations

  • In the App

    Revenue Attached

    Each finding next to what its pages earn, labelled known, influenced or modeled and never added together.

    See Revenue Intelligence

  • In the App

    Decisions

    Merge or Update, with the evidence attached, then verified against a baseline after the change ships.

    See Decisions

Join the waitlist

Early access opens in stages.

Keep exploring

Early access

Be first to see what your SEO really earns.

Early access opens in stages. For in-house teams and agencies: leave your work email, we write when your place comes up, and nothing is charged.

optional

optional

You workoptional

We use these details only to tell you about early access, as our Privacy Policy describes. Every email has a link to leave the list.

Next: confirm your email with the link we send. We write when your place comes up, and nothing is charged.