Internet Service Provider User Customer Lifetime Segmentation Analysis using RFM and K-Means Algorithm
DOI:
10.33395/sinkron.v9i1.13024Keywords:
Customer Segmentation, Lifetime, Clustering, RFM, K-MeansAbstract
The characteristics of each customer can be segmented using RFM (Recency, Frequency, Monetary) which means customer's last transaction time, number of customer transactions, and amount of money spent. The Lifetime and K-Means methods are used to perform the process of clustering or grouping customers based on segmentation through RFM. The results will be divided into 4 clusters namely Gold, Silver, Platinum and Diamond. The results of clustering are visualized with graphs and cluster tables containing the results of segmentation and clusters or groups of From the results obtained from the previous stage, of the 104 customers in the Retail & Distribution Services (RDS) sector, 4 segments resulted in 43 customers with Platinum class, 39 customers with gold class, 14 customers with silver class, and 8 customers with platinum level. The most popular services services or product is high speed dedicated internet services, VPN IP package, and service network package as top 3 results. The largest amount of revenue services or product is transponder full time use services, support network and contact center application as top 3 results.
Downloads
References
Adnyana, I. G., & Sulastra, I. M. D. J. (2020). Implementation of Data Backup and Synchronization Based on Identity Column Real Time Data Warehouse. Lontar Komputer : Jurnal Ilmiah Teknologi Informasi, 11(1), 9. https://doi.org/10.24843/LKJITI.2020.v11.i01.p02
Alizadeh Zoeram, A., & Karimi Mazidi, A. (2018). A new approach for customer clustering by integrating the LRFM model and fuzzy inference system. Iranian Journal of Management Studies, (Online First). https://doi.org/10.22059/ijms.2018.242528.672839
Balaji, S., & Srivatsa, D. S. K. (2012). Customer Segmentation for Decision Support using Clustering and Association Rule based approaches. Engineering Technology, 3(11), 525–529.
Brahmana, R. W. S., Mohammed, F. A., & Chairuang, K. (2020). Customer Segmentation Based on RFM Model Using K-Means, K-Medoids, and DBSCAN Methods. Lontar Komputer : Jurnal Ilmiah Teknologi Informasi, 11(1), 32. https://doi.org/10.24843/LKJITI.2020.v11.i01.p04
Budilaksono, S., Jupriyanto, Suwarno, M. A. S., Suwartane, I. G. A., Azhari, L., Fauzi, A., … Effendi, M. S. (2021). Customer Profilling for Precision Marketing using RFM Method, K-MEANS algorithm and Decision Tree. SinkrOn, 6(1), 191–200. https://doi.org/10.33395/sinkron.v6i1.11225
Chamberlain, B. P., Cardoso, Â., Liu, C. H. B., Pagliari, R., & Deisenroth, M. P. (2017). Customer Lifetime Value Prediction Using Embeddings. Proceedings of the 23rd ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, 1753–1762. Halifax NS Canada: ACM. https://doi.org/10.1145/3097983.3098123
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(10), 1251–1257. https://doi.org/10.1016/j.jksuci.2018.09.004
Department of Informatics Engineering, Widyagama University of Malang, Jalan Borobudur no 35, Malang, 65125, INDONESIA, Marisa, F., Syed Ahmad, S. S., Faculty of Information and Communication Technology, Universiti Teknikal Malaysia Melaka, Jalan Hang Tuah jaya Durian Tunggal, Melaka, 76100, MALAYSIA, Mohd Yusof, Z. I., Faculty of Information and Communication Technology, Universiti Teknikal Malaysia Melaka, Jalan Hang Tuah jaya Durian Tunggal, Melaka, 76100, MALAYSIA, … Department of Informatics Engineering, Pradnya Paramita School of Informatics Management and Computer, Jalan LA Sucipto no 249-A, Malang, INDONESIA. (2019). Segmentation Model of Customer Lifetime Value in Small and Medium Enterprise (SMEs) using K-Means Clustering and LRFM Model. International Journal of Integrated Engineering, 11(3). https://doi.org/10.30880/ijie.2019.11.03.018
Dewi, N. W. E. R., Aris Gunadi, I. G., & Indrawan, G. (2020). Detection of Class Regularity with Support Vector Machine methods. Lontar Komputer : Jurnal Ilmiah Teknologi Informasi, 11(1), 20. https://doi.org/10.24843/LKJITI.2020.v11.i01.p03
Husein, A. M., Setiawan, D., Sumangunsong, A. R. K., Simatupang, A., & Yasmin, S. A. (2022). Combination Grouping Techniques and Association Rules For Marketing Analysis based Customer Segmentation. SinkrOn, 7(3), 1998–2007. https://doi.org/10.33395/sinkron.v7i3.11571
Juniati, F., Monalisa, S., Zafa, R., & Muslim, M. (2020). Klasterisasi Customer Lifetime Value Dengan Model LRFM Menggunakan Algoritma Fuzzy C-Means. Jurnal Ilmiah Rekayasa dan Manajemen Sistem Informasi, 6(1), 38. https://doi.org/10.24014/rmsi.v6i1.8635
Karaa, W. B. A., & Dey, N. (2017). Mining Multimedia Documents. CRC Press. Retrieved from https://books.google.co.id/books?id=-EQPEAAAQBAJ
Nugraha, P. G. S. C., & Mahendra, G. S. (2020). Explorasi Algoritma C4.5 dan Forward Feature Selection untuk Menentukan Debitur Baik dan Debitur Bermasalah pada Produk Kredit Tanpa Agunan (KTA). JST (Jurnal Sains dan Teknologi), 9(1), 39–46. https://doi.org/10.23887/jst-undiksha.v9i1.24627
Pollak, Z. (2021). Predicting Customer Lifetime Values – E-Commerce Use Case.
Putra, A. Z., Pinem, R. W., Silalahi, S., Gulo, F., & Liukhoto, J. A. A. (2022). Classification of Covid-19 Patient Spread Rate By Age and Region With K-Means Algorithm. SinkrOn, 7(3), 1085–1989. https://doi.org/10.33395/sinkron.v7i3.11603
Ramayu, I. M. S. (2023). Rancangan Sistem Informasi Persediaan Stok Obat Dengan Metode System Development Life Cycle di Apotek Nusa Farma Nusa Penida. Jurnal Indonesia : Manajemen Informatika dan Komunikasi, 4(1), 110–120. https://doi.org/10.35870/jimik.v4i1.130
Ramayu, I. M. S., Susanto, F., & Mahendra, G. S. (2022). Penerapan Data Mining dengan Algoritma C4.5 dalam Pemesanan Obat Guna Meningkatkan Keuntungan Apotek. Prosiding Seminar Nasional Manajemen, Desain & Aplikasi Bisnis Teknologi (SENADA), 5, 237–245. Denpasar: Institut Desain Bali.
Ruli, R. D. F., & Wuryanto, E. (2017). Penerapan Clustering K-Means pada Customer Segmentation Berbasis Recency Frequency Monetary (RFM) (Studi Kasus: PT. Sinar Kencana Intermoda Surabaya). 418–427. Surabaya: Universitas Airlangga.
Rumiarti, C. D., & Budi, I. (2017). Segmentasi Pelanggan pada Customer Relationship Management di Perusahaan Ritel: Studi Kasus PT Gramedia Asri Media. urnal Sistem Informasi (Journal of Information System), 13(1), 1–10.
Taqwim, W. A., Setiawan, N. Y., & Bachtiar, F. A. (2019). Analisis Segmentasi Pelanggan Dengan RFM Model pada PT. Arthamas Citra Mandiri Menggunakan Metode Fuzzy C-Means Clustering. Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, 3(2), 1986–1993.
Wang, X., Liu, T., & Miao, J. (2019, December 16). A Deep Probabilistic Model for Customer Lifetime Value Prediction. arXiv. Retrieved from http://arxiv.org/abs/1912.07753
Wardani, N. W., Arnidya, D. J., Putra, I. N. A. S., Desmayani, N. M. M. R., Nugraha, P. G. S. C., Hartono, E., & Mahendra, G. S. (2022). Prediksi Pelanggan Loyal Menggunakan Metode Naïve Bayes Berdasarkan Segmentasi Pelanggan dengan Pemodelan RFM. Jurnal Manajemen dan Teknologi Informasi, 12(2), 113–124. https://doi.org/10.5281/zenodo.7178249
Wardani, N. W., Nugraha, P. G. S. C., Hartono, E., Suryawan, I. W. D., Dirgayusari, A. M., Darmadi, I. W., & Mahendra, G. S. (2022). Penerapan Data Mining Untuk Klasifikasi Penjualan Barang Terlaris Menggunakan Metode Decision Tree C4.5. Jurnal Teknologi Informasi dan Komputer, 8(3), 268–279.
Widiyanto, A. T., & Witanti, A. (2021). Segmentasi Pelanggan Berdasarkan Analisis RFM Menggunakan Algoritma K-Means Sebagai Dasar Strategi Pemasaran (Studi Kasus PT Coversuper Indonesia Global). KONSTELASI: Konvergensi Teknologi dan Sistem Informasi, 1(1), 204–215. https://doi.org/10.24002/konstelasi.v1i1.4293
Xing, B., & Xin-feng, W. (2010). The Evaluation of Customer Potential Value Based on Prediction and Cluster Analysis. 2010 International Conference on Management Science & Engineering 17th Annual Conference Proceedings, 613–618. Melbourne, Australia: IEEE. https://doi.org/10.1109/ICMSE.2010.5719866
Downloads
How to Cite
Issue
Section
License
Copyright (c) 2023 Muhammad Febrian Rachmadhan, Mohamad Hafidhul Umam, Arief Wibowo, I Made Satrya Ramayu
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.