- Product documentation
- Latest Updates
- Release Notes
- Getting started
- Profiles and audiences
- Communication channels
- Get started with communication channels
- About communication channels
- Delivery best practices
- Email messages
- SMS messages
- Push notifications
- In-App messaging
- Direct mail
- Transactional messaging
- Landing pages
- Designing email content
- Testing and Sending
- Reporting
- Integrating with other solutions
- Get started with Campaign integrations
- Campaign and Experience Manager
- Campaign and Target
- Campaign and Analytics
- Campaign and Audience Manager or People core service
- Campaign and Analytics for Mobile
- Campaign and Triggers
- Campaign and Microsoft Dynamics 365
- Managing processes and data
- Get started with data and processes management
- Workflow general operation
- Executing a workflow
- Calling a workflow with external parameters
- Targeting activities
- Execution activities
- Channel activities
- Data management activities
- Filtering data
- Importing and exporting data
- Use cases
- About workflow use cases
- Deliveries
- Creating deliveries with a complement
- Creating deliveries on profiles’ creation date
- Creating a weekly delivery
- Creating a cross-channel delivery
- Identifying duplicates before a delivery
- Birthday delivery
- Coupling email and direct mail deliveries
- Sending an email with enriched fields
- Personalizing an email with additional data
- Sending a recurring push notification
- Segmentation and targeting
- Data management
- Reconcile a File audience with the database
- Deduplicating the data from an imported file
- Enriching profile data with data contained in a file
- External signal activity and data import
- Updating the database with external data
- Updating data based on an automatic file download
- Data reconciliation using relations
- Data update using reconciliation
- Exporting profiles in an external file
- Updating multiple subscription statuses from a file
- Subscribing profiles from a file to a specific service
- Working with Adobe Experience Platform audiences
- Developing
- Administrating
- Get started with Campaign Standard administration
- Monitoring guidelines
- Configuration guidelines
- Users and security
- Configuring channels
- Configuring mobile channels
- Implementing Push tracking
- Adding images and videos iOS
- Understanding push notifications payload structure
- Implementing local notification tracking
- Adobe Launch Synchronization FAQ
- Experience Platform SDK integration FAQ
- Configuring Launch rules to support Adobe Campaign Standard use cases
- Mobile use cases supported in Adobe Campaign Standard
- Configuring SMS channel
- Application settings
- Working with APIs
- Get started with Campaign Standard APIs
- About Campaign Standard APIs
- Global concepts
- Interacting with custom resources
- Managing profiles
- Managing services and subscriptions
- Interacting with marketing history
- Privacy management
- Managing transactional messages
- Managing workflows
- Managing organizational units
- Managing geographical units
- Troubleshooting
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
The following example shows a query activity configured to target men between 18 and 30 years old, living in London.
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
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
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
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
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
-
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.
