Refining the Query

After you drag a field to the Query Pane, you can then specify the values of that field to use in building the query.

1. Next to the field name, select Includes or Excludes.

   When you select Includes, the recipients who meet the criteria in the Field value are included in the query count. Conversely, when you select Excludes, recipients who meet the criteria in the Field value are excluded from the query count. If you create a query with only Exclude statements, the Total Count is calculated by taking the entire database and then subtracting the excluded individuals.

2. View the value in the Count column to determine whether the query returns the approximate number of customers that you expected.

   Note: Unsubs and undels might still be included in the count until you click Get Count, as in Step 4.

3. Drag additional fields to the Query Pane to refine the query.

   To remove any criteria in the query, click next to it.

4. Click Get Count to determine the number of customers in the audience.
5. Repeat steps 1 through 4 until the query yields the results you want.

To undo the most recent action, click .

To redo the most recent action, click .