B2B Content Strategy & Planning

SEO content strategy for organic traffic growth via pillar clusters, competitor audits, and calendar optimization. Use when planning content pillar clusters aligned to business goals, auditing competitor content gaps quarterly, scoring keyword coverage for prioritization, mapping topic clusters with intent gaps, or forecasting traffic uplift from content backlogs. Covers keyword filtering by volume/KD thresholds, gap validation, RICE prioritization, viability matrices, and projected uplift simulations. Not for on-page copywriting, paid ad campaigns, or social media scheduling.

1,341Words

Mar 2026Created

Rachel KimB2B Content Strategy ConsultantView profile

Add to your AI tools

Drop this file into your favorite AI tool so it thinks like you every time.

1Click "Copy skill content" below.
2Open ChatGPT, Gemini, or any AI chat tool.
3Paste into Custom Instructions, system prompt, or project knowledge.
4Done. The AI now follows your methodology.

Step-by-Step Process

Planning Content Pillar Clusters

Generate a RACI matrix table for 3-5 business goals provided in the query (e.g., 30% organic traffic growth, product launches).
- Input: List of goals from user.
- Output: Markdown table with columns Responsible, Accountable, Consulted, Informed; rows for each goal and sub-tasks like keyword research, content production.
- Criterion: Cover alignment across teams; ensures goals drive pillar selection because misaligned pillars yield <10% uplift historically.
- Example: For "30% traffic growth", assign SEO lead as Responsible for keyword filtering.
Filter provided keyword data (or simulate from Ahrefs/SEMrush patterns) for 20-30 pillar candidates with >5K monthly search volume and KD <30.
- Input: Keyword list with volume, KD, intent.
- Output: CSV-style table of top candidates sorted by volume descending.
- Criterion: Export only top options; limits scope to high-opportunity terms because broader lists dilute focus.
Quick-scan top 10-15 candidates using a matching terms simulation (filter 1K+ SV, 20%+ volume gap) to estimate cluster opportunity (sum ~45 supporting volumes).
- Input: Pillar candidates from Step 2.
- Output: Table with estimated total cluster volume per pillar.
- Narrow to 5-8 pillars scoring >=60/100 on 5-factor scorecard (volume potential 40%, business alignment 25%, competitive density 15%, topical authority gap 10%, intent match 10%); apply heuristics avg KD<40 and >=3 unranked high-vol (10K+) terms.
- Criterion: Advance only >=60/100 because it captures 80% of viable opportunity in <1 hour.
Deep-map 8-12 clusters per narrowed pillar using content gap simulation in a Google Sheets-style model; score with weighted factors (business goal alignment 40% >=8/10, cluster opportunity 30%, competitive moat 20%, resource fit 10%).
- Input: Narrowed pillars.
- Output: Per-pillar table with cluster topics, volumes, gaps, scores.
- Select final 3-5 pillars using tiebreaker projected uplift = total cluster vol * (1 - avg KD/100) * 0.15; limit <=2 per goal.
- Criterion: Highest uplift wins because it prioritizes traffic impact over volume alone.
Output hierarchical cluster map as a structured markdown outline.
- Sections: Pillar Core (hero title, core KW, metrics); Sub-Clusters (color-coded by intent with child KW lists); Cannibalization & Gap Audit (table of overlaps/gaps); Viability Matrix (table below); Roadmap & Assets (timeline table).
- Criterion: Include all sections; visualizes dependencies for execution because text hierarchies enable quick scanning.

Viability Matrix Template

Cluster	Volume/KD	Unique Intent Gap (>30%)	Calendar Fit (<20% overlap)	Projected MVP Uplift
Sub-1	20K/25	45% (SEMrush non-overlap)	None next 6mo	15% (hist win * vol)


### Auditing Competitor Content Gaps (Quarterly)
1. Structure provided top 50 keywords per pillar (or simulate SEMrush export) into a scoring table.
   - Input: Competitor keywords with traffic estimates.
   - Output: Table with columns: Keyword, Coverage Score (1-10 on freshness/E-E-A-T/word count), Traffic Potential (>2x ours?).
   - Criterion: Score each manually; quantifies gaps because subjective audits miss 30% of opportunities.

