Master Stockist Customer Segmentation Using RFM Model and Self-Organizing Maps Algorithm

Authors

  • Ni Kadek Ayu Nirwana Institut Bisnis dan Teknologi Indonesia
  • Ni Putu Wahyuni Dewi Institut Bisnis dan Teknologi Indonesia
  • I Made Dwi Putra Asana Institut Bisnis dan Teknologi Indonesia
  • Ni Wayan Jeri Kusuma Dewi Institut Bisnis dan Teknologi Indonesia
  • Gusti Ayu Shinta Dwi Astari Institut Bisnis dan Teknologi Indonesia

DOI:

10.33395/sinkron.v8i4.14112

Abstract

Master Stockist PT SNS 21 Bali struggles to identify member performance based on purchasing behavior because the applicable system only records transactions and stock of goods without providing insight into customers. Customer segmentation can be carried out to identify and understand differences in customer purchasing behavior. Therefore, this study aims to determine customer segmentation using the RFM (Recency, Frequency, Monetary) model and the Self-Organizing Maps (SOM) algorithm. Segmentation development uses the CRISP-DM (Cross-Industry Standard Process for Data Mining) approach. The RFM model numerically represents customer behavior through three variables, while the Self-Organizing Maps algorithm groups customers into segments with similar characteristics. In this research, the best SOM parameters are 750 iterations, learning rate 0.5, radius 0.5, and grid size 1x3, resulting in 3 clusters with a Silhouette Score of 0.647608 and a Davies-Bouldin Index of 0.536503. Cluster 1 consists of 226 new customers with low RFM values who need encouragement to be more active. Cluster 2, comprising seven members, has low recency, high frequency, and high monetary values, representing loyal customers who need to be retained. Cluster 3 consists of 239 inactive customers with high recency, low frequency, and low monetary values, requiring a reactivation strategy.

GS Cited Analysis

Downloads

Download data is not yet available.

References

Adiana, B. E., Soesanti, I., & Permanasari, A. E. (2018). Customer Segmentation Analysis Using a Combination of Rfm Model and Clustering Techniques. Journal of Applied Information Technology, 2(1), 23-32. https://doi.org/10.21460/jutei.2018.21.76

ASTUTI, R. D. (2019). COMPARISON ANALYSIS OF K-MEANS AND K-MEDOIDS ALGORITMA FOR APPLYING SEGMENTATION Submitted as one of the requirements to obtain a degree. 14002140.

Aziz, S., & Mustakim. (2022). Implementation of Self Organizing Map Algorithm to Identify Grouping Patterns of Family Welfare Levels in Siak Regency. IJIRSE: Indonesian Journal of Informatic Research and Software Engineering, 2(2), 82-92.

Birant, D. (2011). Data Mining Using RFM Analysis. Knowledge-Oriented Applications in Data Mining, iii. https://doi.org/10.5772/13683

De Silva, P. Y., Fernando, C. N., Wijethunge, D. D., & Fernando, S. D. (2018). Recursive Hierarchical Clustering Algorithm. International Journal of Machine Learning and Computing, 8(1), 1-7. https://doi.org/10.18178/ijmlc.2018.8.1.654

Fawaz, F., Fitriasari, N. S., & Rosalia, A. A. (2022). Comparison of Self Organizing Map and Fuzzy C-Means Algorithm in clustering fish production of PPN Karangantu. Explore: Journal of Information Systems and Telematics, 13(2), 102. https://doi.org/10.36448/jsit.v13i2.2783

Hermadi, I., & Sitanggang, I. S. (2006). Clustering Using Self Organizing Maps (Case Study: PPMB IPB Data). Self, Wisnujati.

Juhari, T., & Juarna, A. (2022). Implementation of Rfm Analysis Model for Customer Segmentation Using the K-Means Algorithm Case Study Xyz Online Bookstore. Explore, 12(1), 107. https://doi.org/10.35200/explore.v12i1.548

Manalu, D. A., & Gunadi, G. (2022). IMPLEMENTATION OF K-MEANS CLUSTERING DATA MINING METHOD ON TRANSACTION PAYMENT DATA USING PYTHON PROGRAMMING LANGUAGE AT CV DIGITAL DIMENSI. Infotech: Journal of Technology Information, 8(1), 45-54.

