Work with filters create-filters
Data filtering is the process of narrowing down a dataset to only those records that match specific criteria. This subset can then be used for targeted actions (such as updates or audience creation) or for analysis.
When browsing Campaign, data is displayed in lists. You can apply built-in filters to quickly access a defined subset, such as quarantined addresses, untargeted recipients, or records within a specific age range or creation date.
In addition, you can create custom filters, save them for future use, and share them with other Campaign users.
Filters are applied dynamically: whenever the data changes, the filtered results are automatically updated.
The following types of filter are available in Adobe Campaign:
Predefined filters predefined-filters
Predefined filters in the dashboards
By default, Adobe Campaign displays all database records that the operator has permission to read. You can filter this data using the options available in the upper section of the browser window.
There are several ways of filtering the data to be displayed. If necessary, these can be used together. Browse the tabs below to learn more about filtering options.
To filter data based on their folder, click the Folder icon and select the folder containing the data to display.
Only the profiles in the folder are displayed:
Use the cross to the right of the folder selection field to return to the default display mode.
Depending on the type of information displayed, you can apply a filter by status or by state.
For example for deliveries, you can choose to display only finished deliveries as shown below:
You can select the sorting order of the data offered on pages via the drop-down list to the right of the ‘per folder’ filtering field. The content of this field depends on the type of data on the page.
For example, you can sort tasks by priority, creation date, or alphabetical order.
Use the search field to quickly access the item you are looking for: enter the characters included in the label or internal name of the item you want to display, then confirm to apply an automatic filter to the data on the page.
To display all items again, click on the cross to delete the content of the search field.
Predefined filters in the Explorer
Predefined filters are available from the Filters button above each list.
For example, for the profiles, the following built-in filters are available:
You can access the filters details in the Profiles and Targets > Pre-defined filters node of the Explorer.
Select a filter to display its definition.
Use the last tab to preview the filtered data.
| table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 7-row-2 8-row-2 9-row-2 10-row-2 11-row-2 12-row-2 13-row-2 14-row-2 15-row-2 16-row-2 17-row-2 18-row-2 19-row-2 20-row-2 21-row-2 22-row-2 23-row-2 24-row-2 html-authored no-header | |
|---|---|
| Label | Query |
| Opened | Selects recipients who have opened a delivery. |
| Opened but not clicked | Selects recipients who have opened a delivery but have not clicked on a link. |
| Inactive recipients | Selects recipients who have not opened a delivery in X months. |
| Last activity by device type | Selects recipients who have clicked or opened delivery Y using device X in the last Z days. |
| Last activity by device type (Tracking) | Selects recipients who have clicked or opened delivery Y using device X in the last Z days. |
| Untargeted recipients | Selects recipients who have never been targeted via channel Y in X months. |
| Very active recipients | Selects recipients who have clicked in a delivery at least X times in the last Y months. |
| Denylisted email address | Selects recipients whose email address is on the denylist. |
| Quarantined email address | Selects recipients whose email address is quarantined. |
| Email addresses duplicated in the folder | Selects recipients whose email address is duplicated in the folder. |
| Neither opened nor clicked | Selects recipients who have not opened a delivery, or clicked in a delivery. |
| New recipients (days) | Selects recipients that were created in the last X days. |
| New recipients (minutes) | Selects recipients that were created in the last X minutes. |
| New recipients (months) | Selects recipients that were created in the last X months. |
| By subscription | Selects recipients by subscription. |
| By clicking on a specific link | Selects recipients who clicked on a particular URL in a delivery. |
| By post delivery behavior | Selects recipients according to their behavior after receiving a delivery. |
| By creation date | Selects recipients by creation date, over a period ranging from X months (current date minus n months) to Y months (current date minus n months). |
| By list | Selects recipients by list. |
| By number of clicks | Selects recipients who clicked in a delivery in the last X months. |
| By number of messages received | Selects recipients according to the number of messages that they received. |
| By number of opens | Selects recipients who opened between X and Y deliveries over Z amount of time. |
| By name or email | Selects recipients according to their name or email. |
| By age range | Selects recipients according to their age. |
Default filters default-filters
The fields above each list lets you use the predefined default filter for this list. For the recipient list, you can filter on the name and email address by default.
%@gmail.com in the Email field to display all the profiles with a Gmail address. Enter %@L in the Last name field to display all the profiles with a L in their last name.To change the default filter for a recipient list, browse to the Profiles and Targets > Predefined filters node.
For all other types of data, configure the default filter via the Administration > Configuration > Predefined filters node.
Apply the following steps:
-
Select the filter you want to be used by default.
-
Click the Parameters tab and select Default filter for the associated document type.
-
Uncheck that same option for the current default predefined filter.
-
Click Save to apply the filter.
-
Browse to the Recipient folder and click the Remove this filter icon on the right of the current filter: the new default filter is available.
Quick filters quick-filters
You can set and combine Quick filters to build custom filters on specific fields.
Once added, quick filter fields are displayed above the data list, one after the other. They can be deleted independently of each other.
Quick filters are specific to each operator and are re-initialized each time the operator clears the cache of their Client Console.
If you need to reuse a filter, create an advanced filter and save it. Learn more.
To create a quick filter, follow these steps:
-
Right-click the field you want to filter and select Filter on this field.
The default filter fields are displayed above the list.
-
Select the filter options.
-
If needed, use the grey icon on the right side of a filter to remove it.
-
You can combine filters to refine your filter.
If you need to filter on a field which is not available in the form, but in the columns, and filter on that column. To do this,
-
Click the Configure list icon.
-
Select the column to display, for example the age of the recipients, and click Ok.
-
Right-click the Age column in the recipient list, and select Filter on this column.
You can then select the age filtering options. Add another filter on the age to define a range.
Advanced filters advanced-filters
Combine complex criteria in custom Advanced filters. Use these filters to create a complex query or a combination of queries on your data. These filters can be saved and shared with other Campaign users.
Create an advanced filter create-adv-filters
To create an advanced filter, click the Filters button and select Advanced filter….
You can also right-click the list of data and select Advanced filter….
Define the filtering conditions. In the example below, you will filter on recipients whose Account number does not start with NL, and who live in Paris or Los Angeles.
-
Click the Edit expression icon of the Expression column.
-
Select the field to filter on.
-
Select the operator to be applied from the drop-down list.
-
Select an expected value from the Value column. You can combine several filters to refine your query. To add a filter condition, click Add.
note note NOTE You can assign a hierarchy to the expressions or change the order of the query expressions using the toolbar arrows. -
Three operators are available to combine expressions: And, Or, Except. Click the arrow to switch to Or.
-
Click Ok to create the filter and apply it to the current list.
The filter applied is displayed above the list.
To edit or modify this filter, click its description link in blue, above the list.
Save an advanced filter save-adv-filters
You can save an advanced filter as a predefined filter, so that you can reuse it and share it with the other Campaign users.
To save an advanced filter, follow the steps below:
-
Click the description of the filter to edit it.
-
Click the Save as filter icon on the upper right section of the window.
-
Enter a name for this filter and save it.
The filter is added to the predefined filters. It can be updated from this node.
This filter is also available from the predefined filters of the recipient list.
Use a filter to define a segment filter-as-segment
You can use and combine filters to create a target population segment.
Once saved, advanced filters are available when selecting the target population of a message, in the User filters section.
Use functions to build advanced filters use-functions-adv-filters
To perform advanced filtering capabilities, use functions to define the content of the filter. The Advanced filter editor leverages all capabilities of Campaign query editor.
Learn how to build advanced queries in these end-to-end samples:
- Learn how to target on simple recipient attributes in this page.
- Learn how to filter on recipients not contacted during the last 7 days in this page.
- Learn how to recover the list of operators can be filtered by Active accounts in this page.
- Learn how to build a birthday email audience in this page.
Advanced parameters for predefined filters param-for-data-filters
Advanced parameters are available for predefined filters. To access them, browse to the Parameters tab of the filter.
-
To display the filter by default for all the lists based on this Document type, select the Default filter for the associated document type option.
For example, the By name or login filter is applied to operators This option is selected, so the filter is always displayed on all operator lists.
-
To make a filter available to all Campaign operators, select the Filter shared with other operators option.
-
To define a form to select the filtering criteria, select the Use parameter entry form option. This form must be entered in XML format in the Form tab. For example, the built-in predefined filter Recipients who have opened, available from the recipients list, displays a filter field that lets you select the delivery to which the filter applies to.
-
The Advanced parameters link lets you define additional settings.
- You can associate a SQL table with the filter to make it common to all editors that share the table.
- To prevent any user from overriding the filter, select the Do not restrict the filter option. For example, this option is active for “Recipients of a delivery” and “Recipients of deliveries belonging to a folder” filters which are available in the delivery wizard. These filters cannot be overloaded.