ABCDEFGHIJKLMNOPQRST
1
2
3
Month1/1/2015
4
5
Last MonthThis Month +/- +/-
6
7
8
All Visitors (GA)1,3601,022-338-24.85%
9
10
Paid Traffic315170-145-46.03%
11
12
Bounce Rate61.32%58.02%-3.30%-5.38%
13
14
Avg. Session Time2:09:002:10:000:01:000:11:10
15
16
Depth of Visit2.282.5123.00%10.09%
17
18
19
20
Paid Visitors (Clicks)315170-145-0.46
21
22
Impressions70,09430,264-39,830-56.82%
23
24
Avg Position1.61.90.300.19
25
26
Click Through Rate0.45%0.56%0.11%24.44%
27
28
Avg Cost Per Click$2.91$3.22
29
30
31
Paid Cost915.96$547.54
32
33
34
35
36
37
38
NOTE:
39
Data is not complete for this month yet pullled up to Feb 19th
40
41
Enjoy the Template, from Willliam Rock @ http://goo.gl/WulI1x
42
43
44
Please Let me know if this has helped U, Thx
45
46
47
48
Other NOTES: Very Important
49
I will be adding more to this Report so make sure to bookmark this page and check back once in a while .
50
51
52
53
Once you are ready to insert the data, you will need to just click once in the field you want to change and look up to the top left of your screen for an area called Fx then add the data within that section rinse and repeat :)

This way you don't accidentally change the variable for the calculations in Column D & E

You will see the month tab below and you can just duplicate and change the name so you can go back in your data to find areas of important or decline.

If you want to add more rows to collect I would recommend just clicking on the calculation field and copy and past, then choose if it will be a percentage or other.

I am really excited to hear what others think about this report...

Enjoy the Spreadsheet :) Oh and Have Fun, #LEARN and be a #ROCKSTAR in your Business ...

:) More KOOL Toys to Come Soon
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