I am trying to pull a list of constituents who have purchased 3 or more productions out of 9 specific productions. These need to be PAID orders, not comps of any kind. These constituents can have ANY combination grouping of 3 of the 9 productions. Any help is appreciated. This is cross posted in other forums as well.
For Example, out of the multiple possibilities of 9 productions, I would want to see a constituent record with purchases to production 1, 4, and 9; or 2, 3, and 7, etc.
Hi Marie,
You should be able to do this by using the list criteria "tickets - number of unique performances". As your first criteria add the nine performance you want included and then use >= 3 as your unique performances criteria.
I tested it out on our Specials which aren't part of a package and it worked - giving me results that only had 3 or more of those selected performance. Some of the results were people who had included those performances in a CYO package.
If you just want single ticket buyers, you may need to use a MOS criteria also.
Hope that helps!
Michelle
Hi Michelle-
Wish I could say that worked. Yes, it pulls patrons with 3 or more shows, however it returns results based on them having at least one of the nine performances and two or more other shows, not people that have 3 or more of the selected 9.
Could you compile a big list of names in T-STATS of everyone who had tickets to those specific nine shows and then filter that list out by more specific criteria in list builder or extractions?