Skip to content

senanurbalcioglu/flo_rfm_analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

WHAT IS RFM ANALYSIS ?

RFM analysis is a simple and technique method to segment customers according to their recency, frequency and monetary values.
Recency value means when a customer last made a purchase. If first customer shopped one day ago and second customer shopped ten days ago, first customer is more valuable.
Frequency value is how often a customer has made purchase.
Monetary value means how much a customer has spent overall.

RFM Scores

It is standardized to express RFM metric values in the same gender. RFM scores are needed in order to better compare and analyze RFM metric values both within themselves and with each other. Recency, frequency and monetary values are combined. There is a problem. There will be too many combinations as all RFM metrics range from 1 to 5. This situation makes it difficult for the segmentation process to be efficient. This chart shows segments according to recency and frequency values.

image

BUSINESS PROBLEM

FLO wants to set a roadmap for sales and marketing activities.In order for the company to make a medium-long-term plan, it is necessary to estimate the potential value that existing customers will provide to the company in the future.


THE STORY OF DATASET

The dataset is based on the past shopping behavior of customers who made their last purchases from OmniChannel (both online and offline) in 2020 - 2021 consists of the information obtained.

master_id: Unique customer number
order_channel : Which channel of the shopping platform is used (Android, ios, Desktop, Mobile, Offline)
last_order_channel : The channel where the last purchase was made
first_order_date : The date of the customer's first purchase
last_order_date : The date of the last purchase made by the customer
last_order_date_online : The date of the last purchase made by the customer on the online platform
last_order_date_offline : The date of the last purchase made by the customer on the offline platform
order_num_total_ever_online : The total number of purchases made by the customer on the online platform
order_num_total_ever_offline : Total number of purchases made by the customer offline
customer_value_total_ever_offline : The total price paid by the customer for offline purchases
customer_value_total_ever_online : The total price paid by the customer for their online shopping
interested_in_categories_12 : List of categories the customer has purchased from in the last 12 months

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages