본문 바로가기
KERD
논문KCI 등재

Elucidating strategic patterns from target customers using multi-stage RFM analysis

Manojit Chattopadhyay|Subrata Kumar Mitra|Parikshit Charan
한국마케팅과학회 (Korean Scholars of Marketing Science)|2023.06|Journal of Global Scholars of Marketing Science(마케팅과학연구) (全球营销科学学报)|제33권 제3호|pp. 444-474|DOI 10.1080/21639159.2022.2080094

2

조회

0

다운로드

0

인용

0

참고문헌

키워드

data miningclusteringRFM analysisstrategic knowledgetarget customer selection
주제분류경영학

초록

Predicting profitable customers is a strategic knowledge portfolio of retailer managers because some customers are better profitable than others in a business. The present work is an effort to demonstrate a better model of predicting profitable customers. We apply the k-means algorithm to identify customer patterns based on Recency, Frequency, and Monetary (RFM) attributes computed from a real-life dataset of UK-based and registered non-store online retail. Six data mining models have been applied to each identified pattern and overall data to predict whether each customer would purchase in the next six months or not. A comparative analysis of identified pattern characteristics and predictable performances and Type I and Type II errors have been performed to identify the target customer group in terms of better predictability and profitability. The identified patterns help to generate novel marketing strategies. Thus, the retailers may successfully target the most consistently profitable customer groups to apply diverse knowledge on marketing strategies for the specific pattern.

Abstract

Predicting profitable customers is a strategic knowledge portfolio of retailer managers because some customers are better profitable than others in a business. The present work is an effort to demonstrate a better model of predicting profitable customers. We apply the k-means algorithm to identify customer patterns based on Recency, Frequency, and Monetary (RFM) attributes computed from a real-life dataset of UK-based and registered non-store online retail. Six data mining models have been applied to each identified pattern and overall data to predict whether each customer would purchase in the next six months or not. A comparative analysis of identified pattern characteristics and predictable performances and Type I and Type II errors have been performed to identify the target customer group in terms of better predictability and profitability. The identified patterns help to generate novel marketing strategies. Thus, the retailers may successfully target the most consistently profitable customer groups to apply diverse knowledge on marketing strategies for the specific pattern.

