/RFM-Analysis-for-Customer-Segmentation

By performing RFM analysis on the data of a shoe store, it is aimed to divide the customers into segments and take action.

Primary LanguageJupyter NotebookMIT LicenseMIT

RFM Analysis For Customer Segmentation

Business Problem

FLO, an online shoe store, wants to segment its customers and determine marketing strategies according to these segments. To this end, the behaviors of the customers will be defined and groups will be formed according to the clusters in these behaviors.

Dataset Definition

The dataset consists of the information obtained from the past shopping behaviors of customers who made their last purchases from FLO as OmniChannel (both online and offline shopper) in the years 2020-2021.

  • master_id: Unique customer number
  • order_channel: Which channel of the shopping platform is used (Android, ios, Desktop, Mobile)
  • last_order_channel: The channel where the most recent purchase was made
  • first_order_date: Date of first purchase made by the customer
  • last_order_date: Customer's last purchase date
  • 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: The total number of purchases made by the customer on the offline platform
  • customer_value_total_ever_online: The total fee paid by the customer for offline purchases
  • customer_value_total_ever_offline: The total fee paid by the customer for online purchases
  • interested_in_categories_12: List of categories the customer has shopped in the last 12 months

Warning: I would like to state that I cannot share the dataset.