promptsforbusiness
Pack AI prompt · ChatGPT · Claude · Gemini

Keyword clustering from data you paste

Paste a keyword list exported from your SEO tool or Search Console and get it grouped into clusters, with a primary keyword and a page plan for each.

Task: grouping keywords into topic clustersBest in: GeminiFormat: 2-step sequencePack: SEO blog brief + outline

What you'll fill in

  • [keyword data] Your keyword export: keyword plus whatever columns you have (volume, difficulty, impressions, current position). Paste as CSV or a table. e.g. “keyword,volume,difficulty bookkeeping pricing,880,32 ...”
  • [site focus] What your site is about and what you sell e.g. “Software and training for solo bookkeepers”

The prompt

2-step prompt sequenceIn the SEO blog brief + outline pack

The full prompt (2 steps) is included in the pack.

Get the pack — $14

Steps: Step 1 — Cluster the keywords → Step 2 — Prioritize and plan pages

How to use it

  1. Open a new chat in Gemini (the others work too).
  2. Paste step 1 and replace every [bracket] with your details.
  3. When it replies, paste the next step in the same chat.
  4. Review the output, check any facts, and edit to taste.

Why Gemini: Gemini handles long pasted lists and spreadsheets comfortably; Claude and ChatGPT also work well for lists under a few hundred rows.

Tips

3 tips for this prompt come with the pack.

Example output

CLUSTER 1: Bookkeeping pricing Primary keyword: "how to price bookkeeping services" — highest volume in the group with moderate difficulty, clear informational intent. Supporting: bookkeeping pricing, bookkeeping rates per hour, monthly bookkeeping fees, bookkeeping pricing models Intent: Informational Page type: Long-form guide CLUSTER 2: Bookkeeping pricing templates

Preview of the example output. The full example comes with the pack.

Try a free prompt from the same pack

Search intent analysis from the results page

Paste the top search results for your keyword and get a clear read on what searchers actually want, what format wins, and what the current pages miss.

The prompt
You are an experienced SEO content strategist. I want to write a blog post targeting the keyword "[target keyword]".

Important: you cannot see live search results or search volumes, so work only from the results I paste below. If something would require data you do not have, say so instead of guessing.

About my business: [business context]

Current top results (copied from a search):
[serp results]

Analyze and give me:
1. Dominant search intent (informational, commercial, transactional, navigational, or mixed) with a one-paragraph explanation of what the searcher is really trying to get done.
2. The winning content format (e.g. step-by-step guide, listicle, comparison, template, calculator) and typical depth, based on these results.
3. Topics and subtopics that almost every top result covers. These are the "table stakes" my post must include.
4. Gaps: questions, angles, examples, or audiences the current results handle poorly or skip.
5. Whether my business is a natural fit for this keyword, and how to connect the topic to what we offer without making the post a sales page.
6. A one-sentence recommendation: write it, adjust the keyword, or skip it, and why.

Be specific and skeptical. Do not pad.

FAQ

Does this prompt work in ChatGPT, Claude and Gemini?

Yes. It is plain-language and written to work in all three. Best fit: Gemini. Gemini handles long pasted lists and spreadsheets comfortably; Claude and ChatGPT also work well for lists under a few hundred rows.

What do I need to fill in?

Replace each bracket with your own details: [keyword data], [site focus]. The more specific your input, the more useful the result.

Is this prompt free?

It is part of the SEO blog brief + outline pack ($14, one-time), which includes 8 prompts. The $59 All-Access Bundle includes every pack.

Will I get the same result as the example?

No. The example was made for a fictional business to show the shape and quality of the output. Your result depends on your input and the model, so review and edit before you use it.

Do I need a paid AI plan?

Usually not. Free plans handle most prompts. Paid plans help when you paste in long documents or run a long multi-step sequence in one chat.

More prompts in SEO blog brief + outline

FreeBest in Claude

Full blog outline with H2s and H3s

Turns the intent analysis into a detailed, logically ordered outline with headings, what each section must cover, and where examples belong.