Attributes for Profile data filters
Profile data filters are filters created from Lists and Profile Extensions.
Profile data filter attributes
List attributes
These include all system-defined fields, as well as any custom-defined fields in your list. For a list of system-defined fields, see System-Defined List Fields.
Profile Extension attributes
These include all fields in all of the Profile Extension tables associated with the List.
Tips for creating filter conditions
When specifying filter conditions, keep in mind the following:
- To create the filter, drag and drop the table from the Profile column to the Profile Attributes region.
- Each Profile Data filter can have up to ten conditions.
- The "does not contain" condition applies only to records that contain a value, not for records with a null value. This means that your result set will include records that contain any value except the specified one, but not records with no values. For example, the rule “State does not contain California" will include records in New York, Pennsylvania, and Texas, but not records in California nor ones that contain no value. To include empty records as well, add OR "State" - "is null” to the rule.
- "By Date" condition date fields are all initially set to the current date. The “Between” condition includes the first and last dates of the defined date range. By default, both fields are set to the current date.
Note: SQL queries using the BETWEEN condition do not include the final day in a date range. To ensure consistency, add a + 1 to the SQL end date.