FLO_RFM

Bussines Problem

#Segmenting the customers of FLO, an online shoe store, wants to make sense according to these segments. #It will be designed accordingly and will be created according to this particular clustering. #FLO, Wants to determine marketing strategies according to these segments.

Variables

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 the customer's first purchase

last_order_channel : Customer's previous shopping history

last_order_date_offline : The date of the last purchase made by 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 on the offline platform

customer_value_total_ever_offline : Total fees paid for the customer's offline purchases

customer_value_total_ever_online : Total fees paid for the customer's online purchases

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