Complete AI Training

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.

All 16 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. 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

  1. If any inputs are missing, ask for them before starting.
  2. Outline the steps to perform market basket analysis, including data preparation and association rule mining (e.g., Apriori algorithm).
  3. Identify the most significant product associations and explain their business implications.
  4. Provide actionable recommendations for cross-selling, product placement, or promotional strategies based on the findings.
  5. 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?