Applying RFM Module to My case

Feras95p

Dear all,

I have an excel sheet data for a restaurant customers. 

I have a data for 35,000 customers, the data include that:-

1- The date of the first order.

2- The date of the last order.

3- The average days between the orders.

4- The total number of the orders.

5- The total dishes of the orders.

6- The total cost  of the order.

I want to apply the RFM module to identify the customer segment  

Note that all the records are unique by their phone number but I have delete their number due to privacy. 

Any help in that please? I

Thanks in advance for your kind support.

Sample.xlsx

atcodedog05

Hi @Feras95p ,

Here is an approach for your data.

Here is my consideration to support RFM, below fields are assigned to RFM

Recency = Last order was before (days)

Frequency = The average in days between the orders

Monetary = The total cost of the dishes

Customer with no Frequency might need to be handled separately. 

This workflow is attached.

Creating a bucket for Recency, Frequency, Monetary is suggestible. 

And later creating customer groups would help you identify patterns. Refer below example from a case study.

You need to create groups that supports your business use case.

Here is the link of a similar use-case.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Customer-segmentation-in-Alteryx/td-p/157848

I hope this helps. Let me know what you think about it.

Thank you for sharing this scenario. It was a great exposure for me too.

Cheers and Happy Analyzing : )

RFM Consideration.yxzp