Advertising ROI Calculator

How to Use the Advertising ROI Calculator

Marketing reports return on revenue; finance reports return on profit. The gap between those two numbers is the cost of goods, and it is usually enormous. This calculator produces the version a finance team will accept, which is the version worth taking into a budget conversation.

1. Enter the media spend. What actually went to the platforms, for one campaign or channel over one period.
2. Enter the revenue generated. Attributed revenue, and be conscious of the attribution window — a thirty-day view-through model reports far more than a seven-day click model for identical spend.
3. Enter your gross margin. This is the step that separates a marketing return from a real one. Revenue is not money you keep; gross profit is closer.
4. Add agency, creative and tooling costs. These never appear in a platform dashboard and are frequently 10% to 20% of the media spend. Leaving them out is the most common way an advertising return gets overstated.
5. Compare the two ROI figures. The calculator shows the revenue-based version alongside the gross-profit one, deliberately, so the size of the gap is visible.

If the two numbers differ by a factor of ten, that is not an error — it is what measuring against revenue does.

Advertising ROI Formula

Revenue down to gross profit first, and only then the costs.

Note that the denominator is total campaign cost, not media spend alone. A campaign that spends $23,500 on media and $3,200 on an agency has cost $26,700, and measuring the return against only part of what it cost is the same category of error as measuring it against revenue.

Example

$23,500 of media, $3,200 of agency, $91,650 of revenue

1. Gross profit: 91,650 × 0.38 = $34,827.
2. Total campaign cost: 23,500 + 3,200 = $26,700.
3. Profit: 34,827 − 26,700 = $8,127.
4. Advertising ROI: 8,127 ÷ 26,700 × 100 = 30.44%.
5. For comparison, ROI measured on revenue: (91,650 − 23,500) ÷ 23,500 = 290.00%.
6. The headline ROAS is 3.90, against a break-even of 2.63.

Three numbers for one campaign

290%, 3.90 and 30.44% all describe the same campaign. The first ignores the cost of the goods entirely. The second ignores it and the agency fee. Only the third answers the question a finance director is actually asking, which is what the business earned on the money it committed. Presenting the first in a board paper is how marketing budgets lose credibility the following quarter.

What the agency fee costs in return terms

Without the $3,200 of agency and creative cost, the return would be 34,827 − 23,500 = $11,327 on $23,500, or 48.20%. Including it takes the figure to 30.44%. That is a substantial difference from a cost many reports simply omit, and it is the honest basis on which to judge whether the agency is earning its fee.

Two Break-Evens and What Each Is For

The same revenue at different levels of media efficiency.

The second row sits almost exactly at zero, and it is worth noting where: a ROAS of 2.89, comfortably above the 2.63 break-even calculated from margin alone. The difference is the $3,200 of agency and creative cost, which raises the real break-even by about a quarter of a point of ROAS.

That is the practical consequence of counting every cost. Break-even ROAS from gross margin is the right number for judging whether an individual campaign is worth running, because the agency fee is paid whether or not that specific campaign runs. The higher figure, including fixed campaign costs, is the right number for judging whether the whole advertising programme is worth having. Confusing the two leads to either over-cutting individual campaigns or over-defending the programme.

A return of 30.44% deserves one more comparison before anyone celebrates: against what else the money could do. If the business earns 12% on capital elsewhere, this is excellent. If it has projects returning 60%, advertising is the weaker use of the same money, and the business ROI calculator is the right place to run that comparison properly.

Five Reasons the Reported Return Flatters

Five reasons the reported return is usually better than the real one.

Attribution is generous. Platforms count orders they influenced only loosely, and several channels claim the same sale. A thirty-day view-through window can report 30% more revenue than a seven-day click window for identical spend.

Existing customers are counted as wins. Retargeting frequently captures people who were going to buy anyway. The incremental return — what the campaign added rather than what it was present for — is lower, sometimes dramatically.

Internal time is invisible. The people managing the campaign cost money. A half-time marketer on a $23,500 monthly budget adds real cost that belongs in the other-costs field.

Returns and refunds arrive later. Revenue is booked at the sale; the refund shows up weeks afterwards and rarely gets deducted from the campaign that generated it. On a 6% return rate that is a straight 6% overstatement.

The margin used is optimistic. Gross margin quoted from memory is usually the best product rather than the actual mix. Since every figure here scales with it, that single input deserves more care than the rest of the page combined — build it with the gross profit calculator rather than estimating.

There is one measurement that cuts through all five, and it is worth the inconvenience: a holdout. Withhold advertising from a defined region or audience segment for a few weeks and compare its sales against the rest. The difference is the incremental effect, with no attribution model involved at all. It costs real revenue to run and it is the only method that answers the question everyone is actually asking, which is what would have happened anyway.

Most organisations never run one, because turning off advertising feels reckless and the result is often uncomfortable. That combination is precisely why the exercise is valuable — a channel that survives a holdout test can be funded with confidence for years afterwards.

None of that makes the exercise pointless. It makes the direction of the error predictable, which is more useful: if a campaign only just clears break-even on reported figures, it is almost certainly losing money in reality, and that is a decision you can act on with confidence.