Marketing forecasting template

	A	B	C	E	F	H	I	K	L
1	Return on ad spend calculator			Yellow = fill in your own numbers;	the rest will update automatically
2
3		Search ads		YouTube ads		Facebook ads		Quora ads
4		New patients/month wanted	100	New patients/month wanted	100	New patients/month wanted	100	New patients/month wanted	100
5		Lead to patient CVR	30%	Lead to patient CVR	5%	Lead to patient CVR	5%	Lead to patient CVR	5%
6		Leads needed	333	Leads needed	2,000	Leads needed	2,000	Leads needed	2,000
7		Landing page CVR	20%	Landing page CVR	25%	Landing page CVR	25%	Landing page CVR	25%
8		Landing page traffic needed	1,667	Landing page traffic needed	8,000	Landing page traffic needed	8,000	Landing page traffic needed	8,000
9		Ad CTR	5%	Ad CTR	1%	Ad CTR 1%	1.0%	Ad CTR	1.0%
10		Impressions needed	33,333	Impressions needed	800,000	Impressions needed	800,000	Impressions needed	800,000
11		Impressions -> CPMs needed	33	Impressions -> CPMs needed	800	Impressions -> CPMs needed	800	Impressions -> CPMs needed	800
12		CPM	$25.0	CPM	$5.0	CPM	$5.0	CPM	$5.0
13		Ad spend	$833	Ad spend	$4,000	Ad spend	$4,000	Ad spend	$4,000
14		Est. cost per patient	$8	Est. cost per patient	$40	Est. cost per patient	$40	Est. cost per patient	$40
15
16
17
18
19
20
21
22
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