Operators in Segmentation

There are standard data types that are supported in Rev.Up. These data types have implications for how you are able to segment data. The following data types are supported in Rev.Up: 

• Text 
• ID
• Number 
• Integer
• Date 
• Boolean 

Operators for Date Fields: 

• Ever: Used to create a segment to include records where an event took place at any time. 
• Latest Day: Used to create a segment to include records where an event took place on the most recent date that data was loaded to the tenant. 
• Current: Used to create a segment to include records where an event took place in the current period. The current time period. Periods are defined as the calendar week, month, quarter or year. 
• Previous: Used to create a segment to include records where an event took place in the previous period. Periods are defined as the calendar week, month, quarter or year. 
• Last: Used to create a segment to include records where an event took place in the previous days As an example, this operator can be used to build a audience that has filled out a form within the last 1 day. 
• Between Last:  Used to create a segment to include records where an event took place between two periods in the past. Periods are defined as the calendar day, week, month, quarter or year. 
• Between Next: Used to create a segment to include records where an event took place between two periods in the future. Periods are defined as the calendar day, week, month, quarter or year. 
• Between: Used to create a segment to include records where an event took place between two specific dates
• Before Last: Used to create a segment to include records where an event took place before the last period. Periods are defined as the calendar day, week, month, quarter or year. 
• Before: Used to create a segment to include records where an event took place before a specific date. 
• After: Used to create a segment to include records where an event took place after a specific date. 
• After Next: Used to create a segment to include records where an event took place after a specific period. Periods are defined as the calendar day, week, month, quarter or year. 
• Is Empty: Used to create a segment where the value is NULL or empty. 

Operators for Text Fields: 

• Equal to: Is exactly equal to the value entered. 
• Not Equal to: Is not equal to the value entered.
• Starts with: Starts with the value entered. 
• Ends with: Ends with the value entered.
• Contains: Contains in some part of the string the value entered. 
• Does not contain: Does not contain in some part of the string the value entered. Does not include records in the segment where the value is NULL or empty. 
• Is empty: Used to create a segment where the value is NULL or empty. 
• Is present: Used to create a segment where there is a value that is not NULL. 

Operators for Number/Integer Fields: 

• Equal to: Is exactly equal to the value entered. 
• Not equal to: Is not equal to the value entered.
• Greater than: A number greater than the value entered. 
• Greater than or equal to: A number greater than or equal to the value entered. 
• less than: A number less than the value entered. 
• less than or equal to: A number less than or equal to the value entered. 
• between (value1, value 2): A number that is between two values. A number that is between two values. '(' at the beginning or end means that it is not inclusive of the end value. '[' at the beginning or end means it is inclusive of the value.
• between [value1, value2): A number that is between two values. A number that is between two values. '(' at the beginning or end means that it is not inclusive of the end value. 
• between (value1, value 2]: A number that is between two values. '(' at the beginning or end means that it is not inclusive of the end value. '[' at the beginning or end means it is inclusive of the value.
• between [value1, value2): A number that is between two values. A number that is between two values. '(' at the beginning or end means that it is not inclusive of the end value. '[' at the beginning or end means it is inclusive of the value.
• Is empty: Used to create a segment where the value is NULL or empty. 
• Is present: Used to create a segment where there is a value that is not NULL. 

Operators for Boolean Fields: 

• True: The value is True, 1 or Yes. 
• False: The value is False, 0 or No. 
• Is empty: Used to create a segment where the value is NULL or empty. 
• Is present: Used to create a segment where there is a value that is not NULL.