ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo
Question 2 By Doan Quynh Trang ID 483 9038
?
Holistic marketing Marketing must become strategic and drive business strategy.  A company needs to take a more holistic view of: the target customers¡¯ activities, lifestyle, and social space. the company¡¯s channels and supply chain. the company¡¯s communications. the company¡¯s stakeholders¡¯ interests. Holistic marketing will require strong software support.
?
RFM Recency = The more recently purchase the better the customer is Frequency = The more frequent the purchase the more valuable customer is Monetary value = The more money the customer spend on the company product, the higher value they bring to the company
RFM Days from the last purchase Purchase times/ month $ in purchase Customer 1 1 6 12000 Customer 2 3 3 11000 Customer 3 12 12 2000 Customer 4 60 11 3000 Customer 5 13 5 90000 Customer 6 45 1 6000 Customer 7 11 2 50000 Customer 8 23 4 45000 Customer 9 22 5 32000 Customer 10 5 8 15000 Customer 11 8 7 6000 Customer 12 96 3 14000 Customer 13 17 5 21000 Customer 14 21 10 22000 Customer 15 80 9 61000 Weight 33.33% 33.33% 33.33%
RFM Days from the last purchase Purchase times/ month $ in purchase R scales F scales M scales Total Customer 1 1 6 12000 0.3333  0.1667  0.0444  0.5444  Customer 2 3 3 11000 0.1111  0.0833  0.0407  0.2352  Customer 3 12 12 2000 0.0278  0.3333  0.0074  0.3685  Customer 4 60 11 3000 0.0056  0.3056  0.0111  0.3222  Customer 5 13 5 90000 0.0256  0.1389  0.3333  0.4979  Customer 6 45 1 6000 0.0074  0.0278  0.0222  0.0574  Customer 7 11 2 50000 0.0303  0.0556  0.1852  0.2710  Customer 8 23 4 45000 0.0145  0.1111  0.1667  0.2923  Customer 9 22 5 32000 0.0152  0.1389  0.1185  0.2726  Customer 10 5 8 15000 0.0667  0.2222  0.0556  0.3444  Customer 11 8 7 6000 0.0417  0.1944  0.0222  0.2583  Customer 12 96 3 14000 0.0035  0.0833  0.0519  0.1387  Customer 13 17 5 21000 0.0196  0.1389  0.0778  0.2363  Customer 14 21 10 22000 0.0159  0.2778  0.0815  0.3751  Customer 15 80 9 61000 0.0042  0.2500  0.2259  0.4801
RFM Days from the last purchase Purchase times/ month $ in purchase R scales F scales M scales Total Customer 1 1 6 12000 33.33% 16.67% 4.44% 54.44% Customer 5 13 5 90000 2.56% 13.89% 33.33% 49.79% Customer 15 80 9 61000 0.42% 25.00% 22.59% 48.01% Customer 14 21 10 22000 1.59% 27.78% 8.15% 37.51% Customer 3 12 12 2000 2.78% 33.33% 0.74% 36.85% Customer 10 5 8 15000 6.67% 22.22% 5.56% 34.44% Customer 4 60 11 3000 0.56% 30.56% 1.11% 32.22% Customer 8 23 4 45000 1.45% 11.11% 16.67% 29.23% Customer 9 22 5 32000 1.52% 13.89% 11.85% 27.26% Customer 7 11 2 50000 3.03% 5.56% 18.52% 27.10% Customer 11 8 7 6000 4.17% 19.44% 2.22% 25.83% Customer 13 17 5 21000 1.96% 13.89% 7.78% 23.63% Customer 2 3 3 11000 11.11% 8.33% 4.07% 23.52% Customer 12 96 3 14000 0.35% 8.33% 5.19% 13.87% Customer 6 45 1 6000 0.74% 2.78% 2.22% 5.74% Weight 33% 33% 33%

More Related Content

Similar to Customer Equity R F M (20)

