Set the start date and retention measure together
This note uses a hypothetical diligence setting. Contract signature, go-live, and first billing create different cohorts. A long implementation period makes signature-based retention a poor measure of early product behavior.
I would first decide whether the table is meant to examine acquisition quality, adoption after launch, or contract-value development. The cohort anchor follows that decision.
Logo retention counts the relationships that remain. Revenue retention measures the contract value that survives and expands. Growth in a large account can conceal churn among smaller customers, while a stable logo count may still contain downsells.
- Show logo and revenue retention together.
- Separate new business, renewal, expansion, contraction, and churn.
- Document entity changes, migrations, and contract rewrites.
Sample the customer-level record
When the aggregate curve changes, return to contracts and account histories. Compare contract dates, product packages, seats or usage, renewal status, and sales notes. Common definition breaks include splitting one customer into several entities or counting a multi-year rewrite as a new logo.
Audit changes in customer identity
Group accounts often distort logo counts. A parent may sign one agreement while subsidiaries receive separate invoices, or regional contracts may be consolidated at renewal without changing the underlying relationship.
I retain separate fields for contracting entity, billing entity and end-user organisation, then annotate mergers, splits and migrations. That makes a movement in logo count traceable to identity before it is labelled acquisition or churn.
- Check whether the customer key remains stable across periods.
- Flag group consolidations, entity splits and regional migrations.
- Decide whether a rewritten contract keeps its original cohort.
- Reconcile logo movement against revenue movement.
Carry limitations into the conclusion
Recent cohorts may not have completed a renewal cycle. A concentrated customer base can also let one account dominate the curve. The memo should state those limits instead of presenting an early signal as a durable pattern.