You can find the SQL code and query results here.
Churn Rate with Codeflix
This project was a simple one for a common question: calculate the churn rate of subscribers to a service over time. Churn rate is the rate at which existing subscribers cancel their subscription. For example, if Netflix had 100,000 subscribers in January, then 10,000 canceled their subscription, the churn rate would be
10,000 / 100,000 = 10%
This is helpful for following membership trends, especially– as we can see in the resulting project– when comparing one test group against another.
The data I used was from Codeflix, a streaming service that provides educational STEM videos. It included user ids, their subscription start date, subscription end dates, and a test segment number. The dataframe covered a time period from December, 2016 through March, 2017. Using SQL, I calculated the monthly churn rate for the two segments. As the report shows, segment 30 performed significantly better than segment 87, but something occurred in March that increased churn rate in both segments.
Like with my previous project, I elected to complete my report using Prezi.
If the infographic does not show above, try refreshing the page– or just giving it a minute to render.