How to Measure Promotion Lift After A Retail Sale

The coffee buyer and the finance director can look at the same Saturday checkout report and walk away with different orders for next month. One sees a house blend that shoppers carried out by the armful. The other sees a $3 discount on bags that regular customers probably would have bought at full price. Both need to know what happened after the signs came down.
Take a retailer running a one-week sale on its house blend in a group of stores. For this exercise the category has just two products, both one-pound bags of whole-bean coffee. The house blend normally sells for $16 and drops to $13, while the second blend stays at $16. Because both bags are the same size, a switch between them counts as a purchase of the same amount of coffee. A promotion on a two-pound bag would call for a calculation in pounds as well as packages.
Begin with an estimate of what the promotional stores would have sold at regular price. In comparable recent weeks they averaged 200 bags of house blend and 100 of the second blend. In an unpromoted group of similar shops, sales of both blends rose 10% during the sale week. Assume the two groups had previously followed similar trends, with the same prices, availability and assortment. Applying that 10% rise gives the sale stores an expected 220 house and 110 second-blend bags without the offer.
Make that adjustment even if the report already has a “last week” column. Skip it, and the coffee promotion gets credit for an increase that nearby stores experienced at full price. Look at both groups across several weeks before the event. If their trends diverged around earlier holidays, a holiday comparison calls for more care. An untreated store across the street might also lose shoppers to the deal, which would depress its sales and flatter the apparent gain at the promotional stores.
Follow The Missing Bags
Customers bought 330 bags of house blend during the sale. The promotion lift calculation subtracts the 220 expected bags and divides the extra 110 by 220, giving a 50% unit lift for the featured item. That is useful for whoever schedules the coffee delivery. A buyer who plans 220 bags for an identical offer risks running out while there are still shoppers in line.
Across the aisle, the second blend sold 80 bags against an expected 110, a shortfall of 30. In all, customers took home 410 bags against a category baseline of 330: an increase of 80 bags, or about 24%. Some of the house blend’s gain appears to have come at its neighbor’s expense, although the calculation cannot identify which customers switched. And if the second blend was out of stock on Saturday, the manager has another plausible explanation for at least some of the missing bags.

Coffee also keeps long enough for a shopper to put a spare bag in the pantry. In the week after the sale, suppose comparison-store sales hold at 10% above their earlier level, keeping the expected category total at 330. Back at regular price, the promotional stores sell 205 house and 105 second-blend bags. The total of 310 is 20 below expectation. Some shoppers may have bought next week’s coffee early. If payday shifted, a competing store opened or a shipment arrived late, record that before assigning the whole dip to the offer.
Across the two weeks, the sale stores sold 720 bags against 660 expected, which puts the estimated net category lift at 60 bags, or about 9%. Those 60 are a starting point for the next two-week purchasing decision. Extending the review through another normal buying interval could change the estimate again. For a category people buy monthly, stopping after seven quiet days could leave most of the pull-forward effect outside the measurement window.
For an online version of the offer, check the date on which shoppers actually qualified for the price. A code emailed on Friday may still be valid the following Monday. Treat Monday’s redemptions as part of the offer period and move the start of the follow-up window accordingly. Otherwise a report can put discounted orders in the week meant to measure a return to full price.
Sometimes a buyer has to sign a repeat deal before a second week of results comes in. Price the order twice. If sales return to normal quickly, the first week’s 80 extra category bags would stand. If the subsequent shortfall were 40 bags, the two-week gain would halve to 40. Check whether the purchase order can accommodate both outcomes. A supplier willing to deliver the balance after the first weekend can be worth more than a small discount on a fixed shipment.
What Did The Sale Actually Earn?
Assume product and variable selling costs total $8 per bag for either blend and stay the same during the sale. At the promotional price, the house blend earns $5 a bag; its neighbor earns $8. Sale-week contribution comes to $1,650 on 330 house bags plus $640 on 80 second-blend bags, or $2,290. Without a promotion, the expected 330 regular-price bags would have contributed $2,640. The category moved 80 extra bags and gave up an estimated $350 of contribution in that first week.
The following week’s 310 full-price bags contribute $2,480, another $160 below baseline. Across both weeks, the retailer earned an estimated $510 less in contribution than it would have at regular price, before any display expense or vendor funding. If a supplier offers to pay part of the discount, add the funding the retailer actually qualifies for. If management ran the event to recruit coffee subscribers, put the attributable subscription contribution alongside this shortfall, and give those sign-ups time to mature.
Translate the result into quantities at the point where stock has to be available. For the same stores, shelf space and discount, 330 house bags is a reasonable starting forecast for the event week, with a separate estimate for the 80 second-blend bags. The following week’s needs look different again. Carry both weeks into demand planning before deducting inventory already on hand and receipts already committed. Applying a 50% increase to every coffee order would mean buying for sales the retailer has already borrowed from somewhere else.
The next time someone requests another coffee promotion, bring three figures into the room. The featured blend needed 110 extra bags on the shelf that week. The category gained an estimated 60 bags across two weeks. And under the stated assumptions, the retailer gave up $510 in contribution. With those figures, the buyer can discuss a delivery, the merchant can discuss the offer and finance can negotiate supplier support, without asking a single lift percentage to do all three jobs.