Abstract
Customer churn is when the customers either switch from their incumbent service provider to its competitor or stop using the service altogether. Per existing research, it costs five to six times more to acquire customers than to retain existing customers, and this emphasizes the importance of managing churn by organization. In this paper, we build Churn prediction model for one of India’s largest Direct to Home (DTH) operator, for its customer base. We use data provided by the DTH operator to build the model. Given the varied base of customers, the data was segmented in smaller homogenous chunks, with similar profile and behaviour. To achieve this, we conducted segmentwise analysis to determine the factors that affect churn differently in different segments. This indicated the need to have different models. Analysis showed that age on the network was the key segmentation driver and hence separate models were built for each segment. We further applied various data mining techniques such as logistic regression, random forest and gradient boosting method to build the model for each segment. Gradient boosting method outperformed both logistic regression and random forest on measures of AUC and Gini. The proposed model correctly classifies churn customers between 76 and 78% depending on the segment. The primary drivers of churn across all the segments for DTH are the age of the customer, type of package subscribed, longest delinquency, maximum amount recharged and maximum valid days for which customer has recharged their set up box. The paper also shows that customer experience while interacting with operator and quality of device are equally important attributes.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
Bansal, S. (2015). What’s eating DTH operators. LiveMint, May 07, 2015.
Breiman, L. (2001). Random forests. Machine learning, 45(1), 5–32.
Hastie, T., Friedman, J., & Tibshirani, R. (2013). The elements of statistical learning (1st ed., pp. 359–361). New York: Springer.
Kamalraj, N., & Malathi, A. (2013). A survey on churn prediction techniques in communication sector. International Journal of Computer Applications (0975 – 8887), 64(5).
Lazarov, V., & Capota, M. (2007). Business analytics course. TUM Computer Science.
Portela, S., & Menezes, R. (2009). Modelling customer churn: An application of duration models. Portugal: Department of Quantitative Methods, ISCTE Business School.
Rajeswari, P. S., & Ravilochanan, P. (2014). An empirical study on customer churn behaviour of indian prepaid mobile services. Middle-East Journal of Scientific Research, 21(7), 1075–1082.
Sharma, A., & Panigrahi, P. K. (2011, August). A neural network based approach for predicting customer churn in cellular network services. International Journal of Computer Applications (0975 – 8887), 27(11).
The Indian Telecom Services Performance Indicators. Telecom Regulatory Authority of India, January–March 2016.
Tsai, C.-F., & Lu, Y.-H. (2010). Data mining techniques in customer churn prediction. Recent Patents on Computer Science, 3, 28–32.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Appendix
Appendix
1.1 Validation Table Circlewise
See Table 8.
1.2 Cumulative Capture Rate (ROC) Curve at Segment Level for Different Circles
Cumulative capture rate (ROC) curve at segment level: AON less than 1 year
Cumulative capture rate (ROC) curve at segment level: AON between 1 and 2 year
Cumulative capture rate (ROC) curve at segment level: AON between 2 and 4 year
Cumulative capture rate (ROC) curve at segment level: AON greater than 4 year
1.3 Validation Table Monthwise
See Table 9.
1.4 Cumulative Capture Rate Curve at Segment Level for Different Months of Recharges
Cumulative capture rate (ROC) curve at segment level: AON less than 1 year
Cumulative capture rate (ROC) curve at segment level: AON between 1 and 2 year
Cumulative capture rate (ROC) curve at segment level: AON between 2 and 4 year
Cumulative capture rate (ROC) curve at segment level: AON greater than 4 years
Rights and permissions
Copyright information
© 2019 Springer Nature Singapore Pte Ltd.
About this chapter
Cite this chapter
Goenka, A., Chintu, C., Singh, G. (2019). Predicting Customer Churn for DTH: Building Churn Score Card for DTH. In: Laha, A. (eds) Advances in Analytics and Applications. Springer Proceedings in Business and Economics. Springer, Singapore. https://doi.org/10.1007/978-981-13-1208-3_9
Download citation
DOI: https://doi.org/10.1007/978-981-13-1208-3_9
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-13-1207-6
Online ISBN: 978-981-13-1208-3
eBook Packages: Business and ManagementBusiness and Management (R0)