Selecting entries for each entry at that audience level

This selection indicates that there are multiple selections from multiple audience levels.

Select this option if the number of members at the selected audience levels satisfies some condition (for example, Number of Accounts > 1 or Number of Purchases > 3 ).

This option is available only if the input audience level is not normalized (that is, the record ID is not unique in the selected Choose Level table), and the input and output levels are the same. It is the only option available if no alternate keys have been defined for your output audience table.

Select an input source for Inputand the same audience level for the output audience in the Audience process.

The relevant Select options become available.

Select the For Each option.

This option is available only if the input audience level is not normalized (that is, the record ID is not unique in the selected Choose Level table).

A list appears next to the selected option.

Choose a Based On selection.

If the table you select under Choose Audience (that is, the output audience) is not normalized, there might be duplication in your results. You can use a Based On method for Campaign to use when selecting records, to avoid duplication. (For example, if your results might include more than one individual in the same household, you can use Based On to select only one individual from that household, based on the criterion you configure in this feature.)

You must select one of the Based On methods, either Count or Condition:

Specify a Count to use in Based On:

This option lets you select the <Input Audience Level> ID, where the number of occurrences of the <Input Audience Level> ID satisfies the specified condition.

To toggle between different relationships (<,<=,>,>=,=), click the operator button repeatedly until the desired relation is displayed.

-- OR --

Specify a Condition to use in Based On:

Click in the text box to the right of Condition.

The Specify Selection Criteria window appears.

Enter or build a valid query expression, then click OK to save your entry and close the Specify Selection Criteria window.

(Optional) If you selected a count to be based on, Filter becomes available.

Use the Filter function to reduce the number the IDs that will be available to the Based On calculation. For example, you might want to select customer IDs based on their average account balance in the last six months, but before doing that, you would want to filter out all customers whose accounts are inactive.

To filter records before performing the Based On computation, click Filter. The Specify Selection Criteria window appears. You can enter a query expression to specify which records will be used in the Based On calculation. The filtering criteria is applied before performing the Based On calculation, allowing you to remove records from consideration.

Click OK to save your query and close the Specify Selection Criteria window.

Continue configuring the process by completing the fields on the remaining tabs.