Design of Prediction Model using Data Mining for Segmentation and Classification Customer Churn in E-Commerce Mall in Mall

Ilham Huda - Telkom University, Bojongsoang, Bandung, 40257, Indonesia
Agus Achmad Suhendra - Telkom University, Bojongsoang, Bandung, 40257, Indonesia
Moch Arif Bijaksana - Telkom University, Bojongsoang, Bandung, 40257, Indonesia


Citation Format:



DOI: http://dx.doi.org/10.62527/joiv.7.4.2414

Abstract


The classification of churn is driven by the potential risks e-commerce companies face, such as losing customers who discontinue their service usage or churn. Marketing specialists have shifted their efforts from acquiring new customers to retaining existing ones in order to mitigate customer churn. Predictive models are created using data mining techniques to identify customer churn patterns. This study proposes a data mining model aimed at predicting customer behavior, with the processed results utilized as suggestions for improvements and company strategies in customer retention through segmentation and classification. Segmentation and classification involve several variables: Session, Interaction with Application, Actions taken during the interaction, purchasing, claim, and discount. This study employs a clustering technique based on the Recency, Frequency, and Monetary (RFM) model, which considers factors such as the time since the last visit, the number of visits, and the total amount spent by the customer. The classification algorithm model was evaluated by comparing three classification algorithms: decision tree and Support Vector Machine (SVM). The decision tree algorithm had the highest accuracy, achieving an impressive 87% accuracy rate in customer classification. Factors influencing customer churn include purchasing behavior, session activity, claim feature utilization, adding products to cart, and discounts. Improving stock management is crucial to prevent stock shortages, likely to cause churn. Additional measures like sending emails/notifications and offering vouchers/loyalty points can be implemented for customers who added products to their carts but didn't complete the purchase, with a focus on popular products.

Keywords


Customer churn; churn prediction; data mining; e-commerce; decision tree; SVM

Full Text:

PDF

References


M. Chinnu, J. P. G. Scholar, M. Paul, and P. Mathai, “Customer Churn Prediction:A Survey,” International Journal of Advanced Research in Computer Science, vol. 8, no. 5, [Online]. Available: www.ijarcs.info

M. Pondel et al., “Deep Learning for Customer Churn Prediction in E-Commerce Decision Support,” Business Information Systems, pp. 3–12, Jul. 2021, doi: 10.52825/bis.v1i.42.

M. Malleswari, R. J. Manira, P. Kumar, and . M., “Comparative Analysis of Machine Learning Techniques to Identify Churn for Telecom Data,” International Journal of Engineering & Technology, vol. 7, no. 3.34, p. 291, Sep. 2018, doi: 10.14419/ijet.v7i3.34.19210.

J. Han, M. Kamber, and J. Pei, “Data Mining. Concepts and Techniques, 3rd Edition (The Morgan Kaufmann Series in Data Management Systems),” 2011.

F. Buttle and S. Maklan, Customer Relationship Management. Routledge, 2019. doi: 10.4324/9781351016551.

K. Parsaye and M. Chignell, Intelligent Database Tools & Applications: Hyperinformation Access, Data Quality, Visualization, Automatic Discovery. 1993.

P. Berger and M. Kompan, “User Modeling for Churn Prediction in E-Commerce,” IEEE Intelligent Systems, vol. 34, no. 2, pp. 44–52, Mar. 2019, doi: 10.1109/mis.2019.2895788.

M. Fridrich, “Experimental Parameter Tuning of Artificial Neural Network in Customer Churn Prediction,” Trends Economics and Management, vol. 11, no. 28, p. 9, Jun. 2017, doi:10.13164/trends.2017.28.9.

S. Pratidina, "A Design of Data Mining Model in Customer Relationship Management for Patient Churn Segmentation and Classification in Obstetrics and Gynecology Clinic of Hospitals," in Proceedings of the 2020 4th International Conference on Computational Intelligence and Applications, 2020, pp. 15-19, doi:10.1109/ICCIA49802.2020.9189784.

M. Azeem and M. Usman, “A fuzzy based churn prediction and retention model for prepaid customers in telecom industry,” International Journal of Computational Intelligence Systems, vol. 11, no. 1, p. 66, 2018, doi: 10.2991/ijcis.11.1.6.

J. Vijaya and E. Sivasankar, “An efficient system for customer churn prediction through particle swarm optimization-based feature selection model with simulated annealing,” Cluster Computing, vol. 22, no. S5, pp. 10757–10768, Sep. 2017, doi: 10.1007/s10586-017-1172-1.

E.-B. Lee, J. Kim, and S.-G. Lee, “Predicting customer churn in mobile industry using data mining technology,” Industrial Management & Data Systems, vol. 117, no. 1, pp. 90–109, Feb. 2017, doi: 10.1108/imds-12-2015-0509.

