We are in the final days to enter our Data and Analytics - "What's your why?" raffle with SparkED!

Reply with your "why" in text/video format to our forum post by January 28 to be entered! 

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

RFM analysis

vaibhav_jain
8 - Asteroid

Hi, I wanted to know the process for conducting RFM(Recency, Frequency & Monetary) analysis in Alteryx.

 

Kindly share the workflow or the process for conducting the analysis.

 

I have below three columns:-

 

Cutsomer ID | Date | Count of transactions | Amount

 

Please guide

2 REPLIES 2
JohnJPS
15 - Aurora

I'm not a guru at RFM, but I do know that tiling (segmenting) is pretty straightforward in Alteryx.  I've attached a workflow which:

  • Generates sample data according to your specifications (random 100,000 transactions for a random 1000 customers)
  • Does some aggregation
  • Generates segments for R, F, and M
  • Combines them to create a custom "rfmValue")

Hope that helps get you started.

vaibhav_jain
8 - Asteroid

Thanks John for sharing the workflow. Will go through the same..

Labels