Interactive PowerBI Example: Coupon Input

All data has been randomized, masked, and altered for demo purposes only. Videos will highlight functionality and tangible business insights.

The coupon input report is meant to simulate both a financial breakdown as well as an analytical understanding of the impact of sales in the market.

Step 1 - Select the LOB (Line of Business) or product that is being sold. In the default example, we are selecting Bubbletime water.

Step 2 - Input the parameters of this coupon, including the value, the fee of the coupon provider, the budget, and purchase requirement, and selected dates.

The incrementality rate is derived from high-level elasticity rates - it’s the additional impact of the coupon. In this model, we only care about the added lift. If someone was already going to buy the water without the coupon then the coupon is completely decretive. An incrementality rate of 25% for example means that for every 4 people who redeem the coupon 1 person is net new, AKA the presence of the coupon incentivizes 1 new person out of 4 to redeem. The other 3 would have already bought the water without the coupon itself. An incrementality rate of 100% means that all redemptions are from people who are net new. The higher the coupon value the higher the incrementality rate. For example, a $5 coupon for a $30 cake is much more enticing for customers than a $1 coupon for a $30 cake. The incrementality rate will auto-default and adjust based on the relative size of the coupon compared to the retail price, but users can override that with the slider.

Given the inputs in steps 1 & 2, the analysis shows the step by step calculation and how to interpret the results.

The breakdown graph at the bottom left shows the impact of the parameters on Gross Margin, Incrementality, Sales Lift, and Units Sold. The key highlight is that the sales lift and units sold go down as you increase the coupon value, since it equates to less overall coupons to be redeemed given a fixed budget. However, this is partially offset by the velocity of sales (not in model) - where business owners may prioritize a quicker spike in sales in the short-term versus longer term efficiency.