Marketing Budget - Template

	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2	High-level
3
4	Overall			CAC			Efficiency
5	Budget	$2,130,900		Fully-loaded	$68.08		LTV : CAC	4 : 1
6	Spend to date	$528,065		Channel CAC			CAC Payback	4.3
7	On pace for	$2,056,022		Search Ads	$41.00
8	+/-	$74,878		Social Ads	$94.97
9				Events	$10.00
10				Content	$7.66
11
12
13
14
15	Budget breakdown		Coca-Cola	Balanced	Established	Expansion	Emerging	Ours
16	Always-on channels		70	60	80	60	50	60
17	Test-and-learn channels		20	20	5	15	40	10
18	Long-term channels			20	15	25	10	20
19	Moonshot		10					10
20
21	Math
22	👇👇👇
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41	By Month		Jan 2022	Feb 2022	Mar 2022	Apr 2022	May 2022	Jun 2022	Jul 2022	Aug 2022	Sep 2022	Oct 2022	Nov 2022	Dec 2022
42	Budget		$177,575	$44,005	$171,335	$6,240	$10,591	$10,911	$12,504	$10,000	$0	$0	$0	$0
43	Spend		$127,089	$130,930	$150,047	$120,000	$0	$0	$0	$0	$0	$0	$0	$0
44	+/-		$50,486	-$86,924	$21,289	-$113,760	$10,591	$10,911	$12,504	$10,000	$0	$0	$0	$0
45	Fully-loaded CAC		$59.89	$61.33	$68.08
46	Channel CAC
47	Search Ads		$48	$35	$41
48	Social Ads		$70	$31	$95
49	Events		$10
50	Content		$19	$2	$8
51	LTV : CAC		5 : 1	4 : 1	4 : 1
52	CAC Payback		4.0	4.1	4.3
53
54	Channel spend
55	Search Ads		$676	$589	$656
56	Social Ads		$836	$312	$760
57	Events		$2,500	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
58	Content		$8,000	$1,000	$3,500	$3,500	$0	$0	$0	$0	$0	$0	$0	$0
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