✏️Prompts

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