Available Operator

Usage Guidelines

Compatible Ambition Field Types

Equals

Use for an exact match.

Specify a single value or multiple values separated with the delimiter ":::".

Filter is case-sensitive.

Email, Dimension, Number, Unique Employee Identifier, Unique Record Identifier

Not Equal To

Use to exclude records that do not match the specific value.

Specify a single value or multiple values separated with the delimiter ":::".

Filter is case-sensitive.

Email, Dimension, Number, Unique Employee Identifier, Unique Record Identifier

Contains

Use to include records that contain the value anywhere in the field.

Specify a single value or multiple values separated with the delimiter ":::".

Filter is case-sensitive.

Email, Dimension, Unique Employee Identifier, Unique Record Identifier

Does Not Contain

Use to exclude records that contain the value anywhere in the field.

Specify a single value or multiple values separated with the delimiter ":::".

Filter is case-sensitive.

Email, Dimension, Unique Employee Identifier, Unique Record Identifier

Regular Expression

Use to match patterns or partial words, whole words, or even multiple words. 

We advise only using if you're familiar with Regular Expression syntax.

Email, Dimension, Unique Employee Identifier, Unique Record Identifier

Is Blank

Use to include records that do not contain any value. 

Within the Metric Builder, no value is needed to be input in the "Value" field when the "Is Blank" operator is used.

Email, Dimension, Date, Date/Time, Number, Unique Employee Identifier, Unique Record Identifier

Is Not Blank

Use to exclude records that do have a value.

Within the Metric Builder, no value is needed to be input in the "Value" field when the "Is Not Blank" operator is used.

Email, Dimension, Date, Date/Time, Number, Unique Employee Identifier, Unique Record Identifier

Starts With

Use to include only records that begin with the value in the filter.

Narrower search then "Contains".

Filter is case-sensitive. 

Email, Dimension, Unique Employee Identifier, Unique Record Identifier

Ends With

Use to include only records that end with the value in the filter.

Narrower search then "Contains".

Filter is case-sensitive.

Email, Dimension, Unique Employee Identifier, Unique Record Identifier

Greater Than

Use to include records that are greater than the specific value.

Specify a single value.

Number

Greater Than or Equal to

Use to include records that are greater than or equal to the specific value.

Specify a single value.

 Number

Less Than

Use to include records that are less than the value you enter.

Specify a single value.

Number

Less Than or Equal to

Use to include records that are less than or equal to the value you enter.

Specify a single value.

Number