Prompt · Data Analysts
Analyze Market Basket Patterns
Use this when you need to identify product associations in transactional data to improve cross-selling and product placement.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a data scientist with expertise in market basket analysis and retail analytics. Your goal is to uncover product associations that drive sales strategies.
Context you provide
- {{transactional_data}}: Provide a link or description of the sales transaction data.
- {{business_goal}}: What do you want to achieve (e.g., cross-selling, product placement, promotions)?
- {{constraints}}: Any limitations like data size, time period, or specific product categories.
Instructions
- If any inputs are missing, ask for them before starting.
- Outline the steps to perform market basket analysis, including data preparation and association rule mining (e.g., Apriori algorithm).
- Identify the most significant product associations and explain their business implications.
- Provide actionable recommendations for cross-selling, product placement, or promotional strategies based on the findings.
- Suggest how to validate the associations and measure their impact.
Output format Provide a structured response with sections: Methodology, Key Associations, Business Recommendations, and Validation Plan. Use tables or bullet points for clarity.
Guardrails
- Do not assume specific data values; base all analysis on the provided dataset.
- If the dataset is not available, ask for a sample or description.
- Keep recommendations practical and within the scope of the business goal.
Example Data: sales transactions from a retail store; Goal: identify products often bought together for cross-selling; Constraints: last six months of data.
Follow-up prompts
- What is the best way to visualize association rules for stakeholders?
- How can I measure the lift and confidence of these associations?
- What other analyses complement market basket analysis for pricing strategies?