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

  1. 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.
  2. Select the Some entries per... option.
    A list appears next to the selected option.
  3. Select an audience level from the list.
    All alternate defined audience levels (other than the input audience) appear in the list.
  4. Click in the Based on field to enter a query.
    The Specify selection criteria dialog opens.
  5. 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.
  6. Continue configuring the process by completing the fields on the remaining tabs.