CandidSky / BrightHR collaboration master spreadsheet (2016) - (NOT IN USE)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
£
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2016/2017AprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarchTotal
3
Non-branded sessions (new forecast)-----2,5002,7002,9002,5002,8003,1003,300
5
Branded sessions (new forecast)-----1,5001,7501,9001,5002,3002,5002,700
7
Total Sessions (new forecast)-----4,0004,4504,8004,2005,1005,5005,70047,465
8
Non-brand sessions (actual)8985116027241,2001,7331,9062,4162,2322,4372,3974,057
9
Brand sessions (actual)1,9091,9232,2062,1711,9592,0342,3302,9532,4182,8612,3972,820
10
Total Sessions (actual)2,8072,4342,8682,8943,1593,7674,2365,3694,6505,2984,7946,87749,153
11
Conversion Rate1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.00%1.00%1.00%1.00%1.00%
12
Actual conversion rate0.53%1.31%1.43%0.79%1.08%0.90%0.97%0.47%0.41%0.81%0.67%0.29%
13
Free Trials (Target)151822222643572925283133348
14
Free trials (Actuals)153241233434412519433220359
15
AdWords Traffic Value£8,982£7,790£13,397£7,500£10,238£12,205£16,265£21,647£17,650£25,789£20,137£28,572£190,172
16
17
18
19
BrightBase Pageviews (new forecast)
AprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarch
20
Sessions per month1002653755608651,4501,5001,8001,5002,1002,4002,700
21
Pages per sessions1.51.51.51.51.51.51.51.51.51.51.61.5
22
Total pageviews1503985638401,2982,1752,2502,7002,2503,1503,8404,050
23
Total Organic pageviews23,663
24
Total pageviews35,494
25
26
Exec summary (actuals)AprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarchTotal
27
Organic traffic2,8072,4342,8682,8943,1593,7674,2365,3694,6505,2984,7946,87749,153
28
Organic free trial conversions153241233434412519433220359
29
Organic free trial conversion rate0.53%1.31%1.43%0.79%1.08%0.90%0.97%0.47%0.41%0.81%0.67%0.29%0.73%
30
Organic active paying customers8434310152334
31
Organic free trial > active paying conversion rate
9.47%
32
Retainer spend£3,000£3,000£3,000£3,000£3,000£3,000£3,000£3,000£3,000£3,000£3,000£3,000£36,000
33
CPT (cost per trial)£200£94£73£130£88£88£73£120£158£70£94£150£100
34
CPT MoM -53.13%-21.95%78.26%-32.35%0.00%-17.07%64.00%31.58%-55.81%34.38%60.00%
35
CPA (cost per acquisition)£1,059
36
37
38
39
40
41
42
43
44
£36,000Spend
45
46
61500
Estimated traffic
47
1.50%
FT conversion rate
48
923
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
AprilMayJuneJulyAugust
66
Free Trials (Target)
1518222226
67
Free trials (Actuals)
1532412334
68
69
70
71
72
73
74
75
76
77
78
79
80
AprilMayJuneJulyAugust
81
82
83
Total686569567473462
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
Loading...