Customer segmentation using the extended RFMP model based on Customer lifetime value and data mining

Saedi, Abdolah; Abbasi, Meysam; Mehdi Nejad, Alieh

doi:10.48308/jep.2025.236491.1183

Customer segmentation using the extended RFMP model based on Customer lifetime value and data mining

Document Type : Original Article

Authors

¹ Assistant Professor of Management Department. Faculty of Management and Economics. University of Lorestan. Khorramabad . Iran

² Master of IT Management , Faculty of Management & Economic, University of Sistan and Baluchestan, Zahedan, Iran

³ PhD candidate at the Department Of Management, Faculty of Management and Economic,Sistan and Baluchestan University, Zahedan, Iran

10.48308/jep.2025.236491.1183

Abstract

One important way for identifying customers is clustering them to congruent segments. Skillfully clustering can be caused by identifying profitable customers by companies, understanding their requirement and allot their own resources in an appropriate way. We can also examine the change in the clustering of customers after the implementation of any economic policy and formulate and implement suitable public policies accordingly. The main goal of a recent study is clustering and identifying customers using of extended RFMP model. The study was done on 6665 customers of the Zahedan Refah chain store. According to this, after identification, the extended RFMP amounts (sum of recency, frequency, monetary and periodicity) weight of each variable was identified according to the analytic hierarchy process (AHP). At the next stage, optimal clusters number was specified by using Silhouette and Davies Bouldin indexes and customers were clustered with the K-means algorithm and finally, customers were preferred according to customer lifetime value. According to results, customers were divided into 3 parts and their traits were analyzed. Background can be provided for codifying relationship strategies with customers by using of recent study results.

Keywords

References

AbuAli, A. N. & Abu Addose, H. Y. (2010). Data Warehouse Critical Success Factors. Scientific Research, 42(2), 326-335.

Anshari, M., Almunawar, Ariff Lim, M. N., & Syamimi, M, A. (2018). Customer relationship management and big data enabled: Personalization & customization of services. Applied Computing and Informatics, 1-8.

Anton, j. & Hoeck, m. (2002). E-business customer service. Santa Monica, the Anton press.

Armano, G., & Farmani, M. R. (2016). Multiobjective clustering analysis using particle swarm optimization. Expert Systems with Applications, 55, 184–193.

Azimi, R., Ghayekhloo, M., Ghofrani, M., & Sajedi, H. (2017). A novel clustering algorithm based on data transformation approaches. Expert Systems with Applications, 76, 59–70. (in persian)

Bagheri Ghalenooie, M. & Khorrami Sarvestani, H. (2016). Evaluating Human Factors in Customer Relationship Management Case Study: Private Banks of Shiraz City. Procedia Economics and Finance, 36, 369-373. (in persian)

Ballantyne, D. (2003). A relationship-mediated theory of internal marketing. European Journal of marketing, 37(9), 1242-1260.

Borle, S., Singh, S. S., & Jain, D. C. (2008). Customer Lifetime Value Measurement. Management Science, 54(1), 100–112.

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.

Christy, A., J., Umamakeswari, A., Priyatharsini, L., & Neyaa, A. (2021). RFM ranking – An effective approach to customer segmentation. Journal of King Saud University Computer and Information Sciences, 33, 1251- 1257.

Delgado, S., Higuera, C., Calle-Espinosa, J., Mor´an, F., & Montero, F. (2017). A SOM prototype-based cluster analysis methodology. Expert Systems with Applications, 88, 14–28.

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.

Gholamian, m., Niknam, z. (2012). Provide an adapted model for segmentation of banks' customers based on their lifetime value. Journal of Executive Management, 4(7), 5-5. (in persian)

Gichuru, M. J. & Limiri, E. K. (2017). Market Segmentation as a Strategy for Customer Satisfaction and Retention. Economics. Commerce and Management, 7(12), 544-553.

Han, J., & Kamber, M., (2001). Data mining: Concepts and techniques. San Francisco: Morgan Kaufmann Publishers.

Harwati, A., M. & Karunia, A. (2017). Utilization of Social for Consumer Behavior Clustering using Text Mining Method. Engineering and Applied Sciences, 12(3), 6406-6411.

Hiziroglu, A., & Senbas, U. D. (2016). An Application of Fuzzy Clustering to Customer Portfolio Analysis in Automotive Industry. Fuzzy System Applications (IJFSA), 5(2), 13-25.

Khajvand, M & Jafar Tarokh, M. (2011). Analyzing Customer Segmentation Based on Customer Value Components (Case Study: A Private Bank: Technical note). Industrial Engineering, Special Issue, 79-93. (in persian).

Li, H. (2014). Asynchronism-based principal component analysis for time series data mining. Expert Systems with Applications, 41, 2842–2850.

