Share
Explore

How to make a media plan and calculate the desire results?

Clear table
Base version
Channel
Budget
Cost Per Visitor, $
Traffic
Add-to-Cart Rate, %
Add-to-Carts
Conversion to paid order, %
Paid Orders
Average Order Value
Revenue
1
Facebook
$50,000
000
1.9
26,316
000
38
10,000
000
41
4,100
$120.00
$492,000.00
2
Google
$40,000
000
1.3
30,769
000
34
10,461
000
37
3,871
$110.00
$425,810.00
3
TikTok
$15,000
000
0.8
18,750
000
52
9,750
000
34
3,315
$140.00
$464,100.00
4
Email-marketing
$10,000
000
0.8
12,500
000
80
10,000
000
47
4,700
$170.00
$799,000.00
There are no rows in this table
$115,000
Sum
1.2
Average
88,335
Sum
51
Average
40,211
Sum
39.75
Average
15,986
Sum
$135.00
Average
$2,180,910.00
Sum

Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.