1 % Better - TEMPLATE - Google Sheets

	B	C	D	F	G	H	J	K	L	N	O	P
1
2	Marketing Email CTR Improvement - Scenario 1			Scenario 2 + 50% Revenue			Scenario 3			Scenario 4
3		Conversion	Goal		Conversion	Goal		Conversion	Goal		Conversion	Goal
4	Marketing List Size		20000	TAM (Marketing List Size or Impression)		20000	TAM (Marketing List Size or Impression)		20000	TAM (Marketing List Size or Impression)		20000
5	CTR	2%	400	CTR	3%	600	CTR	4%	800	CTR	5%	1000
6	MQLs	10%	40	MQLs	10%	60	MQLs	10%	80	MQLs	10%	100
7	Meetings	20%	8	Meetings	20%	12	Meetings	20%	16	Meetings	20%	20
8	SQLs	75%	6	SQLs	75%	9	SQLs	75%	12	SQLs	75%	15
9	Wins	33%	2	Wins	33%	3	Wins	33%	4	Wins	33%	5
10
11	Avg. Sale Price	Qtrly Wins	Revenue	Avg. Sale Price	Qtrly Wins	Revenue	Avg. Sale Price	Qtrly Wins	Revenue	Avg. Sale Price	Qtrly Wins	Revenue
12	$20,000	2	$185,328	$20,000	3	$277,992	$20,000	4	$370,656	$20,000	5	$463,320
13
14
15
16	Ad CTR Improvement - Scenario 1			Scenario 2 + 30% Revenue			Scenario 3			Scenario 4
17		Conversion	Goal		Conversion	Goal		Conversion	Goal		Conversion	Goal
18	Impressions		20000	Impressions		20000	Impressions		20000	Impressions		20000
19	CTR	0.40%	80	CTR	0.50%	100	CTR	0.60%	120	CTR	0.70%	140
20	MQLs	30%	24	MQLs	30%	30	MQLs	30%	36	MQLs	30%	42
21	Meetings	50%	12	Meetings	50%	15	Meetings	50%	18	Meetings	50%	21
22	SQLs	75%	9	SQLs	75%	11	SQLs	75%	14	SQLs	75%	16
23	Wins	33%	3	Wins	33%	4	Wins	33%	4	Wins	33%	5
24
25	Avg. Sale Price	Qtrly Wins	Revenue	Avg. Sale Price	Qtrly Wins	Revenue	Avg. Sale Price	Qtrly Wins	Revenue	Avg. Sale Price	Qtrly Wins	Revenue
26	$20,000	3	$277,992	$20,000	4	$347,490	$20,000	4	$416,988	$20,000	5	$486,486
27
28
29
30	Prospecting with Continuous Down Funnel Improvements - Scenario 1			Scenario 2 + 100%			Scenario 3			Scenario 4
31		Conversion	Goal		Conversion	Goal		Conversion	Goal		Conversion	Goal
32	Leads (Form Fills & Known Prospects)		25000	Leads (Form Fills & Known Prospects)		25000	Leads (Form Fills & Known Prospects)		25000	Leads (Form Fills & Known Prospects)		25000
33	MQLs	0.5%	125	MQLs	1%	250	MQLs	1%	250	MQLs	1%	250
34	Meetings	20%	25	Meetings	20%	50	Meetings	25%	63	Meetings	25%	63
35	SQLs	75%	19	SQLs	75%	38	SQLs	75%	47	SQLs	80%	50
36	Wins	33%	6	Wins	33%	12	Wins	33%	15	Wins	33%	17
37
38	Avg. Sale Price	Qtrly Wins	Revenue	Avg. Sale Price	Qtrly Wins	Revenue	Avg. Sale Price	Qtrly Wins	Revenue	Avg. Sale Price	Qtrly Wins	Revenue
39	$20,000	6	$579,150	$20,000	12	$1,158,300	$20,000	15	$1,447,875	$20,000	17	$1,544,400
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