/rfm_flo

Primary LanguagePython

Customer Segmentation with RFM

Business Problem

FLO wants to divide its customers into segments and determine marketing strategies according to these segments. Towards this end, customers' behaviors will be defined and groups will be created based on these behavioral clusters.

Dataset Story

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

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 last shopping date of the customer

last_order_date_online : The last shopping date of the customer on the online platform

last_order_date_offline: The last shopping date of the customer on the offline platform

order_num_total_ever_online : 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 online purchases

interested_in_categories_12 : List of categories the customer has shopped in the last 12 months