---
title: Add Instructional or Custom Queries to Instances
description: Learn how to efficiently add and manage instructional or custom queries using the Queries tab in Intentwise Explore.
---

[Skip to content](https://help.intentwise.com/amc-queries-explained#main-content)

![footer-logo.png\]](https://help.intentwise.com/hs-fs/hubfs/footer-logo.png?width=210&height=40&name=footer-logo.png)

Open main navigation

Close main navigation

 Advice and answers from Intentwise

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://help.intentwise.com/?hsLang=en)
2. [Intentwise Explore (AMC)](https://help.intentwise.com/intentwise-explore-amc?hsLang=en)
3. [AMC](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#amc)

# 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.

### 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).![](https://help.intentwise.com/hs-fs/hubfs/image-png-Jun-26-2026-12-44-45-5177-PM.png?width=670&height=418&name=image-png-Jun-26-2026-12-44-45-5177-PM.png)

### Query Settings

Once added, you can monitor each query's details and edit settings from My Queries.![](https://help.intentwise.com/hs-fs/hubfs/image-png-Jun-26-2026-12-55-44-5170-PM.png?width=3348&height=2072&name=image-png-Jun-26-2026-12-55-44-5170-PM.png)![](https://help.intentwise.com/hs-fs/hubfs/image-png-Jun-26-2026-12-55-01-2826-PM.png?width=3346&height=2080&name=image-png-Jun-26-2026-12-55-01-2826-PM.png)![](https://help.intentwise.com/hs-fs/hubfs/image-png-Jun-26-2026-12-54-29-2520-PM.png?width=3338&height=2070&name=image-png-Jun-26-2026-12-54-29-2520-PM.png)

### **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.

![](https://help.intentwise.com/hubfs/image-png-Jun-26-2026-10-47-13-8319-AM.png)

Our expert team meticulously crafts the custom queries from scratch or fine-tunes existing queries to suit specific use cases. [Learn more](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#instructional-queries) 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](https://app.intentwise.com/amc/amc-request-custom-query) by filling out the form.

### Add a Query

Go to a query and click the respective query.![](https://help.intentwise.com/hubfs/image-png-Jun-26-2026-12-58-22-4269-PM.png)![](https://help.intentwise.com/hs-fs/hubfs/image-png-Jun-26-2026-12-58-51-3851-PM.png?width=3346&height=2088&name=image-png-Jun-26-2026-12-58-51-3851-PM.png)

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](https://app.intentwise.com/amc/amc-queries/amc-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.![](https://help.intentwise.com/hs-fs/hubfs/image-png-Jun-26-2026-01-01-42-6420-PM.png?width=3339&height=2080&name=image-png-Jun-26-2026-01-01-42-6420-PM.png)

### Watch the video

<iframe class="hs-responsive-embed-iframe" height="360" src="https://www.youtube.com/embed/ZRWsFOMPLtY" style="position: absolute; top: 0; left: 0; width: 100%; height: 100%; border: none;" width="640" allowfullscreen data-service="youtube"></iframe>

### 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.![](https://help.intentwise.com/hs-fs/hubfs/image-png-Jun-26-2026-01-02-56-1320-PM.png?width=3336&height=2065&name=image-png-Jun-26-2026-01-02-56-1320-PM.png)![](https://help.intentwise.com/hs-fs/hubfs/image-png-Jun-26-2026-01-02-25-7602-PM.png?width=3328&height=2075&name=image-png-Jun-26-2026-01-02-25-7602-PM.png)

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](https://help.intentwise.com/amc-templates-insights-dashboard-explained?hsLang=en) 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 [help@intentwise.com](mailto:help@intentwise.com) for guidance.

- [Getting started](https://help.intentwise.com/getting-started?hsLang=en)
- [Intentwise AI Gateway](https://help.intentwise.com/intentwise-ai-gateway?hsLang=en)
- [Intentwise Ad Optimizer](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#main-content)

    - [Account and Campaign Setup](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#account-and-campaign-setup)
    - [Optimization](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#optimization)
    - [Reporting](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#reporting)
    - [Dashboard Overview](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#dashboard-overview)
    - [Resources](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#resources)
    - [Amazon DSP](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#amazon-dsp)
    - [Additional Features](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#additional-features)
    - [Walmart](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#walmart)
    - [Criteo](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#criteo)
    - [Instacart](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#instacart)
- [Intentwise Explore (AMC)](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#main-content)

    - [AMC](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#amc)
    - [Instructional Queries](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#instructional-queries)
- [Intentwise Analytics Cloud](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#main-content)

    - [Kickstart Guide](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#kickstart-guide)
    - [Configuring Reporting Tools](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#configuring-reporting-tools)
    - [Configuring Data Pipeline](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#configuring-data-pipeline)
    - [Data Sources](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#data-sources)
    - [Looker (Google Data) Studio Tutorials](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#looker-google-data-studio-tutorials)
    - [Intentwise Templates](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#intentwise-templates)
    - [Intentwise Analytics Cloud features](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#intentwise-analytics-cloud-features)
    - [White Label](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#white-label)
- [Intentwise Marketplace Intelligence](https://help.intentwise.com/intentwise-marketplace-intelligence?hsLang=en#main-content)

    - [Content Analytics (CA)](https://help.intentwise.com/intentwise-marketplace-intelligence?hsLang=en#content-analytics-ca)
    - [Share Of Voice (SOV)](https://help.intentwise.com/intentwise-marketplace-intelligence?hsLang=en#share-of-voice-sov)
- [Frequently Asked Questions (FAQs)](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#main-content)

    - [Access and Setup](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#access-and-setup)
    - [Billing](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#billing)
    - [Platform](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#platform)
    - [Reporting](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#reporting)

intentwise.com Help Center

Copyright © 2026, Intentwise Inc.