BookmarkSubscribeRSS Feed
ali_annie
Calcite | Level 5

Hi,

I am new to this community and a new job. I have to do the RFM Analysis for an mobile gaming company, so can anyone help me telling me what will be the code/procedure for RFM to start with?

Suppose the data is

user    session logged in    session stopped     total time used    date of logging in .......

Thanks alot.

4 REPLIES 4
AnnaBrown
Community Manager

Welcome to the community, ali.annie! And congrats on your new job. I'll try to track down an answer for you. Meantime, others in the community may have some input.

Anna


Join us for SAS Community Trivia
SAS Bowl XXIX, The SAS Hackathon
Wednesday, March 8, 2023, at 10 AM ET | #SASBowl

ali_annie
Calcite | Level 5

Thanks Anna!! I really look forward to it and be highly grateful as well Smiley Happy

jwexler
SAS Employee

Welcome!  RFM is at the core of many data mining analyses.  SAS has many, many options to help you analyze your data.  My recommendation is to create some derived variables grouped at the user level, assuming you are trying to determine what types of customers behave differently.   Examples include: # visits, # clicks, duration, last_visit.  You could then add other metrics that indicate whether they purchased.  You could also create variables to indicate where they clicked, so now you a set of measures for each category.

Depending on what your outcome (dependent variable) is, my advice is to see what your data is trying to tell you.  Run a Decision Tree, Regression Model, and maybe a Neural Network in Enterprise Miner.  Depending on your data, you may want to inpute missing values and even create bins of your interval variables.

If you have Enterprise Guide or Excel, you can use the Rapid Predictive Modeler add-in and point to your data, and let SAS run several methods to determine the best model.

If you want to get fancy, you could start doing Path analysis to determine who people are browsing to the most profitable sites and even use Association/Market Basket to determine rules to assign people to buckets.

SAS also has a wealth of training opportunities, feel free to browse SAS Training Courses and e-Learning from the experts at SAS

There's so much you can do!

Thanks,

Jonathan

ali_annie
Calcite | Level 5

Thanks Jonathan!! Really appreciated!! When I asked the question, I had no idea, this community is not only active but also so helpful. Thanks to all of the people. I hope I will be able to help someone someday as well Smiley Happy

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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
  • 4 replies
  • 1790 views
  • 4 likes
  • 3 in conversation