ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Content Strategy Spreadsheet
2
3
4
BUSINESS OBJECTIVES
5
Business ObjectivesBusiness Impact (Reason why?)Benchmark1st Quarter Results2nd Quarter Results3rd Quarter Results4th Quarter ResultsTo fill in this spreadsheet, read this ultimate How-To guide on content markeitng in retail:
6
www.styla.com/blog/content-marketing-for-ecommerce
7
8
To use this spreadsheet, go to File → Make a Copy
9
10
11
CORE MESSAGE
TARGET AUDIENCE
12
Message/TopicPersona 1Persona 2Persona ...
13
Mission StatementNiche & Descriptive Attribute
14
Core Message or QuestionDemographics
15
Additional Secondary MessagesInterests
16
1Typical questions
17
2Pain points
18
3Persona-based keywords & phrases
19
4
20
5
21
6
22
23
COMPETITIVE ANALYSIS
24
CompetitorsTheir core messageTopics they cover on their blogTopics they miss out on
Types of content
FrequencyTypical calls to actions usedAudience response
25
26
27
28
29
30
Our differentiator:
31
32
33
CHANNEL PLAN
34
Content TypesChannelChannel's URLObjectiveStructureFrequencyTone
Desired Action
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100