Hello!
Looking for recommendations on the best way to look at STBs that purchased tickets to multiple productions. Ultimately, I'd like to be able to see how many constituents purchased tickets to 3 perfs, 4 perfs, 5 perfs etc. over the course of the season. Then, I'd like to save each as a list so that I can use them in an extraction.
Thanks!
Michelle
In List Manager we often use the criterion Ticket History Unique Perfs. I think this is a standard criterion because it lives in vs_ticket_history.
So a list with Ticket History Season IN [Current Season] and Ticket History Unique Perfs >= 3/4/5, etc. will work when it comes to performances.
However, if a ticket buyer purchases for multiple performances of the same production and nothing else, they would also qualify for this list, and it sounds like you might not want that? To make a list of 3+ multi-buyers across productions I have made an extraction with similar segments containing three different lines for Ticket History Prod Season: IN Production 1, IN Production 2, HAS Production 3/4/5, then a segment for the next possible combination and so on. This is very manual! If you need to do this often you may want to have a custom criterion created for Unique Production Seasons or however else you group your productions.
-- Mike
Thank you! I may look into creating custom criteria.