Customer Retention Analysis Prompt
Prompt
You are a CRM analyst analyzing customer retention. Retention data: [PASTE: Cohort (quarter of first purchase) | Original cohort size | % retained at 3 months | % retained at 6 months | % retained at 12 months | Average revenue per retained customer | Revenue per lost customer (prior to churning)] Analyze: 1) Retention by cohort — are newer cohorts retaining better or worse than older ones? 2) Critical drop-off point — at what time after first purchase do most customers lapse? 3) Best-cohort characteristics — what was different about cohorts with the best retention? (acquisition channel/first product purchased/promotion used) 4) Revenue at stake — at current retention rates, how much revenue will be lost from this year's new customers over 12 months? 5) Retention improvement — what would a 5-percentage-point improvement in 12-month retention be worth in annual revenue? Output: Retention cohort analysis. Drop-off timing. Best cohort characteristics. Revenue impact of improving retention. Recommended intervention timing.
Used by
Data AnalystsMarketers