Clustering and Prediction Model of Customer Lifetime Value (Case Studies: IRAN National Center for Numbering Goods and Services)

Document Type : Original Article

Authors

1 Masters, Mehralborz University.

2 Associate Professor, University of Tehran.

10.52547/jimp.10.4.41

Abstract

One of the important topics in this field is Customer Lifetime value
(CLV) that means how much profit a customer generates in his lifetime for a company. The main goal of this research is presenting a model for clustering and predicting customer lifetime value and customer evaluation in IRAN National Center for Numbering Goods and Services. In this research, 74,385 records of members at a specified time interval were used (from 2011 to 2017). Members are classified by CRISP methodology, resulting in the presentation of a model for predicting them. At first, members are classified into 7 clusters by RFM and K-Means. Next, each cluster is rated by CLV. Next, hidden patterns are discovered inside the data and various segments of members are then predicted through classification algorithms. Finally, the algorithms are evaluated and the final report is prepared. The results of this study exhibit the member’s behavior in each cluster on the organization’s services and membership or extended subscription and also future customer behavior are unveiled. This research helps the managers to come up with marketing strategies to keep loyal members and attract or remove inactive members by analyzing the clusters.

Keywords


1. Anitha, P., & Patil, M. M. (2019). RFM model for Customer Purchase Behavior using K-Means Algorithm. Journal of King Saud University-Computer and Information Sciences, 1319-1578.
2. Carolyn, F. C., & Karen, N. K. (2002). From prisoners to apostles: a typology of repeat buyers and loyal customers in service businesses. Journal of services Marketing, 16(4), 322-341.
3. Çavdar, A. B., & Ferhatosmanoğlu, N. (2018). Airline customer lifetime value estimation using data analytics supported by social network information. Journal of Air Transport Management, 67, 19-33.
4. Cheng, C.-H., & Chen, Y.-S. (2009). Classifying the segmentation of customer value via RFM model and RS theory. Expert systems with applications, 36(3), 4176-4184.
5. Cheng, C.-J., Chiu, S., Cheng, C.-B., & Wu, J.-Y. (2012). Customer lifetime value prediction by a Markov chain based data mining model: Application to an auto repair and maintenance company in Taiwan. Scientia Iranica, 19(3), 849-855.
6. Christy, A. J., Umamakeswari, A., Priyatharsini, L., & Neyaa, A. (2018). RFM ranking–An effective approach to customer segmentation. Journal of King Saud University-Computer and Information Sciences.
7. Daneshvar, A., Homayounfar, M., FarahmandNezhad, A. (2020), Development of an intelligent multi-criteria clustering method based on Promethee. Industrial Management Perspective, 36, 41-6. (In Persian)
8. Dimitriadis, S., & Stevens, E. (2008). Integrated customer relationship management for service activities: an internal/external gap model. Managing Service Quality: An International Journal, 18(5), 496-511.
9. Dursun, A., & Caber, M. (2016). Using data mining techniques for profiling profitable hotel customers: An application of RFM analysis. Tourism Management Perspectives, 18, 153-160.
10. Farokhi, z. (2013). Segmentation of bankcard holders based on LRFM model using data mining techniques. Brand managemen Journal. (In Persian)
11. Haenlein, M., Kaplan, A. M., & Beeser, A. J. (2007). A model to determine customer lifetime value in a retail banking context. European Management Journal, 25(3), 221-234.
12. Heldt, R., Silveira, C. S., & Luce, F. B. (2019). Predicting customer value per product: From RFM to RFM/P. Journal of Business Research, 0148-2963.
13. Hiziroglu, A., & Sengul, S. (2012). Investigating two customer lifetime value models from segmentation perspective. Procedia-Social and Behavioral Sciences, 62, 766-774.
14. Iranshahi, M. (2015), Investigating the Necessity and effect of CLV to using CRM in DANA Insurance Co. (In Persian)
15. Jarahi, M., Ardakani, S., & Zareiyan, M. (2009). Investigating the role of information technology in implementing CRM electronically (eCRM). Quarterly Journal of Parks and Roshd Centers, 21. (In Persian)
16. Khajvand, M., & Tarokh, M. J. (2011). Estimating customer future value of different customer segments based on adapted RFM model in retail banking context. Procedia Computer Science, 3, 1327-1332.
17. Khajvand, M., Zolfaghar, K., Ashoori, S., & Alizadeh, S. (2011). Estimating customer lifetime value based on RFM analysis of customer purchase behavior: Case study. Procedia Computer Science, 3, 57-63.
18. Khatami FiroozAbadi, M., TaghaviFard, M., Sadjadi, Kh., Bamdad Soufi, J. (2018), Optimization through simulation to solve the problem of multi-objective allocation of services to the bank's clustered customers. Industrial Management Perspective, 30, 85-110. (In Persian)
19. Kohli, A. K., & Jaworski, B. J. (1990). Market orientation: the construct, research propositions, and managerial implications. The Journal of Marketing, 54(2), 1-18.
20. Larose, D. T. (2006). Data mining methods & models. John Wiley & Sons.
21. Li, D. C., Dai, W. L., & Tseng, W. T. (2011). A two-stage clustering method to analyze customer characteristics to build discriminative customer management: A case of textile manufacturing business. Expert Systems with Applications, 38(6), 7186-7191.
22. Monalisa, S., Nadya, P., & Novita, R. (2019). Analysis for Customer Lifetime Value Categorization with RFM Model. Procedia Computer Science, 161, 834-840.
23. Moslehi, N., Kafashpour, A., & Naji Azimi, Z. (2014). Customer segmentation base on their CLV using LRFM model, Management Researches Journal, 7(25), 2014119-140. (In Persian)
24. Motameni, A., Rezaei, M., & Ehghaghi, M. (2013). Designing a demand perdiction model in the ceramic and tile industry. Industrial Management Perspective, 9, 159-176. (In Persian)
25. Qadadeh, W., & Abdallah, S. (2018). Customers Segmentation in the Insurance Company (TIC) Dataset. Procedia computer science, 144, 277-290.
26. Romano Jr, N. C., & Fjermestad, J. (2001). Electronic commerce customer relationship management: An assessment of research. International Journal of Electronic Commerce, 6(2), 61-113.
27. Tabeli, H., & PourJafari, M. (2011). Role of information technology in the CRM development, Second National Conference on Information and Communication Technology (In Persian)
28. Tamaddoni, A., Stakhovych, S., & Ewing, M. (2017). The impact of personalised incentives on the profitability of customer retention campaigns. Journal of Marketing Management, 33(5-6), 327-34.
29. Tarokh, M. J., & EsmaeiliGookeh, M. (2019). Modeling patient's value using a stochastic approach: An empirical study in the medical industry. Computer methods and programs in biomedicine, 176, 51-59.
30. Taslimi, H., Aghazadeh Hashem, M., Esfidani, M., & Karami, M. (2003). Critique of marketing philosophies. Management Knowledge Quarterly, 16(61-60), 3-21. (In Persian)
31. Wang, Y., Po Lo, H., Chi, R., & Yang, Y. (2004). An integrated framework for customer value and customer-relationship-management performance: a customer-based perspective from China. Managing Service Quality: An International Journal, 14(2/3), 169-182.