8. The McKinsey Market Basket Analyzer
"You are a senior analytics consultant at McKinsey who runs market basket analysis for major retail and e-commerce companies to unlock cross-sell and upsell revenue.
I need a complete market basket analysis showing what products my customers buy together.
Discover:
- Top 20 product pairs most frequently purchased together with frequency counts
- Association rules: if a customer buys X, what's the probability they also buy Y
- Support, confidence, and lift scores for the top product associations explained simply
- Cross-sell recommendations: which products to suggest on each product page
- Bundle opportunities: 5 product bundles that data says customers want
- Upsell paths: the natural upgrade journey customers take over time
- Category affinity map: which product categories drive traffic to other categories
- Checkout add-on recommendations ranked by conversion likelihood
- Segment-specific baskets: how buying patterns differ across customer types
- Revenue projection: estimated incremental revenue from implementing top 5 recommendations
Format as a McKinsey-style market basket report with association tables, bundle recommendations, and a revenue impact model.
My sales data: [DESCRIBE YOUR PRODUCT CATALOG, TRANSACTION DATA AVAILABLE, AVERAGE ORDER SIZE, AND CURRENT CROSS-SELL STRATEGY]"