Building renewal cohorts from first payment, not invoice month

Invoice date is convenient for accounting. It is often a poor spine for renewal cohorts. Annual members billed in March for a year that began in November will never sit beside the peers they actually joined with if you cut by invoice month alone.

First successful payment (or first activated entitlement, where that is cleaner) keeps people who entered together in the same cohort. You can still show finance an invoice-month view — just label it as a billing cut, not as the lifecycle cohort.

When monthly and annual plans share a product family, draw separate cohort lines by term length before you compare retention. Mixing them produces a “churn” pattern that simply reflects when the long contracts come due.

If your warehouse cannot yet join first payment to the member record, document that gap in the measurement map. A partial cohort with an honest caveat beats a tidy chart built on the wrong date.