Use sample data or upload a file


The app takes a few seconds to load. Please wait for ~12 seconds.



Upload Data

Upload data from a comma or tab separated file.






Upload Data

Upload data from a .xls or .xlsx file.












Upload Data

Upload data from a .json file.
















Upload Data

Upload data from a .dta file.
















Upload Data

Upload data from a .sav file.
















Upload Data

Upload data from a .sas7bdat file.















Click on a sample for more information




Select Data Set

Select a data set from the drop down box and click on submit.



Data Transformation

Rename variables and modify data types.


Variable
Rename Variable
Modify Data Type




Select Variables

Click on Yes to select variables.


Do you want to select variables?



Data Screening

Screen data for missing values, verify column names and data types.



                    



What type of data do you have?



Transaction Level Data

Each row represents a transaction/order.



Customer Level Data

Each row represents transactions of a customer. The data includes the number of days since the last transaction.



Customer Level Data

Each row represents transactions of a customer. The data includes the date of the latest transaction.


RFM Analysis

Recency, frequency and monetary value analysis for transaction level data i.e. each row represents a transaction/order.



Unique ID:

Order Date:

Revenue:

Analysis Date:

Recency Bins:

Frequency Bins:

Monetary Bins:


Loading...

RFM Analysis

Recency, frequency and monetary value analysis for customer level data i.e. each row represents transactions of a customer and the data includes the number of days since the last transaction.



Unique ID:

Orders:

Days since last transaction:

Revenue:

Analysis Date:

Recency Bins:

Frequency Bins:

Monetary Bins:


Loading...

RFM Analysis

Recency, frequency and monetary value analysis for customer level data i.e. each row represents transactions of a customer and the data includes the date of the latest transaction.



Unique ID:

Orders:

Latest Transaction Date:

Revenue:

Analysis Date:

Recency Bins:

Frequency Bins:

Monetary Bins:


Loading...

RFM Heatmap

The heat map shows the average monetary value for different categories of recency and frequency scores. Higher scores of frequency and recency are characterized by higher average monetary value as indicated by the darker areas in the heatmap.




Loading...

RFM Bar Chart

Examine the distribution of monetary scores for the different combinations of frequency and recency scores.




Loading...

Histograms

Histograms of recency, frequency and monetary value.




Loading...

Scatter Plots

Examine the relationship between recency, frequency and monetary values.




Loading...


Loading...


Loading...

Generate Segments

Classify customers based on the individual recency, frequency and monetary scores. Those customers who do not fall into any of the below segments will be classified as 'Others'.



Number of Segments:

Segment
Recency Score
Frequency Score
Monetary Score




Segment Distribution

Distribution of customers across the segments.




Loading...

                      

Median Recency by Segment




Loading...

Median Frequency by Segment




Loading...

Median Monetary Value by Segment




Loading...






Thank you for using rfm !

Now you should close this window.