Content marketing strategy - content audit, editorial calendar, SEO optimization, content funnel (TOFU/MOFU/BOFU), performance metrics, developer content, social media planning
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] |
