4 Replies Latest reply on Jul 10, 2012 7:08 PM by dalia cohen

Time between purchases? For probability of repurchase report.

I have a list of customers with their various purchases. I am trying to eventually get at a probability of repurchase report, but before that, I need to:

1. Determine which was the initial purchase for each customer

2. Find the time in between their first and second purchase

If possible, I would also like to find the percent of people who after making an initial purchase then make a second one, the percent of people who after making a second purchase then make a third one, etc.

Any help would be much appreciated!! I've search through the different forums here and can't seem to find anything that answers this exactly (or anything I could understand and apply to my data).

Thanks!

• 1. Re: Time between purchases? For probability of repurchase report.

Can you supply some sample data that represents your situation?

• 2. Re: Time between purchases? For probability of repurchase report.

Just did =)

Thanks!

• 3. Re: Time between purchases? For probability of repurchase report.

One option is to add a sequence number and time length from previous to your data source, and then you can do the analysis you are looking for. I would recommend using an ETL to add these columns or you can use Tableau Server to generate the data file, as in http://community.tableau.com/thread/118600

The attached has the formula for generating these columns, and also connected to the pre-processed data, an analysis for what I understand from your question. I also filtered out the records with price of zero prior to computing.

Is this what you are looking for?

1 of 1 people found this helpful
• 4. Re: Time between purchases? For probability of repurchase report.

Yes this is exactly what I was hoping for!

Quick question, though - I can't seem to download the extract to find the formula for "sequence". How did you go about getting sequence, exactly? I'm not sure I fully understood the link about multipass aggregations.

Thanks so much!