Recency, Frequency, Monetary Value, Clustering, and Internal and External Indices for Customer Segmentation from Retail Data
Algorithms · 22.08.2023 · 16 (9) · 396
DOI: 10.3390/a16090396 ↗Kurz gefasst
Fachartikel in der Zeitschrift Algorithms, online erschienen am 22.08.2023. Verfasst von Henrique José Wilbert und 4 weiteren Autor:innen. Die Arbeit wurde bisher 18-mal zitiert (Crossref) und nennt 72 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
While there are several ways to identify customer behaviors, few extract this value from information already in a database, much less extract relevant characteristics. This paper presents the development of a prototype using the recency, frequency, and monetary attributes for customer segmentation of a retail database. For this purpose, the standard K-means, K-medoids, and MiniBatch K-means were evaluated. The standard K-means clustering algorithm was more appropriate for data clustering than other algorithms as it remained stable until solutions with six clusters. The evaluation of the clusters’ quality was obtained through the internal validation indexes Silhouette, Calinski Harabasz, and Davies Bouldin. When consensus was not obtained, three external validation indexes were applied: global stability, stability per cluster, and segment-level stability across solutions. Six customer segments were obtained, identified by their unique behavior: lost customers, disinterested customers, recent customers, less recent customers, loyal customers, and best customers. Their behavior was evidenced and analyzed, indicating trends and preferences. The proposed method combining recency, frequency, monetary value (RFM), K-means clustering, internal indices, and external indices achieved return rates of 17.50%, indicating acceptable selectivity of the customers.
Zitieren
APA
Wilbert, H. J., Hoppe, A. F., Sartori, A., Stefenon, S. F., & Silva, L. A. (2023). Recency, Frequency, Monetary Value, Clustering, and Internal and External Indices for Customer Segmentation from Retail Data. Algorithms, 16(9), 396. https://doi.org/10.3390/a16090396
Vancouver
Wilbert HJ, Hoppe AF, Sartori A, Stefenon SF, Silva LA. Recency, Frequency, Monetary Value, Clustering, and Internal and External Indices for Customer Segmentation from Retail Data. Algorithms. 2023;16(9):396. doi:10.3390/a16090396
BibTeX
@article{Wilbert2023,
author = {Wilbert, Henrique José and Hoppe, Aurélio Faustino and Sartori, Andreza and Stefenon, Stefano Frizzo and Silva, Luís Augusto},
title = {Recency, Frequency, Monetary Value, Clustering, and Internal and External Indices for Customer Segmentation from Retail Data},
journal = {Algorithms},
year = {2023},
volume = {16},
number = {9},
pages = {396},
doi = {10.3390/a16090396}
}
EUVIMED