FLO company wants to determine roadmap for sales and marketing activities. In order to make a medium-long-term plan company needs to estimate the potential value of the customers.
The dataset consists of the information obtained from the past shopping behavior of customers who made their last purchases from Flo as OmniChannel (both online and offline shopper) between 2020 and 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 the customer's first purchase
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 : Total number of purchases made by the customer offline
customer_value_total_ever_offline : Total fee paid by the customer for offline purchases
customer_value_total_ever_online : The total fee paid by the customer for their online shopping
interested_in_categories_12 : List of categories the customer has shopped in the last 12 months