Table of Contents
Breakdown of Operators
When adding a search field, there is an operator to show the relationship between the search field and the value: the search field must equal the value, be less than the value, greater than the value, etc.
There are some fields that these operators do not apply to. For example, Greater Than cannot be applied to a field like "City", as there is no Greater or Lesser Than version of a city name.
- Equals: If the field matches this value, it will appear in the results.
Leave the value field blank to search for profiles where this field is blank.
- Not Equal: If the field does NOT match this value, it will appear in the results.
- Greater Than: If the field is greater than this value, it will appear in the results.
- Less Than: If the field is less than this value, it will appear in the results.
- Contains: If the field contains this value, it will appear in the results.
- Does Not Contain: If the field does NOT contain this value, it will appear in the results.
-
In the Period: For date-related fields, this operator will look at the value, and if it matches the date of the selected period (see list below), it will appear in the results.
- Last 1 Day: The search field will show profiles or records if the chosen date field has a value that falls on yesterday or today.
- Last 7 Days: The search field will show profiles or records if the chosen date field has a value that falls on any day from 7 days ago through today.
- Last 30 Days: The search field will show profiles or records if the chosen date field has a value that falls on any day from 30 days ago through today.
- Month To Date: The search field will show profiles or records if the chosen date field has a value that falls on the first day of the month through the current date.
- Year To Date: The search field will show profiles or records if the chosen date field has a value that falls on any day from the January 1 of this year through the current date.
- Next 7 Days: The search field will show profiles or records if the chosen date field has a value that falls on any day from today through 7 days later.
- Next 30 Days: The search field will show profiles or records if the chosen date field has a value that falls on any day from today through 30 days later.
- Next 60 Days: The search field will show profiles or records if the chosen date field has a value that falls on any day from today through 60 days later.
- Day in the Future: For date-related fields, this operator will look at the value (x) and if the date field has a value that is x days into the future, it will be included in the results. If the value is 30 then it will look for profiles where this date is 30 days from today (today is not included in that calculation).
- Days Ago: For date-related fields, this operator will look at the value (x) and if the date field has a value that is x days in the past, it will be included in the results. If the value is 30 then it will look for profiles where this date is 30 days before today (today is not included in that calculation).
- Between: For date-related fields, this operator will look at the values (x and y) and if the date field has a value that is in between x and y, it will be included in the results. If the values are 1/1/2024 and 3/31/2024 then it will look for profiles where this date is on or between those dates.
Day in the Future and Days Ago are especially helpful when selecting profiles for recurring e-mails.
Multiple Search Fields
If using more than one search field, an AND/OR drop down will appear between rows:
In the example above, it would return profiles that are members AND that are in the city of Dallas.
To also include profiles that are in Austin, it would need to be defined like the example below:
The below example will not work to pull member profiles that are from Dallas OR Austin.
it would return profiles that are members and that are in the city of Dallas AND Austin, instead of Dallas Or Austin.
The example below would also not work because it would return profiles that are members AND in the city of Dallas, OR any profile (member or not) in the city of Austin.
When choosing OR, it establishes a new parameter group. It starts over, so it doesn't see the first row (Member = True). The OR row is technically the first row of the new parameter group.
The example below is the correct setup. It would return profiles that are members, AND in the city of Dallas, OR profiles that are members, AND in the city of Austin.