Liu, D.-R., & Shih, Y. Y. (2005). Integrating AHP and data mining for product recommendation based on customer lifetime value. Information & Management, 42(3), 387–400.

Luo, Y., Yu, X., Yang, D. (2023). A survey of intelligent transmission line inspection based on unmanned aerial vehicle, Artif. Intell. Rev. 56 (1), 173–201.

Maraghi, M., Adibi, M. A., & Mehdizadeh, E. (2020). Using RFM Model and Market Basket Analysis for Segmenting Customers and Assigning Marketing Strategies to Resulted Segments. Journal of Applied Intelligent Systems and Information Sciences, 1(1), 35-43. (in persian)

Melnic, E. L. (2016). How to strengthen customer loyalty, using customer segmentation? Economic Sciences, 9(58), 2, 52-60.

Mirzaiean Rajeh, Sh., Adeli Koudehi, F.; Seyedhosseini, S. M. & Farazmand, R. (2014). A Model for Customer Segmentation Based On Loyalty Using Data Mining Approach and Fuzzy Concept in Iranian Bank. Business and Behavioral Sciences, 4(9), 118-136. (in persian)

Moulay, Y., S., & Hanaa, H. (2023). New RFM-D classification model for improving customer analysis and response prediction. Ain Shams Engineering Journal, 14(12).

Ngai, E. W. T., Xiu, L., & Chau, D. C. K. (2009). Application of data mining techniques in customer relationship management: A literature review and classification. Expert Systems with Applications, 36, 2592–2602.

Nguyen, T. H., Sherif, J. S., & Newby, M. (2007). Strategies for successful CRM implementation. Information Management & Computer Security, 15(2), 102-115.

Peker, S., Kocyigit, A., & Eren, P. E. (2017). LRFMP model for customer segmentation in the grocery retail industry: A case study. Marketing Intelligence & Planning, 35(4), 544-559.

Rahimi, R., & Kozak, M. (2017). Impact of customer relationship management on customer satisfaction: The case of a Budget Hotel Chain. Travel & Tourism Marketing, 34(1), 40–51. (in persian)

Rodriguez, M., Peterson, R. M., & Krishnan, V. (2018). Impact of CRM technology on sales process behaviors: empirical results from US, Europe, and Asia. Business-to-Business Marketing, 25(1), 1–10.

Safari, F., Safari, N., & Montazer, G. A. (2016). Customer lifetime value determination based on RFM model. Marketing Intelligence & Planning, 34(4), 446–461. (in persian)

Sato, Y., Izui, K., Yamada, T., & Nishiwaki, S. (2018). Data mining based on clustering and association rule analysis for knowledge discovery in multi objective topology optimization. Expert Systems with Applications.

Smaili, M. Y., & Hachimi, H. (2020). Hybridization of Improved Binary Bat Algorithm for Optimizing Targeted Offers Problem in Direct Marketing Campaigns. Advances in Science, Technology and Engineering Systems Journal. 5(6):239–46. (in persian)

Seeman, E. D., & O'Hara, M. (2006). Customer relationship management in higher education: Using information systems to improve the student-school relationship. Campus-Wide Information Systems, 23(1), 24-34.

Seyed Hosseini, S. M., Maleki, A., & Gholamian, M. R. (2010).Cluster analysis using data mining approach to develop CRM methodology to assess the customer loyalty. Expert Systems with Applications, 37, 5259–5264. (in persian)

Shamsollahi, M., Badiee, A. & Ghazanfari, M. (2018). Using Combined Descriptive and Predictive Methods of Data Mining for Coronary Artery Disease Prediction: a Case Study Approach. AIand Data Mining, 7(1), 47-58. (in persian)

Shatnawi, M. Q., Yassein, M. B., & Al-natour, H. (2017). Customer relationship management at Jordan University of science and technology: Case study, issues and recommendations. International Conference on Engineering and Technology (ICET).

Shim, B., Choi, K., & Suh, Y. (2012). CRM strategies for a small-sized online shopping mall based on association rules and sequential patterns. Expert Systems with Applications, 39(9), 7736–7742.

Tahmasebi, P., Javadpour, F., & Sahimi, M. (2017). Data mining and machine learning for identifying sweet spots in shale reservoirs. Expert System with Applications, 88, 435–447. (in persian)

Tleis, M., Callieris, R., & Roma, R. (2017). Segmenting the organic food market in Lebanon: an application of K-means cluster analysis. British Food Journal, 119(7), 1423-1441.

Vadim, K. (2018). Overview of different approaches to solving problems of Data Mining. Procedia Computer Science, 123, 234–239.

Xiang, Y., Zuo, Y., & Gaoshan, F. (2024). Design of intelligent detection method for electricity transmission line equipment defect based on data mining algorithm. Thermofluids, 24.