Principles of Retailing: Retail Analytics and CRM - Market Basket Analysis, Association Rules Lift Confidence Affinity

What This Is

Market Basket Analysis (MBA) is a retail analytics technique that identifies relationships between products purchased together. This helps retailers optimize product placement, pricing, and promotions. For instance, if a customer buys a pair of jeans and a shirt together, a retailer might infer that these items are complementary and place them near each other in the store.

Key Frameworks & Metrics

• Association Rules: Identifies relationships between products purchased together, e.g., "If a customer buys a coffee, they are 80% likely to buy a pastry."
• Lift: Measures the increase in sales due to a promotion or product placement, e.g., "A 10% increase in sales when a product is placed near a complementary item."
• Confidence: Measures the reliability of an association rule, e.g., "A 90% confidence level that a customer who buys a certain product will also buy another product."
• Affinity: Measures the strength of a relationship between two products, e.g., "A 50% affinity between a customer who buys a certain product and another product."
• Basket Size: Measures the average number of items purchased per transaction, e.g., "An average basket size of 3 items per transaction."
• Conversion Rate: Measures the percentage of customers who complete a purchase, e.g., "A 20% conversion rate for online transactions."
• Customer Lifetime Value (CLV): Measures the total value of a customer over their lifetime, e.g., "A CLV of $500 for a loyal customer."
• Omnichannel Maturity Model: Measures a retailer's ability to provide a seamless customer experience across channels, e.g., "A retailer with a high omnichannel maturity score can fulfill online orders from any store location."
• Inventory Turnover: Measures the number of times inventory is sold and replaced within a given period, e.g., "A 4x inventory turnover rate for a retailer with a high sales volume."
• Gross Margin Return on Inventory Investment (GMROI): Measures the return on investment for inventory, e.g., "A GMROI of 2.5 for a retailer with a high margin product."

Step-by-Step Process

1. Data Collection: Gather transaction data from various sources, including point-of-sale systems, loyalty programs, and online transactions.
2. Data Cleaning: Remove duplicates and inconsistencies from the data to ensure accuracy.
3. Association Rule Generation: Use algorithms to identify relationships between products purchased together.
4. Lift and Confidence Calculation: Calculate the lift and confidence for each association rule to determine its reliability and effectiveness.
5. Affinity Measurement: Measure the strength of each relationship between products.
6. Basket Size and Conversion Rate Analysis: Analyze basket size and conversion rate to identify opportunities for improvement.

Common Mistakes

• Mistake: Ignoring the importance of data quality and accuracy.
• Correction: Ensure that data is clean and consistent before applying MBA techniques.
• Mistake: Focusing solely on short-term sales gains without considering long-term customer relationships.
• Correction: Balance short-term sales gains with long-term customer loyalty and retention strategies.
• Mistake: Treating all channels separately without considering the customer's omnichannel experience.
• Correction: Ensure a seamless customer experience across all channels to build loyalty and drive sales.

Retail Strategy Tips

• Tip: Use MBA to inform product placement and pricing decisions, ensuring that complementary products are placed near each other and priced competitively.
• Tip: Use CLV to prioritize customer retention and loyalty programs, focusing on high-value customers who drive long-term revenue.
• Tip: Use GMROI to optimize inventory levels and reduce waste, ensuring that high-margin products are stocked and sold efficiently.

Quick Practice Scenario

Scenario: A department store has high footfall but low conversion. Which metric would you analyze first and why?

Answer: Conversion Rate. Analyzing conversion rate would help identify opportunities to improve the customer experience and increase sales.

Last-Minute Cram Sheet

• Association Rule: A rule that identifies relationships between products purchased together.
• Lift: Measures the increase in sales due to a promotion or product placement.
• Confidence: Measures the reliability of an association rule.
• Affinity: Measures the strength of a relationship between two products.
• Basket Size: Measures the average number of items purchased per transaction.
• Conversion Rate: Measures the percentage of customers who complete a purchase.
• Customer Lifetime Value (CLV): Measures the total value of a customer over their lifetime.
• Omnichannel Maturity Model: Measures a retailer's ability to provide a seamless customer experience across channels.
• Inventory Turnover: Measures the number of times inventory is sold and replaced within a given period.
• Gross Margin Return on Inventory Investment (GMROI): Measures the return on investment for inventory.
• Omnichannel is not just being present on all channels – it's about a seamless integrated experience across channels.
• CLV is not just a one-time calculation – it's a dynamic measure that changes over time based on customer behavior.
• GMROI is not just a measure of inventory profitability – it's a key driver of retail profitability.