Auto mobile 2 wheeler sector PPT by BuzzAngles
Auto mobile 2 wheeler sector PPT by BuzzAnglesAuto mobile 2 wheeler sector PPT by BuzzAngles
Auto mobile 2 wheeler sector PPT by BuzzAngles
Therefore Consultancy and Services Pvt. Ltd.
?
Mobile transaction 4th week updated July 21-2023.pptx
Mobile transaction 4th week updated July 21-2023.pptxMobile transaction 4th week updated July 21-2023.pptx
Mobile transaction 4th week updated July 21-2023.pptx
etebarkhmichale
?
Shop@UWDisplay
Shop@UWDisplayShop@UWDisplay
Shop@UWDisplay
Bradley Thomas
?
Longitudinal Panels in the Mobile World - KWP ComTech
Longitudinal Panels in the  Mobile World - KWP ComTechLongitudinal Panels in the  Mobile World - KWP ComTech
Longitudinal Panels in the Mobile World - KWP ComTech
Merlien Institute
?
Who's Who Among Special Finance Companies (2015)
Who's Who Among Special Finance Companies (2015)Who's Who Among Special Finance Companies (2015)
Who's Who Among Special Finance Companies (2015)
DealerStrong
?
financial intelligence for entrepreneurs - TiE Mumbai (Part 1)
financial intelligence for entrepreneurs - TiE Mumbai (Part 1)financial intelligence for entrepreneurs - TiE Mumbai (Part 1)
financial intelligence for entrepreneurs - TiE Mumbai (Part 1)
tiemumbai
?
Case Study on Gloves Sourcing
Case Study on Gloves SourcingCase Study on Gloves Sourcing
Case Study on Gloves Sourcing
John William
?
AMAR_GARG_.pdf
AMAR_GARG_.pdfAMAR_GARG_.pdf
AMAR_GARG_.pdf
KrishnaVashistha4
?
PE_Group5_Paytm
PE_Group5_PaytmPE_Group5_Paytm
PE_Group5_Paytm
Shounak Mitra
?
Create - Day 2 - 12:15 "Attention to Retail: An Exploration Into the Customer...
Create - Day 2 - 12:15 "Attention to Retail: An Exploration Into the Customer...Create - Day 2 - 12:15 "Attention to Retail: An Exploration Into the Customer...
Create - Day 2 - 12:15 "Attention to Retail: An Exploration Into the Customer...
PerformanceIN
?
Field Agent Xmas Shopper Insight
Field Agent Xmas Shopper InsightField Agent Xmas Shopper Insight
Field Agent Xmas Shopper Insight
Robin Shuker
?
[DNTS2019 - EverWin] T¨¤i li?u thuy?t tr¨¬nh v¨°ng 1 Chung k?t
[DNTS2019 - EverWin] T¨¤i li?u thuy?t tr¨¬nh v¨°ng 1 Chung k?t[DNTS2019 - EverWin] T¨¤i li?u thuy?t tr¨¬nh v¨°ng 1 Chung k?t
[DNTS2019 - EverWin] T¨¤i li?u thuy?t tr¨¬nh v¨°ng 1 Chung k?t
Kh?i Ti¨ºn
?
HIRE PURCHASE PPT.pptx
HIRE PURCHASE PPT.pptxHIRE PURCHASE PPT.pptx
HIRE PURCHASE PPT.pptx
SaketSharma97
?
Mobile Payments : It's all in the pricing
Mobile Payments : It's all in the pricingMobile Payments : It's all in the pricing
Mobile Payments : It's all in the pricing
Ambrish Verma
?
Kickfurther deck
Kickfurther deckKickfurther deck
Kickfurther deck
Sean De Clercq
?
Playing the Long Game: Revitalize Your Digital Marketing by Spending on the R...
Playing the Long Game: Revitalize Your Digital Marketing by Spending on the R...Playing the Long Game: Revitalize Your Digital Marketing by Spending on the R...
Playing the Long Game: Revitalize Your Digital Marketing by Spending on the R...
3 Birds Marketing LLC
?
Kickfurther deck
Kickfurther deckKickfurther deck
Kickfurther deck
Sean De Clercq
?
Kickfurther deck
Kickfurther deckKickfurther deck
Kickfurther deck
Sean De Clercq
?
DMS LifeScan Meeting of 02 11 2016 v5
DMS LifeScan Meeting of 02 11 2016 v5DMS LifeScan Meeting of 02 11 2016 v5
DMS LifeScan Meeting of 02 11 2016 v5
Thomas Price
?
Annie Williams Real Estate Report Aug-Sept 2016
Annie Williams Real Estate Report Aug-Sept 2016Annie Williams Real Estate Report Aug-Sept 2016
Annie Williams Real Estate Report Aug-Sept 2016
Jon Weaver
?
Mobile transaction 4th week updated July 21-2023.pptx
Mobile transaction 4th week updated July 21-2023.pptxMobile transaction 4th week updated July 21-2023.pptx
Mobile transaction 4th week updated July 21-2023.pptx
etebarkhmichale
?
Longitudinal Panels in the Mobile World - KWP ComTech
Longitudinal Panels in the  Mobile World - KWP ComTechLongitudinal Panels in the  Mobile World - KWP ComTech
Longitudinal Panels in the Mobile World - KWP ComTech
Merlien Institute
?
Who's Who Among Special Finance Companies (2015)
Who's Who Among Special Finance Companies (2015)Who's Who Among Special Finance Companies (2015)
Who's Who Among Special Finance Companies (2015)
DealerStrong
?
financial intelligence for entrepreneurs - TiE Mumbai (Part 1)
financial intelligence for entrepreneurs - TiE Mumbai (Part 1)financial intelligence for entrepreneurs - TiE Mumbai (Part 1)
financial intelligence for entrepreneurs - TiE Mumbai (Part 1)
tiemumbai
?
Case Study on Gloves Sourcing
Case Study on Gloves SourcingCase Study on Gloves Sourcing
Case Study on Gloves Sourcing
John William
?
Create - Day 2 - 12:15 "Attention to Retail: An Exploration Into the Customer...
Create - Day 2 - 12:15 "Attention to Retail: An Exploration Into the Customer...Create - Day 2 - 12:15 "Attention to Retail: An Exploration Into the Customer...
Create - Day 2 - 12:15 "Attention to Retail: An Exploration Into the Customer...
PerformanceIN
?
Field Agent Xmas Shopper Insight
Field Agent Xmas Shopper InsightField Agent Xmas Shopper Insight
Field Agent Xmas Shopper Insight
Robin Shuker
?
[DNTS2019 - EverWin] T¨¤i li?u thuy?t tr¨¬nh v¨°ng 1 Chung k?t
[DNTS2019 - EverWin] T¨¤i li?u thuy?t tr¨¬nh v¨°ng 1 Chung k?t[DNTS2019 - EverWin] T¨¤i li?u thuy?t tr¨¬nh v¨°ng 1 Chung k?t
[DNTS2019 - EverWin] T¨¤i li?u thuy?t tr¨¬nh v¨°ng 1 Chung k?t
Kh?i Ti¨ºn
?
Mobile Payments : It's all in the pricing
Mobile Payments : It's all in the pricingMobile Payments : It's all in the pricing
Mobile Payments : It's all in the pricing
Ambrish Verma
?
Playing the Long Game: Revitalize Your Digital Marketing by Spending on the R...
Playing the Long Game: Revitalize Your Digital Marketing by Spending on the R...Playing the Long Game: Revitalize Your Digital Marketing by Spending on the R...
Playing the Long Game: Revitalize Your Digital Marketing by Spending on the R...
3 Birds Marketing LLC
?
DMS LifeScan Meeting of 02 11 2016 v5
DMS LifeScan Meeting of 02 11 2016 v5DMS LifeScan Meeting of 02 11 2016 v5
DMS LifeScan Meeting of 02 11 2016 v5
Thomas Price
?
Annie Williams Real Estate Report Aug-Sept 2016
Annie Williams Real Estate Report Aug-Sept 2016Annie Williams Real Estate Report Aug-Sept 2016
Annie Williams Real Estate Report Aug-Sept 2016
Jon Weaver
?

