How to Forecast Trade Spend ROI for Promotions

How to forecast trade spend ROI for a CPG promotion comes down to four pieces: a precise event definition, an honest baseline, a comparable historical event set, and a range rather than a point estimate. The economics of trade spend are brutal precisely because it's hard to both measure past performance and predict future outcomes — each type of promotion serves a different purpose and operates on a different time horizon, which compounds the difficulty.

From working with hundreds of brands, we've found that almost every team has POS data (syndicated like SPINS / NielsenIQ / IRI), retailer portals (Walmart, Whole Foods, Ulta, Target), and promo calendars. Even with abundant data, forecasts can be much more rigorous than what's being done in spreadsheets today.

Last-minute decisions about steeper discounts also eat into margin and therefore growth. A good trade-spend ROI forecast lets brands spend less and keep more margin, especially in competitive categories. (If you're not yet measuring whether past promotions actually worked, A Guide to Trade Promotions Effectiveness Analysis is the prerequisite read.)

What defines a forecast for trade spend and promotion ROI?

A trade spend ROI forecast is an estimate of incremental dollar sales for the trade spend, with a range capturing how uncertain that estimate is.

Trade ROI = incremental sales for the event / incremental trade dollars spent. The incremental sales calculation should account for baseline sales, discount depth, trade mechanics, and cannibalization to avoid skewing results. See How to Tell If a CPG Promotion Actually Worked for the post-event validation that closes the loop on each forecast.

Minimum viable forecast model

• Define the exact promotion event with as many attributes as possible: retailer, banner, region, weeks active, SKUs included, discount depth, and type.
• Build your own baseline from recent trend and last year's same period, then adjust for ACV changes, price changes prior to the event, and known disruptions (OOS, weather, resets).
• Compare against past similar events with the same retailer / SKU / depth combination, then separate lift from price and type of promotion (feature, display).
• Forecast a range instead of a single number. Have a base case (most likely), a downside (execution risk), and an upside (good timing).

The final output should answer expected incremental units, expected incremental dollars, ROI range, top risks, and backup plans in case of underperformance.

Done consistently, forecasting becomes the front half of a loop that reframes trade spend as portfolio allocation — see From Cost Center to Profit Driver: Rethinking the Role of Trade Spend.