(Example) Quant Marketing Plan

	A	B	C	D	E	F	G	H	I	J	K
1	Case Example: Bakery Cafe (Baking Kits)
2
3	Revenue per conversion (avg)
4	200	people
5	50	RM10,000.00
6	Source	Traffic	Conversions	Leads (prospects)	Conversion %	Conversions	Revenue Per User	Total Revenue	Marketing Cost	CAC (Customer Acquisition Cost)
7	Facebook Groups	500	10.00%	50	20.00%	10	RM90.00	RM900.00	RM500.00	RM50.00
8	Facebook ads	10,000	2%	200	5%	10	RM90.00	RM900.00	RM300.00	RM30.00
9	Email list
10	Events
11	Partner up with restaurants
12	Friends & Family
13	TikTok organic
14	Physical Workshop	50	30%	15
15	Total					20	90		RM800.00	RM40.00	(Avg. Acquisition Cost)
16
17
18
19	Total Revenue (RM2000 AOV)								RM30,000.00
20	Profit								RM29,200.00
21
22
23
24	Customer CLTV	RM2,160.00
25	# Customers Acquired	20
26	Potential Revenue	RM43,200.00
27
28	Plan Marketing Budget
29	Number of customers you want	600
30	Average CAC	RM40.00
31	Yearly Marketing Budget	RM24,000.00
32	Potential Revenue	RM54,000.00
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