• Replies 5 replies
  • Subscribers 701 subscribers
  • Views 194 views
  • Users 0 members are here
Options
Related

Flex Package analysis

Tessitura User
$organization

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

Parents
  • $organization

    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

Reply
  • $organization

    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

Children
  • $organization in reply to Nicola Cann

    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, 

  • $organization in reply to Nicola Cann

    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.

  • $organization in reply to Heath Wilder

    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! 

  • $organization in reply to Tessitura User

    Excellent - great 3 person teamwork