Selecting some <Audience> records per <Different audience>
This selection indicates that there are multiple entries per audience.
About this task
In this situation, the input and output audience levels are the same, but a different audience level is used to scope the output. For example, select all customers within each household who have made purchases over $100 (Input audience level is customer, output audience level is customer, scoping by Household level, using Maximum Purchase Value>$100.)
In addition to creating a query, the Based on criterion also supports keywords allowing the functional equivalent of a GROUPBY macro function to be performed.
Procedure
- Select an input source for Input and the same audience
level for the output audience in the Audience process.The relevant Select options become available.
-
Select the Some entries per... option.
A list appears next to the selected option.
-
Select an audience level from the list.
All alternate defined audience levels (other than the input audience) appear in the list.
-
Click in the Based on field to enter a query.
The Specify selection criteria dialog opens.
-
Enter or build a valid query expression, then click OK to save it and
close the Specify selection criteria dialog.
Tip: You create a query expression in the Specify selection criteria dialog the same way that you would for a Select process. For instructions, see the topic Selecting a list of contacts.
- Continue configuring the process by completing the fields on the remaining tabs.