E-Commerce Customer Segmentation Based on RFM Analysis Using DBSCAN Algorithm to Improve Marketing Strategy
DOI:
https://doi.org/10.35870/emt.v9i4.5375Keywords:
Customer Segmentation, E-Commerce, Marketing StrategyAbstract
Customer segmentation is an important step in designing an effective marketing strategy, especially in e-commerce businesses that have a large customer base with diverse shopping behavior characteristics. This study aims to segment customers based on the RFM (Recency, Frequency, and Monetary) approach to identify customer behavior and support more targeted marketing decision-making. The algorithm used in the clustering process is DBSCAN (Density-Based Spatial Clustering of Applications with Noise) because of its ability to find clusters with arbitrary shapes and detect outliers or inactive customers. The research process began with the selection of the dataset, followed by data preprocessing through the stages of cleaning, reduction, RFM transformation, and normalization using the Min-Max method. This study proves that the combination of the RFM approach and the DBSCAN algorithm is effective in segmenting e-commerce customers. The results of this segmentation can be used to develop more personalized marketing strategies, such as active customer retargeting and inactive customer reactivation, so that it can increase marketing efficiency and customer loyalty.
Downloads
References
Abbu, H., & Gopalakrishna, P. (2022). Digital transformation powered by big data analytics: The case of retail grocery business. Hawaii International Conference on System Sciences, 231. https://doi.org/10.24251/hicss.2022.231.
Abe, M. (2016). Deriving customer lifetime value from RFM measures: Insights into customer retention and acquisition. In Customer Relationship Management (pp. 127–160). MIT Press. https://doi.org/10.7551/mitpress/9471.003.0007.
Abednego, L., Nugraheni, C. E., & Salsabina, A. (2023). Customer segmentation: Transformation from data to marketing strategy. Conference Series, 4(1), 139–152. https://doi.org/10.34306/conferenceseries.v4i1.645.
Brahmana, R. W., Mohammed, F. A., & Chairuang, K. (2020). Customer segmentation based on RFM model using K-Means, K-Medoids, and DBSCAN methods. LONTAR KOMPUTER. https://doi.org/10.24843/LKJITI.2020.v11.i01.p04.
Christy, A. J., Umamakeswari, A., Priyatharsini, L., & Neyaa, A. (2021). RFM ranking—An effective approach to customer segmentation. Journal of King Saus University - Computer Science and Information Sciences, 1251–1257.
Datta, P., Fraser, P., & Lebcir, M. (2018). An investigation into the relationship between customer relationship marketing and customer retention: Superstore retailing context in Bangladesh. Journal of Business & Retail Management Research, 13(02). https://doi.org/10.24052/jbrmr/v13is02/art-03.
Duffour, K. A., Gbolonyo, P. K., & Tandoh, I. (2022). Service quality in shipping industry of Ghana—Determinants and impact on customer satisfaction and customer retention. International Journal of Applied Research in Business and Management, 3(2), 112–134. https://doi.org/10.51137/ijarbm.2022.3.2.8.
Erawati, S. H., Amalia, N. S., Mauludin, H., & Liana, Y. (2023). Peran brand image sebagai moderator celebrity endorser pada keputusan pembelian. Akuntansi Bisnis & Manajemen (ABM), 30(2). https://doi.org/10.35606/jabm.v30i2.1276.
Fadhillah, M. F., Suyoso, A. L. A., & Puspitasari, I. (2024). Segmentasi pelanggan dengan algoritma clustering berdasarkan atribut Recency, Frequency dan Monetary (RFM): Customer Segmentation with Clustering Algorithm Based on Recency, Frequency, and Monetary (RFM) Attributes. MALCOM, 5(1), 48–56.
Gomes, M. A., & Meisen, T. (2023). A review on customer segmentation methods for personalized customer targeting in e-commerce use cases. Information Systems and E-Business Management, 21, 527–570.
Gustriansyah, R., Suhandi, N., & Antony, F. (2020). Clustering optimization in RFM analysis based on K-Means. Indonesian Journal of Electrical Engineering and Computer Science, 18(1), 470. https://doi.org/10.11591/ijeecs.v18.i1.pp470-477.
Halim, I., & Berlianto, M. P. (2024). The effect of service quality dimensions, perceived value, customer satisfaction, and brand love toward customer retention on First Media’s subscribers. Widya Cipta - Jurnal Sekretari Dan Manajemen, 8(2), 139–152. https://doi.org/10.31294/widyacipta.v8i2.20052.
Kabasakal, İ. (2020). Customer segmentation based on Recency Frequency Monetary model: A case study in e-retailing. Bilişim Teknolojileri Dergisi, 13(1), 47–56.
Kaya, C., Gemalmaz, S., Üzümcüoğlu, Y., Kartal, M., & Ceylan‐Batur, S. (2024). How Covid-19 changed consumer behavior trends in Türkiye? Dokuz Eylül Üniversitesi Sosyal Bilimler Enstitüsü Dergisi, 26(2), 915–945. https://doi.org/10.16953/deusosbil.1375618.
Kusuma, A. A. N. W., & Sudiartha, I. M. (2020). Segmentasi pelanggan menggunakan RFM dan algoritma DBSCAN untuk mendukung strategi pemasaran. Jurnal Ilmiah Merpati, 8(3), 143–152.
Livne, G., Simpson, A., & Talmor, E. (2011). Do customer acquisition cost, retention, and usage matter to firm performance and valuation? Journal of Business Finance & Accounting, 38(3–4), 334–363. https://doi.org/10.1111/j.1468-5957.2010.02229.x.
Londhe, S. T., & Palwe, S. (2022). Customer-centric sales forecasting model: RFM-ARIMA approach. Business Systems Research Journal, 13(1), 35–45. https://doi.org/10.2478/bsrj-2022-0003.
Madu, M. I., & Manggu, B. (2024). Pengaruh E-Service Quality, brand image, kualitas produk terhadap keputusan pembelian ulang di e-commerce di Kabupaten Bengkayang. Conference, 79–91. https://doi.org/10.31603/conference.12042.
Monalisa, S., Juniarti, Y., Saputra, E., Muttakin, F., & Ahsyar, T. K. (2023). Customer segmentation with RFM models and demographic variable using DBSCAN algorithm. Telkomnika (Telecommunication Computing Electronics and Control), 21(4), 742–749.
Nitzan, I., & Libai, B. (2011). Social effects on customer retention. Journal of Marketing, 75(6), 24–38. https://doi.org/10.1509/jm.10.0209.
Prasetyo, S., Mustafid, M., & Hakim, A. (2020). Penerapan fuzzy c-means kluster untuk segmentasi pelanggan e-commerce dengan metode Recency Frequency Monetary (RFM). Jurnal Gaussian, 9(4). https://doi.org/10.14710/j.gauss.v9i4.29445.
Purnama, S., & Bangun, C. S. (2024). Strategic management insights into housewives consumptive shopping behavior in the post COVID-19 landscape. Aptisi Transactions on Management (Atm), 8(1), 71–79. https://doi.org/10.33050/atm.v8i1.2209.
Rakhman, A., Wirianto, H., Bunfa, L., & Rifiyanti, H. (2022). Faktor—Faktor e-commerce yang memengaruhi tingkat konsumerisme di Jakarta. Jurnal Ilmiah Hospitality, 11(1), 245–258. https://doi.org/10.47492/jih.v11i1.1608.
Riswan, D., Putra, H. E. R., & Saputra, R. N. (2024). Pengembangan sistem rekomendasi berbasis kecerdasan buatan untuk meningkatkan pengalaman pengguna di platform e-commerce. Juktisi, 2(3), 572–580. https://doi.org/10.62712/juktisi.v2i3.145.
Samidi, Suladi, R. Y., & Kusumaningsih, D. (2023). Comparison of the RFM model’s actual value and score value for clustering. Jurnal Resti (Rekayasa Sistem Dan Teknologi Informasi), 7(6), 1430–1438. https://doi.org/10.29207/resti.v7i6.5416.
Singh, R., Patira, R., Singh, A., Choudhary, P., & Gupta, B. K. (2023). Customer segmentation on e-commerce data using clustering and RFM analysis. Data Science and Analytics: Proceedings of the International Conference on Data Science and Analytics 2023, 345–356.
Sutisna, N., & Sutrisna. (2023). Implementasikan sistem informasi dalam mendukung perilaku pembelian terhadap keputusan pembelian e-commerce. Jurnal Mentari Manajemen Pendidikan Dan Teknologi Informasi, 2(1), 20–30. https://doi.org/10.33050/mentari.v2i1.343.
Wang, X.-Y. (2024). Digital marketing strategies and consumer engagement: Unveiling TikTok’s e-commerce dynamics. Advances in Economics Management and Political Sciences, 103(1), 183–190. https://doi.org/10.54254/2754-1169/103/20242445.
Wisnel, W., Wirdianto, E., & Cantika, T. (2022). Analysis of the effect of e-service quality on e-commerce customer satisfaction and loyalty. Motivection Journal of Mechanical Electrical and Industrial Engineering, 4(3), 209–222. https://doi.org/10.46574/motivection.v4i3.145.
Wong, C.-G., Tong, G.-K., & Haw, S.-C. (2024). Exploring customer segmentation in e-commerce using RFM analysis with clustering techniques. Journal of Telecommunications and the Digital Economy, 12(3), 97–125.
Yasfi, S. M., & Pardede, R. (2023). Influence of e-service quality towards customer retention and word of mouth (WOM) mediated by customer satisfaction. Jurnal Indonesia Sosial Sains, 4(11), 1168–1180. https://doi.org/10.59141/jiss.v4i11.927.
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Ferry Irawan, Fitroh Amaluddin, Aris Wijayanti
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
1. Copyright Retention and Open Access License
Authors retain copyright of their work and grant the journal non-exclusive right of first publication under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
This license allows unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
2. Rights Granted Under CC BY 4.0
Under this license, readers are free to:
- Share — copy and redistribute the material in any medium or format
- Adapt — remix, transform, and build upon the material for any purpose, including commercial use
- No additional restrictions — the licensor cannot revoke these freedoms as long as license terms are followed
3. Attribution Requirements
All uses must include:
- Proper citation of the original work
- Link to the Creative Commons license
- Indication if changes were made to the original work
- No suggestion that the licensor endorses the user or their use
4. Additional Distribution Rights
Authors may:
- Deposit the published version in institutional repositories
- Share through academic social networks
- Include in books, monographs, or other publications
- Post on personal or institutional websites
Requirement: All additional distributions must maintain the CC BY 4.0 license and proper attribution.
5. Self-Archiving and Pre-Print Sharing
Authors are encouraged to:
- Share pre-prints and post-prints online
- Deposit in subject-specific repositories (e.g., arXiv, bioRxiv)
- Engage in scholarly communication throughout the publication process
6. Open Access Commitment
This journal provides immediate open access to all content, supporting the global exchange of knowledge without financial, legal, or technical barriers.
