What Is Trade Spend ROI? Formula, Calculation, and a Worked Example

Trade spend is one of the largest line items in consumer packaged goods, and one of the least measured. Industry estimates commonly put it at roughly 20% or more of a manufacturer's gross revenue — second only to the cost of the product itself. Yet most of that money gets evaluated with a glance at one number: did volume go up during the promotion?

It usually did. That doesn't mean the promotion made money.

Trade spend ROI is the discipline of answering the real question — did this promotion earn back more than it cost? — with numbers you can defend. This post covers what trade spend ROI means, the formula, the three inputs people get wrong, and a full worked example you can copy.

What trade spend ROI actually means

Trade spend is the money a manufacturer pays to move product through a retailer: temporary price reductions (TPRs), buy-one-get-one deals (BOGOs), off-invoice allowances, bill-backs, slotting fees, and display money. Trade spend ROI measures the return on that money — specifically, the extra profit the spend generated versus what it cost.

In one sentence: Trade spend ROI is the incremental margin a promotion produced, divided by what the promotion cost you.

The word that does all the work there is incremental. Generic marketing ROI often credits a campaign with all the sales that happened during it. Trade spend ROI does not. A promotion only deserves credit for the units it actually caused — the ones you would not have sold at full price. Everything else is volume you were going to get anyway, and paying to discount it is pure cost.

That single distinction is why a promotion can post a healthy-looking sales bump and still lose money on every case.

The trade spend ROI formula

The clean version of the formula is:

Trade Spend ROI = (Incremental Margin − Trade Spend) ÷ Trade Spend

Where:

• Incremental Margin is your incremental units multiplied by your normal per-case gross margin — the value of the extra product the promotion moved.
• Trade Spend is the full promotional cost: the per-case allowance applied to every discounted case, plus any fixed fees (display, slotting, ad money).

A result of 0% means you broke even. Positive means the promotion paid for itself. Negative means you spent more than you earned back.

There is a simpler ratio version that's useful for quick gut checks — incremental margin divided by trade spend, read as "dollars returned per dollar spent." A 1.0 is break-even; 0.50 means you got fifty cents back for every dollar.

Three inputs decide whether the answer is honest:

1. The baseline. Get this wrong and every other number is wrong. More on it below.
2. Incremental vs. total volume. Credit only the units above baseline. Crediting total volume is the single most common way brokers and brand teams flatter a bad promotion.
3. Gross vs. net spend. A bill-back allowance is paid on all cases sold during the promo, not just the incremental ones. You are discounting the baseline you'd have sold anyway. Leave that out and the spend looks far smaller than it is.

The number everyone gets wrong: your baseline

The baseline is what you would have sold without the promotion. It is the most important number in the entire calculation, and it's the one most reports skip.

Here's the trap. You sold 560 cases during a promo week, so the promo "sold" 560 cases — right? Only if you'd otherwise have sold zero. If this SKU moves 200 cases a week at full price, the promotion is responsible for the difference, not the total. Mistake the total for the result and you'll declare almost every promotion a success while your margin quietly bleeds out.

So how do you set a defensible baseline without a data-science team? Use a rolling 8-week pre-promotion average. Take the same customer and the same SKUs, total the units they ordered in the eight weeks before the promotion started, and divide to get a normal weekly run rate. Then pro-rate it to the length of the promo window.

Eight weeks is the practical sweet spot. It's long enough to smooth out a single odd order or a quiet week, and short enough to reflect current demand rather than last year's. Most importantly, it's transparent: you can show a manufacturer exactly which orders built the number. That matters when you're defending an ROI figure to a brand team. A rolling average from real order history is easy to explain and hard to argue with — unlike a black-box statistical model that produces a baseline nobody in the room can reconstruct.

How to calculate trade spend ROI, step by step

Walk a real example. A snack SKU running a two-week promotion at Kroger.

Step 1 — Set the baseline. Over the eight weeks before the promo, Kroger ordered 1,600 cases of this SKU. That's a run rate of 200 cases per week.

Step 2 — Pro-rate to the promo window. The promotion runs two weeks, so the expected baseline is 200 × 2 = 400 cases. That's what you'd have sold with no promotion.

Step 3 — Pull actual volume. During the two promo weeks, Kroger ordered 560 cases.

Step 4 — Find the incremental units. 560 actual − 400 baseline = 160 incremental cases. As a lift, that's 160 ÷ 400 = +40%. On its own, a +40% lift looks like a clear win.

Step 5 — Calculate incremental margin. Normal gross margin is $6 per case. The promotion earned the value of the 160 extra cases: 160 × $6 = $960.

Step 6 — Calculate trade spend. The deal is a $4-per-case bill-back allowance — and the retailer bills it back on every case sold during the promo, not just the incremental ones. So trade spend is $4 × 560 = $2,240. Notice you paid the discount on the 400 baseline cases you'd have sold anyway.

Step 7 — Calculate ROI. ($960 − $2,240) ÷ $2,240 = −57%. The +40% lift promotion lost money on every dimension. You spent $2,240 to generate $960 of incremental margin.

Two numbers make the loss obvious at a glance:

• Cost Per Incremental Case (CPIC): $2,240 ÷ 160 = $14 per incremental case. You paid $14 to capture $6 of margin. Any time CPIC climbs above your per-case margin, the promotion is underwater.
• Break-even lift: the lift you'd actually need to break even. Because the allowance is paid on the baseline too, you'd need 800 incremental cases — a +200% lift — for incremental margin to cover the spend. You delivered +40%.

That gap between the +40% you got and the +200% you needed is the whole story, and you never see it if you stop at "volume went up."

How to forecast trade spend ROI before you commit

The best time to run this math is before the promotion, while you can still change the deal. You don't need actuals to do it — you need the discount depth, the margin, and the baseline trend.

Start with the break-even lift, which falls straight out of two numbers:

Break-even lift % = Allowance per case ÷ (Base margin per case − Allowance per case)

For the example above: $4 ÷ ($6 − $4) = $4 ÷ $2 = 200%. Now ask the only question that matters: has this SKU at this retailer ever produced a +200% lift in the rolling 8-week trend? If the honest answer is no, the promotion is structurally unprofitable before it starts. You then have three real options — shrink the allowance, negotiate fixed fees down, or pass.

That formula also exposes a hard limit: if the per-case allowance is equal to or greater than your base margin, the denominator collapses and no amount of lift breaks even. You're paying to lose money on every case no matter how the promotion performs. Catching that on a forecast costs nothing. Catching it in a post-mortem costs a quarter.

Where food brokers fit in

For a food broker, this isn't academic — it's how you prove your value to a brand and protect your own commission, since promotional bill-backs cut into net sales and the commission you earn on them. The catch is that doing this by hand, promotion after promotion, retailer after retailer, is exactly the spreadsheet grind that keeps most brokerages stuck at "volume went up."

This is the workflow TradePath HQ automates. You import a manufacturer's deal sheet, the system links every incoming PO for the promoted SKUs to that promotion automatically, and the Promotion ROI Dashboard builds the rolling 8-week baseline, the actual-vs-baseline lift, the CPIC, and the break-even threshold for you — then packages it as a branded report you can hand to the brand. The math in this post is the math it runs.

If you want the broker-specific playbook for putting these numbers to work, read how to measure trade promotion ROI without a BI team.