Data Filter Definition
You create a data filter definition on the Subscribers tab. You choose whether to create a filter that segments a subscriber list or a data extension.
If you choose to create a data filter to segment a subscriber list, you can use any combination of the following types of information to determine whether the subscriber satisfies the conditions:
- Profile attributes
- Preference attributes (except the HTML email preference)
- Measures you create and predefined measures
You do not have to specify a subscriber list in the filter definition. You can associate the same data filter to multiple different lists using different filter activities or groups.
If you choose to create a data filter to segment a data extension, you use the attribute columns in the data extension to determine whether the record satisfies the conditions. Because different data extensions can have different attribute columns, you must specify the data extension to segment when you create the data filter.
When you create a filter, you create conditions that the system evaluates each subscriber or data extension row against to determine if it qualifies for the segment. For each condition, you select:
- The profile attribute, attribute column, or measure to evaluate
- The operator to use to compare the values (See Appendix: Logical Operators.)
- The value to compare against
For example, you might create a condition where:
- The profile attribute is AGE
- The operator is IS GREATER THAN
- The value is 17
When you segment a subscriber list against this condition, only subscribers whose age is 18 or older will satisfy the condition and be added to the segment.
You can put multiple conditions together in a grouping using an AND or OR operator. You can also put multiple groupings together into an outer grouping that uses an AND or OR operator. When you use the OR operator, a subscriber or row that meets one or more of the conditions satisfies the grouping. When you use the AND operator, a subscriber or row must meet all of the conditions to satisfy the grouping.
The data filter creation interface provides graphical tools for creating the conditions and groupings. The SQL created using the graphical tools appears on the screen in the Filter Text section for your reference.