Score demand using intent, business fit and current market evidence
Turn search demand into a clean content roadmap.
Use four structured Excel templates to score keyword opportunities, group shared intent, map topics to pages and guide every important asset from brief through publishing and refresh.
Excel workbooks · No email gate · Practical context included
Keyword & Content Templates in the real world.
Relevant market context, customer intent and measurable digital performance—connected in one focused growth system.
Move from a raw keyword list to mapped pages, connected topic clusters and publish-ready content.
Every download includes enough structure to support real work, while leaving room for your market, evidence, priorities and professional judgment.
Group keywords by shared intent and SERP similarity to reduce cannibalization
Coordinate briefs, evidence, drafting, QA, publishing and refresh work
Keyword & Content Templates
Turn search demand into clean keyword clusters, topical architecture and a repeatable editorial workflow. Choose the file that matches your current task, or use the recommended sequence below.
Keyword Research Template
A structured keyword database with a formula-driven opportunity-scoring workflow.
Replace the examples with current market data, then compare demand, difficulty, commercial fit, intent and funnel stage using one consistent source and date.
- Volume, difficulty, CPC and trend fields
- Intent, funnel stage and business-fit scoring
- Target URL, SERP feature and status mapping
Keyword Cluster Template
Group related queries by shared intent and SERP similarity—not wording alone.
Use this after keyword research to decide which terms belong on one page, which need supporting assets and where cannibalization should be consolidated or separated.
- Cluster IDs and parent-topic mapping
- SERP similarity and keyword roles
- Target URL and cannibalization actions
Content Cluster Template
Plan pillar pages, supporting content and internal-link relationships as one connected system.
Use it to build a 90-day content roadmap around real topic coverage, proof, conversion goals and refresh cycles instead of publishing isolated articles.
- Pillar, hub and supporting-asset mapping
- Internal links, intent and funnel roles
- Proof requirements, CTA goals and refresh dates
Content Creation Guide
A complete brief-to-publish production and quality-control workflow.
Run every important content asset through this checklist to coordinate research, original evidence, drafting, human review, SEO, AEO, accessibility, launch QA and maintenance.
- Strategy, research, evidence and drafting gates
- SEO, AEO, accessibility and conversion checks
- Publishing, measurement and refresh workflow
How to use this collection.
Follow the sequence once, then adapt the cadence to the size of the site, the available evidence and the team responsible for delivery.
Collect current keyword and competitor data
Record the input, decision, owner and evidence before moving to the next stage.
Score and cluster opportunities by shared intent
Record the input, decision, owner and evidence before moving to the next stage.
Map clusters to existing or planned URLs
Record the input, decision, owner and evidence before moving to the next stage.
Build briefs and run every asset through editorial QA
Record the input, decision, owner and evidence before moving to the next stage.
Strong templates support judgment; they do not replace it.
Verify current platform requirements, replace example data, document assumptions and review every high-impact recommendation before changing a live website.
- Use current first-party business and performance data whenever possible.
- Separate observed facts, calculations, hypotheses and recommendations.
- Assign an owner, deadline and acceptance test to implementation work.
- Keep a record of source dates, changes made and measurable outcomes.
Build the complete SEO operating system.
Want help applying these resources to your website?
Request a free SEO audit and get a clearer view of the highest-impact opportunities, risks and next steps.