Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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