Skip to main content
All CollectionsIntentwise Explore (AMC)
Add Instructional or Custom Queries to Instances
Add Instructional or Custom Queries to Instances

Learn how to efficiently add and manage instructional or custom queries using the Queries tab in Intentwise Explore.

Ankita Goyal avatar
Written by Ankita Goyal
Updated over a week ago

Queries Explained

The Queries tab is your central hub for all things related to queries. Choose from predefined queries or run multiple simultaneously across instances. Schedule in advance or request custom queries—Intentwise Explore caters to your every need. Leverage pre-built or customize for unique requirements.

Availability: Intentwise Explore (AMC)

My Queries

Navigate to the My Queries tab under Queries for a comprehensive overview of all your queries. You can add queries by clicking the "Add Query" button. You'll then be directed to the Query Library tab (discussed later in the article).

Query Settings

Once added, you can monitor each query's details and edit settings from My Queries.

Query Library

Under Query Library, you’ll find an exhaustive list of instructional queries from the Amazon Marketing Cloud Console and custom queries. You can select queries, set their frequencies, schedule them, and apply labels to streamline query management.

Our expert team meticulously crafts the custom queries from scratch or fine-tunes existing queries to suit specific use cases. Learn more about various instructional queries available.

Note: If you cannot find the query you're looking for in the Query Library, you can request a custom query by filling out the form.

Add a Query

Go to a query and click the "+ Add To My Queries" button.

To execute queries using the Intentwise platform, add the following details:

  • Name

  • Frequency

  • Date Range and exclusion

  • Select instances and specify DSP Orders and Sponsored Ads Campaigns using input parameters (optional)

  • Labels

All your selected queries find a home in the "My Queries" tab for easy access and monitoring.

Input Parameters

AMC queries are SQL queries running behind the scenes. You can specify input parameters within each query to be used when the AMC SQL query is executed.

Watch the video

Query Results

All your query results can be found in the "Query Results" section. You can find and filter details like execution date, instance, query type, and status. You can also download the reports from here.

Certain queries may take hours to populate, but with Intentwise Explore, you can schedule them in advance, ensuring your data is ready when needed.

Want to explore more? Learn about our pre-built templates and reports for Amazon Marketing Cloud datasets.

Did this answer your question?