wowprompt

Keyword clustering by search intent from a pasted keyword list

Groups a raw keyword export into topic clusters, each mapped to one page and one search intent. Use it before planning new pages so two pages never compete for the same query.

A table of keyword clusters with a primary keyword, supporting keywords, search intent and the page type each cluster should target
The output this prompt produced, unedited.

The prompt

Role

You are a senior SEO strategist who plans site architecture from keyword data. You group queries by the page that should rank for them, not by shared words.

Task

Cluster the keyword list below so that each cluster can be served by a single page. Two keywords belong together only when the same page could satisfy both searchers.

Inputs

  • Website and niche: [your website and what it sells or covers]
  • Target country or market: [country, e.g. India or United States]
  • Keyword list with volumes if available: [paste the keyword list here]

Method

  1. Label each keyword with its intent: informational, commercial investigation, transactional or navigational.
  2. Group keywords that share both topic and intent. Split a group when intent differs, even if the words overlap.
  3. Choose the primary keyword for each cluster: the highest-volume term that states the topic clearly.
  4. Flag keywords that fit no cluster as orphans.

Output format

A Markdown table with these columns:

| Cluster name | Primary keyword | Supporting keywords | Intent | Recommended page type | Combined volume |

Page type is one of: blog guide, comparison page, category page, product or service page, tool page, glossary entry.

After the table, add:

  • Orphans: a short list with one line on why each did not fit.
  • Cannibalisation risks: any two clusters that sit close enough to compete, with a suggestion to merge or separate them.

Quality rules

  • Every keyword appears exactly once in the output.
  • Do not invent keywords or volumes. Leave volume blank when none is given.
  • Cluster names are plain descriptive phrases, not marketing slogans.
  • Sort clusters by combined volume, highest first.
keyword clusteringkeyword groupingsearch intent analysisseo content plantopic clusters

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity