The promo week looked great. Now count the weeks after it. Find out whether the discount really made money.
Take normal weekly units from the weeks before the promo, and dip units from the weeks after it. Unit cost is everything it costs to sell one more unit: product, shipping, fees and returns. Price after the promo is assumed to go back to regular.
| Dip depth (below normal) | Dip units a week | Dip cost | Net profit change |
|---|
Uses your dip length. Depth zero means no dip at all.
| Discount | Margin per unit | Uplift to break even in the promo | Uplift to also cover your dip |
|---|
Uplift is promo weekly units over normal weekly units. A bigger discount shrinks the margin on every unit, including the ones you would have sold anyway.
The break-even uplift in the promo does not depend on volume: it is the margin before the discount over the margin after it, minus one. A 15% discount on a 40% margin needs about 60% more units just to stand still.
pays: the promo window and the dip together leave you better off. the dip eats it: the promo window made money, but the dip took it back. loses money: the promo window itself lost money, before any dip.
The numbers are only as good as your baseline. Seasonality, weather, stock-outs and other marketing in the same weeks all move units. Compare against a control group or the same weeks last year if you can.
The dip is not guaranteed. Products that cannot be stockpiled may show little or none. This tool does not assume a typical dip: you enter the one you measured.
It counts one promotion's profit. It does not count customers you gained and kept, a price you taught people to wait for, or a competitor's response.
Units sold below cost always lose money. If the discounted price is below unit cost, no amount of uplift fixes it.