Session Ready
Exercise

Calculate RFM Score

Great work, you will now finish the job by assigning customers to three groups based on the MonetaryValue percentiles and then calculate an RFM_Score which is a sum of the R, F, and M values.

The datamart has been loaded with the R and F values you have created in the previous exercise.

Instructions
100 XP
  • Create labels for MonetaryValue with an increasing range of 1 through 3.
  • Assign these labels to three equal percentile groups based on MonetaryValue.
  • Create new column M based on the MonetaryValue percentile group.
  • Calculate RFM_Score based on the sum of R, F, and M column values.