| A | B | C | |
|---|---|---|---|
1 | To edit this file, duplicate it into your Google account: File> make a copy | ||
2 | E-commerce Ad Cost/Revenue Calculator | ||
3 | Fill in the red highlighted squares with your specific business goals & metrics. The green highlighted squares can be manipulated with different figures to predict alternate outcomes | ||
4 | STEP 1 | ||
5 | |||
6 | |||
7 | Enter Revenue Target: | $15,000.00 | |
8 | Enter Average Order Value: | $553.00 | |
9 | Number of sales at Price Point required to hit revenue targets: | 27.12477396 | <--Do not edit this cell |
10 | |||
11 | STEP 2 | ||
12 | |||
13 | Website conversion rate(current or projected) | 7.2% | <-- look for your industry benchmark(overall avg is 1-3%) |
14 | Link clicks required | 375 | |
15 | Ad CTR(Click through rate) | 1.5% | |
16 | Estimated CPC(Cost Per Click) | $0.6 | |
17 | Reach required to hit targets | 24,977 | |
18 | Impressions required to hit targets(7x frequency) | 108,399 | |
19 | Impressions required to hit targets(5x frequency) | 77,428 | |
20 | RESULTS | ||
21 | |||
22 | Ad Spend Required | $232 | |
23 | Cost Per Sale (CPA- Estimated) | $9 | |
24 | ROAS(Return on Ad Spend) | 64.58 | |
25 | Net Revenue(pre operating expense) | $14,767.72 |