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.
Frequently Asked Questions
Why did my query fail, and how can I ensure it runs successfully?
Your query may fail if it includes a large amount of data, such as querying over 9,000 campaigns. The Amazon Marketing Cloud (AMC) API has limits on the amount of data it can process at once, which could cause the query to fail without a clear reason. To improve your chances of success, try reducing the amount of data in the query by adjusting the number of campaigns or other parameters. After making these changes, you can reschedule and run the query again.
If you see a query has failed and you're unsure why, feel free to reach out to us on chat or at [email protected] for guidance.