Customer cohort retention summary
Summarize NRR and GRR by quarterly cohort and surface the two cohorts driving the largest delta vs. plan.
Copy and customize
You are a senior CFO producing the following deliverable: customer cohort retention summary.
Context
- Workflow: Strategic & Ad-Hoc
- Inputs available: {paste the data here}
- Period: {month / quarter}
- Audience: {who reads this}
What to produce
1. The headline takeaway in one sentence.
2. The three things that materially moved the result, with quantified contribution.
3. The one risk or anomaly worth flagging.
4. A short forward-looking note: what to watch next period.
Guardrails
- Use only the numbers provided; do not invent values.
- Cite a row reference for every claim.
- Flag anything you cannot reconcile rather than smoothing it over.
Run it in four steps
- Assemble customer-level ARR snapshots for each quarter in scope, using a customer identity that holds steady across time.
- Paste them into
{paste the data here}and set the period range in{month / quarter}. - Run it to summarize NRR and GRR by cohort and surface the two cohorts driving the largest variance to plan.
- Before trusting the deltas, confirm no customers were silently merged or renamed between snapshots, which inflates both churn and expansion.
When to reach for this prompt
Run quarterly, ideally a week before the board meeting. Pair with the ARR bridge if NRR is moving and you need to explain why.
What you can expect back
| Quarterly cohort | GRR | NRR | ARR | vs plan |
|---|---|---|---|---|
| Q1 '25 | 91% | 118% | $12.4M | +$0.6M |
| Q2 '25 | 89% | 112% | $14.1M | -$0.2M |
| Q3 '25 | 87% | 108% | $13.8M | -$0.8M ← largest miss |
| Q4 '25 | 93% | 122% | $16.2M | +$0.4M |
Drivers of Q3 '25 miss: two enterprise downsells in fintech vertical.
This prompt has real limitations you should understand.
Retention rates depend on a stable customer definition. If you reorganize accounts (mergers, splits, subsidiary reassignments) the cohorts shift and historicals stop being comparable. Document any account-restructuring events explicitly.
Customer identity is unstable
Mergers, splits, and subsidiary moves silently restructure cohorts. A "churn" in one quarter is sometimes a re-org in the parent account. The prompt cannot tell — and the cohort it reports as worst-performing might actually be your healthiest.
Small cohorts swing wildly
Quarterly cohorts with a handful of customers can swing twenty points on a single downsell. The prompt reports the number with the same confidence it reports a 200-customer cohort, and leadership will react accordingly.
Plan view is often stale
NRR / GRR targets baked into the original plan rarely get updated as the business shifts segments. The "delta vs. plan" the prompt reports may be measuring against a target no one believes anymore.
What your data needs to look like
- Customer-level ARR snapshots for each quarter analyzed
- A consistent customer identity over time (no silent merges)
- A planning view of NRR / GRR targets by cohort
See how FinanceOS handles this prompt on real financial data.
Book a 20-minute walkthrough. We’ll run this exact prompt against a sample dataset reconciled through FinanceOS, and show you what changes when the data underneath is right.
Book a walkthrough