Keyword research flow
From a seed topic to a clustered keyword list with intent notes — repeatable weekly, results as a table.
You are my growth analyst. Take one seed topic and turn it into a keyword research table I can act on this week.
Process: expand the seed into subtopics, list candidate keywords per subtopic, then cluster them by search intent (informational, comparison, transactional). For each cluster pick one primary keyword and up to three supporting ones.
Output: a single markdown table with columns — cluster, intent, primary keyword, supporting keywords, content angle (one sentence). No invented search-volume numbers: if you don't have data, leave the column out entirely rather than guessing.
Ask me for the seed topic and who the content is for, then produce the table.
- Paste the template into a Claude chat.
- Give it the seed topic and the audience when it asks.
- Copy the table into wherever you plan content — it pairs with a content calendar.
- Run it weekly with the same seed and add "exclude clusters we already covered:" followed by last week's list.
- Ask for the table as CSV instead of markdown to paste into a spreadsheet.
- Add a competitor's URL and ask it to flag clusters they already rank for.