Query samples query-samples
This section presents use case when using a Query activity. For more on how to use a Query activity, refer to this section.
Targeting on simple profile attributes targeting-on-simple-profile-attributes
The following example shows a query activity configured to target men between 18 and 30 years old, living in London.
Targeting on email attributes targeting-on-email-attributes
The following example shows a query activity configured to target profiles with the email address domain “orange.co.uk”.
The following example shows a query activity configured to target profiles whose email address has been provided.
Targeting profiles whose birthday is today targeting-profiles-whose-birthday-is-today
The following example shows a query activity configured to target profiles whose birthday is today.
-
Drag the Birthday filter in your query.
-
Set the Filter type to Relative and select Today.
Targeting profiles who opened a specific delivery targeting-profiles-who-opened-a-specific-delivery
The following example shows a query activity configured to filter profiles who opened the delivery with the label “Summer Time”.
-
Drag the Opened filter in your query.
-
Select the delivery then click Confirm.
Targeting profiles for whom deliveries failed for a specific reason targeting-profiles-for-whom-deliveries-failed-for-a-specific-reason
The following example shows a query activity configured to filter profiles for whom deliveries failed because their mailbox was full. This query is only available for users with administration rights and belonging to the All (all) organizational units (see this section).
-
Select the Delivery logs resource in order to filter directly in the delivery log table (see Using resources different from targeting dimensions).
-
Drag the Nature of failure filter in your query.
-
Select the type of failure you want to target. In our case Mailbox full.
Targeting profiles not contacted during the last 7 days targeting-profiles-not-contacted-during-the-last-7-days
The following example shows a query activity configured to filter profiles who where not contacted during the last 7 days.
-
Drag the Delivery logs (logs) filter in your query.
Select Does not exist in the drop-down list, then drag the Delivery filter.
-
Configure the filter as below.
Targeting profiles who clicked a specific link targeting-profiles-who-clicked-a-specific-link-
-
Drag the Tracking logs (tracking) filter in your query.
-
Drag the Label (urlLabel) filter.
-
In the Value field, type the label that was defined when inserting the link in the delivery, then confirm.
