You are here:
Segmentation Operators in Data 360
For each attribute dragged to the segment canvas from the attribute library, select an operator to modify it and limit records that are selected. The operators that are available depend on the data type of the attribute.
Date
Date operators use your Salesforce org time zone.
| Date Operator | Data Returned |
|---|---|
| Is Anniversary Of | Finds audience members for attributes where the day and month match today's date and month. |
| Is Not Anniversary Of | Finds audience members for attributes where the day and month don’t match today's date and month. |
| Is Today | Finds audience members for attributes where an event occurs between 00:00:00 AM and 23:59:59 PM on today's date. |
| Is Yesterday | Finds audience members for attributes where an event occurred between 00:00:00 AM and 23:59:59 PM on yesterday's date. |
| Is Tomorrow | Finds audience members for attributes where an event occurs between 00:00:00 AM and 23:59:59 PM on tomorrow's date. |
| Is Between | Finds audience members for attributes where an event occurred between 00:00:00 AM on the first date specified and 23:59:59 PM on the last date specified. |
| Is This Month | Finds audience members for attributes where an event occurs in the current calendar month. |
| Is Next Month | Finds audience members for attributes where an event occurs in the next calendar month. |
| Is Last Month | Finds audience members for attributes where an event occurred in the last calendar month. |
| Is On | Finds audience members for attributes where an event occurs on a specified date. |
| Is Before | Finds audience members for attributes where an event occurs before a specified date. |
| Is After | Finds audience members for attributes where an event occurs after a specified date. |
| Last Year | Finds audience members for attributes where an event occurred in the previous calendar year. |
| This Year | Finds audience members for attributes where an event occurs in the current calendar year. |
| Next Year | Finds audience members for attributes where an event occurs in the next calendar year. |
| Last Number Of Days | Finds audience members for attributes where an event occurs in the last number of days until the current day and time. For example, a value of 2 returns events that occurred between February 5, 2020 at 00:00:00 AM and February 7, 2020 at 06:00:00 AM for a segment recounted on February 7, 2020 at 06:00:00 AM. The filter finds all events for February 5, February 6, and until the second that the segment population is recounted on February 7. |
| Greater Than Last Number Of Days | Finds audience members for an attribute where an event occurs before the number of days specified until the beginning of the current day. For example, a value of 7 finds all events that occurred before February 1, 2020 at 00:00:00 AM for a segment recounted at any time on February 8, 2020. |
| Next Number Of Days | Finds audience members for an attribute where an event occurs from the current day and time until the end of the next number of days. For example, a value of 2 returns events that occurred between February 5, 2020 at 06:00:00 AM and February 7, 2020 at 11:59:59 PM for a segment recounted on February 5, 2020 at 06:00:00 AM. The filter finds all events for February 6, February 7, and starting from the second that the segment population is recounted on February 5. |
| Last Number Of Months | Finds audience members for an attribute where an event occurs in the last number of full months. For example, a value of 2 for a segment recounted on March 15, 2020 at 06:00:00 AM returns all events that occurred between January 2020 and February 2020. |
| Next Number Of Months | Finds audience members for an attribute where an event occurs in the next number of full months. For example, a value of 2 for a segment recounted on March 15, 2020 at 06:00:00 AM returns all events from April 2020 and May 2020. |
| Last Number of Years | Finds audience members for an attribute where an event occurs in a calendar year. Enter the number of years to go back to and search for segments for that particular year. This date operator applies only to Calculated Insights. For example, a value of 5 for a segment recounted in 2025 returns all events that occurred between January 2020 and December 2020. |
| Day Of Week | Finds audience members for attributes where an event occurs on the day of the week specified in the filter. |
| Day Of Month | Finds audience members for attributes where an event occurs on the day of the month specified in the filter. |
| Not Day Of Month | Finds audience members for attributes where an event didn’t occur on the day of the month specified in the filter. |
| Month Of The Year | Finds audience members for attributes where an event occurs in the month of the year specified in the filter. |
| Not Month Of The Year | Finds audience members for attributes where an event didn’t occur in the month of the year specified in the filter. |
| Before Day Of Month | Finds audience members for attributes where an event occurs before the day of the month specified in the filter. |
| After Day Of Month | Finds audience members for attributes where an event occurs after the day of the month specified in the filter. |
| Has Value | Finds audience members for attributes where the value is not Null. |
| Has No Value | Finds audience members for attributes where the value is Null. |
Numeric
The percent data type is included within numeric operators. All numeric operators apply to percent.
| Numeric Operator | Data Returned |
|---|---|
| Has Value | Finds audience members for attributes where the value is not Null or Empty. |
| Has No Value | Finds audience members for attributes where the value is Null or Empty. |
| Is Equal To | Finds audience members for attributes with a value equal to a specified value. |
| Is Not Equal To | If a record containing a field with a
Null value is referenced in an Is Not Equal To segment
filter, the record isn’t included in the segment population. To include the record,
configure a filter in the segment to check if the field Has No
Value. Then add the Has No Value and
Is Not Equal To filters within an Or block. |
| Is Less Than | Finds audience members for attributes less than the value specified. |
| Is Less Than or Equal To | Finds audience members for attributes that are less than or equal to the value specified. |
| Is Greater Than | Finds audience members for attributes that are greater than the value specified. |
| Is Greater Than or Equal To | Finds audience members for attributes that are greater than or equal to the value specified. |
| Is Between | Finds audience members for attributes that are between a start and end data. |
| Is Not Between | Finds audience members for attributes that are outside of the range between a start and end date. |
Text
URL, phone, and email are data types included within text operators. All text operators apply to these data types.
| Text Operator | Data Returned |
|---|---|
| Has Value | Finds audience members for attributes where the value is not Null or Empty. |
| Has No Value | Finds audience members for attributes where the value is Null or Empty. |
| Is Equal To | Finds audience members for attributes with a value equal to a specified value. |
| Is Not Equal To | If a record containing a field with a
Null value is referenced in an Is Not Equal To segment
filter, the record isn’t included in the segment population. To include the record,
configure a filter in the segment to check if the field Has No
Value. Then add the Has No Value and
Is Not Equal To filters within an Or block. |
| Contains | Finds audience members for attributes that contain the value specified. This operator ignores null values. |
| Does Not Contain | Finds audience members for attributes that don't contain specified values. This operator ignores null values. |
| Matches | Finds audience members for attributes by using regular operator patterns to sift and match against data. For example, if your attribute contains TestSearch, then the operator matches any data that has the substring TestSearch in it, including TestSearch Results and TestingSearching. |
| Doesn’t Match | Finds audience members for attributes that don’t match a certain regular operator pattern. |
| Begins With | Finds audience members for attributes that begin with a specified value. |
| Exists As A Whole Word | Finds audience members for attributes if the provided parameter exists as a whole word in a statement. It checks whether the text exists as a word (group of chars delimited by word boundaries) in the target field. For example, hello exists as a whole word in hello world but not hel. |
| Is Not In | Finds audience members for attributes that don’t match a set of values. You can select up to 100 values for the Is Not In operator. You can enter comma-separated values such as Product1, Product2, Product3. If Value Suggestion is enabled, you can choose values from the dropdown list. |
| Is In | Finds audience members for attributes that match a set of values. For example,
Gender Is In (F, Female). You can manually enter or paste up to 100 comma-separated
values, such as Product1, Product2,
Product3. If Value Suggestion is enabled, you can choose
values from the dropdown list. You can also use the bulk import option to paste up
to 10,000 comma-separated values. Value Suggestion isn’t available for the bulk
import method. Segments can include only one Is In operator with up
to 10,000 values. |
Boolean
| Boolean Operator | Data Returned |
|---|---|
| Has Value | Finds audience members for attributes where the value is not Null or Empty. |
| Has No Value | Finds audience members for attributes where the value is Null or Empty. |
| Is True | Finds audience members for attributes where the value is not Null or Empty, and the value Is True. |
| Is False | Finds audience members for attributes where the value is not Null or Empty, and the value Is False. |
