ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Q1Q2Q3Q4Yearly
2
TargetActualTargetActualTargetActualTargetActualTargetActual
3
4
Leads69.15.0076.00.0083.60.0092.00.00320.85.00
5
MQLs69.15.0076.00.0083.60.0092.00.00320.85.00
6
SQLs13.81.0015.20.0016.70.0018.40.0064.21.00
7
Closed2.80.003.00.003.30.003.70.0012.80.00
8
9
$ value closed$69,115$0$76,027$0$83,629$0$91,992$0$320,764$0
10
11
Average deal size$25,000#DIV/0!$25,000#DIV/0!$25,000#DIV/0!$25,000#DIV/0!$25,000#DIV/0!
12
13
14
15
16
17
Variables
18
Target for yearly revenue (new business only - not upsell)$320,764
19
Lead Growth Rate10%
20
Lead to MQL rate100%
21
MQL to SQL rate20%
22
SQL to Close rate20%
23
Average deal size (initial deal only)$25,000
24
25
How To Use
26
Change anything in blue below. Once you set it, don't change it for the year.
27
Once you fill out the numbers in blue, it will auto set up the Weekly and Trailing 4 week sheets for you.
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