Question: how to do rfm analysis?
Answer: The first step in building an RFM model is to assign Recency, Frequency and Monetary values to each customer. ... 
The second step is to divide the customer list into tiered groups for each of the three dimensions (R, F and M), using Excel or another tool.