Codeflix Churn Rates Analysis
This research project was implemented using SQL.
The project is concenrated on the calculating churn rates for 2 different segments over the 3 months period for a new company Codeflix.
Codeflix is a streaming video startup. It offers its customers 2 diffrent types of subscription.
I have analyzed the churn rate for 2 subscription types over the 3 months period. The drop rate in subscriptions in segment_30 turned out to be much lower than in segment_87. The highest churn rate for segment_30 is equal to 12%, while for segment_87 it's more than 3 times higher - 49%. In March 2017 almost half of subscribers of segment_87 cancelled their subscription.
The analysis allowed to clearly see difference in drop rate between two segments throughout the time. By recognizing this discrepancy, Codeflix can now make more informed decisions tailored to each segment. This granularity in understanding customer behavior will enable the company to allocate resources and efforts more effectively, ultimately leading to improved customer retention and profitability.
You may check the code and PDF presentation following the link below.