How to Calculate Trade Spend ROI (and Why Most Brands Get It Wrong)

Ask ten CPG trade managers how they calculate promotion ROI, and you will get ten different answers. Some divide incremental revenue by trade spend. Others look at gross margin impact. A few admit they do not calculate it at all. The lack of a consistent methodology is a serious problem, because it means brands cannot reliably compare promotions against each other or against doing nothing.

Common ROI Calculation Mistakes

Mistake 1: Using Total Sales Instead of Incremental Sales

The most pervasive error is treating all sales during a promotion period as if they were caused by the promotion. If you normally sell 1,000 units per week and sell 1,500 during a promotion, the incremental volume is 500 units—not 1,500. Using total sales inflates ROI by 3x or more and makes nearly every promotion look profitable.

Mistake 2: Ignoring Pantry Loading

Promotions often pull forward demand rather than creating new demand. If consumers stock up during a deal and then skip their next purchase, the net incremental volume over a 4–8 week window is lower than the in-period lift suggests. Accurate ROI requires measuring the post-promotion dip and netting it against the in-period lift.

Mistake 3: Excluding All Trade Costs

Trade spend is not just the promotional allowance. It includes scan allowances, off-invoice deductions, display fees, slotting fees, and any performance penalties. A promotion that looks profitable on the allowance alone may be underwater when all associated costs are included.

The Right Formula

A sound promotion ROI calculation follows this structure:

Establishing the Baseline

The baseline—what would have sold without the promotion—is the hardest number to get right, and it is the one that has the most impact on the ROI calculation. Common approaches include:

• Historical average: Average weekly sales over a comparable non-promoted period. Simple but ignores seasonality and trends.
• Year-over-year comparison: Same week last year, adjusted for distribution changes. Better for seasonal categories.
• Statistical modeling: Regression-based approaches that control for seasonality, distribution, pricing, and competitive activity. Most accurate but requires sufficient data history.

Whichever method you use, document it and apply it consistently. An imperfect but consistent baseline methodology is far more useful than a perfect one that changes with every analysis.