ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Copy/Paste the Improve or Leave As-Is URLs from the Content Audit. Set up a Vlookup to pull all other columns based on the URL in this column.Auto-populate from Content Audit tab once the URL is entered into column A.Auto-populate from Content Audit tab once the URL is entered into column A.Use the KWR tab to see which pages already rank for which keywords. Typically defalt to an alredy-ranking page when appropriate.Auto-populate from the Content Audit tab if applicable for this audit.Choose the level of content quality/depth/length required to compete. Use best judgement.Auto-populate from Content Audit tab once the URL is entered into column A.Auto-populate from Content Audit tab once the URL is entered into column A.Auto-populate from Content Audit tab once the URL is entered into column A.Auto-populate from Content Audit tab once the URL is entered into column A.Auto-populate from Content Audit tab once the URL is entered into column A.
2
URLTitleActionPrimary KeywordOther KeywordsPage TpeReq. Content LevelStrategy/DetailsMeta DescriptionWord CountH1H2
3
http://www.domain.com/blue-widgetsBuy Blue WidgetsKeep As-Isblue widgetsbuy blue widgets, compare blue widgets, choosing a blue widgetBlog HomePremiumRewrite the content on this page to be more useful. Include the unique value proposition and make the next desired action/step/conversion more apparent. Add header tags or strong tags to call out certain sections using recommended keywords if appropriate.When choosing a blue widget to buy it is important to know what features to look for. This resource has everything you need to know about blue widgets.1055Compare Blue WidgetsHow to Choose A Blue Widget
4
http://www.domain.com/red-widgetsBest Red WidgetsImprovered widgetsbest red widgets, buy red widgetsTopical Landing PagePremiumConsider adding a comparison chart for this page. Add header tags or strong tags to call out certain sections using recommended keywords if appropriate. Improve On-Page Optimization.We have the best blue widgets2323N/AN/A
5
http://www.domain.com/green-widgetsHow to Make Green WidgetsImprovegreen widgetshow to make green widgetsProduct/ServiceStandardInclude a DIY video on this page. Add header tags or strong tags to call out certain sections using recommended keywords if appropriate. Improve On-Page Optimization. Build-out the content more with useful tips, as it is currently thin.Learn how to make a green widget222N/AN/A
6
http://www.domain.com/purple-widgetsPurple Widgets FTWImprovepurple widgetsviolet widgetsCategoryStandardPurple / Violet widget shoppers are a different breed. They are more visually included than blue widget shoppers. Incorporate better images, and possibly a video demo. Add header tags or strong tags to call out certain sections using recommended keywords if appropriate. Improve the meta desc.We love purple widgets2322N/AN/A
7
http://www.domain.com/big-widgetsBig Widgets RuleImprovebig widgetsbiger widgets, biggest widgets, large widgetsAcillaryBasicIncorporate a variety of keywords like big, biggest, giant, large, largest... into the content and provide more feature details. Add header tags or strong tags to call out certain sections using recommended keywords if appropriate. Improve the meta desc.N/A2222N/AN/A
8
 http://www.domain.com/small-widgetsSmall Widgets Also RuleImprove small widgetstiny widget, little widgetOtherBasicImprove the title tag and on-page content to target recommended keywords. Add header tags or strong tags to call out certain sections using recommended keywords if appropriate. Improve the meta desc.It's not the size of the widget, but how you use it.789N/AN/A
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
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