The documentation includes sample queries for revenue, active trials, and active subscriptions but there are no sample query for churn. How to determine churn as shown in charts? And how to determine the active subscriptions per day that shows a deduction when a user unsubscribes?
Solved
How to calculate churn from the transaction data in S3?
+4Best answer by tina
Hey
A general calculation for the churn chart is (number of subscriptions expired during period – re-subscriptions) / (number of paid subscriptions at the start of the period) * 100
Re-subscriptions is just the number of renewals during the period. Once thing to note if that a subscription is not counted as “churned” until the subscription actually expires. Which means when a customer turns off their auto renewal status (unsubscribes), they will only be counted as “churned” when the subscription expires.
You won’t be able to reproduce the churn chart exactly, but it should get you in the correct ballpark.
This post has been closed for comments
+10Hey
A general calculation for the churn chart is (number of subscriptions expired during period – re-subscriptions) / (number of paid subscriptions at the start of the period) * 100
Re-subscriptions is just the number of renewals during the period. Once thing to note if that a subscription is not counted as “churned” until the subscription actually expires. Which means when a customer turns off their auto renewal status (unsubscribes), they will only be counted as “churned” when the subscription expires.
You won’t be able to reproduce the churn chart exactly, but it should get you in the correct ballpark.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.