ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Past SalesSource:Steps To Tracking KPIs
3
What were your sales over the past 12 month.$500,000 My data1What To Track
4
How many work orders have you completed in the past 12 months? 800 My data2How To Track It
5
What was your average sale price over the past 12 months?$625 My data3
Tracking It Consistently
6
Future Sales
7
What is your sales goal over the next 12 months?$750,000 My data
8
What is your average sale price goal over the next 12 months?$550 My data
9
New | Repeat | Referral (NRR)
10
How many customers do you currently have in your database?1,500My data
11
How much have you spent on new customer marketing in the past 12 months?$18,000 My data
12
Over the past 12 months, how many new leads did your marketing produce?560My gut
13
How many new customers have you acquired in the past 12 months?375My gut
14
How many repeat customers have you serviced in the past 12 months?275My gut
15
How many referral customers have you acquired in the past 12 months?150My gut
22
The Sum Of These Three Lines MUST Match The Total From Cell B4 --- 800 --- -
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
101
102
103
104
105
106