📁 SEO
SEO Keyword Research Prompt: Clusters From Your Search Data
Turn a Search Console export and your keyword tool list into a keyword research sheet: intent clusters, one page per cluster, priority, and SERP checks.
0Reviews
Prompt
Act as an SEO specialist who does keyword research for small sites from the site's own Search Console queries and a keyword tool export, and who never guesses search volume or difficulty. Inputs: - The site, what it sells or publishes, and who it is for: [SiteAndAudience] - Seed topics the business wants to be found for: [SeedTopics] - Search Console queries export (query, clicks, impressions, average position): [SearchConsoleRows] - Keyword tool export (keyword, volume, difficulty, as given by the tool): [KeywordToolRows] - Pages that already exist, with URL and the main topic of each: [ExistingPages] - Competitor or SERP notes you checked by hand: [SerpNotes] - How many new pages you can publish per month: [PublishingCapacity] Generate: 1. A cleaned keyword list: merge SearchConsoleRows and KeywordToolRows, remove duplicates and off-topic queries, and keep every number exactly as exported. 2. Intent labels for each keyword: informational, commercial, transactional, or navigational, with one line on what the searcher wants. 3. Keyword clusters: group keywords a single page could rank for, name the primary keyword of each cluster, and list its secondary keywords. 4. A cluster to page map: for each cluster, the ExistingPages URL that should target it, or "new page" with a proposed slug and page type (guide, list, tool, product, comparison). 5. Quick wins: SearchConsoleRows queries with impressions but an average position between about 8 and 20, the page that ranks, and the one change to test. 6. A cannibalization check: clusters where two ExistingPages compete, and which page should own the cluster. 7. A priority table: cluster, intent, total volume from the export, difficulty from the export, business fit (high, medium, low with a reason), and a priority score explained in one line. 8. A publishing plan that fits PublishingCapacity for the next 3 months, highest priority first. 9. A SERP check list: for the top 5 new pages, what to verify by hand in the live results before writing (page types ranking, forum results, featured snippets). Rules: - Never invent volume, difficulty, clicks, or rankings. Mark anything missing as [CHECK IN TOOL]. - Use SerpNotes as given and do not claim to have seen live search results.
Instructions
Export your query and keyword data first (Google Search Console, Google Keyword Planner, or your SEO tool), then replace every [bracket]. Works on ChatGPT, Claude, and Gemini. The model cannot see live search volume or rankings, so any number it did not get from your export is marked [CHECK IN TOOL].
Generated Output
This image was generated using the prompt above.
Examples
Example Input
SiteAndAudience: A bakery supply shop selling sourdough tools (bannetons, lames, Dutch ovens) to home bakers in the US. SeedTopics: sourdough starter, banneton, scoring bread, Dutch oven bread. SearchConsoleRows: how to clean a banneton | 40 clicks | 2,100 impressions | position 9.4 banneton size for 500g flour | 12 | 1,300 | 14.2 best lame for scoring bread | 8 | 900 | 18.7 sourdough starter not rising | 5 | 3,400 | 31.0 dutch oven sourdough temperature | 22 | 1,800 | 7.1 KeywordToolRows: sourdough starter not rising | volume 6,600 | difficulty 34 banneton vs bowl | 1,000 | 12 how to score sourdough | 5,400 | 41 round vs oval banneton | 480 | 9 ExistingPages: /blog/banneton-care-guide (cleaning and storing), /blog/dutch-oven-baking (baking temperatures), /products/bannetons, /products/bread-lames. SerpNotes: "how to score sourdough" shows video results and two big recipe sites. "banneton vs bowl" shows forum threads and one small blog. PublishingCapacity: 2 new posts a month.
Example Output
1. CLEANED LIST 9 keywords kept (sourdough starter not rising appears in both exports; Search Console numbers and tool numbers kept side by side). 2. INTENT how to clean a banneton: informational, wants a step by step cleaning method. banneton size for 500g flour: informational with buying intent, wants the right basket size. best lame for scoring bread: commercial, comparing lames before buying. sourdough starter not rising: informational, troubleshooting a starter. dutch oven sourdough temperature: informational, wants oven settings. banneton vs bowl: commercial, deciding whether to buy a banneton. how to score sourdough: informational, wants technique. round vs oval banneton: commercial, choosing a shape. 3. CLUSTERS A. Banneton care: how to clean a banneton B. Banneton buying: banneton size for 500g flour, banneton vs bowl, round vs oval banneton C. Scoring: how to score sourdough, best lame for scoring bread D. Starter troubleshooting: sourdough starter not rising E. Dutch oven baking: dutch oven sourdough temperature 4. CLUSTER TO PAGE MAP A -> /blog/banneton-care-guide B -> new page: /blog/banneton-size-and-shape-guide (guide plus size table) C -> new page: /blog/how-to-score-sourdough (guide), linking /products/bread-lames D -> new page: /blog/sourdough-starter-not-rising (troubleshooting checklist) E -> /blog/dutch-oven-baking 5. QUICK WINS how to clean a banneton, position 9.4, 2,100 impressions: /blog/banneton-care-guide. Test: answer the query in the first two sentences and add a short cleaning steps list near the top. banneton size for 500g flour, position 14.2: no page targets it. Cover it in the new cluster B guide with a size by flour weight table. best lame for scoring bread, position 18.7: likely /products/bread-lames [CHECK IN TOOL which URL ranks]. Link it from the new scoring guide. 6. CANNIBALIZATION None found. Watch cluster B: /products/bannetons and the new guide must not both target "banneton size". 7. PRIORITY | Cluster | Intent | Volume (tool) | Difficulty (tool) | Fit | Priority | | B Banneton buying | Commercial | 1,480 (2 of 3 keywords) [CHECK IN TOOL for size query] | 9 to 12 | High, sells bannetons | 1: low difficulty, direct product fit | | D Starter | Informational | 6,600 | 34 | Medium, brings home bakers but sells no product directly | 2: big volume, 3,400 impressions already | | C Scoring | Mixed | 5,400 | 41 | High, sells lames | 3: video heavy SERP, harder | | A Care | Informational | [CHECK IN TOOL] | [CHECK IN TOOL] | Medium | Quick win, update only | | E Dutch oven | Informational | [CHECK IN TOOL] | [CHECK IN TOOL] | Medium | Already position 7.1, keep fresh | 8. PUBLISHING PLAN (2 posts a month) Month 1: banneton size and shape guide; starter not rising checklist. Update the banneton care guide (quick win). Month 2: how to score sourdough, with your own step photos or a short video. Month 3: two posts from the next keyword export, once this round shows results. 9. SERP CHECKS Banneton guide: are forum threads still ranking? If so, answer the size question with a clear table. Starter checklist: check whether a featured snippet lists causes. Scoring guide: count video results; plan your own short clip if videos take the top spots.