Customer lifetime value represents the revenue from a customer over the duration of relationship with the company. The formula is calculated by multiplying average earnings per purchase and number of purchases.
FLO wants to set a roadmap for sales and marketing activities.In order for the company to make a medium-long-term plan, it is necessary to estimate the potential value that existing customers will provide to the company in the future.
The dataset is based on the past shopping behavior of customers who made their last purchases from OmniChannel (both online and offline) in 2020 - 2021 consists of the information obtained.
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 date of the last purchase made by the customer
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 : The total price paid by the customer for offline purchases
customer_value_total_ever_online : The total price paid by the customer for their online shopping
interested_in_categories_12 : List of categories the customer has purchased from in the last 12 months