GitHunt

RFM Analysis Using SQL

BUSINESS PROBLEM

  • Who are the loyal customers of a store?
  • Which customers a store must retain?
  • Which customers have the potential to convert into regular profitable customers?
  • Who are those inconsistent customers who don’t engage regularly with the store?
  • Which group of customers is most probable to respond to your campaign?
  • Who are the churned out customers and who are about to churn?

The dataset can be accessed from the link below.

https://data.world/sanjoseca/procu-card-trans-2016/workspace/file?filename=procurement-card-transactions-2016_1.csv

Contributors

Created April 15, 2022
Updated May 5, 2022
oguzkedek/RFM-Analysis-Using-SQL- | GitHunt