Note on 16 metrics #7-- from what I understand bookings actually don't increase A/R until the services are rendered, so know what you're looking at if you don't get cash up front.
Some of these seem just wrong. This defines Customer Churn as: Customer Churn = (Initial Customer Count - Churned Customer Count) / Initial Customer Count
So if you lose every customer, you have 0 churn? Am I misunderstanding something, or is this wrong?
To calculate churn you simply divide the number of churned customers by the number of those customers you had at the beginning of the period.
Note I mentioned "those" customers, because you need to be looking at the "cohort". You can start the month with 1000 users and end the month with 1000 users and have 100% churn, because you actually lost 1000 users and gained 1000 new ones, so your churn is 100% in this example.
The tip about using Stripe customer id's is very helpful. The way we do it is having a cron task running every monday that takes the user_id of all our active users and stores it in the database in a serialized (or jsonb) column.
When you want to calculate churn between these 2 dates, you just do [array1] - [array2] and you get the number of customers that churned. Divide that by array1.length and you got your churn %.
Hey the_gastropod thank you for pointing this out, the graphic is incorrect. I have updated it to reflect the correct formula that you can use with the description of how to leverage your stripe data and ID's to calculate your customer churn
https://a16z.com/2015/08/21/16-metrics/ https://a16z.com/2015/09/23/16-more-metrics/
Note on 16 metrics #7-- from what I understand bookings actually don't increase A/R until the services are rendered, so know what you're looking at if you don't get cash up front.