More from Trang Doan Quynh (10)

Re/insurance Jan feb-2014
Re/insurance Jan feb-2014Re/insurance Jan feb-2014
Re/insurance Jan feb-2014
Trang Doan Quynh
?
Mar apr-2014
Mar apr-2014Mar apr-2014
Mar apr-2014
Trang Doan Quynh
?
May jun-2014r
May jun-2014rMay jun-2014r
May jun-2014r
Trang Doan Quynh
?
Jul aug-2014
Jul aug-2014Jul aug-2014
Jul aug-2014
Trang Doan Quynh
?
Re/Insurance Nov dec-2014
Re/Insurance Nov dec-2014Re/Insurance Nov dec-2014
Re/Insurance Nov dec-2014
Trang Doan Quynh
?
Re/Insurance Sep oct-2014
Re/Insurance Sep oct-2014Re/Insurance Sep oct-2014
Re/Insurance Sep oct-2014
Trang Doan Quynh
?
Jotun case analysis
Jotun case analysisJotun case analysis
Jotun case analysis
Trang Doan Quynh
?
Marketing Plan Thanulux
Marketing  Plan ThanuluxMarketing  Plan Thanulux
Marketing Plan Thanulux
Trang Doan Quynh
?

Recently uploaded (20)

coffee training in East and west harargh
coffee training in East and west hararghcoffee training in East and west harargh
coffee training in East and west harargh
AddisHailu4
?
Women Economy The presentation, Breaking the Silence: The Untapped Potential ...
Women Economy The presentation, Breaking the Silence: The Untapped Potential ...Women Economy The presentation, Breaking the Silence: The Untapped Potential ...
Women Economy The presentation, Breaking the Silence: The Untapped Potential ...
snehadeeproy085
?
Gross Domestic Product | Economics | Group Presentation
Gross Domestic Product | Economics | Group PresentationGross Domestic Product | Economics | Group Presentation
Gross Domestic Product | Economics | Group Presentation
Marcel David
?
From Community Building to Cultural Shaping: SLICKORPS Drives Transformation ...
From Community Building to Cultural Shaping: SLICKORPS Drives Transformation ...From Community Building to Cultural Shaping: SLICKORPS Drives Transformation ...
From Community Building to Cultural Shaping: SLICKORPS Drives Transformation ...
rsgdyvevztgs
?
Basic Mathematics For Economic Analysis DSC2.pdf
Basic Mathematics For Economic Analysis DSC2.pdfBasic Mathematics For Economic Analysis DSC2.pdf
Basic Mathematics For Economic Analysis DSC2.pdf
RoushanVishwakarma1
?
CORPORATE ACCOUNTING UNIT III - NOTES.pptx
CORPORATE ACCOUNTING UNIT III - NOTES.pptxCORPORATE ACCOUNTING UNIT III - NOTES.pptx
CORPORATE ACCOUNTING UNIT III - NOTES.pptx
manikandansMani2
?
How to Get an ISIN for a Private Company This presentation provides a compreh...
How to Get an ISIN for a Private Company This presentation provides a compreh...How to Get an ISIN for a Private Company This presentation provides a compreh...
How to Get an ISIN for a Private Company This presentation provides a compreh...
nextgenregistry
?
_JoinM2020_FTBEmembers Five Options.pptx
_JoinM2020_FTBEmembers Five Options.pptx_JoinM2020_FTBEmembers Five Options.pptx
_JoinM2020_FTBEmembers Five Options.pptx
FinTech Belgium
?
PFMS Public Finance Management System Presentation Dr. Konka BAMU
PFMS Public Finance Management System Presentation Dr. Konka BAMUPFMS Public Finance Management System Presentation Dr. Konka BAMU
PFMS Public Finance Management System Presentation Dr. Konka BAMU
Prakash Konka
?
RECOVER YOUR SCAMMED FUNDS AND CRYPTOCURRENCY HIRE?iFORCE HACKER RECOVERY
RECOVER YOUR SCAMMED FUNDS AND CRYPTOCURRENCY HIRE?iFORCE HACKER RECOVERYRECOVER YOUR SCAMMED FUNDS AND CRYPTOCURRENCY HIRE?iFORCE HACKER RECOVERY
RECOVER YOUR SCAMMED FUNDS AND CRYPTOCURRENCY HIRE?iFORCE HACKER RECOVERY
lonniecort7
?
Silver One March 2025 Corporate Presentation
Silver One March 2025 Corporate PresentationSilver One March 2025 Corporate Presentation
Silver One March 2025 Corporate Presentation
Adnet Communications
?
JoinM2020_FTBEmembers Five Options .pptx
JoinM2020_FTBEmembers Five Options .pptxJoinM2020_FTBEmembers Five Options .pptx
JoinM2020_FTBEmembers Five Options .pptx
FinTech Belgium
?
Eco Powerpoint updxjkx xslnklnxsated.pptx
Eco Powerpoint updxjkx xslnklnxsated.pptxEco Powerpoint updxjkx xslnklnxsated.pptx
Eco Powerpoint updxjkx xslnklnxsated.pptx
rohitsingh964760
?
AN INVESTIGATION INTO THE SOCIAL MARKETING STRATEGY OF TOAN THINH TRADING AND...
AN INVESTIGATION INTO THE SOCIAL MARKETING STRATEGY OF TOAN THINH TRADING AND...AN INVESTIGATION INTO THE SOCIAL MARKETING STRATEGY OF TOAN THINH TRADING AND...
AN INVESTIGATION INTO THE SOCIAL MARKETING STRATEGY OF TOAN THINH TRADING AND...
lamluanvan.net Vi?t thu¨º lu?n v?n
?
Compliance First, Security Guaranteed: Unveiling the Five Core Advantages of ...
Compliance First, Security Guaranteed: Unveiling the Five Core Advantages of ...Compliance First, Security Guaranteed: Unveiling the Five Core Advantages of ...
Compliance First, Security Guaranteed: Unveiling the Five Core Advantages of ...
MLPRU
?
Economic Revitalization for Pakistan: An Overview
Economic Revitalization for Pakistan: An OverviewEconomic Revitalization for Pakistan: An Overview
Economic Revitalization for Pakistan: An Overview
Vaqar Ahmed
?
_Offshore Banking and Compliance Requirements.pptx
_Offshore Banking and Compliance Requirements.pptx_Offshore Banking and Compliance Requirements.pptx
_Offshore Banking and Compliance Requirements.pptx
LDM Global
?
organizational behaviour in management.pptx
organizational behaviour in management.pptxorganizational behaviour in management.pptx
organizational behaviour in management.pptx
honeyredde0606
?
AP Automation: The Competitive Advantage Your Business Needs
AP Automation: The Competitive Advantage Your Business NeedsAP Automation: The Competitive Advantage Your Business Needs
AP Automation: The Competitive Advantage Your Business Needs
Aggregage
?
JP Morgan 2021 Outlook for Business Development
JP Morgan 2021 Outlook for Business DevelopmentJP Morgan 2021 Outlook for Business Development
JP Morgan 2021 Outlook for Business Development
Dika Rinakuki
?
coffee training in East and west harargh
coffee training in East and west hararghcoffee training in East and west harargh
coffee training in East and west harargh
AddisHailu4
?
Women Economy The presentation, Breaking the Silence: The Untapped Potential ...
Women Economy The presentation, Breaking the Silence: The Untapped Potential ...Women Economy The presentation, Breaking the Silence: The Untapped Potential ...
Women Economy The presentation, Breaking the Silence: The Untapped Potential ...
snehadeeproy085
?
Gross Domestic Product | Economics | Group Presentation
Gross Domestic Product | Economics | Group PresentationGross Domestic Product | Economics | Group Presentation
Gross Domestic Product | Economics | Group Presentation
Marcel David
?
From Community Building to Cultural Shaping: SLICKORPS Drives Transformation ...
From Community Building to Cultural Shaping: SLICKORPS Drives Transformation ...From Community Building to Cultural Shaping: SLICKORPS Drives Transformation ...
From Community Building to Cultural Shaping: SLICKORPS Drives Transformation ...
rsgdyvevztgs
?
Basic Mathematics For Economic Analysis DSC2.pdf
Basic Mathematics For Economic Analysis DSC2.pdfBasic Mathematics For Economic Analysis DSC2.pdf
Basic Mathematics For Economic Analysis DSC2.pdf
RoushanVishwakarma1
?
CORPORATE ACCOUNTING UNIT III - NOTES.pptx
CORPORATE ACCOUNTING UNIT III - NOTES.pptxCORPORATE ACCOUNTING UNIT III - NOTES.pptx
CORPORATE ACCOUNTING UNIT III - NOTES.pptx
manikandansMani2
?
How to Get an ISIN for a Private Company This presentation provides a compreh...
How to Get an ISIN for a Private Company This presentation provides a compreh...How to Get an ISIN for a Private Company This presentation provides a compreh...
How to Get an ISIN for a Private Company This presentation provides a compreh...
nextgenregistry
?
_JoinM2020_FTBEmembers Five Options.pptx
_JoinM2020_FTBEmembers Five Options.pptx_JoinM2020_FTBEmembers Five Options.pptx
_JoinM2020_FTBEmembers Five Options.pptx
FinTech Belgium
?
PFMS Public Finance Management System Presentation Dr. Konka BAMU
PFMS Public Finance Management System Presentation Dr. Konka BAMUPFMS Public Finance Management System Presentation Dr. Konka BAMU
PFMS Public Finance Management System Presentation Dr. Konka BAMU
Prakash Konka
?
RECOVER YOUR SCAMMED FUNDS AND CRYPTOCURRENCY HIRE?iFORCE HACKER RECOVERY
RECOVER YOUR SCAMMED FUNDS AND CRYPTOCURRENCY HIRE?iFORCE HACKER RECOVERYRECOVER YOUR SCAMMED FUNDS AND CRYPTOCURRENCY HIRE?iFORCE HACKER RECOVERY
RECOVER YOUR SCAMMED FUNDS AND CRYPTOCURRENCY HIRE?iFORCE HACKER RECOVERY
lonniecort7
?
Silver One March 2025 Corporate Presentation
Silver One March 2025 Corporate PresentationSilver One March 2025 Corporate Presentation
Silver One March 2025 Corporate Presentation
Adnet Communications
?
JoinM2020_FTBEmembers Five Options .pptx
JoinM2020_FTBEmembers Five Options .pptxJoinM2020_FTBEmembers Five Options .pptx
JoinM2020_FTBEmembers Five Options .pptx
FinTech Belgium
?
Eco Powerpoint updxjkx xslnklnxsated.pptx
Eco Powerpoint updxjkx xslnklnxsated.pptxEco Powerpoint updxjkx xslnklnxsated.pptx
Eco Powerpoint updxjkx xslnklnxsated.pptx
rohitsingh964760
?
AN INVESTIGATION INTO THE SOCIAL MARKETING STRATEGY OF TOAN THINH TRADING AND...
AN INVESTIGATION INTO THE SOCIAL MARKETING STRATEGY OF TOAN THINH TRADING AND...AN INVESTIGATION INTO THE SOCIAL MARKETING STRATEGY OF TOAN THINH TRADING AND...
AN INVESTIGATION INTO THE SOCIAL MARKETING STRATEGY OF TOAN THINH TRADING AND...
lamluanvan.net Vi?t thu¨º lu?n v?n
?
Compliance First, Security Guaranteed: Unveiling the Five Core Advantages of ...
Compliance First, Security Guaranteed: Unveiling the Five Core Advantages of ...Compliance First, Security Guaranteed: Unveiling the Five Core Advantages of ...
Compliance First, Security Guaranteed: Unveiling the Five Core Advantages of ...
MLPRU
?
Economic Revitalization for Pakistan: An Overview
Economic Revitalization for Pakistan: An OverviewEconomic Revitalization for Pakistan: An Overview
Economic Revitalization for Pakistan: An Overview
Vaqar Ahmed
?
_Offshore Banking and Compliance Requirements.pptx
_Offshore Banking and Compliance Requirements.pptx_Offshore Banking and Compliance Requirements.pptx
_Offshore Banking and Compliance Requirements.pptx
LDM Global
?
organizational behaviour in management.pptx
organizational behaviour in management.pptxorganizational behaviour in management.pptx
organizational behaviour in management.pptx
honeyredde0606
?
AP Automation: The Competitive Advantage Your Business Needs
AP Automation: The Competitive Advantage Your Business NeedsAP Automation: The Competitive Advantage Your Business Needs
AP Automation: The Competitive Advantage Your Business Needs
Aggregage
?
JP Morgan 2021 Outlook for Business Development
JP Morgan 2021 Outlook for Business DevelopmentJP Morgan 2021 Outlook for Business Development
JP Morgan 2021 Outlook for Business Development
Dika Rinakuki
?

