Conditions – Numbers
For numerical values, you can set ranges, eg, between 1 and 3 or between 500 and 1500.
- This works for the number of received emails, SMS, numbers of clicks, and even days or months (see below for more news about dates).
- The “different from” condition allows you to make sure that the parameter does not equal the number you entered.
Conditions – Text
You can select one or more elements from the list and remove them by clicking the “X” by each element. When matching identifiers, you are also offered a unique set of operators:
- “At least one” will include all items for which the value is not empty (contains one or more identifiers).
- “Matches” and “matches at least” work with lists of elements, like memberships.
- “Matches” will include only those elements (contacts, products, etc.) for which the parameter matches your selected values.
- Whereas “matches at least” will include all of these plus those that also match other values.
The search for a text value is case-sensitive.
This will only match contacts named “Donald” and not the ones named “donald”. So you should use two conditions if you are looking for both values.
For some parameters, you can refer to specific dates in the future.
These conditions are currently limited to a few selected conditions (most regarding loyalty program values).
Using the correct date format
Keep in mind two aspects when you wish to segment using a date:
- If you are comparing dates (for instance, emails opened within X and Y), use the YYYY-MM-DD date format.
- If you are using dates from your database (eg, birthday segment), input the exact same date format as your database. For instance, if your birthday fields were input as DD-MM-YY, you need to use the same format (ex: 15-12-83, not 83-12-15). This is important if you’re planning to use the date variables.
Using date variables
When using conditions on dates, you can use variables to dynamically select the current day’s date, as used in the birthday filter example below.
- $day$ => current day
- $month$ => current month
- $year$ => current year
Remember that, for custom database fields, you need to use the exact format you entered. If your database dates use the format DD-MM-YYYY and want to use the variables, enter --. If you use the format YYYY/MM/DD, use //.
For all types of events, Splio allows you to select a time range.
If you need to find all contacts who clicked on a link when the promotional offer was in force, you can use the following condition using two fixed dates:
The date range doesn’t include the last day. In the example above, the filter does not include the 1st of October.
Alternatively, if for instance, you need to send a survey to everybody between 30 and 60 days ago since they signed up for your newsletter, you may find the following condition interesting: