The operator is used to indicate how the field is connected to the value, that is in which condition the value will be searched.
Operators are used to search contacts, or to create groups of contacts.
Following are the most common operators used, based on the type of data.
|Text and Email Field||Date and Numeric Field||True/False Field|
|Is equal||Is equal||Is true (or 1)|
|Is not equal||Is not equal||Is false (or 0)|
|Contains||Is less (smaller) then|
|Doesn't contain||Is less (smaller) then or equal|
|Starts with||Is greater (larger) than|
|Doesn't start with||Is greater (larger) than or equal|
|Ends with||Is between|
|Doesn't end with||Is not between|
|Is like||Is empty|
|Is not like||Is not empty|
|Is empty||Is in|
|Is not empty||Is not in|
|Is not in|
Operator: Is greater than
Operator: Is true
Operators used to calculate contacts at the time it is used, and not when the group or search criteria are created
These operatros are very useful as they allow you to calculate the number of corresponding contacts each time the group or search is executed, thus based on a relative date. For example, if you use a criteria with such an operator in a automated marketing scenario, eligible contacts will be recalulcuted each time the scenario is launched.
|Operators based on the use date||Example|
|in the last ...||To target all contacts who have subscribed in the last 6 months.|
|exactly ... ago||To target contacts who have renewed their subscription 15 days ago. (To send them a thank you message.)|
|in the next ...||To target contacts whose birthday is next month.(To send them an invite to a special event.)|
|in exactly ...||To target contacts who subscription expires in exactly 30 days. (To send them a renewal reminder.)|
|between ...||To target contacts between 18 and 25 years old.|
|not between ...||To target contacts older than 18 years old.|