Conclusions of RFM Analysis :-
RFM Value SEGMENT DESCRIPTION 111 Best Customers Bought most recently, frequently and spends the most X1X Loyal Customers Buys most frequently XX1 Big Spenders Spends the Most 311 Almost lost customers Haven’t bought anything recently but purchased frequently and Spends a lot 411 Lost Customers Haven’t bought anything from so long but purchased frequently and Spends a lot 444 Lost Cheap Customers Haven’t Bought anything from so long and purchased less and spends little
Conclusions of Clustering Analysis:- Cluster-0:- (“BEST CUSTOMERS”) Most RFM values-111,211,322,222 Most Repeated country-United Kingdom Most Sales happen in Feb Month Most Sales happen at 8:00-9:00 (Time) Most Sales happen on Tuesday
Cluster-1:- (“LOST CHEAP CUSTOMERS”) Most RFM values-444,443,433,434 Most Repeated country-United Kingdom Most Sales happen in June Month Most Sales happen at 8:00-9:00 (Time) Most Sales happen on Tuesday
Cluster-2:- (“BESTEST CUSTOMER”) Most RFM values-111 Most Repeated country-United Kingdom Most Sales happen in February, January Month Most Sales happen at 8:00-9:00 (Time) Most Sales happen on Tuesday
Cluster-3:- (“BESTEST CUSTOMERS”) Most RFM values-111 Most Repeated country-United Kingdom Most Sales happen in February, January Month Most Sales happen at 8:00-9:00 (Time) Most Sales happen on Tuesday, Friday
Cluster-4:- (“LOST CUSTOMERS”) Most RFM values-344,244,343,243 Most Repeated country-United Kingdom Most Sales happen in January, December Month Most Sales happen at 9:00-10:00 (Time) Most Sales happen on Friday, Tuesday
Cluster-5:- (“FOREIGN CUSTOMERS”) Most RFM values-111,444,211,322 Most Repeated country-Other than United Kingdom Most Sales happen in December, January Month Most Sales happen at 6:00-7:00 (Time) Most Sales happen on Tuesday, Wednesday
Cluster-6:- (“BIG SPENDERS”) Most RFM values-111,211,411,131 Most Repeated country-United Kingdom Most Sales happen in October, December Month Most Sales happen at 6:00-7:00 (Time) Most Sales happen on Tuesday, Sunday
Cluster-7:- (“LOYAL AND BIG SPENDERS”) Most RFM values-111,211,311,411 Most Repeated country-United Kingdom Most Sales happen in February, January Month Most Sales happen at 8:00-9:00 (Time) Most Sales happen on Tuesday, Saturday