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
Hi!
Yes, I'm essentially trying to find a way to filter all of our Flex packages to see which patrons chose more pops or more phils. The goal would be to have two separate lists. Flex w/ more Pops and Flex w/ more Phils that we could include in our renewal mailings. Currently, I have a table that shows everyone with a CYO order and how many tickets they have within the each of the seasons. I haven't experimented further, but I'd love to have a formula (or list filters) that can categorize them without going through each patron. I'd love to see what you can come up with! I'm also working on it a little today, so if I have any luck I'll post it here. Best,