Customer Equity R F M

  • 1. Question 2 By Doan Quynh Trang ID 483 9038
  • 2. ?
  • 3. Holistic marketing Marketing must become strategic and drive business strategy. A company needs to take a more holistic view of: the target customers¡¯ activities, lifestyle, and social space. the company¡¯s channels and supply chain. the company¡¯s communications. the company¡¯s stakeholders¡¯ interests. Holistic marketing will require strong software support.
  • 4. ?
  • 5. RFM Recency = The more recently purchase the better the customer is Frequency = The more frequent the purchase the more valuable customer is Monetary value = The more money the customer spend on the company product, the higher value they bring to the company
  • 6. RFM Days from the last purchase Purchase times/ month $ in purchase Customer 1 1 6 12000 Customer 2 3 3 11000 Customer 3 12 12 2000 Customer 4 60 11 3000 Customer 5 13 5 90000 Customer 6 45 1 6000 Customer 7 11 2 50000 Customer 8 23 4 45000 Customer 9 22 5 32000 Customer 10 5 8 15000 Customer 11 8 7 6000 Customer 12 96 3 14000 Customer 13 17 5 21000 Customer 14 21 10 22000 Customer 15 80 9 61000 Weight 33.33% 33.33% 33.33%
  • 7. RFM Days from the last purchase Purchase times/ month $ in purchase R scales F scales M scales Total Customer 1 1 6 12000 0.3333 0.1667 0.0444 0.5444 Customer 2 3 3 11000 0.1111 0.0833 0.0407 0.2352 Customer 3 12 12 2000 0.0278 0.3333 0.0074 0.3685 Customer 4 60 11 3000 0.0056 0.3056 0.0111 0.3222 Customer 5 13 5 90000 0.0256 0.1389 0.3333 0.4979 Customer 6 45 1 6000 0.0074 0.0278 0.0222 0.0574 Customer 7 11 2 50000 0.0303 0.0556 0.1852 0.2710 Customer 8 23 4 45000 0.0145 0.1111 0.1667 0.2923 Customer 9 22 5 32000 0.0152 0.1389 0.1185 0.2726 Customer 10 5 8 15000 0.0667 0.2222 0.0556 0.3444 Customer 11 8 7 6000 0.0417 0.1944 0.0222 0.2583 Customer 12 96 3 14000 0.0035 0.0833 0.0519 0.1387 Customer 13 17 5 21000 0.0196 0.1389 0.0778 0.2363 Customer 14 21 10 22000 0.0159 0.2778 0.0815 0.3751 Customer 15 80 9 61000 0.0042 0.2500 0.2259 0.4801
  • 8. RFM Days from the last purchase Purchase times/ month $ in purchase R scales F scales M scales Total Customer 1 1 6 12000 33.33% 16.67% 4.44% 54.44% Customer 5 13 5 90000 2.56% 13.89% 33.33% 49.79% Customer 15 80 9 61000 0.42% 25.00% 22.59% 48.01% Customer 14 21 10 22000 1.59% 27.78% 8.15% 37.51% Customer 3 12 12 2000 2.78% 33.33% 0.74% 36.85% Customer 10 5 8 15000 6.67% 22.22% 5.56% 34.44% Customer 4 60 11 3000 0.56% 30.56% 1.11% 32.22% Customer 8 23 4 45000 1.45% 11.11% 16.67% 29.23% Customer 9 22 5 32000 1.52% 13.89% 11.85% 27.26% Customer 7 11 2 50000 3.03% 5.56% 18.52% 27.10% Customer 11 8 7 6000 4.17% 19.44% 2.22% 25.83% Customer 13 17 5 21000 1.96% 13.89% 7.78% 23.63% Customer 2 3 3 11000 11.11% 8.33% 4.07% 23.52% Customer 12 96 3 14000 0.35% 8.33% 5.19% 13.87% Customer 6 45 1 6000 0.74% 2.78% 2.22% 5.74% Weight 33% 33% 33%