Business Problem:
FLO wants to determine the roadmap for sales and marketing activities. In order for the company to make a medium-long-term plan, existing customers need to contact the company in the future the potential value they will provide needs to be estimated.
Features:
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