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.
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
Unfortunately the forum software only allows upload of images, not other files. Perhaps you could upload it to DropBox, Google Docs or similar and then link to it?
@DanFeliciano I have tweaked the forum setting to (hopefully) allow you to upload a .transform file in a post, in the same way as you can upload an image.
EDT fans, this is the transform I created using @Nicolai data and requirements. I used the Unique Transform to come up with essentially the same result as @Admin 's.
I added the calculation between dates. I think @Admin is trying to teach me to code. This is my Pièce de résistance.