BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
AvinashRdy
Calcite | Level 5

Hi,

I'm dealing with data from a hotel where customers visit occasionally. Here, the recency wouldn't be much higher compared to any retail store. Hence, we decided to go with binning the data starting with Monetary value first, then binning Frequency finally binning Recency. The final index would be MFR index rather than RFM.

Please suggest / comment on using MFR instead of RFM in this scenario. mi

Thank you in advance for your help.

Regards,

Avinash

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHemedinger
Community Manager

RFM is all about segmenting customers according to their value to your business, for the purpose of creating the next offer or some other interaction with the customer.  If you want to weight the "M" more than the "R" because you feel that's a better indication of value or likelihood to respond, you can do that with proper data preparation.

Are you using the RFM task in SAS Enterprise Guide?  If so, you can simulate a greater "M" value by multiplying the actual monetary amount by some index (you decide the weight) and using that as a proxy for the Monetary bin assignment.  Also, if you allocate more bins (or fewer bins) you can control the granularity of the segmentation for any or all of the three aspects of value.

bins.png

Chris

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!

View solution in original post

3 REPLIES 3
ChrisHemedinger
Community Manager

RFM is all about segmenting customers according to their value to your business, for the purpose of creating the next offer or some other interaction with the customer.  If you want to weight the "M" more than the "R" because you feel that's a better indication of value or likelihood to respond, you can do that with proper data preparation.

Are you using the RFM task in SAS Enterprise Guide?  If so, you can simulate a greater "M" value by multiplying the actual monetary amount by some index (you decide the weight) and using that as a proxy for the Monetary bin assignment.  Also, if you allocate more bins (or fewer bins) you can control the granularity of the segmentation for any or all of the three aspects of value.

bins.png

Chris

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
AvinashRdy
Calcite | Level 5

Thank you for the response. This is very helpful for my research Smiley Happy

AnnaBrown
Community Manager

Thank you for joining the SAS Data Mining Community, AvinashRdy!


Feel free to mark answers as "correct" or "helpful" so that other community members can see what worked for you.

Thanks!

Anna

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 2091 views
  • 1 like
  • 3 in conversation