RFM customer segmentation

Customer Segmentation RFM model

1. Create recency, frequency, monetary values by using excel functions.

2. Create chapters for RFM assignment, keep these headers in your assignment. You can name your chapters different, but you should give these information below.

a. Business case/scenario etc.

b. Technical details of the model - introduction

c. Data understanding - Data preparation for the model (i.e., feature extraction, adding new variables to data set, )

e. Model development (i.e., how many groups you have, how you named them, )

i. Understanding and interpreting the final groups- relation with the business scenario, meaning of the groups, model, write a chapter named CONCLUSION or FINDINGS or DISCUSSIONS. Use extra features to analyze the data like gender (age, location, ) distribution of groups.