I have a list of purchases by customers that includes customer name, product purchased and date of purchase.
Is there a way to get a list of everyone who bought item A and then item B, in that order. (ie: Not people who purchased B and then later purchased A)
Here’s a sample sheet I’ve been trying with:
The purpose of this workflow is to determine how many people who “purchase” product #10 (which is the free sample) end up becoming paying customers and purchase product #20.
From the sample data I would like to get freebie@gmail.com but not payee@gmail.com Even though they both ‘purchased’ both products, only freebie@gmail.com got the free sample first.
If I could also find out how long in between free and paid that would be the cherry on top!
This is something I have been trying to do for years in many CRM and ecommerce platforms I have used but it seems incredibly difficult if not impossible to do in most.
It would be very valuable to business owners who want to know which products lead customers to make bigger purchases later.
Any hints, suggestions or ideas about which filters or transforms I should focus on or even a general strategy would be great!
Thanks