ABDEFGHIJKLMNOPQRSTUVWX
1
30-Day Campaign
2
3
4
Feel free to make a copy of this document and use as a template.
5
Outlined Boxes with a yellow fill are cells for user input
→
6
7
8
Assumptions:
7,000 impressions (hedged from 10,000)
9
5% conversion rate (this is a B2B business)
10
4% CTR
11
12
13
Monthly Ad Case Study
Google Ads
14
15
Ad Spend ($50/day)$1,500.00
16
Impressions7,000
17
Cost per Thousand Impression (CPM)$0.21
18
New Leads280
19
Click-Through Rate (CTR)4.00%
20
Conversion %5%
21
New Customers14
22
Avg Order Value (AOV)$2,000.00
23
Revenue$28,000.00
24
Agency Fees$450.00
25
26
27
Customer Acquisition Cost (CAC)$1,950.00
28
Customer Lifetime Value (LTV)$28,000.00
29
LTV/CAC14.36
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