Hi all! I have been tasked with analyzing our flex packages (CYO) to see whether patrons who purchase them are adding more Philharmonics or Pops series concerts to them. (Ex. CYO6's with 4+ Phils, or 4+ Pops in order to send them more targeted marketing materials. I may be missing something, but I can't seem to find a way to accomplish this (through Analytics nor list making) and might have to resort to looking through orders...Any advice would be appreciated!Michael
Hello! Could you maybe provide some more information about what you're trying to do?Seems to me like you could filter down to people who've purchased a CYO 6 package and then total the number of orders with 4+ phils or 4+ pops and see which has more? You could do this relatively easily with some bucketing/formulas and filtering I think!If this is the kind of thing you're trying to do I can try to set up a table showing how I'd do it with our 6+ subscribers and a concert breakdown - full disclosure, I haven't yet done this so it might not work as I expect!
Cheers, N
I set up my buckets like this:
If the number of unique production seasons in a package order (filtered by the blue) is more than 3 (ie: Constituent selected 4+ pops) it counts 1.
SUM ( [Constituent ID], COUNT( [Package ID], IF ( ([# of unique Production Season], [Production Season] ) > 3 , 1, NULL) )
Filter this for Pops or Phil Production Seasons, depending on the bucket.
Hi Heath, Thank you for this! I've changed it slightly to encompass every package size: SUM ( [Constituent ID], COUNT( [Package ID], IF ( ([# of unique Production Season], [Production Season] ) > [# of Performance Code}/2 , 1, NULL)And this seems to be catching everything for now. Much appreciated!
Excellent - great 3 person teamwork