Тёмный

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

Jie Jenn
Подписаться 63 тыс.
Просмотров 5 тыс.
50% 1

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.
💻 Dataset download: data.world/dataman-udit/us-re...
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🛒 By shopping on Amazon → amzn.to/2JkGeMD
👩‍💻 Follow me on Linked: / jiejenn
🌳 Becoming a Patreon supporter: / jiejenn
✉️ Business Inquiring: RU-vid@LearnDataAnalysis.org
#sql #sqlserver #dataanalysis #rfm

Опубликовано:

 

27 мар 2023

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 4   
@user-ff2lb1qb6w
@user-ff2lb1qb6w Год назад
Thanks
@evantackett8198
@evantackett8198 11 месяцев назад
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?
@JamliRima
@JamliRima 8 месяцев назад
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)
@-brian--
@-brian-- 8 месяцев назад
is there a github link for this
Далее
кукинг с Даниилом 🥸
01:00
Просмотров 848 тыс.
IQ Level: 10000
00:10
Просмотров 4 млн
Database Indexing for Dumb Developers
15:59
Просмотров 48 тыс.
RFM Analysis With Excel
19:24
Просмотров 44 тыс.
Lecture 40: RFM and Market Basket Analysis
34:41
Просмотров 4,6 тыс.
кукинг с Даниилом 🥸
01:00
Просмотров 848 тыс.