You are here:
Activation Filter Operators
Use filter operators to refine the data payload sent to your activation targets. When defining activation filters, you can apply these operators to specific attributes to ensure only the most relevant data triggers an update in your downstream systems.
Text Operators
These operators are available for attributes with a text data type.
| Operator | Description | Example |
|---|---|---|
| Is Changed | Checks if the value of the attribute has changed on the event being evaluated. If the value remains the same, the record is filtered out. | Attribute: Loyalty_Status Value: Is Changed |
| No Value | Matches records where the attribute is null or empty. | Attribute: Email_Address Value: No Value |
| Has Value | Matches records where the attribute isn’t null or empty. | Attribute: Phone_Number Value: Has Value |
| Equal | Matches records where the attribute exactly matches the specified value. | Attribute: Gender Value: ‘Female’ |
| Not Equal | Matches records where the attribute doesn’t match the specified value. | Attribute: Region Value: ‘North’ |
| Contains | Matches records where the attribute contains the specified string. This operator ignores null values. | Attribute: Job_Title Value: ‘Manager’ |
| Does Not Contain | Matches records where the attribute doesn’t contain the specified string. This operator ignores null values. | Attribute: Email Value: ‘test’ |
| Begins With | Matches records where the attribute starts with the specified characters. | Attribute: Postal Code Value: ‘94’ |
| Ends With | Matches records where the attribute ends with the specified characters. | Attribute: Email Value: ‘.org’ |
| Exists As A Whole Word | Matches records where the specified string exists as a distinct word within the attribute. | Attribute: Description Value: ‘urgent’ |
| Matches | Matches records based on a specified pattern (often used for wildcards or specific formatting). | Attribute: SKU Value: ‘AB-????’ |
| Does not Match | Matches records that don’t follow the specified pattern. | Attribute: SKU Value: ‘X-????’ |
| In | Matches records where the attribute matches one of the values in a provided list. | Attribute: State Value: ‘CA, NY, TX’ |
| Not In | Matches records where the attribute doesn’t match any value in a provided list. | Attribute: Status Value: ‘Inactive, Suspended’ |
Number Operators
These operators are available for attributes with a Number data type.
| Operator | Description | Example |
|---|---|---|
| No Value | Matches records where the value is null. | Attribute: Credit_Score Value: No Value |
| Has Value | Matches records where the value isn’t null. | Attribute: Phone_Number Value: Has Value |
| Equal | Matches records where the value equals the specified number. | Attribute: Age Value: 25 |
| Not Equal | Matches records where the value doesn’t equal the specified number. | Attribute: Items_in_Cart Value: 0 |
| Less Than | Matches records where the value is smaller than the specified number. | Attribute: Inventory_Count Value: 30 |
| Less Than or Equal | Matches records where the value is smaller than or equal to the specified number. | Attribute: Order_Total Value: 50.00 |
| Greater Than | Matches records where the value is larger than the specified number. | Attribute: Lifetime_Value Value: 1000 |
| Greater Than or Equal | Matches records where the value is larger than or equal to the specified number. | Attribute: Loyalty_Points Value: 500 |
| Between | Matches records where the value falls between two specified numbers (inclusive). | Attribute: Age Value: 18, 35 |
| Not Between | Matches records where the value falls outside two specified numbers. | Attribute: Risk_Score Value: 1, 5 |
Date and Timestamp Operators
These operators are available for Date and Timestamp (Date/Time) data types.
| Operator | Description | Example |
|---|---|---|
| No Value | Matches records where the date is null. | Attribute: Expiry_Date Value: No Value |
| Has Value | Matches records where the date isn’t null. | Attribute: Activation_Date Value: Has Value |
| Anniversary Of | Matches records where the month and day match the current date, regardless of year. | Attribute: Birthdate Value: Anniversary Of |
| Not Anniversary Of | Matches records where the month and day don’t match the current date. | Attribute: Join_Date Value: Not Anniversary Of |
| Equal | Matches records on a specific date. | Attribute: Event_Date Value: 2025-01-01 |
| Before | Matches records before a specific date. | Attribute: Created_Date Value: 2024-01-01 |
| After | Matches records after a specific date. | Attribute: Last_Modified Value: 2025-06-01 |
| Equal or Before | Matches records on or before a specific date. | Attribute: Due_Date Value: 2025-12-31 |
| Equal or After | Matches records on or after a specific date. | Attribute: Start_Date Value: 2025-01-01 |
| Between | Matches records falling between two specific dates. | Attribute: Promo_Period Value: 2025-01-01, 2025-01-31 |
| Not Between | Matches records falling outside two specific dates. | Attribute: Blackout_Dates Value: 2025-12-20, 2025-12-31 |
Relative to Now Filters
Use these operators to filter dates relative to the moment that the activation runs. These are useful for rolling windows (for example, "users active in the last 30 days").
| Operator | Description | Example |
|---|---|---|
| In the next N days | Matches dates occurring within the next specified number of days. | Attribute: Renewal_Date Value: 30 |
| In the last N days | Matches dates that occurred within the past specified number of days. | Attribute: Last_Purchase Value: 90 |
| In the next N months | Matches dates occurring within the next specified number of months. | Attribute: Target_Date Value: 3 |
| In the last N months | Matches dates that occurred within the past specified number of months. | Attribute: Last_Login Value: 6 |
| In the next N years | Matches dates occurring within the next specified number of years. | Attribute: Maturity_Date Value: 1 |
| In the last N years | Matches dates that occurred within the past specified number of years. | Attribute: Join_Date Value: 5 |
| Before the last N days | Matches dates that occurred before a rolling window of days. | Attribute: Last_Contact Value: 180 (Filters for users not contacted in over 6 months) |