Mardiyah, I. (2022). Implementation of the Self Organizing Maps Method in Grouping Covid-19 Distribution Areas in East Java Province. 1-101.

Muqsit, M. A., & Swanjaya, D. (2021). Analysis of Customer Satisfaction Survey Data Grouping Models Using the Self Organizing Maps Method. 126-131. https://proceeding.unpkediri.ac.id/index.php/inotek/article/view/1091/702

MUSDARI, M., Amalia, E. L., & Yunhasnawa, Y. (2019). Clustering for Sales Management System in Laptop Clinic Using Self Organizing Maps (SOM) Method. Polinema Applicative Informatics Seminar, 18-23.

Paembonan, S., & Abduh, H. (2021). Application of Silhouette Coefficient Method for Drug Clustering Evaluation. PENA TEKNIK: Scientific Journal of Engineering Sciences, 6(2), 48. https://doi.org/10.51557/pt_jiit.v6i2.659

Purbasari, I. Y., Puspaningrum, E. Y., & Putra, A. B. S. (2020). Using Self-Organizing Map (SOM) for Clustering and Visualization of New Students based on Grades. Journal of Physics: Conference Series, 1569(2). https://doi.org/10.1088/1742-6596/1569/2/022037

Septiani, I. W., Fauzan, Abd. C., & Huda, M. M. (2022). Implementation of K-Medoids Algorithm with Davies-Bouldin-Index Evaluation for Clustering Postoperative Life Expectancy in Patients with Lung Cancer. Journal of Computer Systems and Informatics (JSON), 3(4), 556. https://doi.org/10.30865/json.v3i4.4055

Tholib, A. (2020). MARKET CLUSTERIZATION MANAGEMENT: Application of Customer Segmentation Based on the Self-Organizing Map (SOM) Method at CV Karunia Probolinggo. TRILOGI: Journal of Technology, Health, and Humanities, 1 (2), 35-45. https://doi.org/10.33650/trilogi.v1i2.1897

Twin, A. (2023). What Is Data Mining? How It Works, Benefits, Techniques, and Examples. Investopedia Is Part of the Dotdash Meredith Publishing Family. https://www.investopedia.com/terms/d/datamining.asp

Wei, J. T., Lin, S. Y., Yang, Y. Z., & Wu, H. H. (2020). Using a combination of RFM model and cluster analysis to analyze customers' values of a veterinary hospital. IAENG International Journal of Computer Science, 47(3), 442-448.

Wicaksana, P. A., Swamardika, I. B. A., & Hartati, R. S. (2022). Literature Review of Customer Behavior Analysis Using RFM Model. Scientific Magazine of Electrical Technology, 21(1), 21. https://doi.org/10.24843/mite.2022.v21i01.p04

Widiyanto, A. T., & Witanti, A. (2021). Customer Segmentation Based on RFM Analysis Using K-Means Algorithm as a Basis for Marketing Strategy (Case Study of PT Coversuper Indonesia Global). CONSTELATION: Convergence of Technology and Information Systems, 1(1), 204-215. https://doi.org/10.24002/konstelasi.v1i1.4293

Wijaya, I. D., Hendrawan, M. A., & Anabela, N. N. (2023). Grouping Potential Tourism Objects with Self Organizing Maps (SOM) and Sum Additive Weighting (SAW). JISKA (Sunan Kalijaga Informatics Journal), 8(1), 1-9. https://doi.org/10.14421/jiska.2023.8.1.1-9

Downloads


Crossmark Updates

How to Cite

Nirwana, N. K. A. ., Dewi, N. P. W., Asana, I. M. D. P., Dewi, N. W. J. K., & Astari, G. A. S. D. (2024). Master Stockist Customer Segmentation Using RFM Model and Self-Organizing Maps Algorithm. Sinkron : Jurnal Dan Penelitian Teknik Informatika, 8(4), 2447-2457. https://doi.org/10.33395/sinkron.v8i4.14112