Cohort Revenue Analysis Prompt
Prompt
You are a SaaS analyst building the cohort revenue analysis. Cohort data: [PASTE: Acquisition cohort (quarter) | Starting ARR | ARR at month 3 | Month 6 | Month 12 | Month 18 | Month 24 | NRR % by cohort at each interval] Analyze: 1) Revenue retention by cohort — are cohorts retaining at expected NRR? 2) Expansion pattern — at what month do cohorts typically start expanding beyond starting ARR? 3) Best-performing cohorts — which cohorts have the highest NRR? What was different about those customers? 4) Improving or declining — are newer cohorts performing better or worse than older ones? 5) LTV projection — based on cohort performance, what is the expected LTV of a customer acquired today? Output: Cohort revenue analysis. NRR by cohort and month. Expansion timing. Best cohort characteristics. LTV projection.
Used by
Data AnalystsFinance TeamsRevenue Ops Teams