scholarly journals Customer segmentation using bisecting k-means algorithm based on recency, frequency, and monetary (RFM) model

2019 ◽  
Vol 8 (2) ◽  
pp. 78-83
Author(s):  
Novianti Puspitasari ◽  
Joan Angelina Widians ◽  
Noval Bayu Setiawan

Information on customer loyalty characteristics in a company is needed to improve service to customers. A customer segmentation model based on transaction data can provide this information. This study used parameters from the recency, frequency, and monetary (RFM) model in determining customer segmentation and bisecting k-means algorithm to determine the number of clusters. The dataset used 588 sales transactions for PT Dinar Energi Utama in 2017. The clusters formed by the bisecting k-means and k-means algorithm were tested using the silhouette coefficient method. The bisecting k-means algorithm can form the best customer segmentation into three groups, namely Occasional, Typical, and Gold, with a silhouette coefficient of 0.58132.

Jurnal INFORM ◽  
2020 ◽  
Vol 5 (2) ◽  
pp. 54
Author(s):  
Aloysius Matz Teguh Utomo

Loyal customers are one of the factors that determine the development of a business. Therefore, businesses need a strategy to keep customers loyal, even making customers who were previously less loyal to become more loyal. The strategy used must be right on target according to customer segmentation. The purpose of this paper is to model a cluster of customer loyalty to help businesses in making the right decisions of marketing strategy. Segmentation is done using the k-means algorithm with LRIFMQ (length, recency, interval, frequency, monetary, quantity) as parameters, and the CLV (customer lifetime value) of each cluster is calculated. Data obtained from PT. XYZ (a company engaged in food processing) for one year (1 January 2019 - 31 December 2019), with 337.739 transactions, and 26.683 customers. AHP (analytical hierarchy process) method is used for LRIFMQ weighting because this method has a consistency index calculation. The silhouette coefficient is used to calculate the cluster quality and determine the optimal number of clusters. The best results are obtained with the silhouette coefficient value of 0,632904 with the number of clusters 6.


2022 ◽  
Vol 10 (4) ◽  
pp. 583-593
Author(s):  
Syiva Multi Fani ◽  
Rukun Santoso ◽  
Suparti Suparti

Social media is computer-based technology that facilitates the sharing of ideas, thoughts, and information through the building of virtual networks and communities. Twitter is one of the most popular social media in Indonesia which has 78 million users. Businesses rely heavily on Twitter for advertising. Businesses can use these types of tweet content as a means of advertising to Twitter users by Knowing the types of tweet content that are mostly retweeted by their followers . In this study, the application of Text Mining to perform clustering using the K-means clustering method with the best number of clusters obtained from the Silhouette Coefficient method on the @bliblidotcom Twitter tweet data to determine the types of tweet content that are mostly retweeted by @bliblidotcom followers. Tweets with the most retweets and favorites are discount offers and flash sales, so Blibli Indonesia could use this kind of tweet to conduct advertising on social media Twitter because the prize quiz tweets are liked by the @bliblidotcom Twitter account followers.


2018 ◽  
Vol 1 (1) ◽  
pp. 16-24
Author(s):  
Ni Wayan Wardani ◽  
Gede Rasben Dantes ◽  
Gede Indrawan

Customer is a very important asset for retail companies. This is the reason why retail companies should plan and use a fairly clear strategy in treating customers. With the large number of customers, the problem that must be faced is how to identify the characteristics of all customers and able to retain existing customers in order not to stop buying and moving to a competitor retail company. By applying the concept of CRM, a company can identify customers by segmenting customers while also being able to implement customer retention programs by predicting potential churn on each customer class. The data used comes from UD.Mawar Sari. Customer segmentation process uses RFM model to get customer class. UD. Mawar Sari customer class is dormant, everyday, golden and superstar. The construction of prediction models using the Decision Tree C4.5. The application of the prediction model obtains performance results, that is: Dormant: Recall 97.51%, Precision 75.18%, Accuracy 76.18%. Everyday: Recall 100%, Precision 99.04%, Accuracy 99.04%.  Golden: Recall 100%, Precision 98.84%, Accuracy 98.84%. Superstar: Recall 96.15%, Precision 99.43%, Accuracy 95.63%. Results of the evaluation with confusion matrix it can be concluded that the dormant customer class is a potentially churn customer class.


Repositor ◽  
2020 ◽  
Vol 2 (7) ◽  
pp. 945
Author(s):  
Adnan Burhan Hidayat Kiat ◽  
Yufiz Azhar ◽  
Vinna Rahmayanti

