Content Success Score Tool by Trung Ngo | Version 1
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Content Performance Data
2
Do not edit fields in columns with purple headers. The formulas are pre-populated and will calculate as post information and performance metrics are added to the correct fields.
3
Instructions:

1. Complete the information in the "Settings" tab.
2. Populate information for columns with blue headers.
3. The Content Success Score is automatically calculated based on your data and settings and is reported in column J, titled "Content Success Score."
4
Content Success Score Calculations
5
Post InformationPerformance MetricsPerformance Against Average
6
URLPublish DateCategoryAuthorComment CountTotal Social EngagementsLinking Root DomainsUnique VisitsAverage Time on SiteContent Success ScoreStart of Benchmark PeriodComment Count vs. Avg.Total Social Engagements vs. Avg.Linking Root Domains vs. Avg.Unique Visits vs. Avg.Average Time on Site vs. Avg.
7
www.example.com/page-13/12/2014SEOAuthor 11348124610:02:566612/12/2013236.36%400.00%168.42%85.11%169.64%
8
www.example.com/page-116/23/2014Social MediaAuthor 3131515880:01:23583/25/2014102.63%166.67%16.67%157.92%136.81%
9
www.example.com/page-67/26/2014Social MediaAuthor 115596940:03:57574/27/2014136.36%54.05%124.14%124.09%231.78%
10
www.example.com/page-23/24/2014SEOAuthor 112977720:01:335512/24/2013179.10%76.27%94.59%147.44%82.74%
11
www.example.com/page-82/10/2014SEOAuthor 231157900:01:215511/12/201352.17%162.96%76.92%143.38%66.67%
12
www.example.com/page-171/29/2014Email MarketingAuthor 39696740:00:345410/31/2013135.00%112.50%128.57%143.00%25.19%
13
www.example.com/page-42/28/2014SEOAuthor 14857820:01:185411/30/201390.32%116.67%77.78%141.37%83.49%
14
www.example.com/page-912/4/2014Content MarketingAuthor 21015134680:00:47529/5/2014100.00%125.00%177.27%103.31%60.00%
15
www.example.com/page-511/13/2014Content MarketingAuthor 181457850:01:56508/15/2014100.00%100.00%100.00%100.00%100.00%
16
www.example.com/page-201/4/2014SEOAuthor 3103106300:03:585010/6/2013100.00%100.00%100.00%100.00%100.00%
17
www.example.com/page-137/10/2014Email MarketingAuthor 32856310:01:08494/11/201420.69%75.00%75.00%122.68%118.60%
18
www.example.com/page-123/23/2014Email MarketingAuthor 31113101310:03:214712/23/2013180.00%107.34%134.33%26.41%175.46%
19
www.example.com/page-102/12/2014SEOAuthor 24685230:00:224511/14/201374.07%90.91%117.65%95.89%21.65%
20
www.example.com/page-185/3/2014PPCAuthor 3149143240:00:21452/2/2014175.00%71.05%180.00%67.02%23.11%
21
www.example.com/page-37/30/2014SEOAuthor 112932350:02:56445/1/2014107.14%97.83%46.88%47.53%150.43%
22
www.example.com/page-1512/5/2014Social MediaAuthor 361113250:01:14439/6/201466.67%93.62%17.39%77.20%95.79%
23
www.example.com/page-142/13/2014SEOAuthor 30763630:01:084111/15/20130.00%105.00%90.00%70.49%70.83%
24
www.example.com/page-71/6/2014Content MarketingAuthor 11721100:02:133510/8/201318.18%140.00%33.33%29.73%71.70%
25
www.example.com/page-194/5/2014PPCAuthor 311332050:01:18351/5/2014161.76%25.42%44.78%42.61%80.91%
26
www.example.com/page-1612/2/2014Content MarketingAuthor 312741060:01:12359/3/2014120.00%66.67%88.89%23.79%76.60%
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
Loading...