05-21-2013 02:09 AM
RFM Segmentation is the subject of Rules Base Segmentation by taking in to account -
If it is like above then you can process with RFM Segmentation by using your transaction dataset as follow:
Now based on the above two KPIs, create RFM score by combining both the KPIs like -
RFM_Score = av.spend || av.visit;
Once you have RFM_Score variable ready, do Proc Rank and you will have rank based on Spend and Visit Dimension...
Finally based on assigned rank (by using Proc Rank), create some rules as follow:
The above procedure of creating RFM Segmentation does not include Margin Dimension as you can eassily group the households based on Frequency and Recency...You can simply calculate Margin KPI and pool more insight from that...
Hope it will be useful to your project...If you can post some sample transaction data, we can discuss more on RFM Segmentation...the above discussion is the starting in creating RFM Segmeatation...
You need to fix period through which you can refresh your RFM Model like every 4 week, 8 week, 13 weeks, etc...
08-07-2013 05:35 PM
If you have access to Enterprise Guide 6.1, then you can perform RFM analysis by selecting Tasks > Data Mining > Recency, Frequency, and Monetary Analysis ... The RFM analysis is a feature in SAS BASE 9.4 and above.