The energy provider puts great value on service, but few activities have been carried out in the area of churn prevention. In general, energy providers rarely have a centralized 360-degree view of customers. On the contrary, customer data is often stored in a very fragmented manner (partly due to data security and privacy regulations), and is difficult to integrate into a uniform data model for analysis. However, a uniform data model is the prerequisite to identify customers at risk of churn.
To reduce customer workload and overhead costs, Contiamo has introduced a simple but efficient system that delivers results in a very short time. The chosen tools naturally allow for easy extension and integration into the customers’ ecosystem later on.
We defined project phases in advance and had regular meetings for two-way discussions of the data and to present our results:
- Kickoff workshop to identify available data, discuss hypotheses on churn reasons and define the prediction target
- Data transfer with continuous support
- Data cleaning and preparation so that transformed datasets are suitable for machine learning and can be furthermore be reused for other analytical questions
- Data investigation and churn analysis in both Tableau and Jupyter notebooks
- Model preparation: identification of churn-influencing factors (thus strong predictors for the final machine learning model)
- Modelling: Creation of snapshots of the customer journey and training & testing of the churn prediction model
- Backtesting and generation of the output: churn predictions for customers including risk factors
- Real-world testing with collaboratively discussed prevention measures
43% preventable cancellations
360-degree customer insights
The client was looking for a way to prevent customer churn through data analytics. The Contiamo team developed a predictive model that showed which customers were most likely to quit soon, including the most relevant risk factors for these customers. This explainable model design and the good prediction rate (up to 43% in the most at-risk group) enabled the energy provider to take targeted measures to prevent churn of customers at highest risk. The model highlighted new topics for further analyses: e.g., personalizability of tariff suggestions and customer service support with recommendations for actions.