| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Advertising Projections Sheet | ||||||||||||||||||
2 | Platform | Tactic | % of total spend | Spend | Daily spend | CPC | Clicks | CTR | Impressions | Conv. Rate | Leads | Cost per Lead | Lead --> Client Rate | Converted Leads | CPA (sale) | Avg order value | Revenue | ROAS | Compared to Projections |
3 | Search | 40% | $2,000.00 | $66.67 | $2.00 | 1,000 | 5.00% | 20,000 | 10.00% | 100 | 20.00 | 10.00% | 10 | $200.00 | $750.00 | $7,500.00 | 375.00% | ||
4 | |||||||||||||||||||
5 | Display | 20% | $1,000.00 | $33.33 | $0.50 | 2,000 | 1.00% | 200,000 | 5.00% | 100 | 10.00 | 10.00% | 10 | $100.00 | $750.00 | $7,500.00 | 750.00% | ||
6 | |||||||||||||||||||
7 | Acquisition | 20% | $1,000.00 | $33.33 | $0.50 | 2,000 | 2.00% | 100,000 | 5.00% | 100 | 10.00 | 10.00% | 10 | $100.00 | $750.00 | $7,500.00 | 750.00% | ||
8 | |||||||||||||||||||
9 | Remarketing | 20% | $1,000.00 | $33.33 | $1.00 | 1,000 | 3.00% | 33,333 | 8.00% | 80 | 12.50 | 10.00% | 8 | $125.00 | $750.00 | $6,000.00 | 600.00% | ||
10 | |||||||||||||||||||
11 | Total | Total | 100% | $5,000.00 | $166.67 | $0.83 | 6,000 | 1.70% | 353,333 | 6.33% | 380 | 13.16 | 10.00% | 38 | $131.58 | $750.00 | $28,500.00 | 570.00% | |
12 | |||||||||||||||||||
13 | |||||||||||||||||||
14 | Monthly Budget: | $5,000.00 | |||||||||||||||||
15 | |||||||||||||||||||
16 | |||||||||||||||||||
17 | = can be modified | ||||||||||||||||||
18 | |||||||||||||||||||
19 | |||||||||||||||||||
20 | |||||||||||||||||||