How to Measure Trade Marketing ROI in Retail
Trade marketing is one of the largest lines in an FMCG P&L, and one of the least consistently measured. Here is a practical framework for calculating and improving trade ROI.
Trade marketing is one of the largest line items in a FMCG profit and loss account. It is also one of the hardest to measure. Most brands know roughly how much they spent on promotions last year. Very few can tell you with confidence whether it was worth it.
The Trade Marketing ROI Formula
The calculation itself is straightforward:
Trade ROI = (Incremental Gross Margin minus Trade Investment) / Trade Investment x 100
Four quantities are easy to confuse, so it is worth separating them:
- Incremental revenue is the additional sell-out generated above the baseline: what you would have sold anyway without the activation.
- Incremental gross margin is that revenue after the cost of goods. This is the figure the ROI calculation uses.
- Trade investment is everything the activation cost: discount funding, listing fees, display and execution costs.
- ROI is what remains once the investment is subtracted from the incremental gross margin, expressed against that investment.
Revenue uplift on its own is not ROI. A promotion can lift sell-out substantially and still lose money once the discount and the cost of goods are accounted for.
The hard part is the incremental figure. That is the additional sell-out generated by the promotion above the baseline, meaning what you would have sold anyway without the activation. Getting the baseline right is where most brands struggle.
Building Your Baseline
Three approaches are commonly used:
- Historical average: Use the same period from prior years, adjusted for trend. Simple but sensitive to market shifts.
- Control stores: Run the promotion in a matched set of stores, leaving a similar set un-activated as a control. More accurate, but requires careful store selection.
- Econometric modelling: Separate the promotion effect from seasonality, distribution changes, and competitor activity using regression. Most accurate, but requires data science resource.
For most mid-size FMCG brands, combining historical averaging with control stores gives a workable baseline without heavy analytical overhead.
Common Mistakes
- Counting sell-in as revenue: Promotional volume shipped to the retailer's warehouse is not consumer demand. Track sell-out wherever possible.
- Ignoring cannibalisation: A promotion on one SKU often shifts volume from another in your portfolio. Net incremental revenue can be much lower than gross uplift.
- Forgetting the cost of goods: ROI should be calculated on margin, not revenue, for a true picture of profit impact.
From Measurement to Optimisation
Once you can measure ROI per promotion, the next step is optimisation: understanding which mechanics work best for which categories and channels. A good trade marketing platform lets you tag every activation with its mechanic, channel, and account, so you can slice ROI data in minutes rather than weeks.