The query editor is a wizard that allows you to filter data contained in the Adobe Campaign database.
This feature lets you build a population to better target your recipients thanks to the predefined filters and rules.
The palette, located on the left hand side of the editor, is divided into two tabs, which contain elements divided into thematic blocks. These tabs are:
The elements contained in the tabs must be moved into the workspace in order to be configured and taken into account for the query. Depending on the targeting dimension selected (see Targeting dimensions and resources), you can:
The workspace is the central zone in which you can configure and combine rules, audiences, and predefined filters added from the palette.
When you move an element from the palette into the workspace, a new window opens and you can start Creating queries.
The query editor can be used to define an audience or test profile in a message, a population in a workflow and to create a query type audiences.
Queries can be defined in the Audience window while creating a delivery or in a Query activity while creating a workflow.
For a 1-N link with another database resource, you can define a sub-query on the fields of this second resource.
For example, you can only select the Exists operator on the profile tracking logs and approve the rule. The rule will return all of the profiles for which tracking logs exist.
Administrators can create filters to facilitate complex and repetitive queries. These will appear in the query editor in the form of pre-configured rules and they limit the number of steps needed to be carried out by the user.
To combine the workspace elements, interlock them into one another to create different groups and/or group levels. You can then select a logical operator to combine elements on the same level:
If you would like to modify an element of the query, click on the edit icon. The rule is opened as it was previously configured and you can then carry out any necessary adjustments.
Your queries are now created and defined, this allows you to build a population to better personnalize your deliveries.