Ad Spend ROI Calculator: Calculate ad spend roi calculator in Seconds

Calculate ROI on advertising spend. Measure campaign performance. This tool helps you calculate, understand, and optimize this metric for your business.

By Veira Finance Expert, Finance Advisor at VeiraPublished June 2024Updated June 2024
Calculator
Result
Profit after ad spend: KES 24,000
Ad spendKES 60,000
Revenue attributed to itKES 280,000
Gross profit at 30% marginKES 84,000
Profit after the ad spendKES 24,000
Return on ad spend4.67x
Break-even return on ad spend3.33x

The number that matters is the break-even figure: at a 30% margin you need 3.33x revenue per shilling of spend just to cover the campaign. Anything below that loses money however good the revenue looks. Most advertising judged a success on revenue alone fails this test, because margin is never applied.

Automate this
Want Veira to do this for every sale, every shift, every branch, automatically?

Revenue is not the test

Advertising judged on revenue alone almost always looks successful, because revenue ignores what the goods cost. The test is whether gross profit on the attributed revenue exceeds the spend.

The break-even return on ad spend follows from your margin: at a 30% margin you need 3.33 shillings of revenue per shilling spent just to stand still. At a 20% margin you need 5. Most campaigns that get repeated have never been measured against that line.

Attribution is the weak input

The figure this calculation is most sensitive to is the revenue you attribute to the campaign, and it is the one hardest to get right. Be conservative: count what you can trace, not what coincided.

A simple honest method for a small shop is to compare the same weekday in the weeks before and during, and attribute only the difference.

Prefer this running automatically, on every sale, with no manual entry?

Sign Up

Worked examples

KES 60,000 spend, KES 280,000 attributed revenue, 30% margin
  • Gross profit KES 84,000
  • Profit after spend KES 24,000
  • Return on ad spend 4.67x against a 3.33x break-even

Frequently asked questions

How do I measure return on ad spend?
Apply your gross margin to the revenue you can attribute to the campaign, then subtract the spend. Revenue alone ignores what the goods cost and makes almost any campaign look successful.
What is break-even ROAS?
One hundred divided by your gross margin percentage. At a 30% margin it is 3.33x, at 20% it is 5x. Below that line the campaign loses money however good the revenue looks.
How do I attribute revenue to a campaign?
Be conservative and count only what you can trace. For a small shop, comparing the same weekday before and during the campaign and attributing only the difference is a defensible method.
Should I include staff time in ad spend?
Yes if someone spends meaningful time on it. Campaigns that look profitable on media cost alone often are not once the time is counted.

Doing this by hand every time? Veira runs the same calculation automatically on every sale, no spreadsheet required.

Need help, or want to talk it through first? Chat with us on WhatsApp