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
  • The reason it brings back 0 is because the production season cannot be equal to Butterfly and Dutchman at the same time.

    You will need to use 2 lists.

    First List (Butterfly List)

    • Ticket_History_Price_Type IN REG
    • Ticket_History_Prod_Season IN Butterfly

    Second List (Been to Both)

    • Ticket_History_Price_Type IN REG
    • Ticket_History_Prod_Season IN Dutchman
    • List IN (Butterfly List)

    Ensure first list is Dynamic and it should then regenerate every time you generate the second list.

    Mark

Reply
  • The reason it brings back 0 is because the production season cannot be equal to Butterfly and Dutchman at the same time.

    You will need to use 2 lists.

    First List (Butterfly List)

    • Ticket_History_Price_Type IN REG
    • Ticket_History_Prod_Season IN Butterfly

    Second List (Been to Both)

    • Ticket_History_Price_Type IN REG
    • Ticket_History_Prod_Season IN Dutchman
    • List IN (Butterfly List)

    Ensure first list is Dynamic and it should then regenerate every time you generate the second list.

    Mark

Children
No Data