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
Hi Holton,
There is a Ticket History criteria element called "Ticket History Unique Perfs." Try setting that to >= 2, along with your price type criteria and the "Ticket History Season" criteria with your particular season selected.
-Michael Flaherty-Wilcox, Tessitura Network
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)
Second List (Been to Both)
Ensure first list is Dynamic and it should then regenerate every time you generate the second list.
Mark
Adding a criteria for "Ticket History Season" or "Ticket History Keyword" would help isolate just opera buyers. Are your seasons or keywords structured that way?