Churn Risk Scoring

Analyze these customer behavior signals to identify churn risk. For each customer, evaluate: - Days since last purchase vs. their typical purchase interval - Trend in order frequency (increasing, stable, or declining) - Recent support tickets or complaints (if provided) - Email engagement trend (if provided) - Average order value trend Score each customer's churn risk as High / Medium / Low with a brief rationale. For the top 20 highest-risk customers, recommend a specific intervention: - "Discount offer" — for price-sensitive customers showing purchase decline - "Personal outreach" — for high-LTV customers with recent complaints - "Product recommendation" — for customers whose usual repurchase cycle is overdue - "Win-back sequence" — for customers likely already churned Include timing: when to reach out for maximum recovery probability. Here is my customer data: [PASTE YOUR DATA]

**Churn Risk Summary:** | Risk Level | Count | % of Base | Annual Revenue at Risk | |------------|-------|-----------|----------------------| | High Risk | 47 | 5% | $38,400 | | Medium Risk | 123 | 12% | $22,100 | | Low Risk | 830 | 83% | — | **Key Insight:** 3 of your top 5 at-risk customers have unresolved support tickets. Resolve these BEFORE sending discount offers — fixing service issues yields 2-3x better retention than discounts for complaint-driven churn. **Top 10 Priority Interventions:** | # | Customer | LTV | Overdue | Signal | Action | When | Channel | |---|----------|-----|---------|--------|--------|------|---------| | 1 | C0234 | $1,240 | 45 days | Frequency dropped 60%, 1 ticket | Resolve ticket + personal outreach | Immediate | Phone + email | | 2 | C0891 | $890 | 30 days | 2 support tickets, email opens 5% | Fix issues + "we fixed it" + 15% off | Within 48h | Support + email | | 3 | C0445 | $670 | 60 days | Email opens at 0%, AOV declining | SMS win-back: 20% off favorites | This week | SMS (email dead) | | 4 | C0312 | $580 | 52 days | Purchase interval 2.3x normal | "Running low?" replenishment reminder | This week | Email | | 5 | C0178 | $520 | 38 days | AOV dropped 40% last 2 orders | Product quiz → personalized bundle rec | Within 7d | Email | | 6 | C0667 | $490 | 70 days | No engagement, previously 4x/yr buyer | Final SMS: 25% off, one-click reorder | This week | SMS only | | 7 | C0823 | $440 | 42 days | Support ticket + declining opens | Resolve ticket + curated recommendations | Within 48h | Email + SMS | | 8 | C0156 | $380 | 55 days | Browsed 3x without buying last month | Retarget with viewed-product ad + 10% off | Within 7d | Meta ads | | 9 | C0934 | $350 | 48 days | Email opens dropped 80% → 15% | Re-engagement: "New arrivals since you left" | Within 7d | Email | | 10 | C0401 | $310 | 65 days | Subscription cancelled last month | Personal email: "Why did you cancel?" survey | Within 7d | Email | **Projected Recovery:** At 25-30% win-back rate on top 10, expect to recover $1,400-$1,700 in annual revenue within 30 days.