Alteryx Designer Desktop Discussions

Feras95p · ‎10-20-2020

Dear all,

I have a set of data of the customers of a restaurant, I have the data in the excel sheet format, the data I have is formatted like this for each customer

The customer phone number, the date of first visit, the date of the last visit, total number of orders, total amount of the all orders and the average of days between the orders.

What I'm looking for is to do the Customer Segmentation because I have more than 10,000 customers.

Any help in that please?

Qiu · ‎10-20-2020

@Feras95p
I searched the community with the keyword "Customer Segmentation".
Hope these will go you a start.

https://community.alteryx.com/t5/Data-Science/Beginner-s-Guide-to-Customer-Segmentation/ba-p/138442

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

RolandSchubert · ‎10-20-2020

Hi @Feras95p ,

seems you want to do customer segmentation based on an extended RFM model.

I think, the first step is to "translate" the different combinations of recency, frequency, time as a customer and monetary value to a specific "segment description", e.g. a long time customer, who recently has been in the restaurant, usually visits the restaurant very frequently and spends a lot of money in the restaurant is a "Top Customer", whereas the same customer may be assigned to the group "at risk", if his last visit is long ago (at least, considerable longer than average).

The next step would be a definition of scores for "recency" (e.g. within last week = 5, last two weeks = 4, last month = 3) , "frequency", "monetary value" and "time as a customer" and calculate these scores for each of the customers.

If you concatenate the resulting scores the final result will be a string like "5555" (=> "Top Customer") or "2455" (=> customer spent big money, but hasn't been here for a long time).

Hope this is helpful.

Best,

Roland