Goal of the analysis:
The goal of a Promotional Pricing and Discount Depth Analysis in the consumer packaged goods (CPG) industry is to evaluate the effectiveness of price promotions and the impact of different discount levels on sales, profitability, and consumer behavior. This analysis helps CPG companies determine the optimal pricing strategies for driving short-term sales, increasing market share, and maintaining profitability. By understanding how various discount depths influence consumer demand, companies can create more effective promotions and avoid unnecessary margin erosion.
Data required:
- Sales data before, during, and after promotions
- Discount levels and types (e.g., percentage off, buy one get one free, multi-buy deals)
- Profit margin data by product
- Redemption rates for coupons and promotions
- Consumer behavior data (e.g., purchase frequency, basket size, new vs. repeat customers)
- Market share data for promotional periods
- Competitor pricing and promotional activities
- Marketing spend related to the promotion
- Distribution and supply chain costs during promotional periods
- Return and refund rates during promotional periods
Detailed step-by-step instruction on how to conduct the analysis:
1. Define the objectives of the analysis.
Set clear goals for the promotional pricing analysis. Objectives may include understanding the impact of different discount levels on sales volume, evaluating how promotions affect profit margins, or identifying whether promotions attract new customers or simply accelerate purchases from existing customers.
2. Collect sales and pricing data for promotional periods.
Gather sales data for the periods before, during, and after each promotion. Break down the sales by product and promotion type (e.g., percentage discount, buy-one-get-one-free).
Analyze the sales lift driven by each promotion using the following formula:
Sales Lift (%) = ((Sales During Promotion – Sales Before Promotion) / Sales Before Promotion) x 100
For example, if sales were $50,000 before the promotion and increased to $75,000 during the promotion:
Sales Lift = (($75,000 – $50,000) / $50,000) x 100 = 50%
3. Assess the impact of discount depth on sales.
Evaluate the sales response to different levels of discounting. Track how sales volumes change as discounts increase, and determine the point at which deeper discounts no longer lead to proportionate increases in sales.
Use this data to identify the optimal discount depth that maximizes revenue without unnecessarily eroding margins. For example, a 10% discount may increase sales by 20%, but a 30% discount may only result in a 35% sales increase. In this case, the 10% discount is more efficient.
4. Analyze the impact on profitability.
Calculate how the promotion affected profitability by comparing gross margins before and during the promotion.
The formula for gross margin is:
Gross Margin (%) = ((Revenue – Cost of Goods Sold) / Revenue) x 100
For example, if a product is normally sold for $20 with a cost of goods sold (COGS) of $12, the gross margin would be:
Gross Margin = (($20 – $12) / $20) x 100 = 40%
During a promotion, if the price is reduced to $16, the new gross margin would be:
Gross Margin = (($16 – $12) / $16) x 100 = 25%
Use this analysis to determine if promotional pricing significantly reduces profitability and whether the sales lift compensates for the margin loss.
5. Evaluate the effect on consumer behavior.
Analyze how promotions influence consumer behavior, such as purchase frequency, basket size, and whether the promotion attracted new customers or incentivized repeat purchases.
Track whether customers are stockpiling products during promotions (buying more than they normally would) or making impulse purchases due to the discounted price.
Key questions to consider include:
- Are consumers buying larger quantities of discounted products?
- Are new customers being drawn to the brand during the promotion?
- Does the promotion encourage higher basket values or more frequent purchases?
6. Measure promotional effectiveness and redemption rates.
For coupon-based promotions or digital discounts, track redemption rates and assess how these impact sales.
A high redemption rate indicates that consumers found value in the promotion, while a low redemption rate may signal that the offer was not compelling enough or was poorly executed.
Coupon Redemption Rate (%) = (Number of Coupons Redeemed / Number of Coupons Distributed) x 100
For example, if 5,000 coupons were distributed and 500 were redeemed:
Coupon Redemption Rate = (500 / 5,000) x 100 = 10%
7. Review competitor pricing and promotional activity.
Compare your promotional pricing strategy with that of key competitors. Monitor competitor promotions during the same period to see how their discount levels and strategies impacted your sales.
If competitors offered deeper discounts, assess whether this drew customers away or if your brand was able to maintain share with less aggressive pricing.
8. Analyze the post-promotion impact.
Review sales data after the promotion to determine if there was a drop-off in demand (often referred to as the “post-promotion slump”). If sales drop significantly after the promotion, it may indicate that the promotion was too short-term focused or overly dependent on price-sensitive shoppers.
Calculate post-promotion sales decline as:
Post-Promotion Sales Decline (%) = ((Sales After Promotion – Sales During Promotion) / Sales During Promotion) x 100
For example, if sales during the promotion were $75,000 and dropped to $40,000 afterward:
Post-Promotion Sales Decline = (($40,000 – $75,000) / $75,000) x 100 = -46.67%
9. Assess supply chain and inventory impact.
Review how promotions affected supply chain and inventory management. Large discounts can lead to stockpiling, which may strain inventory levels and create challenges for meeting demand. Ensure that your supply chain can handle the increased demand during promotions to avoid stockouts or delivery delays.
Format of the output of analysis:
The output of a Promotional Pricing and Discount Depth Analysis typically includes:
- A breakdown of sales performance before, during, and after promotions.
- Sales lift percentage for each promotion and discount level.
- Impact of discount depth on profitability and gross margin.
- Analysis of consumer behavior (e.g., purchase frequency, basket size, new vs. repeat customers).
- Coupon redemption rates or promotional effectiveness metrics.
- A comparison of promotional performance against competitors.
- Insights into post-promotion sales decline and inventory management challenges.
- Recommendations for optimizing future promotions based on findings.
How to interpret results:
- High sales lift with minimal margin erosion: Indicates that the promotion was successful in driving sales without severely impacting profitability. This suggests that the discount level was well-calibrated to boost demand while maintaining a healthy gross margin.
- High sales lift with significant margin erosion: If the promotion led to a strong increase in sales but significantly reduced gross margin, it may indicate that the discount depth was too aggressive. Consider testing smaller discounts to see if similar sales gains can be achieved without sacrificing profitability.
- Low sales lift despite deep discounts: This suggests that the promotion may not have been well-targeted or compelling to consumers. Review the offer, promotional messaging, or product selection to better align with customer preferences.
- Post-promotion sales decline: If sales drop significantly after the promotion, it could indicate that customers are highly price-sensitive or that they stocked up during the promotion, reducing future demand. Consider balancing short-term promotions with long-term brand-building initiatives to maintain steady demand.
Steps a company can take to improve on this measure:
- Optimize discount levels: Use historical data to identify the most effective discount depth for maximizing sales without significantly reducing profitability. Test different discount levels (e.g., 10%, 20%, 30%) to find the sweet spot that drives demand while protecting margins.
- Target promotions to specific customer segments: Tailor promotions to different customer segments based on purchase behavior and preferences. For example, offer deeper discounts to price-sensitive shoppers and smaller incentives to brand-loyal customers.
- Reduce post-promotion slumps: To avoid a significant drop-off in sales after a promotion, consider running smaller, more frequent promotions or offering loyalty-based incentives to keep customers engaged even after the promotion ends.
- Enhance promotion timing and messaging: Ensure that promotions are timed strategically, aligning with seasonal demand spikes or new product launches. Improve promotional messaging to highlight the value of the product, not just the discount.
- Test and measure promotion types: Experiment with different types of promotions (e.g., percentage discounts, buy-one-get-one-free, multi-buy deals) to see which resonates most with consumers. Track the performance of each promotion type to refine your overall promotional strategy.
- Monitor supply chain readiness: Ensure that the supply chain is prepared for increased demand during promotional periods. Work with suppliers to secure inventory and optimize distribution to prevent stockouts or delays.
Request the PDF Download of How to Analyze a Consumer Packaged Goods Company
