NerdMarketing.com CPA, ROAS, ROMI Calcs

	A	B	C	D	E
1		Ad Campaign #1	Ad Campaign #2	Facebook Ads	Amazon Ads

2	Variables
3	Gross Margin %	35%	35%	35%	35%
4	Variable cost per order	$ 5.00	$ 5.00	$ 5.00	$ 5.00
5	AOV	$ 100.00	$ 100.00	$ 100.00	$ 100.00
6
7	Campaign
8	Impressions	1000	1500	1000	500
9	Clicks (Visits)	50	80	50	5
10	Conversions (Transactions)	30	35	10	2
11	Unique customers acquired	29	30	10	2
12	Revenue pre-discount	$ 4,000.00	$ 3,500.00	$ 1,000.00	$ 200.00
13	Campaign Cost	$ 200.00	$ 250.00	$ 50.00	$ 50.00
14	Discount Amount	15%	5%	0	0
15
16	CPA Calc
17	Clickthru Rate (CTR)	5.00%	5.33%	5.00%	1.00%
18	Ave Cost per Click (CPC)	$ 4.00	$ 3.13	$ 1.00	$ 10.00
19	Cost per Acquisition (CPA)	$ 6.90	$ 8.33	$ 5.00	$ 25.00
20
21	ROMI Calc
22	Gross Margin (in $)	$ 1,400.00	$ 1,225.00	$ 350.00	$ 70.00
23	Variable Overhead Cost	$ 150.00	$ 175.00	$ 50.00	$ 10.00
24	Gross Profit	$ 1,250.00	$ 1,050.00	$ 300.00	$ 60.00
25	Discount Cost	$ 600.00	$ 175.00	$ -	$ -
26	Net Profit before Marketing Expense	$ 650.00	$ 875.00	$ 300.00	$ 60.00
27	Marketing Expense	$ 200.00	$ 250.00	$ 50.00	$ 50.00
28	Net Profit	$ 450.00	$ 625.00	$ 250.00	$ 10.00
29	"Amount you paid"	$ 800.00	$ 425.00	$ 50.00	$ 50.00
30	"Amount you made"	$ 450.00	$ 625.00	$ 250.00	$ 10.00
31
32	ROAS	17	13	20	4
33	ROMI	56%	147%	500%	20%
34	Annualized ROMI	675%	1765%	6000%	240%
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