How to separate voluntary and involuntary cancellations for users who expired before and after trial expired?

To obtain this data, what you can do is:

  • Download the Subscriptions - Churned export
  • Go to the expiration_reason column to filter out either voluntary or involuntary churn reasons depending on which category you're looking at 1st
  • Then compare the trial_ends_at date with the expires_at date column.

If the subscription expired on the same date as the trial_ends_at date, then this means that the customer was never billed. If the expiration date is after the trial_ends_at date, then this means the subscription did convert and the customer was billed.