Skip to content

Define filter conditions

After these steps, a node keeps only the records that meet your conditions.

Before you begin

Permission
Campaign Audience Builder: User permission set group or one that contains it. See Permission sets.

Each node on the canvas has its own conditions. A record of that node’s object stays in the audience only if it meets them.

  1. Double-click the node on the canvas. The dialog Edit Contact Filter opens, named after the node. When you add a related object, the dialog opens after you choose the object. See Add related objects.

  2. Select Add Condition.

  3. Under Field, type part of the field name and select the field. The list shows only fields you have access to.

  4. Under Operator, choose how to compare. The operators depend on the field type. See Filter operators.

  5. Enter the Value.

  6. Repeat for every condition, then choose under Filter Records where how the conditions combine.

  7. Select Done.

ChoiceA record stays when
All Conditions Are MetIt meets every condition. This is the default.
Any Condition Is MetIt meets at least one condition.
Custom Logic Is MetIt meets the expression in Custom Logic.

In Custom Logic, use the condition numbers with AND, OR, NOT and parentheses, for example (1 OR 2) AND 3. Use every number at least once. Put negations in parentheses, such as (NOT 1), and group mixed AND and OR.

Conditions combine the fields of one node. How related nodes combine is set separately. See Combine related-object filters.

One condition on a text field can hold a list, for example postal codes.

  1. Enter or paste the values in Value, separated by commas, semicolons or tabs.

  2. Select Split into 5 values under the field. Each value becomes a pill.

CAB splits only when you select the link, so Smith, John stays one value. A list matches records with any of its values. With Does Not Equal and Does Not Contain, it matches records with none of them. In custom logic, the list counts as one condition.

  • To add a value, type in Add value and press Enter, or type a comma or semicolon. A pasted column from a spreadsheet adds one pill per line.
  • To remove a value, select the X on its pill.
  • To see every value, select Edit 5 values. The window shows one value per line; a comma in a line belongs to the value. Combine into one value turns the list back into one text value.

For the size of a list, see Limits and requirements.

For a Date or Date/Time field, select Use relative date under the value and enter an expression such as LAST 30 DAYS or THIS FISCAL YEAR. The date then moves with every run. Use calendar date switches back to a fixed date. See Filter operators.

From two conditions on, a grip appears to the left of each condition when you point at it.

  • Drag the grip to move the condition. Press Esc to cancel.
  • Or select the grip and choose Move up, Move down, Move to top or Move to bottom.
  • With the keyboard, focus the grip and press the up or down arrow key.

The numbers always run from top to bottom. CAB rewrites custom logic so it keeps its meaning: moving condition 3 to the top turns 1 AND (2 OR 3) into 2 AND (3 OR 1).

Select the delete icon at the end of the condition. It appears from two conditions on. In custom logic, CAB removes the number and renumbers the rest: removing 2 from (1 OR 2) AND 3 gives 1 AND 2.

After your first change, Undo and Redo appear in the header of the dialog. They cover every change in the dialog: conditions, their order, the logic, With or Without, and the logic between related objects. Typing in one field counts as one change.

You can also press Cmd+Z or Ctrl+Z to undo, and Cmd+Shift+Z, Ctrl+Shift+Z or Ctrl+Y to redo. In a text field, these keys undo your typing there. The history ends when you close the dialog.