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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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