How To Perform an RFM (Recency, Frequency, Monetary) Analysis Using SQL

preview_player
Показать описание
In this video, we'll learn how to perform an RFM analysis using SQL (In SQL Server).

RFM analysis is a marketing technique used to analyze customer behavior based on three factors: recency, frequency, and monetary value. Recency refers to how recently a customer has made a purchase, frequency refers to how often a customer makes purchases, and monetary value refers to how much a customer spends on each purchase. By analyzing these factors, businesses can gain insights into their customers' behavior and tailor their marketing strategies accordingly.

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Venmo: @Jie-Jenn

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#sql #sqlserver #dataanalysis #rfm
Рекомендации по теме
Комментарии
Автор

Great video! I am a little bit confused as to how you grouped your RFM scores into a "bucket". Why did you use the (R+F+M/ 3 ) rather than the NTILE buckets you used earlier?

evantackett
Автор

For the monetary score is it possible to work with : sales=Order Quantity×(Unit Price−(Unit Price×Discount Applied) or profit = sales - (Order Quantity*Unit Cost)

JamliRima