An e-commerce site wants a forward-looking projection for customer actions according to the CLTV values of its customers.
With the dataset in your hand, is it possible to identify the customers who can generate the most revenue within 1-month or 6-month time periods?
- The dataset named Online Retail II includes the sales of a UK-based online store between 01/12/2009 - 09/12/2011.
- The product catalog of this company includes souvenirs. They can also be considered as promotional items.
- There is also information that most of its customers are wholesalers.
Dataset online_retail_II_xlsx
Variables
- InvoiceNo – Invoice Number If this code starts with C, it means that the transaction has been cancelled.
- StockCode – Product code Unique number for each product.
- Description – Product name
- Quantity – Number of products Indicates how many of the products on the invoices have been sold.
- InvoiceDate – Invoice date
- UnitPrice – Invoice price (Sterling)
- CustomerID – Unique customer number
- Country – Country name
- Reference - VBO