참고문헌 (121)

  1. Aeron, H., "Data mining framework for customer lifetime value-based segmentation", Journal of Database Marketing & Customer Strategy Management, 19(1), pp.17~30 (2012)[DOI]
  2. Ahn, Y., "Customer attrition analysis in the securities industry : A large-scale field study in Korea", International Journal of Bank Marketing, 38(3), pp.561~577 (2019)[DOI]
  3. Albadvi, A., "Integrating rating-based collaborative filtering with customer lifetime value : New product recommendation technique", Intelligent Data Analysis, 14(1), pp.143~155 (2010)[DOI]
  4. Asllani, A., "Using RFM data to optimize direct marketing campaigns : A linear programming approach", Academy of Marketing Studies Journal, 15(2), pp.59~76 (2011)
  5. Asllani, A., "A multi-objective optimization approach using the RFM model in direct marketing", Academy of Marketing Studies Journal, 19(3), pp.49~ (2015)
  6. Baesens, B., "Bayesian neural network learning for repeat purchase modeling in direct marketing", European Journal of Operational Research, 138(1), pp.191~211 (2002)[DOI]
  7. Berrueta, L. A., "Supervised pattern recognition in food analysis", Journal of Chromatography, 1158(1), pp.196~214 (2007)[DOI]
  8. Bhaskar, T., "An optimization model for personalized promotions in multiplexes", Journal of Promotion Management, 15(1–2), pp.229~246 (2009)[DOI]
  9. Bishop, C. M, "Neural networks for pattern recognition" (1996), Oxford University Press
  10. Blattberg, R. C., "Database marketing", pp.13~46 (2008), Springer
  11. Bolton, R. N., "The theoretical underpinnings of customer asset management : A framework and propositions for future research", Journal of the Academy of Marketing Science, 32(3), pp.271~292 (2004)[DOI]
  12. Borle, S., "Customer lifetime value measurement", Management Science, 54(1), pp.100~112 (2008)[DOI]
  13. Bose, I., "Quantitative models for direct marketing : A review from systems perspective", European Journal of Operational Research, 195(1), pp.1~16 (2009)[DOI]
  14. Jürgen Kai-Uwe Brock, "The emergence and implications of Technologized Marketing", Journal of Global Scholars of Marketing Science(마케팅과학연구), 31(3), pp.372~391 (2021), 한국마케팅과학회[DOI]
  15. Buckinx, W., "Customer base analysis : Partial defection of behaviourally loyal clients in a non-contractual FMCG retail setting", European Journal of Operational Research, 164(1), pp.252~268 (2005)[DOI]
  16. Bulysheva, L., "Segmentation modeling algorithm : A novel algorithm in data mining", Information Technology and Management, 13(4), pp.263~271 (2012)
  17. Chen, M. C., "Mining changes in customer behavior in retail marketing", Expert Systems with Applications, 28(4), pp.773~781 (2005)[DOI]
  18. Chen, D., "Data mining for the online retail industry : A case study of RFM model-based customer segmentation using data mining", Journal of Database Marketing & Customer Strategy Management, 19(3), pp.197~208 (2012)[DOI]
  19. Chen, K., "Predicting customer churn from valuable B2B customers in the logistics industry : A case study", Information Systems and E-Business Management, 13(3), pp.475~494 (2015)[DOI]
  20. Chen, Y. L., "Discovering recency, frequency, and monetary (RFM) sequential patterns from customers’ purchasing data", Electronic Commerce Research and Applications, 8(5), pp.241~251 (2009)[DOI]
  21. Cheng, H. D., "Approaches for automated detection and classification of masses in mammograms", Pattern Recognition, 39(4), pp.646~668 (2006)[DOI]
  22. Chiang, W. Y., "To establish online shoppers’ markets and rules for dynamic CRM systems : An empirical case study in Taiwan", Internet Research, 22(5), pp.613~625 (2012)[DOI]
  23. Chiang, W. Y., "Applying a new model of customer value on international air passengers’market in Taiwan", International Journal of Tourism Research, 14(2), pp.116~123 (2012)[DOI]
  24. Cho, Y. S., "Clustering of item category with weight and bayesian probability for recommender system", Advanced Science Letters, 21(3), pp.391~395 (2015)[DOI]
  25. Collins, K., "Analytical CRM: Driving profitable customer relationships", Strategic Planning (2001)
  26. Correia, A., "Why do tourists persist in visiting the same destination", Tourism Economics, 21(1), pp.205~221 (2015)[DOI]
  27. Coussement, K., "Data accuracy’s impact on segmentation performance : Benchmarking RFM analysis, logistic regression, and decision trees", Journal of Business Research, 67(1), pp.2751~2758 (2014)[DOI]
  28. Davenport, T. H., "How do they know their customers so well?", MIT Sloan Management Review, 42(2), pp.63~ (2001)
  29. David L. Davies, "A Cluster Separation Measure", IEEE Transactions on Pattern Analysis and Machine Intelligence, PAMI-1(2), pp.224~227 (1979), Institute of Electrical and Electronics Engineers (IEEE)[DOI]
  30. De Cannière, M. H., "Relationship quality and the theory of planned behavior models of behavioral intentions and purchase behavior", Journal of Business Research, 62(1), pp.82~92 (2009)[DOI]
  31. Demšar, J, "Statistical comparisons of classifiers over multiple data sets", Journal of Machine Learning Research, pp.1~30 (2006)
  32. Dhandayudam, P., "Customer behavior analysis using rough set approach", Journal of Theoretical and Applied Electronic Commerce Research, 8(2), pp.21~33 (2013)[DOI]
  33. Djurisic, V., "Bank CRM optimization using predictive classification based on the support vector machine method", Applied Artificial Intelligence, 34(12), pp.941~955 (2020)[DOI]
  34. Dursun, A., "Using data mining techniques for profiling profitable hotel customers: An application of RFM analysis", Tourism Management Perspectives, 18, pp.153~160 (2016)[DOI]
  35. Fader, P. S., "RFM and CLV : Using iso-value curves for customer base analysis", Journal of Marketing Research, 42(4), pp.415~430 (2005)[DOI]
  36. Fader, P. S., "Probability models for customer-base analysis", Journal of Interactive Marketing, 23(1), pp.61~69 (2009)[DOI]
  37. Faraway, J. J, "Extending the linear model with R: Generalized linear, mixed effects and nonparametric regression models", pp.2016, Chapman and Hall
  38. Filzmoser, P., "Applied compositional data analysis", pp.163~179 (2018), Springer
  39. Friedman, M., "The use of ranks to avoid the assumption of normality implicit in the analysis of variance", Journal of the American Statistical Association, 32(200), pp.675~701 (1937)[DOI]
  40. Friedman, M., "A comparison of alternative tests of significance for the problem of m rankings", The Annals of Mathematical Statistics, 11(1), pp.86~92 (1940)[DOI]
  41. Friedman, J. H., "Multivariate adaptive regression splines", Annals of Statistics, 19(1), pp.1~67 (1991)[DOI]
  42. Ghatasheh, N., "Business analytics in telemarketing : Cost-sensitive analysis of bank campaigns using artificial neural networks", Applied Sciences, 10(7), pp.2581~ (2020)[DOI]
  43. Güçdemir, H., "Integrating multi-criteria decision making and clustering for business customer segmentation", Industrial Management & Data Systems, 115(6), pp.1022~1040 (2015)[DOI]
  44. Ha, S. H., "Application of data mining tools to hotel data mart on the intranet for database marketing", Expert Systems with Applications, 15(1), pp.1~31 (1998)[DOI]
  45. Han, J., "Data mining: Concepts and techniques" (2000), Morgan Kaufmann Publishers
  46. Han, J., "Anthony. KH Tung., spatial clustering methods in data mining: A survey, geographic data mining and knowledge discovery", pp.1~29 (2001)
  47. Hastie, T., "The elements of statistical learning", pp.257~298 (2001), Springer
  48. Hastie, T., "The elements of statistical learning: Data mining, inference, and prediction" (2008), Springer-Verlag
  49. Heldt, R., "Predicting customer value per product : From RFM to RFM", P, 2021, pp.127, 444~453
  50. Hosseini, M., "New approach to customer segmentation based on changes in customer value", Journal of Marketing Analytics, 3(3), pp.110~121 (2015)[DOI]
  51. Hsieh, N. C., "An integrated data mining and behavior scoring model for analyzing bank customers", Expert Systems with Applications, 27(4), pp.623~633 (2004)[DOI]
  52. Hu, Y. H., "Discovering valuable frequent patterns based on RFM analysis without customer identification information", Knowledge-Based Systems, 61, pp.76~88 (2014)[DOI]
  53. Shelby D. Hunt, "The philosophy of science foundations of marketing research: For scientific realism and the inductive realist models of theory status and generation", Journal of Global Scholars of Marketing Science(마케팅과학연구), 28(1), pp.1~32 (2018), 한국마케팅과학회[DOI]
  54. Johnson, R. A., "Multivariate statistics, a practical approach" (1988)
  55. Johnson, J. W., "Can purchase behavior predict relationship perceptions and willingness to donate", Psychology & Marketing, 31(8), pp.647~659 (2014)[DOI]
  56. Ke, D., "Who will stay with the brand after posting non-5", 5rating of purchase? an empirical study of online consumer repurchase behavior, 2021, pp.19(2), 405~437
  57. Khobzi, H., "A new application of RFM clustering for guild segmentation to mine the pattern of using banks’ e-payment services", Journal of Global Scholars of Marketing, 27(3), pp.178~190 (2014)[DOI]
  58. Eun Young Kim, "The Effect of E-SERVQUAL on e-Loyalty for Apparel Online Shopping", Journal of Global Scholars of Marketing Science(마케팅과학연구), 19(4), pp.57~65 (2009), 한국마케팅과학회
  59. Kim, G., "A support vector machine(SVM)approach to imbalanced datasets of customer responses : Comparison with other customer response models", Service Business, 7(1), pp.167~182 (2013)[DOI]
  60. 김연정, "중소 전자상거래 기업의 소비자정보 최적화를 위한 효율적 마케팅 모튤: e-CRM 연동전략을 중심으로", Journal of Global Scholars of Marketing Science(마케팅과학연구), (14), pp.125~144 (2004), 한국마케팅과학회
  61. Kohavi, R., "Glossary of terms", Machine Learning, 30(2–3), pp.271~274 (1998)
  62. Kumar, V., "The power of CLV : Managing customer lifetime value at IBM", Marketing Science, 27(4), pp.585~599 (2008)[DOI]
  63. V. Kumar, "It takes two to tango: Statistical modeling and machine learning", Journal of Global Scholars of Marketing Science(마케팅과학연구), 31(3), pp.296~317 (2021), 한국마케팅과학회[DOI]
  64. Latinovic, Z., "Achieving the promise of AI and ML in delivering economic and relational customer value in B2B", Journal of Business Research, 144, pp.966~974 (2022)[DOI]
  65. Leal-Rodriguez, A. L., "Generating customer value through the boosting of relationships and organisational innovativeness", Knowledge Management Research & Practice, 18(3), pp.336~347 (2020)
  66. Ledolter, J., "Multinomial logistic regression", Data Mining and Business Analytics with R, pp.132~149 (2013)[DOI]
  67. 이병희, "Transfer of Marketing Knowledge within Multinational Corporations and Its Impact on Performance: Moderating Effects of Absorptive Capacity, Socialization, and Local Knowledge", Journal of Global Scholars of Marketing Science(마케팅과학연구), 18(4), pp.279~308 (2008), 한국마케팅과학회
  68. Peter S.H. Leeflang, "Identifying the direct mail-prone consumer", Journal of Global Scholars of Marketing Science(마케팅과학연구), 23(2), pp.175~195 (2013), 한국마케팅과학회[DOI]
  69. Li, C., "An empirical study of dynamic customer relationship management", Journal of Retailing and Consumer Services, 12(6), pp.431~441 (2005)[DOI]
  70. Li, S. T., "Business intelligence approach to supporting strategy making of ISP service management", Expert Systems with Applications, 35(3), pp.739~754 (2008)[DOI]
  71. Liao, Y. W., "Exploring the relationship between intentional and behavioral loyalty in the context of e-tailing", Internet Research, 24(5), pp.668~686 (2014)[DOI]
  72. Libai, B., "Brave new world? on AI and the management of customer relationships", Journal of Interactive Marketing, 51, pp.44~56 (2020)[DOI]
  73. Liu, D. R., "A hybrid of sequential rules and collaborative filtering for product recommendation", Information Sciences, 179(20), pp.3505~3519 (2009)[DOI]
  74. Liu, D. R., "Integrating AHP and data mining for product recommendation based on customer lifetime value", Information & Management, 42(3), pp.387~400 (2005)[DOI]
  75. Liu, F., "How many, how often, and how new? a multivariate profiling of mobile app users", Journal of Retailing and Consumer Services, 38, pp.71~80 (2017)[DOI]
  76. Lönnstedt, I., "Replicated microarray data", Statistica Sinica, 12(1), pp.31~46 (2002)
  77. Lumsden, S. A., "Customer value in an all-inclusive travel vacation club : An application of the RFM framework", Journal of Hospitality & Leisure Marketing, 16(3), pp.270~285 (2008)[DOI]
  78. Malthouse, E. C., "Performance-based variable selection for scoring models", Journal of Interactive Marketing, 16(4), pp.37~50 (2002)[DOI]
  79. Marcus, C., "A practical yet meaningful approach to customer segmentation", Journal of consumer marketing, 15(5), pp.494~504 (1998)[DOI]
  80. Martins, M. C. M., "Cross-Validation of segments of credit card holders", Journal of Retailing and Consumer Services, 19(6), pp.629~636 (2012)[DOI]
  81. McCarty, J. A., "Segmentation approaches in data-mining : A comparison of RFM, CHAID, and logistic regression", Journal of Business Research, 60(6), pp.656~662 (2007)[DOI]
  82. McCullagh, P., "Generalized linear models (Vol. 37)" (1989), CRC Press
  83. Mefford, R. N., "The economic value of a sustainable supply chain", Business and Society Review, 116(1), pp.109~143 (2011)[DOI]
  84. Miguéis, V. L., "Modeling partial customer churn : On the value of first product-category purchase sequences", Expert Systems with Applications, 39(12), pp.11250~11256 (2012)[DOI]
  85. Paola Andrea Morales, "Insights, challenges and recommendations for research on sustainability in marketing", Journal of Global Scholars of Marketing Science(마케팅과학연구), 30(4), pp.394~406 (2020), 한국마케팅과학회[DOI]
  86. Morganosky, M. A., "Retail involvement in direct marketing", Journal of Retailing and Consumer Services, 4(3), pp.145~151 (1997)[DOI]
  87. Nelder, J. A., "Generalized linear models", Encyclopedia of Statistical Sciences (1972)[DOI]
  88. Nemenyi, P. B., "Distribution-free multiple comparisons", Ph.D., pp.1963
  89. Olson, D. L., "Comparison of customer response models", Service Business, 3(2), pp.117~130 (2009)[DOI]
  90. Olson, D. L., "Direct marketing decision support through predictive customer response modeling", Decision Support Systems, 54(1), pp.443~451 (2012)[DOI]
  91. Omar, Y. M., "Business analytics in manufacturing : Current trends, challenges and pathway to market leadership", Operations Research Perspectives, 6, pp.100127~ (2019)[DOI]
  92. Oyedele, A. O., "Machine learning predictions for lost time injuries in power transmission and distribution projects", Machine Learning with Applications, 6, pp.100158~ (2021)[DOI]
  93. Pino-Mejías, R., "Predicting the potential habitat of oaks with data mining models and the R system", Environmental Modeling & Software, 25(7), pp.826~836 (2010)[DOI]
  94. The pairwise multiple comparison of mean ranks package (PMCMR), "Pohlert, T.", ~ (2015)
  95. Rahim, M. A., "RFM-Based repurchase behavior for customer classification and segmentation", Journal of Retailing and Consumer Services, 61, pp.102566~ (2021)[DOI]
  96. Raouf Ahmad Rather, "Customer brand identifi cation, affective commitment, customer satisfaction, and brand trust as antecedents of customer behavioral intention of loyalty: An empirical study in the hospitality sector", Journal of Global Scholars of Marketing Science(마케팅과학연구), 29(2), pp.196~217 (2019), 한국마케팅과학회[DOI]
  97. Ravasan, A. Z., "A fuzzy ANP based weighted RFM model for customer segmentation in auto insurance sector", International Journal of Information Systems in the Service Sector, 7(2), pp.71~86 (2015)[DOI]
  98. Reinartz, W. J., "The impact of customer relationship characteristics on profitable lifetime duration", Journal of Marketing, 67(1), pp.77~99 (2003)[DOI]
  99. Ripley, B., "Package ‘mass’", Cran R, 538, pp.113~120 (2013)
  100. Rust, R. T., "Will the frog change into a prince? Predicting future customer profitability", International Journal of Research in Marketing, 28(4), pp.281~294 (2011)[DOI]
  101. Rust, R. T., "Driving customer equity: How customer lifetime value is reshaping customer strategy" (2000), Free Press
  102. Safari, F., "Customer lifetime value determination based on RFM model", Marketing Intelligence & Planning, 34(4), pp.446~461 (2016)[DOI]
  103. Schijns, J. M., "Segment selection by relationship strength", Journal of Direct Marketing, 10(3), pp.69~79 (1996)[DOI]
  104. Singh, A., "Two-Tiered clustering classification experiments for market segmentation of EFTPOS retailers", Australasian Journal of Information Systems, 19, pp.S117~S132 (2015)[DOI]
  105. Yang Sun, "Influence of sustainable marketing activities on customer equity", Journal of Global Scholars of Marketing Science(마케팅과학연구), 26(3), pp.270~283 (2016), 한국마케팅과학회[DOI]
  106. Swets, J. A., "The relative operating characteristic in psychology", Science, 182(4116), pp.990~1000 (1973)[DOI]
  107. Trawiński, B., "Nonparametric statistical analysis for multiple comparison of machine learning regression algorithms", International Journal of Applied Mathematics and Computer Science, 22(4), pp.867~881 (2012)[DOI]
  108. Van den Poel, D., "Predicting online-purchasing behaviour", European Journal of Operational Research, 166(2), pp.557~575 (2005)
  109. "Support vector machines" (1995)[URL]
  110. Varadarajan, R., "Customer information resources advantage, marketing strategy and business performance : A market resources based view", Industrial Marketing Management, 89, pp.89~97 (2020)[DOI]
  111. Venables, W. N., "Modern applied statistics with S" (2002), Springer Science &Business Media
  112. Venkatesan, R., "A customer lifetime value framework for customer selection and resource allocation strategy", Journal of Marketing, 68(4), pp.106~125 (2004)[DOI]
  113. Venkatesan, R., "Optimal customer relationship management using bayesian decision theory : An application for customer selection", Journal of Marketing Research, 44(4), pp.579~594 (2007)[DOI]
  114. Viaene, S., "Wrapped input selection using multilayer perceptrons for repeat-purchase modeling in direct marketing", Intelligent Systems in Accounting, Finance and Management, 10(2), pp.115~126 (2001)[DOI]
  115. Erica Winters, "Consumer evaluation of customer loyalty programs: the role of customization in customer loyalty program involvement", Journal of Global Scholars of Marketing Science(마케팅과학연구), 22(4), pp.370~385 (2012), 한국마케팅과학회
  116. Witten, I. H., "Data mining: Practical machine learning tools and techniques" (2005), Morgan Kaufmann
  117. Wong, J. Y., "Managing valuable Taiwanese airline passengers using knowledge discovery in database techniques", Journal of Air Transport Management, 13(6), pp.362~370 (2007)[DOI]
  118. Xu, Y., "Adopting customer relationship management technology", Industrial Management & Data Systems, 102(8), pp.442~452 (2002)[DOI]
  119. Zeithaml, V. A., "The customer pyramid : Creating and serving profitable customers", California Management Review, 43(4), pp.118~142 (2001)
  120. Zhang, Y., "Predicting customer value using clumpiness : From RFM to RFMC", Marketing Science, 34(2), pp.195~208 (2015)[DOI]
  121. Zineldin, M., "The royalty of loyalty : CRM, quality and retention", Journal of Consumer Marketing, 23(7), pp.430~437 (2006)[DOI]

