Page Comparison

...

To add fields to your query, click on the field in the field library and then select the values you want to include. The way you select the values depends on the field type.

Skittle	Field Type	To Add This Field
Image Modified	Single Response	Check all values you want to include in the query
Image Modified	Multiple Response	Check values and indicate whether they should be included or excluded from the query.
Image Modified	Behavior	Check values and indicate whether they should be included or excluded from the query.
Image Modified	Date	Type in a date in the format MM/DD/YYYY in the search box or click on the link for the date picker. You can search multiple dates by separating them by commas (ex. 01/02/2012, 01/13/2012) or for a date range by including a dash between dates (ex. 01/02/2012-01/13/2012).
Image Modified	Text	Search for one or more text strings. When you want to search multiple values, wildcard symbols can be used to pull different information:   asterisk (*) – 0 to many charactershash (#) – 1 character only #* or *# – 1 to many characters (all fields that have text in them and are not blank) Click on the help link in Audience Builder for further search options.
Image Modified	Yes/No	Check the values that you want to include
Image Modified	Query	Check the Audience Builder query that you want to include in your current query.

When you select the field values, they will appear in the query window. Customer counts are displayed for each value, as well as the customer count for the field. For multi-response demographics, date fields and behaviors, the sum of the counts for the individual values may be greater than the customer count for the field. This is because customers can have multiple individual values, but they are only included once in the customer count for the field. You will need to select your arithmetic operator using the drop down menu next to the field name. This determines how the field will affect the total customer count for the query, displayed as Net Customers Selected.

...

Example 1 – Presidents in the Manufacturing industry in the state of Illinois OR Managers in the Manufacturing industry in the state of Wisconsin. Using the group function allows you to create an output file that includes Presidents in Illinois and Managers in Wisconsin. If the group function was NOT used, the output would include Presidents and Managers in the Manufacturing industry in Wisconsin or Illinois.

Example 2 – Qualified one year subscribers OR Qualified direct written requesters. Using the group function allows you to create an output file that includes Qualified subscribers that are one year OR direct requesters. In this example, it is possible for a subscriber to meet the criteria for both groups (a subscriber can be one year AND a direct written requester). The output file would only include these subscribers once. If the group function was NOT used, the output would only include qualified subscribers that are one year AND direct written requesters.

It is possible for a subscriber to meet the criteria for multiple groups. The Net Customers Selected count only counts these subscribers once. If the customer is in multiple groups, they are assigned to the first group in which they appear in the query window (in this case group 1).

...