...
| Info |
|---|
This article supports Audience Studio - Legacy. |
Review the following operator information to help you create accurate SQL code for your segment attribute conditions. You can sort the Operator or Description column by selecting the column heading.
| Operator | Description |
|---|---|
| equal to | Include profiles that are exactly equal to the selected value. |
| not equal to | Include profiles that are not equal to the selected value. |
| greater than | Match all profiles that are greater than |
| the specified value. | |
| greater than or equal to | Match all profiles that are greater or equal to the selected value. |
| less than | Match all profiles that are less than the selected value. |
| less than or equal to | Match all profiles that are less than or equal to the selected value. |
| contains | Match all profiles that contain the selected value. |
| starts with | Match all profiles that begin with the selected value. |
| ends with |
...
| Match all profiles that end with the selected value. | |
| regex | Match all profiles based on a regular expressions pattern (regex). |
| not regex | Exclude all profiles based on a regular expressions pattern (regex). |
| is between | Match all profiles between two provided values. |
| does not contain | Match all profiles that do not contain the selected value. |
| does not start with | Match all profiles that do not begin with the selected value. |
| does not end with | Match all profiles that do not end with the selected value. |
| is one of | Match all profiles that contain one of the selected values. |
| is not one of | Match all profiles that do not contain one of the selected values. |
| is not between | Match all profiles that do not contain values that are between the selected values. |
| exists | Match all profiles where the selected attribute exists. |
| does not exist | Match all profiles where the attribute does not exist. |
| does not exist or greater than | Match all profiles where the attribute does not exist or is greater than a certain value. |
| does not exist or greater than or equal to | Match all profiles where the attribute does not exist or is greater than or equal to a certain value. |
| does not exist or less than | Match all profiles where the attribute does not exist or is less than a certain value. |
| does not exist or less than or equal to | Match all profiles where the attribute does not exist or is equal to a certain value. |
equal to
Use the equal to operator to include profiles that are exactly equal to the selected value.
...
Use the in between operator to not match all profiles between to two provided values.
Example
Match all profiles with a likely_to_shop score between 10 and 20.
...