AnalyticsSearch Console and SEO analysisIntermediateAnalyses your data

Search Console keyword cannibalization candidates

Finds queries where several of your pages compete, and helps decide whether it is harmful or harmless before merging or redirecting anything.

For: Performance marketers, Marketing analysts, Growth marketers · Works with: Google Search Console, Any capable chat model (ChatGPT, Claude, Gemini, others)

Public beta. This prompt was drafted with AI assistance and checked by automated rules, but it has not been reviewed or tested by a person yet. Treat it as a starting point and check the output. It is hidden from search engines while in beta. Use the “Was this prompt useful?” box to tell us what works.

Your prompt

Act as an SEO analyst. From the Search Console rows below (query | page | clicks | impressions | position) for last 6 months, find queries where more than one of my pages receives impressions. Data: Query | Page | Clicks | Impr | Pos utm builder | /utm-builder | 420 | 18000 | 5.2 utm builder | /bulk-utm-builder | 35 | 9100 | 11.8 utm builder | /glossary/utm | 12 | 6000 | 14.0 Site context: tools site with a glossary and a blog. Tasks: 1. State assumptions (for example that multiple pages appearing for one query can be harmless, and that position is an average). 2. List queries with two or more pages, showing each page's impressions, clicks and position. 3. For each, judge whether it looks like harmful cannibalisation (pages with the same intent splitting visibility) or normal coexistence (different intents, or one page clearly dominant), explaining your reasoning from the data. 4. For the likely harmful cases, recommend options (differentiate content, consolidate, adjust internal links, canonicalise or redirect) and the risks of each; recommend checking the actual SERP and page content before acting. 5. List what you cannot tell from this data. Rules: do not invent traffic projections or rankings. Missing data must be flagged. Verify counts and totals. Do not state that consolidation will improve rankings; present it as a hypothesis to test.

Customize

The fields start with example values so you can see how the prompt works. Everything stays in your browser.

Period.

Paste your rows. The default is small fictional sample data so the preview works; replace it with your own export.

How your pages relate.

Example of what to expect

Illustrative only. It describes the kind of result this prompt aims for; real output varies by tool, model and run.

A list of queries served by multiple pages with per-page numbers, a judgement of harmful vs normal coexistence, options with risks, and limits of the data. (Illustrative.)

Expected format: Assumptions, multi-page query table, judgement, options with risks.

How to use it

  1. Check the live SERP and each page's content.
  2. Change one thing at a time.
  3. Track impressions and clicks per page afterward.

Limitations

  • Several pages ranking for one query is not automatically a problem.
  • Consolidation can lose rankings; test carefully.

Platform notes

Google Search Console

Official docs read · checked 2026-10-11

Search Console data lags by 2-3 days, adding page or query dimensions can drop rows, and the API caps rows per request (per Google's documentation); account for this when comparing recent periods.

General notes on Google Search Console
  • Adding page or query dimensions can drop rows, and data lags by 2-3 days, so recent days look artificially low. Totals computed without page/query dimensions are more accurate.

Any capable chat model (ChatGPT, Claude, Gemini, others)

Official docs read · checked 2026-10-11

Works in any capable chat model. Paste a small anonymised export and recompute the key numbers yourself: chat models can misread columns or miscalculate.

General notes on Any capable chat model (ChatGPT, Claude, Gemini, others)
  • These prompts are plain text and work in any chat assistant. For analytics prompts, paste a small, anonymised export; a chat model can misread columns or miscalculate, so recompute key numbers yourself.

Source, license and attribution

Origin
Original by MarketerTools
Publisher
MarketerTools
License
Original work by MarketerTools, free to copy and use. Informed by the linked documentation; no third-party text is reproduced.
Platform assumptions checked
2026-10-11

Documentation and references behind this prompt

These informed the structure and the platform notes. A reference is not a license, and no third-party prompt text is copied here.

Spotted an attribution error, or are you a source owner with a request? Use the chat button at the bottom right and quote prompt ID ana-021. We will correct or remove it.

Related prompts

  • AnalyticsIntermediateAnalyses your data

    Search Console page-level decline diagnosis

    Breaks a traffic decline into impressions, CTR and position changes by page and query so the right class of cause is investigated first.

    Google Search Console · Any capable chat model (ChatGPT, Claude, Gemini, others)