Buyer LTV Path
We have a sales funnel with multiple products within it. Product A (with three price points), B, C, D and they get progressively more expensive. The dataset I have being pulled in includes all of the relevant information. It records every single transaction, and includes: DateTime, email, product purchased, purchase amount
If a contact purchases multiple times, they will have multiple rows specific to that product purchased. The one thing that will be the same is their email.
I'm trying to create a card that is a table and shows the count of each product path purchased by column. The far left column will have Product A and its three products. The column to its right will have Product B, and to its right will be Product C, etc. The counts in each column represent the people who have purchased all options.
There would be a single row of Product A price option 1 with a count that shows only those who purchased that one product and nothing more.
There would be another row of Product A price option 1 with a count in Column A showing a different number and also has a number in Column B for those who purchased Product A price option 1 as well as Product B.
And so on. I think once this is solved, the rest of the cards will be easy enough to create.
I tried creating this in a Sumo card pivot table, and it gets me close. I can see each contact and the different products they purchased, but the final step is combining the products. And combining the products on a datset or even BeastMode level I don't think will work because then I'd lose the pathing.
Any help is appreciated. Thanks!