Serambi Engineering
Vol. 10 No. 2 (2025): April 2025

Customer Segmentation Analysis with RFM Model (Recency, Frequency, Monetary) and K-Means Clustering: Case Study of Bottled Water Sales at PT XYZ

Sitorus, Ema Rosary (Unknown)
Isna Nugraha (Unknown)



Article Info

Publish Date
14 Mar 2025

Abstract

Customer segmentation is a crucial process in understanding consumer behavior patterns to support strategic decision making in marketing. The main challenge faced by companies is to accurately group customers based on transaction data. The purpose of this study is to find out and segment customers using the algorithm K-Means clustering based on RFM model (Recency, Frequency, Monetary) on Bottled Water sales transaction data at PT XYZ. The research method involves analysis of 111 customer data processed using software Orange Data Mining, with validation of results using Silhouette Score which is useful in determining the amount cluster ideal. This research produced four cluster customers, with Cluster 4 reflects customers with the highest level of loyalty, marked by a value Frequency And Monetary the dominant one, while Cluster 3 describes customers with low loyalty potential. The results of this study provide a scientific basis for the development of more focused and efficient data-based marketing strategies.

Copyrights © 2025






Journal Info

Abbrev

jse

Publisher

Subject

Earth & Planetary Sciences Energy Engineering Environmental Science Industrial & Manufacturing Engineering

Description

The Serambi Engineering journal is published as a medium to distribute information on research results in engineering and science, both carried out by lecturers from the Serambi Mekkah University and other parties. Published research can be in the form of field research or laboratory research as ...