Free tool · Trade spend
Trade-promotion ROI calculator
A promotion that doubles volume can still lose money, because the discount applies to the units you would have sold anyway. Compare baseline and promoted volume, the per-unit discount, fees, and the post-promotion dip to see the incremental profit and the lift you need to break even.
No login. Runs in your browser. Nothing is saved or sent.
Volume
What this retailer or account sells in a normal week without the promotion.
Total for all promotion weeks, including the baseline units.
Units you expect to lose afterwards because shoppers or the retailer stocked up. Use 0 if unknown.
Economics
What you invoice the retailer or distributor.
Off-invoice, bill-back, or scan allowance per unit sold during the promotion.
Slotting, display, ad, demo, and other lump-sum charges.
Results
- Incremental profit
- -$2,000.00
- Gross profit lost versus not running it
- Return on trade spend
- -$0.40 per $1
- Incremental profit per dollar of discount and fees
- Lift
- 75%
- 3,000 incremental units over 4,000 baseline
- Break-even lift
- 146.4%
- 9,858 promotion units needed
The math
| Gross profit without the promotion | $4,800.00 |
|---|---|
| Gross profit with the promotion (after discount, fees, and dip) | $2,800.00 |
| Unit margin: regular / on promotion | $1.20 / $0.70 |
| Total trade spend (discount + fees) | $5,000.00 |
| Of which discount on units that would have sold anyway | $2,000.00 |
Measures your gross profit only; it does not include retailer margin, consumer price, or halo effects on other items. Nothing you enter leaves your browser.
How it is calculated
- Baseline units = baseline per week x promotion weeks. Regular unit margin = price - cost.
- Profit without the promotion = baseline units x regular unit margin.
- Profit with the promotion = promotion units x (margin - discount) - fixed fees - post-promotion dip units x regular margin.
- Incremental profit = profit with - profit without. Return on trade spend = incremental profit / (discount on all promotion units + fixed fees).
- Break-even units = (baseline profit + fees + dip x margin) / (margin - discount). Break-even lift is that over the baseline.
Doing this every day in Skygn
Skygn tracks trade promotions per customer with type (off-invoice, bill-back, scan-down, display, MCB, or other), dates, planned spend, and expected lift. Accruing a promotion drafts the journal entry, and a deductions register links retailer short-pays to the promotion and invoice, with a planned versus claimed analysis per promotion.
Skygn does not import retailer scan data or model promotional lift; the volume figures in this calculator are your estimates.
Read the full guide: Trade promotion and deductions management for emerging CPG brands.
Frequently asked questions
- What is a good trade promotion ROI?
- Any promotion with positive incremental profit returns more than it costs on these terms. Many promotions come out negative once subsidized baseline volume and the post-promotion dip are counted, which is why it is worth checking before you commit.
- Why does the discount apply to baseline units?
- During the promotion every unit sold carries the discount, including the ones shoppers would have bought at full price. That subsidized spend is usually the biggest cost of a promotion.
- Does this include the retailer's margin?
- No. It measures your gross profit at the price you invoice. Retailer margin, consumer shelf price, and effects on your other items are outside the calculation.
- Are my numbers saved?
- No. The calculation runs in your browser and nothing you enter is sent or stored.
Stop recalculating it in a spreadsheet
Skygn is the ERP for food & beverage and CPG brands: lots and expiry, recipes and costing, quality and recall, and trade spend in one system. One plan with every module, and a 14-day free trial.