Create a Group Filter

You can create group filters to specify the filters to use on grouped data.

Group filters are applied to the data after the grouping is completed and must be aggregate functions. For example, if you join the Contacts (contacts) table to the Marketing Activities (ma_trans) table, create a fixed filter for ma_trans.type of email Sent, group by contacts.c_id, and use the group filter count(*) > 10, then only those contacts that have been sent more than ten emails will be selected in the segment.

1. From the Criteria tab, click Edit Group Filters.
   The Edit Groups window opens.
2. Click Add Filter
   The Add Filter window opens.
3. Enter field information on the Add Filter window. See How Segment Filters Work.
4. Click OK to save the group filter.
   The additional actions that become available are identical to those used when creating logical expressions for segment filters. These actions let you edit your filter, create additional filters, add OR logic to the join filters, negate filters, and view a text definition of the join filter logical expression. See Edit a Logical Expression.
5. Click OK.