ABCDEFGHIJKLMNO
1
 Make a COPY to edit. How to: *See Top Left. File > "Make a copy."
2
What is CLV: https://docs.google.com/document/d/1ensAl_R5x1a3S3P9WJh-JrybPT7Lw08dbDoOMFrxhFU/edit#
3
4
5
Customer Lifetime Value (CLV)Suggested Minimum Investment11%Projected Campaign ROI
6
 $ 1,600 $ 10,560 $ 96,000
7
8
9
10
Cost per Customer
11
$176.00
12
13
Fill Below this Line.
14
15
Average Purchase ValueProjected New Customers / Leads per Campaign
16
 $ 400.00 60
17
18
Patronage (Customer Life Span * Purchase Frequency)
19
4
20
21
22
Example using "Botox" from the Cosmetics tab below. Priced @ $408.00 with 4 treatments a year. How many Botox treatments needed per Year
23
Source - Suggested Minimum Investment What is a good Marketing Budget?
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