Content Strategy
Content Audit Framework
Audit Spreadsheet Template
| URL | Title | Type | Funnel Stage | Traffic (30d) | Engagement | Conversion | Last Updated | Quality | Action |
|---|
| /blog/x | [title] | Blog | TOFU | [visits] | [time/bounce] | [leads] | [date] | [1-5] | Keep/Update/Remove |
Audit Process
- Inventory: Export all content URLs and metadata
- Metrics: Pull analytics for each piece (traffic, engagement, conversion)
- Quality Score: Rate 1-5 on accuracy, relevance, depth, UX
- Action Decision:
| Quality | Traffic | Action |
|---|
| High | High | Keep, optimize keywords |
| High | Low | Promote, update distribution |
| Low | High | Update content quality |
| Low | Low | Remove or consolidate |
- Gap Analysis: What topics are missing vs. competitor coverage?
Content Inventory Categorization
| Category | Description | Examples |
|---|
| Evergreen | Always relevant | How-to guides, reference docs |
| Timely | Time-sensitive | News, trends, event coverage |
| Pillar | Comprehensive topic hub | Ultimate guide, definitive resource |
| Cluster | Supporting pillar content | Specific sub-topic articles |
| Conversion | Action-oriented | Case studies, comparisons, pricing |
| Community | User-generated / social proof | Testimonials, guest posts |
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
| Content Type | Frequency | Time to Create | Distribution |
|---|
| Blog post | 2-4/month | 3-5 days | Blog, social, newsletter |
| Tutorial | 1-2/month | 5-7 days | Blog, YouTube, docs |
| Case study | 1/month | 2-3 weeks | Blog, sales, email |
| Newsletter | Weekly/biweekly | 1 day | Email |
| Social post | Daily | 30 min | Platform-specific |
| Video/webinar | 1-2/month | 1-2 weeks | YouTube, social |
| Documentation | Continuous | Varies | Docs site |
| Whitepaper/ebook | Quarterly | 3-4 weeks | Gated landing page |
SEO Content Optimization
On-Page SEO Checklist
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
| Stage | Goal | Content Types | CTA |
|---|
| TOFU | Attract, educate | Blog, social, video, podcast, infographic | Subscribe, follow, share |
| MOFU | Engage, nurture | Case study, webinar, whitepaper, comparison | Download, register, try |
| BOFU | Convert, close | Demo, trial, pricing, implementation guide | Buy, start, schedule |
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
| Goal | Metrics | Tools |
|---|
| Awareness | Unique visitors, page views, social reach, impressions | GA4, social analytics |
| Engagement | Time on page, scroll depth, bounce rate, comments, shares | GA4, Hotjar |
| Lead Gen | Form submissions, email signups, content downloads | HubSpot, Mailchimp |
| Conversion | Trial signups, demo requests, purchases | CRM, product analytics |
| Retention | Return visitors, email open rate, community activity | GA4, email platform |
Content Scorecard
## Monthly Content Scorecard
### Traffic
| Metric | Last Month | This Month | Change |
|--------|-----------|-----------|--------|
| Total visits | [X] | [Y] | [+/-Z%] |
| Organic traffic | [X] | [Y] | [+/-Z%] |
| New visitors | [X] | [Y] | [+/-Z%] |
### Engagement
| Metric | Last Month | This Month | Target |
|--------|-----------|-----------|--------|
| Avg time on page | [X] | [Y] | > 3 min |
| Bounce rate | [X%] | [Y%] | < 55% |
| Pages per session | [X] | [Y] | > 2 |
### Conversion
| Metric | Last Month | This Month | Target |
|--------|-----------|-----------|--------|
| Email signups | [X] | [Y] | [target] |
| Content downloads | [X] | [Y] | [target] |
| Trial signups | [X] | [Y] | [target] |
### Top Performers
| Content | Views | Conversions | Conv Rate |
|---------|-------|------------|----------|
| [title 1] | [X] | [Y] | [Z%] |
| [title 2] | [X] | [Y] | [Z%] |
Content Repurposing Strategies
Repurposing Matrix
Blog Post (pillar)
├── Twitter/X thread (key takeaways)
├── LinkedIn post (professional angle)
├── Instagram carousel (visual summary)
├── YouTube video (talking head + slides)
├── Podcast episode (interview format)
├── Newsletter section (curated excerpt)
├── Slide deck (conference talk)
├── Infographic (data visualization)
├── Reddit/HN post (community discussion)
└── Documentation section (if technical)
Repurposing Checklist
| Source | Target | Adaptation |
|---|
| Long blog | Twitter thread | 8-12 key points, add visuals |
| Blog | LinkedIn | Professional tone, add personal take |
| Blog | Newsletter | Summary + personal insight + CTA |
| Webinar | Blog | Transcript + structure + screenshots |
| Case study | Social proof | Pull quotes + metrics |
| FAQ section | YouTube shorts | 60-sec answers |
| Documentation | Tutorial blog | Step-by-step with context |
Developer-Focused Content Patterns
Technical Blog Post Template
# [Action Verb] [Technology] with [Tool/Method]
**TL;DR:** [1-2 sentence summary of what they'll learn/build]
## Prerequisites
- [requirement 1]
- [requirement 2]
## The Problem
[What problem does this solve? Why should they care?]
## Solution
[High-level approach]
### Step 1: [First step]
```[language]
// Code example with comments
Step 2: [Second step]
// Code example
How It Works
[Explain the "why" behind the code]
Common Pitfalls
- [Pitfall 1]: [How to avoid]
- [Pitfall 2]: [How to avoid]
Next Steps
- [Further reading]
- [Related project]
- [Community link]
### Developer Content Types
| Type | Length | Audience | Goal |
|------|--------|----------|------|
| Quick tip | 300-500 words | All devs | Quick wins, shareability |
| Tutorial | 1000-2000 words | Beginners | Teach specific skill |
| Deep dive | 2000-4000 words | Intermediate+ | Thorough understanding |
| Architecture post | 1500-3000 words | Senior devs | Design decisions |
| Changelog/release notes | 200-500 words | Users | Inform about updates |
| Comparison guide | 1500-2500 words | Evaluators | Help decision-making |
| Open source contribution guide | 500-1000 words | Contributors | Onboard contributors |
## Social Media Content Planning
### Platform Strategy
| Platform | Audience | Tone | Content Type | Frequency |
|----------|----------|------|-------------|-----------|
| Twitter/X | Devs, tech | Conversational, witty | Tips, threads, memes | 1-3/day |
| LinkedIn | B2B, leadership | Professional, insightful | Articles, achievements | 3-5/week |
| YouTube | Learners | Educational, clear | Tutorials, demos | 1-2/week |
| Reddit | Community | Authentic, helpful | Discussions, AMAs | 2-3/week |
| HN | Builders | Technical, direct | Launches, deep dives | Strategic |
| Dev.to | Developers | Technical, friendly | Tutorials, experiences | 1-2/week |
### Social Post Templates
```markdown
## Twitter/X Thread Template
1/ [Hook - surprising stat or bold claim]
2/ [Context - why this matters]
3/ [Point 1 - with example]
4/ [Point 2 - with example]
5/ [Point 3 - with example]
6/ [Practical takeaway]
7/ [CTA - link, follow, retweet]
## LinkedIn Post Template
[Opening hook - first 2 lines visible before "see more"]
[Personal story or observation]
[3-5 key insights with line breaks]
[Actionable takeaway]
[Question to drive engagement]
#[relevant] #[hashtags] #[3-5max]
Anti-Patterns
| Anti-Pattern | Neden Yanlis | Dogru Yol |
|---|
| Content without strategy | Wasted effort | Tie every piece to a funnel stage + goal |
| Publish and forget | Decay over time | Schedule updates, track performance |
| Keyword stuffing | Penalized by search engines | Natural language, semantic keywords |
| Only TOFU content | No conversion path | Balance funnel stages |
| Ignoring distribution | "Build it and they will come" fallacy | 20% creation, 80% distribution |
| No repurposing | Inefficient | Every piece should become 3-5 formats |
| Copying competitors | No differentiation | Unique angle, proprietary data, hot takes |
| All text, no visuals | Low engagement | Add diagrams, screenshots, videos |
| No CTA | Missed conversions | Every piece needs a next step |
| Inconsistent publishing | Audience loses trust | Sustainable cadence > burst publishing |