ABCDEFGHIJKLMNOPQRSTUVWX
1
Step 1: Make a copy (this version isn't editable)
2
Step 2: Complete the purple cells
3
Metric:
4
Total Revenue needed:$10,000,000KPIs Required to Reach Yearly Goal
5
Marketing Share of Revenue85%KPIPer YearPer Month
6
Average Deal Size$100,000Visitors118,0569837.96
7
Opportunity to Customer Conversion Rate30.00%Leads3,542295.14
8
SQL to Opportunity Conversion Rate50.00%MQLs2,833236.11
9
MQL to SQL Conversion Rate20.00%SQLs56747.22
10
Lead to MQL Conversion Rate 80.00%Opportunities28323.61
11
Visitor to Lead Conversion Rate3.00%Customers857.08
12
13
14
Total Revenue by Channel: (assumption)
15
Marketing$8,500,000
16
Non-Marketing$1,500,000
17
Total Revenue$10,000,000
18
19
20
# of Customers we need to generate (Inbound Revenue/Average Deal Size)
21
Revenue$8,500,000
22
Average Deal Size$100,000
23
# of customers we need to generate85
24
25
26
# of opportunities we need to generate over 1 year (# of Opportunityr to customer conversion rate)
27
# of Customers85
28
Opportunity to Customer Conversion Rate30.00%
29
# of opportunities we need to generate283
30
31
32
# of SQLs we need to generate over 1 years (# of SQ Lto customer conversion rate)
33
# of Opportunities283
34
SQL to Opportunity Conversion Rate50.00%
35
# of SQLs we need to generate567
36
37
38
# of MQLs we need to generate over 1 years (# of MQL to SQL conversion rate)
39
# of SQLs567
40
MQL to SQL conversion rate20.00%
41
# of MQLs we need to generate2,833
42
43
44
# of leads we need to generate over 1 years (# of Leads to MQL conversion rate)
45
# of MQLs2,833
46
Visitor to MQL Conversion Rate80.00%
47
# of leads we need to generate3,542
48
49
50
# of visitors we need to generate over 1 years (# of Visitors to leads conversion rate)
51
# of Leads3,542
52
Visitor to MQL Conversion Rate3.00%
53
# of visitors we need to generate118,056
54
55
56
# of visitors, leads and customers we need to generate each month
57
Visitors9837.96
58
Leads295.14
59
MQLs236.11
60
SQLs47.22
61
Opportunities23.61
62
Customers7.08
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