2. Flag gaps using prioritization formula: IF traffic potential >2x AND coverage <50% THEN high priority.
   - Input: Scored table from Step 1.
   - Output: Sorted gap list with formula-applied scores.
   - Cross-check with GSC trends; exclude declining topics.
   - Criterion: Only flag validated gaps; prevents chasing stale keywords that drop 20-50% YoY.

3. Generate gap audit report outline.
   - Sections: Executive Summary (top 10 gaps), Scored Table, Prioritized Backlog (formula-ranked).
   - Criterion: Limit to top 10; focuses action on highest ROI.

### Optimizing Content Calendars (Performance Forecasting)
1. Aggregate provided 90-day GA4/Search Console data into an Airtable-style table.
   - Input: Performance metrics (views, clicks, conversions).
   - Output: Table grouped by content topic with historical win rates.
   - Criterion: 90-day window; captures recent patterns without seasonal bias.

2. Apply RICE framework (Reach, Impact, Confidence, Effort) to content backlog.
   - Input: Backlog topics with estimates.
   - Output: RICE-scored table (score = R*I*C/E); sort descending.
   - Criterion: Threshold >1.5 for inclusion; filters to 20% of backlog driving 80% uplift.

3. Simulate traffic projections using SEMrush volumes * historical win rates (e.g., 0.15 avg).
   - Input: RICE table.
   - Output: Projection table with 90-day uplift estimates.
   - Seasonal cross-check via Trends simulation.
   - Criterion: Only project >1.5 ROI with relevance; avoids low-yield topics.

RICE Scoring Template

Topic	Reach (vol)	Impact (conv %)	Confidence (hist win)	Effort (hrs)	RICE Score
Topic1	50K	5%	0.2	40	12.5

Decision Rules

Use these thresholds to advance or pivot during workflows.

Stage	Condition	Action	Reason
Quick-scan narrowing (Step 3b)	Avg KD >=40 OR <3 unranked 10K+ terms	Fail preliminary score; do not advance	High KD blocks ranking; few high-vol terms mean low uplift potential (<5% projected).
Pillar scoring	Business goal alignment <8/10	Disqualify candidate	Misalignment wastes 70% of production effort on irrelevant traffic.
Pillar selection	No candidate >=75/100 total	Pivot to goal refinement (Step 1)	Low scores indicate poor data fit; refinement unlocks 2x better options.
Viability matrix	<25% addressable gap	Pivot to sub-cluster or scrap	Low gaps yield duplicate content with <10% unique traffic.
Calendar inclusion	RICE >1.5 AND seasonal match	Add to calendar	Ensures 3x ROI over average backlog items.

Example: 'best CRM for SMBs' advanced (avg KD 28, 4x10K+ terms) because it met all heuristics.

Hard Constraints

Never full-map more than 8 candidates upfront when planning pillar clusters because it exceeds 4-hour limit and violates 80/20 prioritization (focus 20% effort on 80% opportunity).
Never advance pillars with <50K total cluster volume because historical uplift falls below 10%.
Always Gantt-link dependencies in roadmap timelines (e.g., clusters after hero) because unlinked sequences cause 25% delays.

Common Mistakes to Avoid

Don't inflate quick-scan volumes with dud keywords (<1K SV, branded long-tails); instead, sum top 45 terms via =SUMIF(SV>1000,VolGap>20%) and Trends cross-check, because filters reveal true opportunity (e.g., 'CRM integrations' dropped from 15K to <5K viable).
Don't over-assign in roadmaps without capacity scoring; instead, apply three-rule framework (green <6 items/qtr, sequence hero first + 3/wk max + 2wk buffers, Gantt flags), because it prevents 4-6 week delays.

Tools and Deliverables

Simulate these tools with tables/formulas when raw data unavailable:

