PromptFork

Cluster raw keyword lists into topic maps with intent and content gaps

Turns an exported keyword list into clustered topic maps with intent labels, an opportunity ranking, and a content-gap shortlist — decision-ready, not a raw spreadsheet.

Open in Studio
Prompt
You are a senior SEO strategist. I will paste an exported keyword list (keyword, volume, difficulty if available).

[KEYWORD ROWS]

Do the following:
1. Clean the data: drop brand/irrelevant/junk terms; normalize plural and near-duplicate variants; flag any row missing volume.
2. Cluster keywords into tightly-themed topic groups. Name each cluster with the head term a real searcher would use. A cluster shares search intent, not just a word.
3. For every cluster, label intent (informational / commercial / transactional / navigational), estimate combined monthly volume, and rate difficulty (Low/Med/High) from the data provided.
4. Rank clusters by opportunity = meaningful volume x lower difficulty x clear monetization path. Show the scoring in a table.
5. Surface content gaps: clusters with strong intent where we likely have no page. Flag 5-10 to prioritize.
6. For the top 3 clusters, draft a working page title, H1, and 3 subtopics the page should cover.

Rules:
- Do not invent volumes. Missing number -> label it 'unverified'.
- Do not recommend a topic unless the data supports it. If the dataset is thin, say so and stop.
- Treat 'low competition' claims skeptically — repeat only what the data shows.

Output: cluster table, opportunity ranking, gap shortlist, and the top-3 page specs.

Success signal: the output is good only if every cluster is intent-grouped (not word-grouped), every number is sourced or marked 'unverified', and you stopped or flagged clearly if the dataset was thin.

Use case

Use when you have a Keyword Planner/Ahrefs/Semrush export and need to see real topics, intent, and gaps before briefing content.

When to use this

After exporting keywords, before writing any brief. Paste up to a few hundred rows.

Follow-up prompts

  • Turn the top 3 clusters into full content briefs with word count and internal-link targets.
  • Map each cluster to an existing URL and flag cannibalization risk.
  • Generate an internal-linking plan across the top 10 clusters.
#seo#keyword-research#content-strategy#marketing
Source
promptfork seed
License
CC-BY-4.0
Published
6/22/2026

More prompts you might like

Turn Search Console performance data into a prioritized content action list

Converts a Google Search Console export (pages, queries, clicks, impressions, CTR, position) into a ranked action list — which pages to update, consolidate, or build — instead of a pretty chart you never act on.

#seo#google-search-console
New

Run a competitor SERP and keyword gap analysis

Compares your site's keyword coverage against named competitors to surface topics they rank for and you do not — a ranked gap list with intent and difficulty, decision-ready not a raw diff.

#seo#competitive-analysis
New

10 scroll-stopping Meta ad hooks engineered for the 125-character fold

Generate 10 psychologically-targeted opening hooks using pattern interrupt theory, engineered to earn the 'See more' click — with the specific angles, character constraints, and thumbstop formulas that separate winning Meta ads from noise.

New

4-step B2B cold outreach sequence with trigger events and the PS technique

A research-first cold email sequence that opens with a real trigger event (not a template), uses proof and varied angles across 4 touches, and includes the PS line trick that gets 19% more replies — written like a human, not a sequence tool.

New
Editor’s pickMarketing & AdvertisingSeed

Find the content gaps your competitors rank for — and the moats they can't copy

Map competitor coverage to surface high-intent topics you're missing, identify your defensible content moats, target SERP features, and get a publishing velocity plan to claim each cluster.

New
Editor’s pickMarketing & AdvertisingSeed

Design a programmatic SEO page template that's actually useful

Blueprint a scalable [modifier]+[entity] page template with unique value per page — not thin doorway pages.

New