Reducing Customer Churn for XL Axiata Prepaid: Factors and Strategies
Main Article Content
Abstract
Understanding and mitigating customer churn is pivotal for companies, especially those operating with subscription models like telecommunications firms. This study focuses on XL Axiata Company, delving into the factors driving customer churn. The data used is from a questionnaire and focuses on consumers who have used prepaid cards and are considered churn customers, while customers who continue to use cards are termed non-churn customers. Using machine learning algorithms such as logistic regression, ANN, and XGBoost, the data is applied in the prediction step of customer churn classification. The best machine learning method's coefficient results will be followed by strategy analysis using the QSPM method and risk analysis of the loss distribution using the CVaR method. According to the findings of this study, ANN is the most accurate machine learning method, and network factors are the most important factors in customer churn, followed by level of interest in VAS products, company services, failed calls, customers who have made calls to call service, package prices that are fairly expensive, and ads that are less attractive. The QSPM strategy study indicated an AI/ML approach to examine the bundling promo with VAS products, taking into account the impact on customer churn and implementation costs. The CVaR risk analysis results reveal that the VAS products that can be prioritized in the VAS promo plan are bundling products in the form of primary quotas and online games, which are more profitable than bundling with video streaming or chatting.
Article Details
This work is licensed under a Creative Commons Attribution 4.0 International License.
This work is licensed under a Creative Commons Attribution 4.0 International License.
References
Abdelmonem, M. S., & Elgeuoshy, O. (2021). Strategic Management Audit For Orange Egypt for Telecommunications Prepared by.
Ahn, J. H., Han, S. P., & Lee, Y. S. (2006). Customer churn analysis: Churn determinants and mediation effects of partial defection in the Korean mobile telecommunications service industry. Telecommunications Policy, 30(10–11), 552–568. https://doi.org/10.1016/j.telpol.2006.09.006
Al-Mashraie, M., Chung, S. H., & Jeon, H. W. (2020). Customer switching behavior analysis in the telecommunication industry via push-pull-mooring framework: A machine learning approach. Computers and Industrial Engineering, 144. https://doi.org/10.1016/j.cie.2020.106476
Amin, A., Al-Obeidat, F., Shah, B., Adnan, A., Loo, J., & Anwar, S. (2019). Customer churn prediction in telecommunication industry using data certainty. Journal of Business Research, 94, 290–301. https://doi.org/10.1016/j.jbusres.2018.03.003
Belsley, D. A. (1991). Conditioning diagnostics: Collinearity and weak data in regression. John Wiley & Sons, Inc.
Calzada-Infante, L., Óskarsdóttir, M., & Baesens, B. (2020). Evaluation of customer behavior with temporal centrality metrics for churn prediction of prepaid contracts. Expert Systems with Applications, 160. https://doi.org/10.1016/j.eswa.2020.113553
Cenggoro, T. W., Wirastari, R. A., Rudianto, E., Mohadi, M. I., Ratj, D., & Pardamean, B. (2021). Deep Learning as a Vector Embedding Model for Customer Churn. Procedia Computer Science, 179, 624–631. https://doi.org/10.1016/j.procs.2021.01.048
Coussement, K., Lessmann, S., & Verstraeten, G. (2017). A comparative analysis of data preparation algorithms for customer churn prediction: A case study in the telecommunication industry. Decision Support Systems, 95, 27–36. https://doi.org/10.1016/j.dss.2016.11.007
David, M. E. , D. F. R. , & D. F. R. (2009). the Quantitative Strategic Planning Matrix (Qspm) Applied To a Retail Computer Store. The Coastal Business Journal, 8(1), 42–52.
Fred R. David. (1997). Strategic Management,. Prentice Hall Inc.
Ghozali, I. (2016). Aplikasi Analisis Multivariete Dengan Program IBM SPSS 23. Badan Penerbit Universitas Diponegoro.
Ibrahim, OM. (2013). A comparison of methods for assessing the relative importance of input variables in artificial neural networks. Journal of Applied Sciences Research, 9(11), 5692–5700.
James, G. , W. D. , H. T. , & T. R. (2013). An introduction to statistical learning. Springer., Vol. 112.
Jorion, P. (2007). Value at Risk : The New Benchmark for Managing Financial Risk. 3rd Ed., McGraw-Hill, New York.
Lu, N., Lin, H., Lu, J., & Zhang, G. (2014). A customer churn prediction model in telecom industry using boosting. IEEE Transactions on Industrial Informatics, 10(2), 1659–1665. https://doi.org/10.1109/TII.2012.2224355
Óskarsdóttir, M., Van Calster, T., Baesens, B., Lemahieu, W., & Vanthienen, J. (2018). Time series for early churn detection: Using similarity based classification for dynamic networks. Expert Systems with Applications, 106, 55–65. https://doi.org/10.1016/j.eswa.2018.04.003
Pamungkas, N. P. (2018). Analisis Risiko Return Saham Sub Sektor Telekomunikasi Di Indonesia Menggunakan Metode Cvar Dengan Pendekatan Armax Dan Variasi Garchx . Institut Teknologi Sepuluh Nopember.
Pendharkar, P. C. (2009). Genetic algorithm based neural network approaches for predicting churn in cellular wireless network services. Expert Systems with Applications, 36(3 PART 2), 6714–6720. https://doi.org/10.1016/j.eswa.2008.08.050
Rockafellar, R. T. dan U. S. (2002). Conditional value-at-risk for general loss distributions. Journal of Banking & Finance, 26, 1443–1471.
Shukla, V., Prashar, S., & Pandiya, B. (2021). Is price a significant predictor of the churn behavior during the global pandemic? A predictive modeling on the telecom industry. Journal of Revenue and Pricing Management. https://doi.org/10.1057/s41272-021-00367-2
Suhardi. (2011). Quantitative Strategic Planning Matrix (QSPM). STIE Semarang, 3 Number 1. https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&ved=2ahUKEwj3mMazpdz4AhVgZ2wGHek0BOUQFnoECAgQAQ&url=https%3A%2F%2Fmedia.neliti.com%2Fmedia%2Fpublications%2F132774-ID-quantitative-strategic-planning-matrix-q.pdf&usg=AOvVaw3cMYbJl5o2L4qfn3prIWjV
Sulikowski, P., & Zdziebko, T. (2021). Churn factors identification from real-world data in the telecommunications industry: Case study. Procedia Computer Science, 192, 4800–4809. https://doi.org/10.1016/j.procs.2021.09.258
Verbeke, W., Dejaeger, K., Martens, D., Hur, J., & Baesens, B. (2012). New insights into churn prediction in the telecommunication sector: A profit driven data mining approach. European Journal of Operational Research, 218(1), 211–229. https://doi.org/10.1016/j.ejor.2011.09.031
Wells, A., & Billings, K. (n.d.). 30 Multichannel.com VIEWPOINT.