Discounts and promotions in retail
From the mechanic and budget to a control-group estimate and a post-mortem.
Route steps
- Quick business check: two periods
From basic figures of two periods calculates gross margin, operating profitability, turnover, days of inventory, receivables and payables, the cash cycle, the share of returns and old stock and shows which way each moved. - Average stock for the year and turnover
Calculates average stock from monthly balances, turnover and days of inventory and shows how far a one-date balance distorts the picture in a seasonal business. - Season sell-through pace and leftover risk
From sales so far shows the sold share, stock in weeks, the forecast leftover at season end and the pace needed to reach the target. - Weekly markdown ladder: discount steps and an ending-stock goal
Compares three scenarios to the end of the season: keep the price, cut in steps, or one deep cut at the end. Shows the ending stock, the result including the clearance of leftovers, the exit price and warns when a discount does not pay back. - Multi-buy: effective discount and basket
Converts “2 for 1”, “second at a discount”, “3 for 2” and a set into an effective discount per piece. Shows the basket margin before and after, how many pieces per basket are needed for the same margin and the average basket after. - Stacking: total discount and order of application
Combines a shelf discount, a promo code and points or cashback into one total discount, shows the unit price and margin, the “ceiling” of the total discount at your minimum margin and the difference between orders of application. - Promotion calendar and discount budget
Turns a monthly promotion plan into a discount budget in money, calculates the maintained margin of the plan and the permitted depth at your target, and flags months overloaded with promotions and months below the target margin. - Frequent promotions: reference price and waiting for discounts
A simple model: the more often and the deeper the promotions, the lower the price a customer treats as normal and the more purchases move into promotions. Compares profit under the current and the proposed policy and shows what volume growth is needed to offset the lost price. - Promotion result: incremental profit
Compares the profit of a promotion with the profit you would have had without it and subtracts cannibalization, pull-forward demand and costs. Shows the required and actual sales growth, the baseline cushion and the sensitivity to its estimate. - Post-promotion dip and pull-forward demand
From weeks before, during and after a promotion, estimates the baseline, the uplift, the post-promotion dip and the share of uplift eaten by the dip. Shows how many weeks it took sales to return to baseline and suggests a gap before the next promotion. - Control group: promotion effect (difference-in-differences)
Compares stores or regions in a promotion with similar ones without it, before and after. Shows the effect of the promotion in pieces and percent, a rough interval from the pre-promotion spread, a “parallel trends” check before the promotion and the result in money. - Promotion post-mortem: plan, actual and verdict
Matches plan and actual on six indicators, takes into account the baseline method and what was measured, and gives a “repeat, change or stop” verdict with a list of measurement errors. Do it 2–4 weeks after the promotion ends, when the dip is visible.
Documents for this route
- Promo calendar and promotion effectiveness
- Price and purchase psychology: what to test and how to measure the effect
- Price elasticity of demand: how to estimate it from data without being fooled
- A/B tests for promotions and promos: hypothesis, sample, power, p-value, peeking
- Dynamic pricing: elasticity by segment, brand constraints, an optimal clearance path and the Thompson bandit
- Provision for inventory impairment: FSBU 5/2019, IAS 2, net realizable value
- Markdown mathematics: steps, leftovers, timing and liquidation
- Marketplace economics: tariff, logistics, buyout, storage, ad cost share and price