In this analysis, I answered 5 questions that my customer had. I highlighted the key points which would help my customer increase sales. The data has been completely anonymized and modified. Here is an extract of that analysis.
date product userId
2012-08-14 23:57:08 Orange 2
2013-11-03 23:59:24 Pear 3
2013-04-04 00:00:10 Kiwi 5
2015-05-30 00:02:56 The whole fruit basket! 6
2014-09-14 23:59:23 Mango 7

Question 1: What is the share of repeat customers?

There are 5234 distinct customers. Out of which 3657 bought more than one product. Therefor, the ratio of customers who bought more than one product is 69,9%

Question 2: When oranges are bought first, what is the most common second purchase? What is the latency between first and second purchase?

Let’s first look at the sales data:

First Purchased Product Second Purchased Product Number Of Cases Share Of Cases (%) Purchase latency
Orange Apple 167 48 26 weeks
Orange Mango 111 32 17 weeks
Orange Pear 51 15 32 weeks
Orange Kiwi 13 4 31 weeks
Orange The whole fruit basket! 4 1 50 weeks
Orange Orange 1 0 0 weeks

48% of second purchases are Apples. Half of these Apples are purchased in the first 26 weeks after purchasing Oranges. Example users that follow this pattern are: 7006, 10726 and 12385.
32% of second purchases are Mangoes. Half of these purchases are made in the first 16 weeks after purchasing Oranges. Example users that follow this pattern are 4764 and 13029.

Let’s then look at the distribution of second product purchases:

Each bar in this graph corresponds to a 5 week period.

Apple sales peak at the beginning (first 15 weeks) and then slowly decrease. Mango sales peak at the beginning (first 5 weeks) and then drop very sharply.

Recommendation

Based on this distribution, I would offer Apples once in the first 15 weeks. And continue offering them every 5 weeks for a year. Or maybe every 10 weeks if 5 feels too intrusive. As for the Mangoes, based on the distribution in question 3, I would offer them as the client is purchasing oranges. I would also offer them once every 5 or 10 weeks for a year.