Clustering and Profiling of Customers Using RFM for Recomendation Customer Relationship Management

research
  • 06 May
  • 2019

Clustering and Profiling of Customers Using RFM for Recomendation Customer Relationship Management

Abstract—The problem faced by the company is how to determine potential customers and apply CRM (Customer Relationship Management) in order to perform the right marketing strategy, so it can bring benefits to the company.This research aims to perform clustering and profiling customer by using the model of Recency Frequency and Monetary (RFM) to provide customer relationship management (CRM) recommendation to middle industrial company. The method used in this study consists of four steps: data mining from transaction history data of customer sales, data mining modeling using RFM with K-Means algorithm and customer classification with desicion tree (J48), determination of customer loyalty level and recommendation of customer relationship management (CRM) on the medium-sized industry. This research produces RFM data mining model for medium industrial companies. In addition, the results of the study provide recommendations of four customer segments and characteristics of each customer to perform customer relationship strategy. 

Unduhan

 

REFERENSI

[1]  Niyagas, Waminee., Srivihok, Anongnart., dan Kristin, Sukumal (2006), “Clustering Ebanking Customer Using Data Mining And Marketing Segmentation”, ECTI Transactions on Computer and Information Technology, Vol.2, No.1, Hal. 6369.

[2]  Golsefid, Samira M., Ghazanfari, Mehdi dan Alizadeh, Somayeh (2007), “Customer Segmentation in Foreign Trade based on Clustering Algorithms, case study: Trade Promotion Organization of Iran”, International Journal of Computer,Information, and Systems Science, and Engineering, Vol 1, No.3, hal. 175-181

[3] Trappey, Charles V., Trappey, Amy J.C., Chang, Ai-Che., dan Huang, Ashley Y.L. (2009), “The Analysis of Customer Service Choices and Promotion Preferences using Hierarchical Clustering”, Journal of the Chinese Institue of Industrial Engineer, Vol.26, No.5, hal. 367-376

[4]  Zheng Shi, Zheng Wen dan Jin Xia (2015). “AnIntelligent  Recommendation  System  based  on  Customer Segmentation”, International Journal of Research in Business Studies and Management, Volume 2, Issue 11, PP 78-90

[5]  R. Roselin, and C. Hanupriya, “Customer Behaviour Analysis for Credit Card Proposers Based on Data Mining   Techniques,” International  journal of Innovative research in Advanced Engineering (IJIRAE) 2014.

[6]  Bramer, M. (2007). Principles of Data Mining. London:    Springer.

[7] Maimon, O., & Rokach, L. (2010). Data Mining and Knowledge Discovery Handbook Second Edition. New York: Springer.

[8]  P. Wongchinsri, W. Kuratach, "A survey - data mining frameworks in credit card processing"  International Conference on Electrical 2016 International Conference on IEEE, 2016, pp. 1-6

[9]  V. Jayasree, and R. V. S. Balan, “A review on data mining in banking  sector,” American Journal of Applied Sciences, 10(10), 2013.

[10]  Kohavi, Ron., dan Parekh, Rajesh (2004). “Visualizing  RFM Segmentation”, SIAM.

[11]  M. Khajvand and M.J.Tarokh, “Recomendation Rules for an Online Game Site Based on Customer Lifetime Value,”Service Systems and Service Management (ICSSSM), 2010 International Conference on IEEE.

[12] Larose, D. T. (2006). Data Mining Methods and Models. Canada: John Wiley & Sons, inc.

[13] Hill, Niegel, 1996,”Hand Book of  CustomerSatisfactionMeasurement”,  Gower. Publishing  , England.

[14] Davies, D.L., & Bouldin, D. W.(1979). A Cluster separation measure. IEEE transactions on pattern analysis and machine intelligence, (2), 224-227.