Trade marketing ROI: promotions after funding costs

The ROI trade marketing teams report should compare incremental manufacturer contribution with all program funding. Calculate the contribution on consumer units above an agreed baseline, deduct allowances and retailer support, and divide the remaining amount by that funding. The result is a conditional estimate: its credibility depends on the baseline and cost boundary.

Set the boundary before opening the spreadsheet

Choose one retailer, promotion window and covered store group. Use the same products, package sizes and dates for actual consumer sales and baseline units. Consumer sales should reflect returns consistently; the Census Bureau's retail definitions likewise describe sales net of refunds and allowances for returned merchandise.

The baseline is expected sales without the promotion, supplied by your commercial planning process. Record its source and approval before evaluating results. A previous period may be a useful reference, but changes in distribution, seasonality and availability can make it unsuitable as a counterfactual.

Use manufacturer value per consumer unit before the specific program funding being evaluated. Subtract the matching variable product and fulfillment costs to get contribution per unit. This is an economic comparison on consumer units, not a claim that manufacturer accounting revenue is recognized when consumers buy.

For the broader inventory and spend reconciliation, use trade marketing analytics. The distinction between return and revenue-only ratios is covered in marketing ROI vs ROAS.

Assemble the input rows

An illustrative US beverage manufacturer evaluates a September 2026 promotion at one retailer. All figures below cover the same participating stores. Funding is the final program obligation, including amounts settled and still accrued, with each obligation counted once.

The manufacturer values are already net of routine discounts and returns, but exclude the listed promotional allowances. Costs include the variable costs chosen for this decision. Add any other incremental execution costs to the appropriate input before calculating return.

Put these columns in A:G, with product rows in rows 2 and 3. Retain promotion and retailer identifiers in the underlying source register so a reviewer can trace each allowance or fee.

Calculate contribution and ROI

Estimated incremental contribution = (Actual consumer units − Baseline units) × (Manufacturer value per unit − Variable cost per unit)

Trade marketing ROI = (Estimated incremental contribution − Program funding) / Program funding

Use the following Google Sheets formulas, then fill down. Incremental units in H2:

=C2-B2

Unit contribution in I2:

=D2-E2

Incremental contribution in J2:

=H2*I2

Funding in K2:

=F2+G2

Contribution after funding in L2:

=J2-K2

ROI in M2:

=IF(K2=0,"",L2/K2)

Citrus contributes (10,000 − 8,000) × (4.00 − 2.40) = $3,200 before funding. Berry contributes (6,600 − 6,000) × (5.00 − 3.00) = $1,200. Total estimated incremental contribution is therefore $4,400.

Calculate the total ROI from summed dollars, with this formula in M4:

=IF(SUM(K2:K3)=0,"",SUM(L2:L3)/SUM(K2:K3))

The result is 1,600 / 2,800 = 57.1%, rounded to one decimal place. A zero funding denominator makes this ROI undefined; it does not justify displaying an infinite return.

If the funding register has several rows per program, aggregate it before combining it with the product summary. Google's SUMIFS documentation describes summing amounts against multiple criteria. For example, with promotion in Funding column A, product in B and amount in C:

=SUMIFS(Funding!$C$2:$C$5000,Funding!$A$2:$A$5000,$P$1,Funding!$B$2:$B$5000,A2)

Put the promotion identifier in P1. Covirage is not affiliated with Google.

Prove the total and test a changed fee

Funding reconciles as 1,700 + 1,100 = $2,800. The contribution bridge must satisfy 4,400 = 2,800 + 1,600. Tie the funding total to the source register and explain any difference from settled cash using outstanding accruals and approved adjustments.

Now change only the Citrus retailer fee, increasing it from $600 to $1,000. Everything else stays as shown above.

The extra $400 reduces contribution after funding by $400 and raises the denominator. Revised ROI is 1,200 / 3,200 = 37.5%. This isolates why a higher retailer fee matters even when consumer sales are unchanged.

Read the estimate with its limitations

These sales comparisons cannot prove incremental sales caused by the promotion. NIST explains that association does not establish causality. Review the estimate with finance and the account owner, and use an appropriate control design when a causal conclusion is required.

The questions a CPG commercial director asks help place return alongside account coverage and execution. For decisions about the next program, improve marketing ROI covers the broader improvement process.

Where it goes wrong

• Subtracting allowances twice. Revenue already net of promotional funding needs a different bridge or an add-back.
• Using all promotional sales as incremental. Baseline sales belong outside the incremental numerator.
• Mixing shipments and consumer purchases. Retailer inventory can move independently of demand.
• Omitting late obligations. A pending retailer claim can change both funding and return after the campaign ends.

Calculate your own trade return in Covirage

Bring a sample of your own retailer sales, agreed baseline, cost and funding exports to Covirage. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the comparisons with every figure traced to its rows. Create a free Covirage account and bring your own program files.

See Covirage for CPG brands for the industry context.