Ahrefs/SEMrush equivalents: Keywords Explorer (Matching terms 1K+ SV, 20% gap), Content Gap (gap %), Site Explorer (DR moat vs SERP).
Google Sheets/Excel: Weighted score models, =SUMIF filters.
Google Trends: Seasonality check.
GSC simulation: 30-day uplift proxy via hist win * vol.
Airtable: Data aggregation tables.

Primary deliverables:

Pillar cluster map (markdown hierarchical outline with tables).
Competitor gap report (scored table + backlog).
Optimized calendar (RICE table + projections).

Edge Cases and Limitations

Hidden cannibalization (e.g., 60% subterm overlap post-quick-scan): Compute unique gaps >30% via non-overlap %, calendar fit <20%, project MVP uplift (hist * vol); scrap if <25% gap because duplicates cannibalize 40% of gains.
Competition surges (KD spikes >55 post-scan): Re-run viability matrix; pivot if moat erodes because E-E-A-T shifts invalidate 20-30% of projections.

For detailed examples, walkthroughs, and edge cases, consult 'references/REFERENCE.md'.

Use when

planning content pillar clusters
mapping topic clusters for SEO
auditing competitor content gaps
optimizing content calendars via forecasting
selecting high-potential SEO pillars
validating keyword clusters with gaps
forecasting organic traffic uplift

content-strategyseo-optimizationpillar-clusterskeyword-researchtopic-clusteringcompetitor-auditcontent-calendartraffic-forecasting

your turn

Expertise like this takes years to develop.

Now any AI tool can learn it in seconds.

Planning Content Pillar Clusters

Generate a RACI matrix table for 3-5 business goals provided in the query (e.g., 30% organic traffic growth, product launches).
- Input: List of goals from user.
- Output: Markdown table with columns Responsible, Accountable, Consulted, Informed; rows for each goal and sub-tasks like keyword research, content production.
- Criterion: Cover alignment across teams; ensures goals drive pillar selection because misaligned pillars yield <10% uplift historically.
- Example: For "30% traffic growth", assign SEO lead as Responsible for keyword filtering.
Filter provided keyword data (or simulate from Ahrefs/SEMrush patterns) for 20-30 pillar candidates with >5K monthly search volume and KD <30.
- Input: Keyword list with volume, KD, intent.
- Output: CSV-style table of top candidates sorted by volume descending.
- Criterion: Export only top options; limits scope to high-opportunity terms because broader lists dilute focus.
Quick-scan top 10-15 candidates using a matching terms simulation (filter 1K+ SV, 20%+ volume gap) to estimate cluster opportunity (sum ~45 supporting volumes).
- Input: Pillar candidates from Step 2.
- Output: Table with estimated total cluster volume per pillar.
- Narrow to 5-8 pillars scoring >=60/100 on 5-factor scorecard (volume potential 40%, business alignment 25%, competitive density 15%, topical authority gap 10%, intent match 10%); apply heuristics avg KD<40 and >=3 unranked high-vol (10K+) terms.
- Criterion: Advance only >=60/100 because it captures 80% of viable opportunity in <1 hour.
Deep-map 8-12 clusters per narrowed pillar using content gap simulation in a Google Sheets-style model; score with weighted factors (business goal alignment 40% >=8/10, cluster opportunity 30%, competitive moat 20%, resource fit 10%).
- Input: Narrowed pillars.
- Output: Per-pillar table with cluster topics, volumes, gaps, scores.
- Select final 3-5 pillars using tiebreaker projected uplift = total cluster vol * (1 - avg KD/100) * 0.15; limit <=2 per goal.
- Criterion: Highest uplift wins because it prioritizes traffic impact over volume alone.
Output hierarchical cluster map as a structured markdown outline.
- Sections: Pillar Core (hero title, core KW, metrics); Sub-Clusters (color-coded by intent with child KW lists); Cannibalization & Gap Audit (table of overlaps/gaps); Viability Matrix (table below); Roadmap & Assets (timeline table).
- Criterion: Include all sections; visualizes dependencies for execution because text hierarchies enable quick scanning.