| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||
3 | ||||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||
5 | ||||||||||||||||||||||||||
6 | Conversion Metrics & ROI Calculators | |||||||||||||||||||||||||
7 | ||||||||||||||||||||||||||
8 | Across the next few tabs, you'll find three different calculators to help you forecast performance, estimate Max CPC limits and Target CPAs, and calculate Return on Investments (ROI) and Profits on Investments (POI) | |||||||||||||||||||||||||
9 | ROI & Breakeven ROAS Calculator is the most complicated due to the different elements. In essence though, change the Profit Margin % to represent the average Profit Margin for the business/account. Then change all the other green fields (Ad Spend and ROAS/Revenue). Row 5 allows you to calculate the required ROAS to achieve the Revenue Target Row 6 allows you to calculate the required Revenue to achieve the ROAS Target Conversion Metric Calculator and Conv. Value Projections are similar tools. Change the metrics in the white cells to calculate the metric in the yellow cells. | |||||||||||||||||||||||||