Customer Churn

Businesses use customer churn analysis as one of their key business metrics because the cost of retaining an existing customer is far less than acquiring a new one.

Churn = Percentage of existing customers who stop purchasing your products or services, often measured in a year.

How can data analytics help?

Predicting when, why, and which customers will return or leave is a big challenge for many businesses. Predictive marketing can help flag customers who are at risk of leaving so that marketers can take proactive steps to retain these customers. Predictive analytics can also generate insights about loyalty-inducing behaviors that maximize customer lifetime value. Understanding the underlying customer patterns will greatly impact a business' ability to retain their customers.

Case Study: How can I help to reduce churn and increase revenue?

For a telecommunications company, I have done an extensive analysis to help reduce churn. The telectommunications company wanted to know what causes customers to churn and whether one can know which customers are likely to churn.

Out of a total of 7043 customers, 26.6% of them have churned over the analysis period. That is about 1900 customers.

Who is churning?

We identified some of the types customers who are likely to churn. We compare the churn rate with average monthly recurring revenue (MRR).

A quick glance at the demographics and we can see that although seniors account for only 16% of the customers, they have a higher MRR and churn rate than those who are not seniors.

Gender does not seem to influence whether a customer will churn or not and both genders bring in similar average monthly revenue.

More than half of the customer base are on a month-to-month contract. This time of contract has a churn rate greater than 40%, meanwhile one-year contracts has less than 15% churn and two-year contracts has less than 5% churn.

It is clear that the ease of ending a contract influences churn rate immensely and with month-to-month contracts being more than 50% of customers, this cannot be ignored.

When are they churning?

The average customer tenure is 29 months. The churn rate is the highest (>40%) in the first five months with the first month reaching over 60% churn. The longer the customers stay, the lower their chances are of leaving.

Customers with monthly charges higher than $65 are the most susceptible to churn. The company is losing more valuable customers. Interestingly enough, there's a slight increase in customer retention when the monthly charges are between $65-$85.

Do you want to know more about how data analysis can help you? Please get in touch with me

: lutosibotoboto@gmail.com
|
© Luto Sibotoboto