ABCDEJKLMNOPQRSTUVWXYZ
1
Q2 ActualsCell Color Legend
2
Current DetailsModelGoogle Ads - SearchGoogle Ads - DisplayLinkedIn - Convo AdsTotalInput Raw Data
3
Total Spend$10,000$30,000$30,000$30,000$90,000Totals
4
Leads1601609564781,594Formulas
5
Demos70705731158
6
Deals20254130.00
7
Est. Revenue (Annual)$120,000$150,000$24,000$6,000$180,000
8
Cost-Per-Lead$63$188$31$63$56
9
Cost-Per-Demo$143$429$526$968$570
10
11
Current DetailsModelGoogle Ads - SearchGoogle Ads - DisplayLinkedIn - Convo AdsTotalAssumptions% IncreaseIncremental ROI
12
Avg. Contract Value (Annual)$6,000$6,000$6,000$6,000$6,000Lead > Demo0.00%$0.00
13
Demo > Deal (Close Rate)29%36%7%3%19.0%
14
Lead > Demo44%44%6%6%10%
15
16
Lifetime Value (LTV):ModelGoogle Ads - SearchGoogle Ads - DisplayLinkedIn - Convo AdsTotal
17
Gross Margin (GM%):65%65%65%65%65%
18
Lifespan of a customer (months):1212121212
19
Monthly Avg. Order Value$500$500$500$500$500
20
Lifetime Value (LTV)$12,000$3,900$3,900$3,900$3,900
21
ROI$230,000$67,500-$14,400-$26,100$27,000
22
LTV:CAC Ratio24.003.250.520.131.30
23
24
25
Q3 ProjectionsChannelQuarterly Demo GoalDemo % IncreaseSpend RequiredIncrease in SpendIncremental ROI
26
Current DetailsModelGoogle Ads - SearchGoogle Ads - DisplayLinkedIn - Convo AdsTotalGoogle Ads - Search10043%$42,857$12,857$28,929
27
Total Cost$42,857$52,632$96,774$192,263Google Ads - Display10075%$52,632$22,632-$10,863
28
Leads2291,6771,5423,448LinkedIn - Convo Ads100223%$96,774$66,774-$58,094
29
Demos100100100400LinkedIn - Sponsored Content1000%$0$0$0
30
Deals35.77.03.246Channel Ex. 10%$0$0$0
31
Revenue (Annual)$214,286$42,105$19,355$275,746Channel Ex. 20%$0$0$0
32
Cost-Per-Lead$188$31$63$56Channel Ex. 30%$0$0$0
33
Cost-Per-Demo$429$526$968$481Total400340.88%$192,262.92$102,262.92-$40,028.13
34
35
AssumptionsModelGoogle Ads - SearchGoogle Ads - DisplayLinkedIn - Convo AdsTotal
36
Avg. Contract Value (Annual)$6,000$6,000$6,000$6,000
37
Demo > Deal (Close Rate)36%7%3%11%
38
Lead > Demo44%6%6%12%
39
40
Lifetime Value (LTV):ModelGoogle Ads - SearchGoogle Ads - DisplayLinkedIn - Convo AdsTotal
41
Gross Margin (GM%):60%60%60%60%
42
Lifespan of a customer (months):18181818
43
Monthly Avg. Order Value$500$500$500$500
44
Lifetime Value (LTV)$5,400$5,400$5,400$5,400
45
ROI$150,000-$14,737-$79,355$55,908
46
LTV:CAC Ratio4.500.720.181.29
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