{"slug":"kw-content-planner-intent-table","title":"Keyword Content Planner: Seed to Intent-Classified Content Plan","tags":["keyword-research","content-planning","search-intent","content-calendar","seo"],"agent_summary":"Full keyword-to-content plan pipeline: seed keyword expansion to clustered super-categories, long-tail generation, search intent classification, and click-optimized title and meta creation. Output is a ready-to-execute content calendar with intent labels.","trigger_phrases":["keyword content plan","content plan from keyword","keyword to content calendar","search intent classification","keyword planning","content calendar from keywords","kw content planner"],"runnable":true,"markdown":"\n# Keyword Content Planner: Seed to Intent-Classified Content Plan\n\nFrom one seed keyword to a full content calendar. Five steps: expand the seed, cluster into super-categories, generate long-tail targets, classify intent, then write titles and meta for each piece.\n\n---\n\n## Step 1: Seed Keyword Expansion\n\nStart with 1-3 seed keywords. A seed is a broad, short-tail phrase that defines the topic:\n\nExamples:\n- \"roof repair\" (service)\n- \"email marketing\" (topic)\n- \"personal injury lawyer Chicago\" (local service)\n\n**Expansion sources:**\n- Google autocomplete (type seed + A through Z)\n- PAA questions from first SERP page\n- Google's \"related searches\" at bottom of SERP\n- Competitor page H2 structures\n\n**Output:** 30-60 raw keyword ideas for each seed.\n\n---\n\n## Step 2: Cluster Into Super-Categories\n\nGroup the 30-60 raw keywords into 4-6 super-categories. These become the pillar topics.\n\n**Example (seed: \"roof repair\"):**\n\n| Super-Category | Keyword Examples |\n|---------------|-----------------|\n| Cost and Pricing | roof repair cost, how much to repair roof, roof repair estimate |\n| DIY vs Professional | DIY roof repair, fix roof yourself, when to call a roofer |\n| Types of Damage | hail damage roof repair, wind damage, missing shingles |\n| Finding a Contractor | best roofer near me, how to choose a roofing contractor |\n| Process and Timeline | how long does roof repair take, roof repair process |\n| Location-Specific | roof repair Denver, roofing contractors near me |\n\nEach super-category = one pillar page + supporting cluster pages.\n\n---\n\n## Step 3: Long-Tail Generation\n\nFor each super-category, generate 5-10 long-tail keyword targets:\n\n**Long-tail characteristics:**\n- 4-7 words\n- Specific qualifier (city, price range, material type, audience type)\n- Lower competition than seed\n- Clear intent signal\n\n**Long-tail formula:**\n`[Qualifier] + [Super-category keyword] + [Modifier]`\n\nExamples for \"Cost and Pricing\":\n- \"average cost to repair roof after hail storm\"\n- \"roof repair cost per square foot 2026\"\n- \"how much does it cost to fix a leaking roof\"\n- \"roof repair cost in Denver Colorado\"\n- \"small roof repair cost vs full replacement\"\n\n---\n\n## Step 4: Search Intent Classification\n\nClassify every keyword before assigning to a content type:\n\n| Intent Type | Signal Words | Best Content Type |\n|-------------|-------------|-------------------|\n| **Informational** | what, how, why, when, guide, tips, explained | Blog article, how-to |\n| **Commercial investigation** | best, top, review, compare, vs | Comparison page, review |\n| **Transactional** | buy, hire, cost, near me, free estimate | Service page, landing page |\n| **Navigational** | [brand name] + action | Homepage, about, contact |\n\n**Intent table output:**\n\n```\nKEYWORD INTENT TABLE:\n[Keyword] | [Intent] | [Content Type] | [Priority]\nroof repair cost Denver | Transactional | Service/Location page | High\nhow long does roof repair take | Informational | Blog article | Medium\nbest roofers Denver | Commercial | Comparison/list article | High\nemergency roof repair near me | Transactional | Service page + GMB | Highest\n```\n\n---\n\n## Step 5: Click-Optimized Titles and Meta Descriptions\n\nFor each planned content piece, generate:\n\n**Title tag (50-60 chars):**\n- Primary keyword in first 40 characters\n- Qualifier or power word in remainder\n- Current year if evergreen list/guide\n\n**Meta description (145-160 chars):**\n- Restate intent match in first sentence\n- Add specificity (number, outcome, or unique angle)\n- End with CTA\n\n**Template:**\n```\nTitle: [Primary keyword] — [Qualifier] | [Brand Name]\nMeta: [Intent-matching opening statement]. [Specific detail]. [CTA].\n```\n\n**Example:**\n```\nTitle: Roof Repair Cost in Denver (2026) | [Company Name]\nMeta: Average roof repair costs $380-$1,700 in Denver. See real prices by damage type and get a free estimate from licensed local roofers.\n```\n\n---\n\n## Final Content Plan Output\n\n```\nCONTENT PLAN — [Niche/Client]\n\nPILLAR 1: [Super-category]\nTarget keyword: [primary keyword]\nIntent: [type]\nTitle: [title tag]\nMeta: [meta description]\nContent type: [service page / blog / location page]\nWord count: [target]\nCTA: [conversion goal]\n\n  CLUSTER 1.1: [Long-tail keyword]\n  Intent: [type]\n  Title: [title]\n  Meta: [meta]\n  Content type: [type]\n  Word count: [target]\n\n  CLUSTER 1.2: ...\n\nPILLAR 2: ...\n```\n\n#content-sop #keyword-research #content-planning #search-intent\n","html":"<h1>Keyword Content Planner: Seed to Intent-Classified Content Plan</h1>\n<p>From one seed keyword to a full content calendar. Five steps: expand the seed, cluster into super-categories, generate long-tail targets, classify intent, then write titles and meta for each piece.</p>\n<hr>\n<h2>Step 1: Seed Keyword Expansion</h2>\n<p>Start with 1-3 seed keywords. A seed is a broad, short-tail phrase that defines the topic:</p>\n<p>Examples:</p>\n<ul>\n<li>\"roof repair\" (service)</li>\n<li>\"email marketing\" (topic)</li>\n<li>\"personal injury lawyer Chicago\" (local service)</li>\n</ul>\n<p><strong>Expansion sources:</strong></p>\n<ul>\n<li>Google autocomplete (type seed + A through Z)</li>\n<li>PAA questions from first SERP page</li>\n<li>Google's \"related searches\" at bottom of SERP</li>\n<li>Competitor page H2 structures</li>\n</ul>\n<p><strong>Output:</strong> 30-60 raw keyword ideas for each seed.</p>\n<hr>\n<h2>Step 2: Cluster Into Super-Categories</h2>\n<p>Group the 30-60 raw keywords into 4-6 super-categories. These become the pillar topics.</p>\n<p><strong>Example (seed: \"roof repair\"):</strong></p>\n<p>| Super-Category | Keyword Examples |\n|---------------|-----------------|\n| Cost and Pricing | roof repair cost, how much to repair roof, roof repair estimate |\n| DIY vs Professional | DIY roof repair, fix roof yourself, when to call a roofer |\n| Types of Damage | hail damage roof repair, wind damage, missing shingles |\n| Finding a Contractor | best roofer near me, how to choose a roofing contractor |\n| Process and Timeline | how long does roof repair take, roof repair process |\n| Location-Specific | roof repair Denver, roofing contractors near me |</p>\n<p>Each super-category = one pillar page + supporting cluster pages.</p>\n<hr>\n<h2>Step 3: Long-Tail Generation</h2>\n<p>For each super-category, generate 5-10 long-tail keyword targets:</p>\n<p><strong>Long-tail characteristics:</strong></p>\n<ul>\n<li>4-7 words</li>\n<li>Specific qualifier (city, price range, material type, audience type)</li>\n<li>Lower competition than seed</li>\n<li>Clear intent signal</li>\n</ul>\n<p><strong>Long-tail formula:</strong>\n<code>[Qualifier] + [Super-category keyword] + [Modifier]</code></p>\n<p>Examples for \"Cost and Pricing\":</p>\n<ul>\n<li>\"average cost to repair roof after hail storm\"</li>\n<li>\"roof repair cost per square foot 2026\"</li>\n<li>\"how much does it cost to fix a leaking roof\"</li>\n<li>\"roof repair cost in Denver Colorado\"</li>\n<li>\"small roof repair cost vs full replacement\"</li>\n</ul>\n<hr>\n<h2>Step 4: Search Intent Classification</h2>\n<p>Classify every keyword before assigning to a content type:</p>\n<p>| Intent Type | Signal Words | Best Content Type |\n|-------------|-------------|-------------------|\n| <strong>Informational</strong> | what, how, why, when, guide, tips, explained | Blog article, how-to |\n| <strong>Commercial investigation</strong> | best, top, review, compare, vs | Comparison page, review |\n| <strong>Transactional</strong> | buy, hire, cost, near me, free estimate | Service page, landing page |\n| <strong>Navigational</strong> | [brand name] + action | Homepage, about, contact |</p>\n<p><strong>Intent table output:</strong></p>\n<pre><code>KEYWORD INTENT TABLE:\n[Keyword] | [Intent] | [Content Type] | [Priority]\nroof repair cost Denver | Transactional | Service/Location page | High\nhow long does roof repair take | Informational | Blog article | Medium\nbest roofers Denver | Commercial | Comparison/list article | High\nemergency roof repair near me | Transactional | Service page + GMB | Highest\n</code></pre>\n<hr>\n<h2>Step 5: Click-Optimized Titles and Meta Descriptions</h2>\n<p>For each planned content piece, generate:</p>\n<p><strong>Title tag (50-60 chars):</strong></p>\n<ul>\n<li>Primary keyword in first 40 characters</li>\n<li>Qualifier or power word in remainder</li>\n<li>Current year if evergreen list/guide</li>\n</ul>\n<p><strong>Meta description (145-160 chars):</strong></p>\n<ul>\n<li>Restate intent match in first sentence</li>\n<li>Add specificity (number, outcome, or unique angle)</li>\n<li>End with CTA</li>\n</ul>\n<p><strong>Template:</strong></p>\n<pre><code>Title: [Primary keyword] — [Qualifier] | [Brand Name]\nMeta: [Intent-matching opening statement]. [Specific detail]. [CTA].\n</code></pre>\n<p><strong>Example:</strong></p>\n<pre><code>Title: Roof Repair Cost in Denver (2026) | [Company Name]\nMeta: Average roof repair costs $380-$1,700 in Denver. See real prices by damage type and get a free estimate from licensed local roofers.\n</code></pre>\n<hr>\n<h2>Final Content Plan Output</h2>\n<pre><code>CONTENT PLAN — [Niche/Client]\n\nPILLAR 1: [Super-category]\nTarget keyword: [primary keyword]\nIntent: [type]\nTitle: [title tag]\nMeta: [meta description]\nContent type: [service page / blog / location page]\nWord count: [target]\nCTA: [conversion goal]\n\n  CLUSTER 1.1: [Long-tail keyword]\n  Intent: [type]\n  Title: [title]\n  Meta: [meta]\n  Content type: [type]\n  Word count: [target]\n\n  CLUSTER 1.2: ...\n\nPILLAR 2: ...\n</code></pre>\n<p>#content-sop #keyword-research #content-planning #search-intent</p>\n"}