skip to the main content area of this page
EMM Help: Custom Query

Custom Query

The Custom Query is an addition to the query string for a particular campaign that will modify the default behavior of the chosen audience. Please note that CustomQueries ONLY affect live audiences. It will not modify any of the Test Audiences.

Custom Query Format:
Since the Custom Query is added onto the end of the standard audience query strings, it should take the following format:
    [conditional statement] field [evaluator] value
where
    [conditional statement] is either AND or OR
    field is a valid field name for the audience selected
    [evaluator] can be =, <> (not equal), LIKE or IN for text fields and =, !=, >, or < for numeric or date fields

Examples:

  • AND CustomerID = 123456 this sends the campaign's message ONLY to the customer with the id 123456
  • AND CustomerID <> 123456 this sends the campaign's message EVERYONE BUT to the customer with the id 123456
  • AND Email LIKE '%@yahoo.com' this sends the campaign's message to EVERYONE who's email address ends in @Yahoo.com