Content Strategy

Content Audit Framework

Audit Spreadsheet Template

Audit Process

1. Inventory: Export all content URLs and metadata
2. Metrics: Pull analytics for each piece (traffic, engagement, conversion)
3. Quality Score: Rate 1-5 on accuracy, relevance, depth, UX
4. Action Decision:

5. Gap Analysis: What topics are missing vs. competitor coverage?

Content Inventory Categorization

Editorial Calendar Planning

Monthly Calendar Template

## [Month] Editorial Calendar

### Theme: [monthly theme tied to business goal]

| Week | Type | Title | Author | Funnel | Channel | Status |
|------|------|-------|--------|--------|---------|--------|
| W1 | Blog | [title] | [author] | TOFU | Blog, Twitter | Draft |
| W1 | Social | [campaign] | [author] | TOFU | Twitter, LinkedIn | Scheduled |
| W2 | Tutorial | [title] | [author] | MOFU | Blog, YouTube | Outline |
| W2 | Newsletter | [subject] | [author] | MOFU | Email | Draft |
| W3 | Case Study | [title] | [author] | BOFU | Blog, Sales | Research |
| W3 | Social | [campaign] | [author] | TOFU | All | Planned |
| W4 | Docs Update | [section] | [author] | MOFU | Docs site | Planned |
| W4 | Webinar | [topic] | [speaker] | BOFU | Zoom, YouTube | Planned |

Content Cadence

SEO Content Optimization

On-Page SEO Checklist

• Target keyword in title (H1) - front-loaded
• Target keyword in URL slug
• Target keyword in first 100 words
• Meta description (150-160 chars) with keyword and CTA
• H2/H3 subheadings with related keywords
• Internal links to related content (3-5)
• External links to authoritative sources (2-3)
• Image alt text with descriptive keywords
• Schema markup (article, FAQ, how-to)
• Reading time estimate
• Table of contents for long-form (1500+ words)

Keyword Research Template

## Keyword: [primary keyword]

| Metric | Value |
|--------|-------|
| Monthly search volume | [volume] |
| Keyword difficulty | [1-100] |
| CPC | [$X.XX] |
| Search intent | [informational / transactional / navigational] |
| Current ranking | [position or N/A] |

### Related Keywords
| Keyword | Volume | Difficulty | Priority |
|---------|--------|-----------|----------|
| [related 1] | [vol] | [diff] | [H/M/L] |
| [related 2] | [vol] | [diff] | [H/M/L] |
| [related 3] | [vol] | [diff] | [H/M/L] |

### SERP Analysis
- Position 1: [competitor URL] - [content type, word count]
- Position 2: [competitor URL] - [content type, word count]
- Position 3: [competitor URL] - [content type, word count]

### Content Strategy
- Content type: [blog / guide / comparison / tool]
- Word count target: [based on SERP analysis]
- Unique angle: [what makes ours different]

Content Structure for SEO

# [Primary Keyword] - [Benefit/Hook] (H1)

[Introduction: Hook + problem statement + what they'll learn]
[Target keyword in first 100 words]

## Table of Contents

## [H2: Related keyword question/topic]
[Content section - 200-400 words]
[Include data, examples, visuals]

## [H2: Next related topic]
[Content section]

## [H2: Practical/actionable section]
[Code examples, templates, step-by-step]

## FAQ
### [Common question 1?]
[Concise answer - good for featured snippets]

### [Common question 2?]
[Concise answer]

## Conclusion
[Summary + CTA]

Content Funnel (TOFU / MOFU / BOFU)

Funnel Strategy

                    TOFU (Awareness)
                   /                \
         Blog posts              Social content
         SEO content             Video tutorials
         Infographics            Podcasts
                  \              /
                   MOFU (Consideration)
                  /                \
         Case studies            Webinars
         Comparison guides       Email nurture
         Technical docs          Free tools
         Whitepapers             Workshops
                  \              /
                   BOFU (Decision)
                  /                \
         Free trial              Demo request
         ROI calculator          Pricing page
         Implementation guide    Customer stories
         Onboarding content      Sales enablement

Content Types by Funnel Stage

Funnel Content Mapping

## Feature: [Feature/Product Name]

### TOFU Content
- Blog: "What is [concept]? A Beginner's Guide"
- Blog: "Top 10 [category] Tools in [year]"
- Video: "[concept] Explained in 5 Minutes"
- Social: "[stat] of [audience] struggle with [problem]"

### MOFU Content
- Guide: "How to Choose the Right [category] Tool"
- Case Study: "How [company] Solved [problem] with [product]"
- Webinar: "Best Practices for [topic]"
- Comparison: "[product] vs [competitor]: Honest Comparison"

### BOFU Content
- Demo: "See [product] in Action"
- Calculator: "[metric] ROI Calculator"
- Guide: "Getting Started with [product]"
- Testimonial: "[customer] Increased [metric] by [X]%"

Content Performance Metrics

Metrics by Goal

Content Scorecard

## Monthly Content Scorecard

### Traffic
| Metric | Last Month | This Month | Change |
|--------|-----------|-----------|--------|
| Total visits | [X] | [Y] | [+