관련 논문AI추천

K-means를 적용한 고객 가치 사례 분석김성수, 류종석, 이동준, 장시환, 최황용산업기술연구소 · 산업기술연구2024 · 제44권 제1호Customer Classification and Market Basket Analysis Using K-Means Clustering and Association Rules: Evidence from Distribution Big Data of Korean Retailing Company이영찬, 리우룬칭, 무홍레이한국지식경영학회 · 지식경영연구2018 · 제19권 제4호Data Mining Application in Customer Relationship Management for Hospital Inpatients이은환대한의료정보학회 · Healthcare Informatics Research2012 · 제18권 제3호캠핑 예약 플랫폼의 고객 행동 데이터 기반 고객 세그멘테이션 전략: RFM 분석 모델과 K-Means 클러스터링 기법 비교를 기반으로문재형, 한지은산업개발연구소 · 산업혁신연구2025 · 제41권 제2호소비자 군집분석을 통한 온라인 쇼핑몰 마케팅 전략 수립김성혜, 배준수한국산업경영시스템학회 · 한국산업경영시스템학회지2024 · 제47권 제3호Target Market Determination for Information Distribution and Student Recruitment Using an Extended RFM Model with Spatial AnalysisBAHARIN Safiza Suhana Kamal, ERNAWATI, KASMIN Fauziah한국유통과학회 · 유통과학연구2022 · 제20권 제6호

이 간행물의 다른 논문 (7건)

Luxury product and brand purchasing behavior: A conceptual perspectiveMetin Kozak, Antonia Correiapp. 327-331How do customers respond to external store environment? Analyzing the new luxury segmentMichela C. Mason, Adriano Paggiaro, Francesco Raggiotto, Andrea Morettipp. 332-348Mapping the most competitive journals in advertising research. A bibliometric analysis in a 25-year periodJosé M. Merigo, Ignacio Munoz Quezada, Leslier Valenzuela-Fernándezpp. 349-381Selling the value: Perceptions of value from key stakeholders in university sales centersMark J. Pelletier, Matthew M. Lastner, Lisa L. Scribnerpp. 382-401So, you want to start a sales center? An organizational learning approach to sales center formation and growthCindy B. Rippé, Shannon Cummins, Olivia J. DeGeorgepp. 402-428
원문 보기