Executive Overview

Note: Charts below are intentionally code‑free and data‑light for an executive audience. Calculations follow standard definitions used in prior analyses (e.g., 90th‑percentile peaks, share of households redeeming ≥1 coupon, and mean basket with IQR).


1) Weekly Sales Peaks

What to look for
- Shaded bands mark top 10% sales weeks (peak periods).
- Month labels reveal seasonality; week numbers provide precise timing.

Why it matters
- Enables forward inventory and staffing plans around known surges.
- Guides promo and media timing to amplify demand in the right windows.

Weekly sales with peak periods highlighted (top 10% weeks).

Weekly sales with peak periods highlighted (top 10% weeks).


2) Coupon Usage by Income × Household Size

What to look for
- Each bubble represents a customer segment (income × household size).
- Higher = heavier coupon use; larger = more households in the segment.

Why it matters
- Identifies priority segments for coupon distribution and creative.
- Helps balance efficiency (usage rate) with scale (segment size).

Coupon usage rate by income (midpoint) and household size; bubble size = households in segment.

Coupon usage rate by income (midpoint) and household size; bubble size = households in segment.


3) Promotions Increase Spend per Shopping Trip

What to look for
- Bars show average basket value; whiskers display the middle 50% (IQR).
- The gap between bars quantifies the promo lift in dollars and percentage.

Why it matters
- Demonstrates how discounts motivate larger baskets despite price reductions.
- Supports promo calendar decisions and category funding discussions.

Average basket value for promo vs non‑promo baskets; whiskers show the middle 50% (IQR).

Average basket value for promo vs non‑promo baskets; whiskers show the middle 50% (IQR).