Find Keyword Cannibalization in Your URL and Ranking Data with Fix Actions

Get your competing pages grouped by search intent, with a primary URL and a merge, redirect, differentiate or keep action for each, backed by your ranking data.

You getSummary, one table per group with these columns and next steps

Prompt

Prompt
You are a technical SEO specialist who audits websites for keyword cannibalization.

I will paste a list of URLs with the queries they rank for, their positions, and clicks and impressions where I have them, exported from Google Search Console or a rank tracker. Find the pages that compete for the same search intent and tell me what to do with each one.

Rules:
1. Group pages by search intent, not exact keyword match. Two pages compete only if one searcher would be satisfied by either page.
2. Flag a group only when at least two URLs rank for the same or near-identical queries. Ignore queries with a single ranking page.
3. Give every URL in a group exactly one action: merge, redirect (301), differentiate, or keep. Add a one-sentence reason that cites the data, such as positions, clicks or query overlap.
4. Name one primary URL per group. Choose it by clicks first, then by best average position.
5. Do not guess traffic, rankings or backlinks that are not in my data. Write "not in data" for any gaps.

Output format:
1. Summary: the number of groups found and the 3 highest-impact fixes.
2. One table per group with these columns: URL | Shared queries | Avg position | Clicks | Action | Reason.
3. Next steps: a numbered list in the order I should do them.

End with one line on what this data cannot show, such as backlinks or conversions, and how that could change the advice.

Example output

At a glanceClicks per competing URL across 3 groups6-month Search Console clicks; /snake-plant-care/ has no click data
  • /pothos-care-guide/ (keep): 1,310
  • /monstera-yellow-leaves/ (keep): 820
  • /snake-plant-watering/ (keep): 610
  • /monstera-...-fix/ (merge): 320
  • /snake-plant-repotting/ (differentiate): 140
  • /pothos-care-2021/ (redirect): 95

Example for: a houseplant care blog with 9 URLs from a 6-month Search Console export.

Summary

3 cannibalization groups found.

Highest-impact fixes:

  1. Merge the two monstera yellow-leaves posts. Together they hold 1,140 clicks but split rankings between positions 6 and 9.
  2. Redirect the old 2021 pothos guide into the current pothos care guide.
  3. Differentiate the two snake plant pages, one for watering and one for repotting.

Group 1: Why monstera leaves turn yellow

URLShared queriesAvg positionClicksActionReason
/monstera-yellow-leaves/monstera yellow leaves, why is my monstera turning yellow6.2820Keep (primary)Highest clicks and best position for the core query.
/monstera-leaves-turning-yellow-fix/monstera yellow leaves, monstera leaves turning yellow9.4320MergeSame intent and 4 of 5 shared queries; fold its overwatering section into the primary.

Group 2: Pothos care guide

URLShared queriesAvg positionClicksActionReason
/pothos-care-guide/pothos care, how to care for pothos4.81,310Keep (primary)Ranks top 5 and drives most clicks.
/pothos-care-2021/pothos care, pothos care tips14.195Redirect (301)Outdated duplicate at position 14 that adds no unique queries.

Group 3: Snake plant watering vs repotting

URLShared queriesAvg positionClicksActionReason
/snake-plant-watering/how often to water snake plant, snake plant care5.5610Keep (primary)Owns the watering queries with the most clicks.
/snake-plant-repotting/snake plant care, when to repot snake plant11.3140DifferentiateOverlaps only on "snake plant care". Retitle and refocus on repotting so it stops chasing the general query.
/snake-plant-care/snake plant care18.7not in dataKeepHub page; click data is missing. Recheck before acting.

Next steps

  1. Merge /monstera-leaves-turning-yellow-fix/ into /monstera-yellow-leaves/, then 301 the old URL.
  2. 301 /pothos-care-2021/ to /pothos-care-guide/ and update internal links.
  3. Rewrite the title and H1 of /snake-plant-repotting/ to target "when to repot snake plant".
  4. Point internal links with "snake plant care" anchor text to /snake-plant-care/ only.
  5. Recheck positions in Search Console after 4–6 weeks.

Limits: this data does not show backlinks or conversions. A merged or redirected page with strong links or sales may deserve to be the primary URL instead.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Grouping by intent rather than exact keyword stops false alarms on pages that share words but serve different searchers.
  • Forcing one action and a data-backed reason per URL turns the audit into a to-do list.
  • The "not in data" rule stops the model from inventing traffic or backlink numbers.

Use this after exporting 3–12 months of query and page data from Google Search Console. Paste it into ChatGPT, Claude or Gemini right after the prompt. Include URL, query, position and clicks for the best results.

Common edits

  • Add a column for impressions or click-through rate if your export includes them.
  • Ask for suggested new title tags for every page marked differentiate.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in SEO