- Promotions and settlements · TPM
- CFO / Finance, Accounting / Analytics, Operations Manager
- Retail and branch networks, Manufacturing, Logistics and warehousing
Promotion ROI calculation: a formula, a worked example and common errors
In short
Promotion ROI is the incremental margin a promotion earned minus its total cost, divided by that cost. To calculate it you need the sales above baseline, the margin on those sales and every cost of the terms, including bonuses and free goods. The most common error is counting all sales in the period as the promotion's result. Remanently Trade Marketing keeps cost and turnover together so the figures are available for the calculation.
The formula
Promotion ROI compares what the promotion earned with what it cost.
ROI = (incremental margin minus total promotion cost) divided by total promotion cost
Each part needs a definition, because most disagreements about ROI are really disagreements about these parts.
- Incremental sales: actual sales in the period minus baseline sales.
- Incremental margin: incremental sales multiplied by the margin per unit or per currency unit, before the promotion cost.
- Total promotion cost: discounts given, free goods at their cost, bonuses earned, credit notes and any contribution to the customer's activity.
Agree on these with finance before the first calculation. The number is only as credible as the definitions behind it.
A worked example
A supplier runs a six-week promotion for one distributor on a single product.
| Item | Value |
|---|---|
| Baseline sales for six weeks | 6,000 units |
| Actual sales in the promotion | 8,400 units |
| Incremental units | 2,400 |
| Regular price per unit | 10.00 |
| Margin before promotion | 40% (4.00 per unit) |
| Discount during promotion | 1.00 per unit on all 8,400 units |
| Bonus earned on crossing a volume threshold | 1,500 |
Step 1: incremental margin. The 2,400 extra units earn 4.00 each at the regular margin, so 9,600. But the discount also reduces margin on the 6,000 baseline units, which would have sold anyway.
Step 2: total cost. The discount on all 8,400 units is 8,400. Add the bonus of 1,500. Total cost is 9,900.
Step 3: ROI. Incremental margin of 9,600 minus cost of 9,900 gives minus 300. Divided by 9,900, ROI is about minus 3%. The promotion sold 40% more units and lost money.
Look at the sales report alone and this promotion looks like a success. This is why trade promotion effectiveness is measured on cost, not turnover. The numbers here are illustrative only.
Where the worked example could change
Small changes in assumptions move the answer, so test them.
- If the discount applied only to units above baseline, cost falls sharply and ROI turns positive. Terms design matters as much as volume.
- If part of the 2,400 units was pulled forward from the next period, true increment is lower and ROI worse. Check the weeks after the promotion.
- If the bonus threshold had been set 10% higher and the distributor missed it, the cost of 1,500 would not have been paid. The tier placement was a decision with a price.
Common errors
- Counting all promotion sales as the result. Only the increment above baseline counts.
- Using revenue instead of margin. Extra revenue at a low margin can be worth less than the cost of the terms.
- Leaving out later costs. Bonuses and credit notes arrive after the period. If the calculation is done before they are settled, ROI is overstated.
- Ignoring free goods. Free units have a cost even though they have no price on the invoice.
- Ignoring the discount on baseline units. This is often the largest part of the cost.
- A baseline chosen after the fact. Set the method before launch, or the baseline will drift toward the answer people want.
Reporting the result
Show ROI together with its inputs: baseline, incremental units, margin and each cost line. A bare percentage invites argument, while a short table lets a reader challenge one assumption without rejecting the whole result. Keep the same layout for every campaign so results can be compared side by side.
Who needs the number
The CFO uses ROI to compare campaigns competing for the same budget. Accounting checks that the cost side matches credit notes and provisions. The sales manager uses it to decide which terms to offer next year. Because they use the same number for different purposes, it helps to publish the method once and keep it fixed.
Using the example to set rules
The loss in the example came from one design choice: the discount covered every unit instead of only the units above baseline. Before approving a term, ask what share of the discount lands on sales that would have happened anyway. Where that share is high, change the structure: a threshold set above the normal run rate, a bonus that applies only to the increment, or a smaller discount over a shorter period.
A second rule concerns timing. Do not report ROI until the last bonus and credit note for the campaign are settled. A figure produced earlier is an estimate and should be labeled as one. Finance and sales then see the same final number, and the number stops moving after it is published.
Calculating before and after
The same arithmetic works in two directions. Before launch, you enter planned turnover and planned cost and see the expected ROI. After the campaign you replace the plan with actuals. The gap between the two is a lesson about your baseline and about the response of customers. See trade promotion optimization for how to use that gap.
If the budget side of the question interests you, trade spend management covers how to keep the cost visible across all campaigns.
Getting the inputs from one place
The formula is simple. Collecting inputs is the work: discounts from one file, bonuses from another, turnover from a third. Remanently Trade Marketing keeps budgets, price lists, turnover, promotions and bonuses in one process, calculates which terms and tiers were met from sales data, and supports profitability simulations before launch in its extended scope. That gives you the cost and turnover figures the ROI calculation needs without rebuilding them each time. See the Trade Marketing page or ask for a demo with one of your own promotions.
Frequently asked questions
What is a good promotion ROI?
There is no universal figure. A positive ROI means the incremental margin covered the full cost. Companies often set an internal minimum that reflects the other uses of the same budget.
Should ROI use revenue or margin?
Margin. Extra revenue at a thin margin can be worth less than the cost of the terms that produced it, so revenue-based ROI overstates results.
When should I calculate ROI, before or after the promotion?
Both. Before launch, use planned turnover and planned cost to estimate it. After the campaign and after bonuses are settled, replace the plan with actuals and compare.
Why is my promotion ROI negative when sales rose?
Usually because the discount applied to baseline units that would have sold anyway, or because bonuses and free goods added cost that the sales report does not show.
Can Remanently Trade Marketing calculate ROI?
It keeps the cost of terms and the turnover in one process, calculates condition and tier fulfillment from sales data and shows profitability as sales result against cost. Profitability simulations before launch are part of the extended scope.
Run the calculation on your own promotion
Bring one promotion, its terms and its turnover to a short demo. We will enter them in Remanently Trade Marketing and show the cost against the result.
Module: Remanently Trade Marketing (TPM) · Pricing · Contact · Get started