Churn Risk Detection

Overview

This skill identifies customers exhibiting churn signals by analyzing purchase recency decay, frequency decline, engagement drop-off, and behavioral anomalies. It produces a risk-scored customer list with churn probability estimates, time-to-churn predictions, revenue-at-risk quantification, and prescribed intervention strategies. Designed for non-contractual CPG and retail contexts where churn is silent (customers simply stop buying).

When to Use

Proactively identifying customers likely to churn before they lapse
Building retention trigger campaigns based on behavioral signals
Quantifying revenue at risk from customer attrition
Evaluating the health of a customer base over time
Designing and prioritizing win-back campaigns
Setting up automated churn prevention workflows in CRM/ESP

Required Inputs

Input	Required	Description
Transaction Data	Yes	Customer-level purchase history with dates, amounts, and order counts
Customer IDs	Yes	Unique identifiers for each customer
Analysis Date	Yes	Current date or reference date for recency calculations
Category Purchase Cycle	Recommended	Expected repurchase interval for product category (e.g., 30 days for coffee)
Engagement Data	Recommended	Email opens/clicks, site visits, app sessions over time
Subscription Status	No	Active, paused, cancelled subscription status (if applicable)
Customer Service Data	No	Support tickets, complaints, returns, refund history
Acquisition Channel	No	How the customer was acquired (organic, paid, referral, etc.)

Methodology

Step 1 — Define Churn for the Business

In non-contractual settings, churn must be operationally defined:

Category-Based Churn Definition:

Churn Threshold = Expected Repurchase Cycle × Churn Multiplier

Recommended Multipliers:
  Consumables (coffee, supplements, cleaning): 2.0× → e.g., 30-day cycle → churn at 60 days
  Semi-durable (skincare, personal care): 2.5× → e.g., 60-day cycle → churn at 150 days
  Durable (cookware, appliances): 3.0× → e.g., 180-day cycle → churn at 540 days
  Grocery basket: 1.5× → e.g., 14-day cycle → churn at 21 days

If category cycle is unknown, calculate from data:

Median Inter-Purchase Interval (IPI) = Median of (Order Date N+1 - Order Date N) across all customers

Churn Threshold = Median IPI × 2.0 (or use 75th percentile IPI × 1.5)

Step 2 — Behavioral Signal Extraction

Extract churn signals across multiple dimensions:

Purchase Behavior Signals:

Signal	Calculation	Churn Indicator
Recency Gap	Days since last purchase ÷ Avg IPI	Ratio >1.5 indicates concern; >2.0 critical
Frequency Decline	Orders in last 90d vs. prior 90d	>30% decline is a strong churn signal
AOV Decline	AOV last 3 orders vs. lifetime AOV	>20% decline indicates reduced commitment
Basket Shrinkage	Items per order trending down	Reducing engagement with product range
Category Narrowing	# categories last 3 orders vs. historical	Down-trading to fewer categories
Promotion Dependency	% of recent orders with discount code	Increasing to >80% signals price-only loyalty

Engagement Signals:

Signal	Calculation	Churn Indicator
Email Open Decay	30-day open rate vs. 90-day average	>40% decline
Click-through Decline	30-day CTR vs. 90-day average	>50% decline
Site Visit Frequency	Sessions last 30d vs. prior 30d	>50% decline
App Uninstall	App removed or sessions dropped to zero	Strong churn signal
Loyalty Inactivity	Points earned last 60d = 0 (for loyalty members)	Disengagement signal

Service Signals:

Signal	Churn Indicator
Recent complaint (unresolved)	2× churn risk elevation
Multiple returns (3+ in 90 days)	3× churn risk elevation
Negative review or rating	1.5× churn risk elevation
Subscription downgrade or pause	Immediate intervention needed
Delivery failure or late shipment	1.5× churn risk elevation (compounding)

Step 3 — Churn Risk Scoring Model

Build a composite churn risk score (0–100):

Weighted Signal Model:

Churn Risk Score = 
    (Recency Gap Score × 0.30) +
    (Frequency Decline Score × 0.25) +
    (Engagement Decay Score × 0.20) +
    (AOV/Basket Decline Score × 0.10) +
    (Service Issue Score × 0.10) +
    (Promotion Dependency Score × 0.05)

Each component scored 0–100:
  Recency Gap Score = min(100, (Days Since Purchase ÷ Churn Threshold) × 100)
  Frequency Decline Score = min(100, max(0, (1 - Recent Freq ÷ Historical Freq) × 100))
  ...etc.

Risk Tier Classification:

Tier	Score Range	Estimated Churn Probability	Urgency
Low Risk	0–25	<10%	Monitor quarterly
Moderate Risk	26–50	10%–30%	Monitor monthly; soft engagement
High Risk	51–75	30%–60%	Active intervention within 2 weeks
Critical Risk	76–100	>60%	Immediate intervention; likely churning now

Step 4 — Revenue-at-Risk Quantification

Calculate the financial impact of potential churn:

Revenue at Risk (per customer) = Predicted Annual Revenue × Churn Probability

Where Predicted Annual Revenue = Historical AOV × Historical Annual Frequency

Aggregate Revenue at Risk = Σ (Revenue at Risk per customer) for all customers with score >50

Segment-Level Risk Summary:

Segment        | Customers at Risk | Avg Churn Score | Revenue at Risk | % of Total Revenue
Champions      | XX                | XX              | $XX,XXX         | X%
Loyal          | XXX               | XX              | $XXX,XXX        | XX%
At Risk        | X,XXX             | XX              | $XXX,XXX        | XX%
Total          | X,XXX             | --              | $X,XXX,XXX      | XX%

Step 5 — Churn Driver Analysis

Identify the primary churn drivers in the customer base:

Recency-driven churn: Customers simply haven't returned — no engagement decline, just inactivity
Experience-driven churn: Customers had negative experiences (returns, complaints, delivery issues)
Value-driven churn: Customers only buy on promotion; churn when discounts stop
Competition-driven churn: Cross-shopping signals (declining share of wallet)
Lifecycle-driven churn: Natural category exit (e.g., baby products as children age out)
Subscription fatigue: Active subscription cancellations or skip frequency increasing

Map each at-risk customer to their primary churn driver for targeted intervention.

Step 6 — Intervention Prescription

Prescribe actions based on risk tier and churn driver:

Risk Tier	Driver	Intervention	Channel	Timing
High	Recency	"We miss you" + incentive	Email + SMS	Day 1 of high-risk classification
High	Experience	Service recovery outreach	Personal email or phone	Within 48 hours
High	Value	Exclusive loyalty offer (not discount)	Email	Day 3
Critical	Recency	Escalated offer + free shipping	SMS + push	Immediate
Critical	Subscription	Pause option + downsell offer	Email + in-app	Pre-cancellation trigger
Moderate	Recency	Content re-engagement (new products, tips)	Email	Weekly cadence
Moderate	Value	Bundle offer or subscribe-and-save pitch	Email	Next promotional window

Incentive Ladder (escalating offers for non-responsive at-risk customers):

Day 0: Personalized product recommendation (no incentive)
Day 7: 10% off next order
Day 14: 15% off + free shipping
Day 21: 20% off + free gift with purchase
Day 30: Final win-back: 25% off "last chance" offer
Day 45: Move to suppression list; reduce marketing spend

Step 7 — Monitoring & Alert System Design

Define ongoing churn monitoring:

Daily scan: Flag newly critical-risk customers for immediate action
Weekly digest: Summary of risk tier migration (how many moved from moderate to high?)
Monthly review: Churn rate trend, intervention effectiveness, revenue-at-risk dashboard
Quarterly recalibration: Adjust scoring weights based on observed churn vs. predicted churn

Alert Triggers:

Customer crosses from moderate to high risk → trigger retention workflow
High-value customer (top 10% LTV) enters high risk → alert customer success team
Churn rate exceeds baseline by >20% → flag systemic issue for investigation
Subscription cancellation initiated → trigger save flow

Output Specification

Churn Risk Scorecard: Every customer scored with risk tier, probability, and primary driver
Revenue-at-Risk Summary: Aggregate and segment-level revenue exposure
Top 50 At-Risk Customers: Prioritized list of highest-value customers at greatest risk
Churn Driver Distribution: Breakdown of primary churn causes across the at-risk population
Intervention Playbook: Per-tier, per-driver recommended actions with channel and timing
Monitoring Dashboard Spec: Metrics, thresholds, and alert rules for ongoing churn tracking

Examples

Input: "Identify churn risk for our pet food DTC brand. 25,000 customers, average repurchase cycle is 28 days. We've noticed a spike in subscription cancellations."

Output: 3,200 customers (13%) classified as high or critical risk, representing $420K in annual revenue at risk. Subscription cancellers (800 customers) are the highest-risk cohort; primary driver is subscription fatigue (average tenure 8 months). Recommendation: introduce "pause" option, flexible delivery frequency, and surprise-and-delight program at month 6. Non-subscription at-risk customers show recency-driven patterns; prescribe a 4-step incentive ladder.

Input: "Our beauty brand has 60% first-year churn. Help us understand why and who's most at risk."

Output: Churn analysis reveals 42% of first-year churn happens before the 2nd purchase (within 60 days). Primary driver: post-purchase disengagement (no email engagement after order confirmation). High-risk new customers identified by: no email open within 14 days, no site revisit within 30 days, and single-SKU first order. Intervention: redesigned post-purchase nurture sequence with education content, usage tips, and day-45 reorder incentive.

Guidelines

Non-contractual churn (CPG/retail) requires probabilistic estimation — there is no single "churn event"
Always define churn threshold relative to category purchase cycle, not arbitrary time periods
Combine behavioral signals; no single metric reliably predicts churn alone
High-value customers warrant more aggressive (and more expensive) retention interventions
For low-value, high-churn segments, it may be more efficient to let them churn than to invest in retention
Distinguish between addressable churn (can be prevented) and structural churn (lifecycle exit)
Track intervention effectiveness: what % of high-risk customers were retained after intervention?
Avoid "discount addiction" — escalate non-monetary value (exclusive access, content, community) before discounts
For subscription businesses, monitor skip rate and frequency changes as early warning signals

Validation Checklist

Churn is operationally defined with category-appropriate thresholds
Multiple behavioral signals are combined (not relying on recency alone)
Risk scores are calibrated against observed churn rates
Revenue at risk is quantified at customer and segment level
Churn drivers are identified and mapped to specific interventions
High-value at-risk customers are prioritized for immediate action
Intervention playbook includes escalation ladder and channel recommendations
Monitoring system includes automated alert triggers
False positive rate is assessed (customers flagged but didn't actually churn)

churn-risk-detection