Propose customers to get a bonus for a small products number increase within one order. For example, propose a client to buy 3 lip balms at a special price, if there are 2 lip balms in the client's average order. Be sure to choose products with regular demand for such a promotion.
The data required:
- Sales data broken down to SKU
The items to be calculated:
- Calculate the average units number per one order for each product