Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


...

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.


OperatorDescription
equal toInclude profiles that are exactly equal to the selected value.
not equal toInclude profiles that are not equal to the selected value.
greater thanMatch all profiles that are greater than
or equal toless thanless than
the specified value.
greater than or equal to
containsstarts withends withregexnot regexis betweendoes not containdoes not start withdoes not end withis one ofis not one ofis not betweenexists

...

Match all profiles that are greater or equal to the selected value.
less thanMatch all profiles that are less than the selected value.
less than or equal toMatch all profiles that are less than or equal to the selected value.
containsMatch all profiles that contain the selected value.
starts withMatch all profiles that begin with the selected value.
ends withMatch all profiles that end with the selected value.
regexMatch all profiles based on a regular expressions pattern (regex).
not regexExclude all profiles based on a regular expressions pattern (regex).
is betweenMatch all profiles between two provided values.
does not containMatch all profiles that do not contain the selected value.
does not start withMatch all profiles that do not begin with the selected value.
does not end withMatch all profiles that do not end with the selected value.
is one ofMatch all profiles that contain one of the selected values.
is not one ofMatch all profiles that do not contain one of the selected values.
is not betweenMatch all profiles that do not contain values that are between the selected values.
existsMatch all profiles where the selected attribute exists.
does not existMatch all profiles where the attribute does not exist.
does not exist or greater thanMatch all profiles where the attribute does not exist or is greater than a certain value.
does not exist or greater than or equal toMatch all profiles where the attribute does not exist or is greater than or equal to a certain value.
does not exist or less thanMatch all profiles where the attribute does not exist or is less than a certain value.
does not exist or less than or equal toMatch 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.

...