Equals | The value on the contact record exactly matches the filter value. | - |
Not Equal | The value on the contact record is any value that does not match the filter value. | - |
After* | The value on the contact record is after the date or time frame in the filter value. After selecting this operator, you must select and configure one of the following date options: - Absolute: Select this option to specify an exact date.
- Relative: Select this option to specify the number of days, months, or years. This value is relative to the date and time when the segment is built or rebuilt. For more information, see Important considerations for segment building.
| - If the absolute date is set to 2024-06-12, all contacts with field value greater than June 12, 2024 are added to the segment.
- If the relative value is set to 1 day and the segment built or rebuilt date is June 12, 2024 08:30 AM, all contacts with field value greater than June 14, 2024 08:30 AM are added to the segment.
|
After (Including day)* | The value on the contact record is on or after the date or time frame in the filter value. - Absolute: Select this option to specify an exact date.
- Relative: Select this option to specify the number of days, months, or years. This value is relative to the date and time when the segment is built or rebuilt. For more information, see Important considerations for segment building.
| - If the absolute date is set to 2024-06-12, all contacts with field value greater than or equals to June 12, 2024 are added to the segment.
- If the relative value is set to 1 month and the segment built or rebuilt date is June 12, 2024 11:00 AM, all contacts with field value greater than or equals to July 12, 2024 11:00 AM are added to the segment.
|
Before* | The value on the contact record is before the date or time frame in the filter value. - Absolute: Select this option to specify an exact date.
- Relative: Select this option to specify the number of days, months, or years. This value is relative to the date and time when the segment is built or rebuilt. For more information, see Important considerations for segment building.
| - If the absolute date is set to 2024-06-12, all contacts with field value less than June 12, 2024 are added to the segment.
- If the relative value is set to 1 day and the segment built or rebuilt date is June 12, 2024 08:30 AM, all contacts with field value less than June 10, 2024 08:30 AM are added to the segment.
|
Before (Including day)* | The value on the contact record is on or before the date or time frame in the filter value. - Absolute: Select this option to specify an exact date.
- Relative: Select this option to specify the number of days, months, or years. This value is relative to the date and time when the segment is built or rebuilt. For more information, see Important considerations for segment building.
| - If the absolute date is set to 2024-06-12, all contacts with field value less than or equals to June 12, 2024 are added to the segment.
- If the relative value is set to 1 month and the segment built or rebuilt date is June 12, 2024 11:00 AM, all contacts with field value less than or equals to May 12, 2024 11:00 AM are added to the segment.
|
Empty | No value exists in the field on the contact record. | - |
Not empty | A value exists in the field on the contact record. | - |
Like | This operator is not supported in date or datetime fields, and must not be used. | - |
Not like | This operator is not supported in date or datetime fields, and must not be used. | - |
Regexp | The value on the contact record matches the specified regular expression pattern. If you are not proficient with regular expression, do not use this operator. | - |
Not regexp | The value on the contact record does not match the specified regular expression pattern. If you are not proficient with regular expressions, do not use this operator. | - |
Starts with | The value on the contact record begins with the specified number in the filter value. These filter values should generally reference years, or years and months. | A value of 19 matches any contacts whose field value has a year in the 1900s. A value of 200 matches contacts with a year value between 2000 and 2009 and a value of 2020-11 matches contacts with a field value in November 2020. |
Ends with | The value on the contact record match ends with the specified number in the filter value. These filter values should generally reference days, or months and days. | A value of 1 matches anyone whose field value is on the 1st, 11th, 21st, or 31st of any month but a value of 01 matches the 1st of a month. A value of 01-01 finds contacts whose value is for January 1 of any year. |
Contains | The value on the contact record contains the specified content in the filter value. Acquia does not recommend using this operator because there are very few use cases for this data apart from potentially finding a somewhat random subset of contacts (without using Randomizer). | - |
In the last* | The value on the contact record is between the current date and the last X days, months, or years. Here, X is the number specified in the filter value. This value is relative to the date and time when the segment is built or rebuilt. For more information, see Important considerations for segment building. | If the value is set to 10 days and the segment built or rebuilt date is June 12, 2024, all contacts with field value between June 02, 2024 00:00:00 and June 12, 2024 23:59:59 are added to the segment. |
In the next* | The value on the contact record is between the current date and the next X days, months, or years. Here, X is the number specified in the filter value. This value is relative to the date and time when the segment is built or rebuilt. For more information, see Important considerations for segment building. | If the value is set to 10 days and the segment built or rebuilt date is June 12, 2024, all contacts with field value between June 12, 2024 00:00:00 and June 22, 2024 23:59:59 are added to the segment. |
Between* | The value on the contact record is between the range specified in the filter value. This operator includes the start and end date in the range. Depending on the filter type, it can be a date range or a numeric range. | - |
Not between* | The value on the contact record is not between the range specified in the filter value. This operator includes the start and end date in the range. Depending on the filter type, it can be a date range or a numeric range. | - |
* The Campaign Studio user interface is updated to rename these operators in July, 2024. For segments that were created prior to this update, Campaign Studio will display the updated name but will keep the values unchanged. For example, the relative values used previously will be displayed as absolute values until the filter is edited. |