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
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
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.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Analyze server logs for crawl budget waste
Identify wasted Googlebot crawls on 404s, internal search pages, and redirect loops. Use it to protect crawl budget on large websites.
Audit redirect spreadsheets for chains and loops
Find redirect chains, circular loops, and soft 404 dumps in URL migration sheets before launching. Use it during pre-launch technical reviews.
Audit site crawl data to rescue orphaned and buried pages
Turn crawl reports into an actionable internal linking strategy to restore crawl paths for high-value pages with zero internal links.
Design a programmatic page template with unique blocks
Build a modular page wireframe with variable data slots to prevent duplicate content flags on scaled landing pages.
Sanitize dynamic dataset fields for clean landing page URLs
Clean messy raw spreadsheet strings into uniform, URL-safe slugs that prevent routing collisions across scaled directories.
Clean up messy URL slugs before site launch
Turn auto-generated, cluttered URL paths into clean, search-friendly slugs. Use this before launching new pages or publishing blog posts.
- Score page copy for E-E-A-T gaps
- Find the Search Intent Mismatch Between Your Page and Its Target Query
- Turn Search Console Page-2 Queries into a Prioritized Striking-Distance Fix List
- Audit XML Sitemap Structure for Large Websites
- Generate Valid Article and BreadcrumbList Schema JSON-LD
- Map 301 Redirects for Website Migrations