Operators are functions that can be performed on numbers, dates, and strings. They can be used for aggregations and logic building. Operators are commonly found in smart filters as well as while building custom dimensions. Below are the various types of operators with descriptions.
While adding custom dimensions, the drop-down list of operators changes based on the data type of the standard dimension that is being used to construct the logic for the custom dimension. For example, if you pick the standard dimension to be ‘Lead Age’, then the operator dropdown next to it will only show the number operators.
String Operators
Operator | Description | Case-sensitive (Yes/No) | Return Value Type |
|---|---|---|---|
Contains | Check if a string contains a particular letter, word, phrase, or sub-string | Yes | Boolean |
Does not contain | Check if a string does not contain a particular letter, word, phrase, or sub-string | Yes | Boolean |
Start with | Check if a string starts with a particular letter, word, phrase, or sub-string | Yes | Boolean |
End with | Check if a string ends with a particular letter, word, phrase, or sub-string | Yes | Boolean |
Like | Check if a specified string exists | Yes | Boolean |
Not like | Check if a specified string does not | Yes | Boolean |
Concatenate | Concatenates/combines two strings | Yes | String |
Is | Compare two strings and return TRUE if they are exactly the same, else, return FALSE | Yes | Boolean |
Is not | Compare two strings and return TRUE if they are not the same, else, return FALSE | Yes | Boolean |
In | Check if a string is present among a list of values | Yes | Boolean |
Not In | Check if a string is not present among a list of values | Yes | Boolean |
Number Operators
Operator | Description | Return Value Type |
|---|---|---|
Addition (+) | Add a number/numerical dimension to another number/numerical dimension | Number |
Subtraction (-) | Subtract a number/numerical dimension from another number/numerical dimension | Number |
Multiplication (*) | Multiply a number/numerical dimension by another number/numerical dimension | Number |
Division (/) | Divide a number/numerical dimension by another number/numerical dimension | Float |
Greater than (>) | Compare if a number/numerical dimension is greater than another number/numerical dimension, if so, return TRUE | Boolean |
Less than (<) | Compare if a number/numerical dimension is less than another number/numerical dimension | Boolean |
Equal to (=) | Compare if a number/numerical dimension is equal to another number/numerical dimension | Boolean |
Not equal to (≠) | Compare if a number/numerical dimension is not equal to another number/numerical dimension | Boolean |
Less than or equal to (<=) | Compare if a number/numerical dimension is less than or equal to another number/numerical dimension | Boolean |
Greater than or equal to (>=) | Compare if a number/numerical dimension is greater than or equal to another number/numerical dimension | Boolean |
Number between | Check if a number/numerical dimension is between two other numbers/numerical dimensions (including the start and stop numbers) | Boolean |
In | Check if a number/numerical dimension is among a list of values | Boolean |
Not in | Check if a number/numerical dimension is not among a list of values | Boolean |
Is positive | Check if a number/numerical dimension is positive (greater than 0) | Boolean |
Is negative | Check if a number/numerical dimension is negative (less than 0) | Boolean |
Date Operators
Operator | Description | Return Value Type |
|---|---|---|
Before | Check if a date is before (less than) another date | Boolean |
After | Check if a date is after (greater than) another date | Boolean |
On | Check if a date is the same (equal to) as another date | Boolean |
Not on | Check if a date is the not same (not equal to) as another date | Boolean |
Date between | Check if a date lies between two dates, including the start and end dates | Boolean |
Logic Operators
Operator | Description | Return Value Type |
|---|---|---|
And | Use the AND operation on 2 operands. You can add more AND conditions if there are more than 2 operands. | Boolean |
Or | Use the OR operation on 2 operands. You can add more OR conditions if there are more than 2 operands. | Boolean |
If | Use this operator to check if a condition is TRUE and only then process the block | Boolean |
Else if | If a prior condition is false, then use this operator to check if another condition is TRUE and only then process the block. This has to be preceded by at least one IF condition. | Boolean |
Else | If the prior IF or ELSE IF conditions are false, then use this operator to process the block. This has to be preceded by at least one IF condition. | Boolean |
General Operators
Operator | Description | Return Value Type |
|---|---|---|
Is Empty | Check if the attribute is empty (doesn’t contain any value) | Boolean |
Is not empty | Check if the attribute is not empty (contain at least one value) | Boolean |
Is null | Check if the attribute value is NULL | Boolean |
Is not null | Check if the attribute value is not NULL | Boolean |