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

The general steps to find purchasers to multiple events are:

1. Open the Mail List Window.

   Click here to learn how to open the window.

2. Click the New button.

   The Mail List Inserting window opens.

   

3. Enter a Name and Description for the list.
4. Click the Save button.
5. In the Criteria Groups tab, click the Create Group button.
6. Choose To Add Patrons to the Mail List.

The Mail List Data Selection dialog opens.



7. In the drop down list, choose ticket data per performance.
8. Click the Next button.

   The Edit Report Parameters window opens.

   

9. Select the criteria 'Play #' or 'Event #' (depending on what your venue calls it) and then select multiple events from the pick list
10. After you have completed making your selections, click Save.

    You are returned to the Parameters window.

    

11. Click the Having button on the Parameters window.

The having criteria should be the 'Event #'.

Pick Unique count on the left.

On the right, enter the range of unique events such as between 3 and 6.



12. Click Save.

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.