Mail List of Attendees to Multiple Events

A question that has been asked many times is "How do we find people who bought multiple events?". Just by changing the data you select from, you can use the technique described below to find people who:

• donated multiple times
• volunteered multiple times
• received multiple mailings or eblasts
• bought multiple gift certificates
For the purposes of the example, refer to the picture below. The general steps to find purchasers to multiple events are:
• Create a group in the criteria window based on ticket data per performance
• Select the criteria 'Play #' or 'Event #' (depending on what your venue calls it) and then select multiple events from the pick list
• Click the Having button on the criteria window
• The having criteria should be the 'Event #'. Be sure to pick
  • Unique count on the left
  • and on the right, enter the range of unique events such as between 3 and 6
• When you execute the mail list, you will get people who have bought 'distinct' events out of the criteria you selected
• You can make the first part of the criteria as complicated as you wish, such as 'all regular tickets' that were 'sold by user xxx' and were 'sold on a thursday afternoon' just by adding more lines to the regular criteria as you've done before.