ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBE
6
Week # 2022-122022-132022-142022-152022-162022-172022-182022-192022-202022-21
7
Week ending Tuesday the..29 Mar 5 Apr 12 Apr 19 Apr 26 Apr 3 May 10 May 17 May 24 May 31 May
8
9
10
Weekly/monthly KPI review template
Instructions:
1. Make your own copy of this document (File > Make a copy..).
11
by Andy Young // @andyy
2. Choose your start date, week/month interval etc on the Settings tab below.
12
Version 1.3 - updated 17th Apr 2017
3 Enter your metric names in column D, using columns A-C for different level headings.
13
http://bit.ly/kpi-sheet
4. Enter metric values for each period into the cells below.
14
5. Review the "KPIs with % change" tab for week-on-week/month-on-month analysis.
15
6. Delete these instruction rows (8-17) when done.
16
17
18
Revenue
19
[Profit..]
20
Revenue
21
Top-level KPI
22
# [sales/subscribers/transactions]
23
Nuance
24
e.g. average sale amount
25
e.g. # customers
26
Drivers
27
..
28
..
29
..
30
Funnel
31
Subheading
32
metric
33
⤷ submetric
34
⤷ submetric
35
Subheading
36
Subheading 2
37
metric
38
⤷ submetric
39
⤷ submetric
40
Subheading 2
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
101
102
103
104
105