Did That Promotion Work? Measuring Campaign ROI From PoS Transactions

Why Promoted Product Sales Alone Tell a Misleading Story#

A retailer runs a twenty percent discount on a popular product and sees sales triple during the promotion period. Success, right? Not necessarily. Some of those sales would have occurred at full price without the discount. These are not incremental; they represent margin given away on demand that existed anyway. Other sales may be pulled forward from future periods. Customers who would have bought next month stockpiled at the discount price, creating a post-promotion sales dip that offsets the promotion lift. Some sales came at the expense of competing products in your own store. A discounted brand-name item may have cannibalized sales of your higher-margin private label alternative, actually reducing total category profit despite the volume spike. And some sales attracted price-sensitive customers who will never return at full price, generating revenue without building lasting customer relationships. Accurate promotion measurement requires isolating the true incremental effect: additional gross profit that would not have been generated without the promotion, after accounting for margin reduction, cannibalization, demand shifting, and customer acquisition quality. PoS transaction data makes this measurement possible because it records every transaction before, during, and after the promotion, allowing you to construct a counterfactual baseline of what would have happened without the campaign. Most small retailers skip this analysis because it seems complex, but the core calculations are straightforward once the data is organized properly.

Calculating Incremental Revenue and Margin Impact#

Incremental revenue is the difference between actual sales during the promotion and the sales that would have occurred without it. The challenge is estimating the counterfactual. The most practical approach for small retailers is the baseline comparison method. Calculate the average daily sales for the promoted product over the four weeks preceding the promotion, adjusted for any known seasonal trends or day-of-week effects. This becomes your expected baseline. Actual promotional sales minus the baseline equals your estimated incremental volume. Multiply incremental units by the promotional selling price minus cost to get the incremental gross profit from added volume. Then subtract the margin given up on baseline sales that would have occurred at full price anyway. If the baseline was twenty units per day at full price with a forty percent margin, and the promotion generated sixty units per day at a twenty percent discount reducing margin to twenty-five percent, the calculation separates the twenty baseline units where you lost fifteen percentage points of margin from the forty incremental units that generated new gross profit at the reduced margin. The net effect might be positive or negative depending on the volume lift relative to the margin reduction. For many common promotions, the true incremental profit is substantially smaller than the apparent revenue increase suggests, and some promotions are actually profit-negative when baseline cannibalization is properly accounted for. AskBiz automates this baseline calculation by comparing promotional period performance against the pre-promotion trend, presenting the incremental revenue and margin impact clearly.

Measuring Cannibalization and Halo Effects#

Cannibalization occurs when promotional sales of one product reduce sales of another product in the same category. A discounted cola promotion might reduce sales of other beverages in the cooler. A buy-one-get-one offer on a specific pasta brand might suppress sales of competing pasta brands that carry higher margins. Measure cannibalization by tracking total category sales and margin during the promotion, not just the promoted SKU. If the promoted product volume increased by five hundred dollars but total category revenue only increased by two hundred dollars, three hundred dollars of the promoted product sales replaced sales of other items in the category. The margin impact may be worse than the revenue impact if the cannibalized products carried higher margins than the promoted product. Halo effects work in the opposite direction. Some promotions drive traffic that benefits non-promoted categories. A heavily advertised loss leader might bring customers into the store who then purchase full-margin items they would not have bought otherwise. Measure halo effects by tracking store-wide sales during the promotional period, looking for unusual lifts in categories unrelated to the promotion. Basket analysis is particularly revealing here. If promotional transactions contain significantly more non-promoted items than typical transactions, the promotion is generating basket halo revenue that should be credited to the campaign ROI. AskBiz cross-category analytics show how promotional activity in one department affects sales velocity and margin performance in adjacent departments, revealing both cannibalization costs and halo benefits that single-category analysis would miss.

Evaluating Post-Promotion Demand Shifts#

Demand shifting, where customers stockpile during a promotion and buy less afterward, is one of the most overlooked costs of discounting. If a pantry staple promotion causes customers to buy two months of supply at once, the two weeks following the promotion will show depressed sales as customers consume their stockpile. The net effect over the full cycle of pre-promotion, promotion, and post-promotion periods may be close to zero incremental volume with significant margin loss on units sold at the discount price. Measure post-promotion effects by tracking promoted product sales for two to four weeks after the promotion ends and comparing them against the pre-promotion baseline. A significant dip below baseline suggests demand was pulled forward rather than created. The severity of demand shifting varies by product type. Consumable products that customers use at a fixed rate, like cleaning supplies and personal care products, are highly susceptible to stockpiling. Perishable products with short shelf lives are less susceptible because customers cannot stockpile what expires before they can use it. Impulse purchases and discretionary items generate more genuine incremental demand because the purchase decision is triggered by the promotion rather than merely accelerated. Use this understanding to design future promotions strategically. Promote perishable and impulse categories where genuine demand creation is more likely. Avoid deep discounts on shelf-stable staples where stockpiling is the dominant response. When you must promote staples, consider volume limits or loyalty-exclusive pricing that reduces the stockpiling effect. AskBiz tracks post-promotion demand curves automatically, flagging products where the promotional lift was substantially offset by subsequent demand depression.

Building a Promotion Effectiveness Scorecard#

Create a standardized scorecard for every promotion that captures the full economic impact rather than just the headline sales figure. The scorecard should include promotional revenue, baseline revenue that would have occurred without the promotion, incremental revenue calculated as the difference, gross margin rate during promotion versus standard margin, incremental gross profit after margin adjustment on baseline sales, category cannibalization effect measured as the change in non-promoted SKU sales within the category, halo effect measured as incremental sales in non-promoted categories, post-promotion demand shift measured as deviation from baseline in the two to four weeks following the campaign, and customer acquisition quality measured by repeat purchase rate of customers who first purchased during the promotion. Score each promotion on a composite scale and rank them against previous campaigns. Over time, this scorecard library becomes a decision-support tool for promotional planning. You can identify which promotion types, discount depths, product categories, and timing windows consistently generate positive incremental profit and which consistently destroy value despite appearing successful on the surface. Share scorecard results with suppliers who fund promotional activity. Many vendor-funded promotions are evaluated only on volume, ignoring margin impact and cannibalization. Showing suppliers the full economic picture creates more productive conversations about promotional design and funding levels. AskBiz generates promotion scorecards automatically from PoS transaction data, applying the baseline, cannibalization, and demand-shift calculations without manual analysis.