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 set of past events, and a range instead of a point estimate. The economics of trade spend are brutal precisely because it's hard to do two things at once, measure past performance and predict what's next. Every type of promotion has a different purpose and a different time horizon, which only makes it harder.

From working with hundreds of brands, we've found almost every team already has the raw material: POS data (syndicated like SPINS, NielsenIQ, or IRI), retailer portals (Walmart, Whole Foods, Ulta, Target), and promo calendars. The data is rarely the problem. The forecasts could be a lot more rigorous than what most teams do in spreadsheets today.

Last-minute decisions to go steeper on a discount eat margin, and margin is growth. A good trade-spend ROI forecast lets a brand spend less and keep more of the margin, which matters most in competitive categories. (If you're brand-new to the discipline, What Is Trade Promotions Analysis? is the primer that defines the terms used below. 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 that captures how uncertain the estimate is.

Trade ROI is incremental sales for the event divided by incremental trade dollars spent. The incremental sales figure should account for baseline sales, discount depth, trade mechanics, and cannibalization, or the result will be skewed. 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 you can: 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 before the event, and known disruptions (out-of-stocks, weather, resets).
• Compare against past similar events with the same retailer, SKU, and depth combination, then separate lift from price and from type of promotion (feature, display).
• Forecast a range, not a single number. A base case (most likely), a downside (execution risk), and an upside (good timing).

The final output should answer five things: expected incremental units, expected incremental dollars, the ROI range, the top risks, and the backup plan if the event underperforms.

Do this consistently and 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. For a quick directional figure before you model an event, the ROI calculator estimates the annual upside from your revenue, out-of-stock rate, and trade spend.