ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions:Please make a copy of this workbook to edit. There are several calculators in this workbook that you can use to help you with ad planning, channel and partner budget allocation and forecasting exercises. Every business is different and may require inputs that do not reflect what we've shared here. Before jumping into the calculators, we recommend you pull your historical metrics and industry or model related benchmarks to use as a more relevant proxy in the calculators. These are basic scenarios. Depending on the complexity of your business, you may want to hire an expert to build a more robust and relevant model. Use logic to gut check any outputs from these calculators, and make sure your math adds up!
2
3
4
5
6
7
8
Benchmarks or metrics you'll want to know before using the calculatorsCVR% Conversion Rate
9
AOVAverage Order Value
10
CACCost to Acquire a Customer
11
CPLCost per Lead
12
CPVCost per Video View
13
ROASReturn on Ad Spend
14
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