A. Babkin and I. Goldberg, “Incorporating Time-Dependent Covariates into BG-NBD Model for Churn Prediction in Non-Contractual Settings,” SSRN Electronic Journal, 2017, doi:10.2139/ssrn.2905307.

V. R. Hananto, A. D. Churniawan, and A. P. Wardhanie, “Perancangan Analytical CRM untuk Mendukung Segmentasi Pelanggan di Institusi Pendidikan,” Jurnal Ilmiah Teknologi Informasi Asia, vol. 11, no. 1, p. 79, Feb. 2017, doi: 10.32815/jitika.v11i1.55.

A. Yulianto and F. Firmansyah, “Prediksi Customer Churn Pada Bisnis Retail Menggunakan Algoritma Naïve Bayes,” remik, vol. 6, no. 1, pp. 41–47, Nov. 2021, doi: 10.33395/remik.v6i1.11196.

E. A. el Kassem, S. Ali, A. Mostafa, and F. Kamal, “Customer Churn Prediction Model and Identifying Features to Increase Customer Retention based on User Generated Content,” International Journal of Advanced Computer Science and Applications, vol. 11, no. 5, 2020, doi: 10.14569/ijacsa.2020.0110567.

B. Zhang, “Customer Churn in Subscription Business Model—Predictive Analytics on Customer Churn,” BCP Business & Management, vol. 44, pp. 870–876, Apr. 2023, doi:10.54691/bcpbm.v44i.4971.

E. Zdravevski, P. Lameski, C. Apanowicz, and D. Ślȩzak, “From Big Data to business analytics: The case study of churn prediction,” Applied Soft Computing, vol. 90, p. 106164, May 2020, doi:10.1016/j.asoc.2020.106164.

H. Dang Tran, N. Le, and V.-H. Nguyen, “Customer Churn Prediction in the Banking Sector Using Machine Learning-Based Classification Models,” Interdisciplinary Journal of Information, Knowledge, and Management, vol. 18, pp. 087–105, 2023, doi: 10.28945/5086.

M. Arowolo, B. Jimada-Ojuolape, S. Yakub, A. S. Olaniyi, A. M. Olaolu, and S. Y. Kayode, "Customer Churn Prediction in Banking Industry Using K-Means and Support Vector Machine Algorithms," International Journal of Multidisciplinary Sciences and Advanced Technology, vol. 1, no. 1, 2020, doi: 10.5281/zenodo.4543690.

T. J. Shen, A. Samad, and B. Shibghatullah, "Developing Machine Learning and Deep Learning Models for Customer Churn Prediction in Telecommunication Industry," 2022. [Online]. Available: www.kaggle.com.

A. Mishra and U. S. Reddy, “A comparative study of customer churn prediction in telecom industry using ensemble based classifiers,” 2017 International Conference on Inventive Computing and Informatics (ICICI), Nov. 2017, doi: 10.1109/icici.2017.8365230.

N. Jajam and N. Panini Challa, “Dynamic Behavior-Based Churn Forecasts in the Insurance Sector,” Computers, Materials & Continua, vol. 75, no. 1, pp. 977–997, 2023, doi:10.32604/cmc.2023.036098.

A. Dingli, V. Marmara, and N. S. Fournier, “Comparison of Deep Learning Algorithms to Predict Customer Churn within a Local Retail Industry,” International Journal of Machine Learning and Computing, vol. 7, no. 5, pp. 128–132, Oct. 2017, doi:10.18178/ijmlc.2017.7.5.634.

Y. Liu, J. Fan, J. Zhang, X. Yin, and Z. Song, “Research on telecom customer churn prediction based on ensemble learning,” Journal of Intelligent Information Systems, vol. 60, no. 3, pp. 759–775, Sep. 2022, doi: 10.1007/s10844-022-00739-z.

X. Zhao, “Research on E-Commerce Customer Churning Modeling and Prediction,” The Open Cybernetics & Systemics Journal, vol. 8, no. 1, pp. 800–804, Dec. 2014, doi: 10.2174/1874110x01408010800.

W. Pedrycz, “Introducing WIREs Data Mining and Knowledge Discovery,” WIREs Data Mining and Knowledge Discovery, vol. 1, no. 1, pp. 1–1, Jan. 2011, doi: 10.1002/widm.17.

D. T. Larose and C. D. Larose, "Discovering Knowledge in Data an Introduction to Data Mining Second Edition Wiley Series on Methods and Applications in Data Mining."

Yulianti, "Metode Data Mining Untuk Prediksi Churn Pelanggan," Jurnal ICT Akademi Telkom Jakarta, no. 17.

A. Kolomiiets, O. Mezentseva, and K. Kolesnikova C. A., "Customer Churn Prediction in the Software by Subscription models IT business using machine learning methods."