Enter your ad spend and the revenue it brought in. You get your return on ad spend (ROAS), as a ratio and as a percentage, and your advertising cost of sales (ACoS). Add your gross margin to see your break-even ROAS, the point below which the ads cost more than the profit they bring in. You can also start from a target ROAS to find the revenue you need or the most you can spend. Every step is shown.
Choose what to work out
'ROAS' measures a campaign from what it cost and what it brought in. 'Revenue' gives the sales a budget has to generate to meet your target ROAS. 'Max spend' gives the most you can spend for a revenue goal without falling below that target.
Figures excluding VAT, for the same period
Turnover is measured after deducting VAT, so take VAT out of your sales if your tracking records VAT-inclusive basket values; otherwise the ROAS looks better than it is. For spend, count everything the ad platform charged, fees included, excluding VAT if you reclaim it. Use sales and spend for the same period. If several platforms each claim the same sale, their revenue figures add up to more than you actually sold: for an overall ROAS, divide your total revenue by your total ad spend.
Gross margin and break-even ROAS
Gross margin here is your profit as a share of the selling price excluding VAT: (selling price − cost of the product) ÷ selling price. It is not the markup, which is worked out on cost. For an accurate break-even point, also take off what each sale costs you to fulfil: delivery, payment fees and marketplace commission. Your break-even ROAS is 1 ÷ gross margin: at 40%, each pound of advertising must bring in at least £2.50 of revenue to pay for itself.
Rounding
Amounts are rounded to the nearest penny, with halves rounded up. Two figures are rounded the safe way, so that the target ROAS is still met: the revenue needed is rounded up to the penny and the maximum spend down to the penny (for a £200 revenue goal at a target ROAS of 3, the maximum spend is £66.66, not £66.67). The ROAS and the break-even ROAS are rounded to two decimal places, the ROAS percentage to a whole number, and the ACoS and the ROI to two decimal places. Each line of the workings uses only figures shown in the workings, so you can check it by hand.
ROAS = revenue excl. VAT ÷ ad spend excl. VAT; as a percentage: ROAS × 100.
ACoS = ad spend ÷ revenue × 100 = 100 ÷ ROAS.
Revenue needed = ad spend × target ROAS; maximum spend = revenue goal ÷ target ROAS.
Break-even ROAS = 1 ÷ gross margin.
Profit after ad spend = revenue × gross margin − ad spend; ROI = profit after ad spend ÷ ad spend.
Example: £800 of ads for £3,600 of sales
An online shop spends £800.00 on social media ads in a month, and the sales attributed to them come to £3,600.00, both excluding VAT. Its ROAS is £3,600.00 ÷ £800.00 = 4.5, or 450%, and its ACoS is 22.22%. At a 30% gross margin its break-even ROAS is 1 ÷ 30% = 3.33. The gross profit on those sales, £1,080.00, pays for the £800.00 of ads and leaves £280.00, an ROI of 35%. To hit a ROAS of 6 on the same budget, it would need £4,800.00 of sales.