hi

Hello, I have an excel file to google drive https://drive.google.com/drive/folders/1p9rJ5FaT7M9wSvyeXTeJjBsva5Vjz5pa?usp=drive_link here you will find RFM segment for different scores and...

Need Help

abc_777
2 years ago
I am using RFM analysis concept to find Item promotion

I have
1) Item Promotion days that promotion ran
2) Number of invoices customers bought on that promotion
3) number of customer bought on that promotion
4) number of times that the promotion code was used
5) Quantity sold only on those promotion

i want to use these 5 matrix or parameters to find out which promotion is best and which are worst gradually

following is my another blog post query to find that out

https://community.fabric.microsoft.com/t5/Desktop/hi/m-p/3809323#M1232266

so RFM is best to do and for that i want 5 digits number for promotion segmentation

I hope you can help me out

thx

PawelWrona

Resolver II

2 years ago

Exactly, if RFM Analysis is combine value of 3 scores (recency, frequency, monetary), how you would like to expand it to 5 digit scores? Where the other two are coming from?

abc_777

Solution Specialist

2 years ago

I am using RFM analysis concept to find Item promotion

I have

1) Item Promotion days that promotion ran

2) Number of invoices customers bought on that promotion

3) number of customer bought on that promotion

4) number of times that the promotion code was used

5) Quantity sold only on those promotion

i want to use these 5 matrix or parameters to find out which promotion is best and which are worst gradually

following is my another blog post query to find that out

https://community.fabric.microsoft.com/t5/Desktop/hi/m-p/3809323#M1232266

so RFM is best to do and for that i want 5 digits number for promotion segmentation

I hope you can help me out

thx

Forum Discussion

hi