I'm attempting to create an extraction for recent multi-buyers in our festival season (aka people who are not subscribers but have attended 2-4 productions as a single ticket buyer), divided by people who are interested in "Classics" vs "Contemporary" operas.
I tried to set this up with "Ticket History Season" in 2018 and "Ticket History Unique Perfs HH" set to >= 2, but this list also includes people who have bought just 2 performances of the same production. When I try to narrow it down to specific productions by adding the criteria "Ticket History Production" in Show 1 and another "Ticket History Production" in Show 2, the resulting count goes to zero. If I set it up using "Ticket History Production" in both Show 1 and 2, I do get a list showing people who bought 2 or more tickets to either or both productions. But then if I try to narrow it down to just people who bought, for example, contemporary shows by using "Ticket History Production" not in Show 3, the list still includes people who saw Show 3.
Is there any workaround that any of you have developed to have an extraction that specifically shows people who attended 2 or more productions (not just performances) per season, segmented by show type? Any light you can shed would be much appreciated!
Anh Le | Assistant Director of Marketing
Opera Theatre of Saint Louis | ExperienceOpera.org
ale@opera-stl.org | (314) 963-4294
You are on the right track but you are looking for someone IN your primary production but also HAS your secondary productions. And then iterate on that! I am working on an extraction with multibuyers in it right now. My first segment looks like this:
One extraction segment on its own will only give you people who have your first show. In my case, I kept copying this segment, changing the IN production to the next production and removing that production from the HAS pool. (And in my case changing the season for half the segments but you can probably not use it at all.) Since my total pool was 19 productions that means 18 segments to cover every combination!
I just have this in my main mailhouse extraction but some organizations do their multibuyers in a separate extraction, then save to list and use the list in their main extraction so it's only promoted as one segment.
Also there are more elegant ways of doing this on the back end, so if you need multibuyers often you may want to ask for custom elements like "# of unique productions" or "# of unique contemporary productions."
-- Mike