Segmentasi pelanggan pada perusahaan merupakan tindakan yang dapat mempermudah perusahaan dalam mengambil keputusan ke depan. Pada penelitian ini data yang digunakan berasal dari perusahaan otomotif, PT Hasjrat Abadi Ambon. Data yang dipakai terdiri dari data transaksi dan pelanggan kendaraan bermotor. Penerapan model RFM dapat mengelompokkan pelanggan-pelanggan berdasarkan nilai variabel Recency, Frequency dan Monetary. Hasil dari model RFM akan memperoleh status baru pada tiap pelanggan dari skala terbaik sampai terburuk. Pelanggan yang telah memiliki status akan dikelompokkan menggunakan metode K-Means menjadi beberapa Cluster(kelompok). Dalam menentukan jumlah Cluster yang optimal maka diterapkan metode Elbow. Algoritma yang digunakan dalam pembentukan Cluster terdiri dari Euclidean Distance dan Manhattan Distance. Kedua algoritma akan dibandingkan kualitas pembentukan Clusternya menggunakan metode Silhoutte Coefficient. Hasil yang diberikan pada penelitian ini berupa data yang terbagi atas 5 kelompok dengan dilakukannya lima kali pengujian untuk menentukan centroid yang unggul. Cluster yang unggul akan dibuatkan visualisasi datanya untuk memudahkan perusahaan dalam mengambil keputusan. Berdasarkan penerapan Silhoutte Coefficient, algoritma yang lebih unggul yaitu Manhattan Distance dengan nilai s(i) sebesar 0.152695. Customer segmentation at the company is an action that can facilitate the company in making decisions going forward. In this study the data used came from an automotive company, PT Hasjrat Abadi Ambon. The data used consists of transaction data and motor vehicle customers. The application of the RFM model can classify customers based on the value of the Recency, Frequency and Monetary variables. The results of the RFM model will obtain a new status on each customer from the best to the worst scale. Customers who already have status will be grouped using the K-Means method into several Clusters (groups). In determining the optimal number of Clusters, the Elbow method is applied. The algorithm used in Cluster formation consists of Euclidean Distance and Manhattan Distance. The two algorithms will be compared the quality of the Cluster formation using the Silhoutte Coefficient method. The results given in this study are in the form of data divided into 5 groups by conducting five tests to determine superior centroids. Excellent clusters will be made of data visualization to facilitate the company in making decisions. Based on the application of Silhoutte Coefficient, a superior algorithm is Manhattan Distance with value s(i) : 0.152695.


Author(s):  
Atik Febriani ◽  
Syahfara Ashari Putri

A good company is a company that is responsive to market changes and opportunities by utilizing existing data and information. Company data and information can come from internal or external sources. One of the internal data sources that can be utilized is customer data. This data will be used as the basis for determining customer segmentation. Segmentation is a process to determine customer characteristics with certain similarities, making it easier to extract information related to profitable customers. Customer business behavior can be seen from recency (last transaction period), frequency (number of transactions), and monetary (rupiah issued) or known as RFM analysis. The effective RFM analysis helps achieve the implementation of customer relationship management because this model is an important facility in measuring the profitability of customer value. To consider this RFM model, researchers use clustering which assumes that customers are in the same cluster, then consider customers with customers in the cluster. This clustering will display customer segmentation. This clustering method uses K-Means clustering. From the results of data processing, 3 clusters were formed from 25 customer data. Based on the clusters formed, it can be concluded that customer purchases have a different pattern. Clusters included in the segment of potential customers are cluster 1. Clusters are needed to get customers who previously had low R, high F, and high M values. While the strategy that needs to be improved is cluster 2.


2019 ◽  
Vol 1 (2) ◽  
pp. 45
Author(s):  
Yanuar Wicaksono

Customer knowledge is an important asset, in gathering, and managing from sharing customer knowledge into valuable capital for the company. This causes the company to continue to innovate in producing products and serving according to customer needs. To find out the needs of each customer, the company needs to make customer segmentation. Customer segmentation is defined as the division into different groups with similar characteristics to develop marketing strategies that are tailored to customer characteristics. The easiest, simplest, well-known and commonly used model of customer characteristics is the model of the recency, frequency, monetary (RFM) criteria. The RFM model still has weaknesses in low customer segmentation capacity and does not provide information on the continuity of customer transactions in understanding customer loyalty. The research method used is the Knowledge Discovery in Database (KDD) method. The data is transformed into another format that suits the needs of analysis and then the customer is segmented using clustering data mining techniques with the K-Means algorithm. From the experiments, the RFM model guesses loyal customers when reviews, frequency and monetary are high. In reality, the recency only provides information on the customer making the last transaction and the high number of transaction frequencies can be done without the customer's stability in making transactions each period. Implementing multi-criteria in customer segmentation can be better than just RFM criteria. So it will not be wrong to treat customers according to the groups that have been formed.


2021 ◽  
Vol 9 (4) ◽  
pp. 541
Author(s):  
I Gusti Ayu Widiantari Putri ◽  
Ida Bagus Gede Dwidasmara

Kreasi Slaka Bali is a company engaged in the silver handicraft sector. Each stage of the process is still done manually, starting from material preparation, handmade work, until making the packaging for delivery. Certainly, this requires more time to be able to produce an item of the same quality in each production. The need for extra time and business in product manufacturing, the company needs a marketing strategy that can be seen from consumer interest in the product. So this research discusses consumer interest based on transaction data by forming clusters based on purchases amount with other attributes, namely the product price, product size, product weight, and level of difficulty. The data used is transaction data for 2 transactions in 2019. The algorithm used is K-Means with the Elbow Method to determine the number of clusters. There are clusters of k = 5 with the cluster that has the most data in the first cluster (k = 0) with a total purchase of 193 products with an average price of US $ 69,554688.


Sign in / Sign up

Export Citation Format

Share Document