trouble creating a list of multi show single ticket buyers

Former Member
Former Member $organization

The request I thought was really simple. Create a list of people who have gone to more than one show within a season as single ticket buyers. We use a specific price type for most of our single buyers so I figured I could have three lines of criteria: 

Ticket_History_Price_Type IN REG

Ticket_History_Prod_Season IN Butterfly

Ticket_History_Prod_Season IN Dutchman

I know from prior searching that there people that fall into that category but List Manger pulls back 0. If of course I change the operator to HAS, I get everyone that has gone to either of those shows. I've been working with RAMP for about a week on this and nothing is working. I've tried running an extraction to no avail. I thought I'd reach out to the community to see if someone has thoughts as to why this is not working. Is there something obvious that both RAMP and I are missing in this?

Thanks in advance

Parents
  • Former Member
    Former Member $organization
    So, this SHOULD work, but I forgot to mention, just to make things more complicated, that we use the REG price type for other events than just operas. So when I use the unique criteria, it pulls these non-opera events that have the REG PT. I know htat’s my fault that I should have created unique PTs for all different types of events.
     
    Holton Johnson
    Technology and Database Administration
    Austin Opera
    Direct: 512-610-7666
    Box Office: 512-472-5992
    3009 Industrial Terrace, Suite 100 | Austin, TX 78758
    /Users/melysa/Library/Containers/com.microsoft.Outlook/Data/Library/Caches/Signatures/signature_135253855
              
     
Reply
  • Former Member
    Former Member $organization
    So, this SHOULD work, but I forgot to mention, just to make things more complicated, that we use the REG price type for other events than just operas. So when I use the unique criteria, it pulls these non-opera events that have the REG PT. I know htat’s my fault that I should have created unique PTs for all different types of events.
     
    Holton Johnson
    Technology and Database Administration
    Austin Opera
    Direct: 512-610-7666
    Box Office: 512-472-5992
    3009 Industrial Terrace, Suite 100 | Austin, TX 78758
    /Users/melysa/Library/Containers/com.microsoft.Outlook/Data/Library/Caches/Signatures/signature_135253855
              
     
Children