hi

[abc_777]

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 those scors are 3 digits according to segment like follows

Segment	Scores
Champions	555
Champions	554
Champions	544
Champions	545
Champions	454
Champions	455
Champions	445
Loyal	543
Loyal	444
Loyal	435
Loyal	355
Loyal	354
Loyal	345
Loyal	344
Loyal	335
Potential Loyalist	553
Potential Loyalist	551
Potential Loyalist	552
Potential Loyalist	541

I want to make theses score 5 digit accordingly to segment as follows for example

Segment	Scores
Champions	55555
Champions	55554
Champions	54444
Champions	54445
Champions	44454
Champions	45455
Champions	44445
Loyal	54333
Loyal	43344
Loyal	43335
Loyal	33355
Loyal	33354
Loyal	33345
Loyal	33344
Loyal	33335
Potential Loyalist	54553
Potential Loyalist	55551
Potential Loyalist	55552
Potential Loyalist	54551

how could i do that? if some one can make for me and upload to shared google drive pleae

thanks

[PawelWrona]

Can't find any patterm here. It doesn't seem to be something you can solve automatically, at least based on the input you provided.

[abc_777]

but its a standard for RFM analysis, there you will see 3 digits but i extend to 5. and i dont know how to cater 5 digit numbers with different types of segment. 

there must be a way to define it. 

[PawelWrona]

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 · Accepted solution]

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