Comments
-
Thanks for your response @GrantSmith. I managed to do something very similar to this via an ETL. Which allowed me to make column 1 on my table, "Product Names", then subsequent columns the individual products. Aggregating by count yields the number of contacts who purchased that first product as well as any following…
-
Yeah, sorry - that was part of my original response that got deleted. In the link above also here: https://docs.google.com/spreadsheets/d/15R6NHnENuXyzl7D5QPq6PfJMRrnHVtZXedULvnJJ5_g/edit#gid=0 Sheet2 is what the raw data looks like. I added the column 'Transaction Number' via ETL to track which transaction it is for each…
-
I wrote up a long reply only to be timed out of this board and lose it all. Rad. https://docs.google.com/spreadsheets/d/15R6NHnENuXyzl7D5QPq6PfJMRrnHVtZXedULvnJJ5_g/edit#gid=0 Sheet 1 is an example of the type of card I'd like to made. Keeping in mind, for example, Product A1, in column B... are the count of emails who…