Fictura
Funnel & cohorts

Churn states

Nine mutually exclusive states derived from a user's latest billing events — never stored, so they can't go stale.

StateMeaning
in_trialInside a free trial that hasn't resolved.
convertedPaid — a trial that converted, or a direct purchase.
cancelledAuto-renew switched off; access continues until the period ends.
expiredAccess has actually ended.
billing_issueA payment failed and the card is being retried, with no grace period.
grace_periodA payment failed and the store is keeping access open while it retries.
pausedThe subscription is paused (Play Store).
refundedThe store refunded the purchase.
noneNo billing history at all.

States are derived on read from the billing event stream — RevenueCat and Stripe webhooks — rather than written to a column, so a late-arriving event corrects history automatically. An UNCANCELLATION (or a reversed refund) restores the state the user was in before. States read both the current billing names and the older ones, so history written before the rename counts the same.

Cancelled ≠ expired

The distinction runs through the whole product (and the billing webhook): cancelled users still have access and are the win-back window; expired users don't. Treating the two as one state undercounts your recoverable revenue.

You'll meet the same states in the Trial outcomes card, on each row of the Users table, on the single-user page, and as the cohort axis in Cohort compare. Trial conversion rate is trial users who paid ÷ all trial users.