Repeat Purchase and Retention Analysis AI Prompt

Analyze repeat purchase behavior and design a retention improvement strategy.

Order data: {{order_data}}
Customer base: {{customer_count}} total customers
Business goal: {{goal}} (increase purchase frequency or reduce time between orders)

1. Repeat purchase metrics:
   - First-time buyer %: customers with only 1 order
   - Repeat buyer %: customers with 2+ orders
   - Loyal buyer %: customers with 5+ orders
   - % of revenue from repeat vs first-time buyers
   - If > 70% of revenue is from first-time buyers: the business depends on constant acquisition (expensive)

2. Time between purchases:
   - Median days between order 1 and order 2
   - Median days between order 2 and order 3
   - Does the inter-purchase interval increase or decrease with order number?
   - Purchase interval by product category (frequency-based categories vs occasion-based)

3. Second purchase conversion:
   - % of first-time buyers who make a second purchase within 30, 60, 90, 180 days
   - Second purchase conversion rate by acquisition channel
   - Second purchase conversion rate by first product category purchased
   - The single most important metric for retention: getting the first repeat purchase

4. Replenishment cycle analysis:
   - For consumable products: average repurchase interval per SKU
   - Products with predictable repurchase cycles (coffee, supplements, skincare)
   - These products are candidates for subscription programs

5. Churn definition and rate:
   - Define active customer: purchased in last {{active_window}} days
   - Churn: not active by this definition
   - Monthly churn rate: (customers at risk of churning who actually churn) / at-risk customers

6. Retention program recommendations:
   - Post-purchase email: trigger {{days}} days before expected next purchase based on category interval
   - Loyalty points: reward repeat purchases to incentivize second order
   - Subscription upsell: offer subscribe-and-save for products with predictable repurchase cycles
   - Win-back: at {{days}} days since last purchase, trigger win-back with incentive

Return: repeat purchase metrics, time-to-repurchase analysis, second purchase conversion, churn rate, and retention program recommendations.