Ask Claude, ChatGPT or Cursor which products win new customers or which campaigns work together. DataDoe runs the AMC query on your own instance, brings the result back and puts it next to your sales, profit and ad data.
Cursor · Agent
| AMCRank | AMCProduct | AMCNew customers | AMCNew-to-brand share | DataDoeProfit after ads |
|---|---|---|---|---|
| 1 | Bamboo cutting board set | 1,184 | 71% | +$4,210 |
| 2 | Cutting board with juice groove | 806 | 64% | +$1,980 |
| 3 | Large cutting board | 512 | 58% | −$340 |
| 4 | Butcher block | 297 | 44% | −$610 |
Amazon Marketing Cloud (AMC) is Amazon Ads’ clean room. Each advertiser gets a private instance, built on AWS Clean Rooms, where SQL runs over pseudonymized ad exposures and purchases, and only aggregated results come out. It shows what a single campaign report cannot: which ads brought in new customers, which campaigns work together, and what shoppers buy next.
DataDoe connects that instance to your AI client and the REST API. Your AI runs a ready-made report or writes its own SQL, checks it before it runs, schedules the reports that should repeat, and reads each result in the same conversation as your Seller Central, Vendor Central and Amazon Ads data.
Templates adapted from Amazon’s Instructional Query Library and checked by DataDoe. Your AI runs one as it is, edits its SQL to filter campaigns or products, or saves it as a schedule.
| Question | Template | Needs · suggested cadence |
|---|---|---|
| New customers | ||
| Which products win customers who are new to your brand? | ntb-by-asin | Weekly |
| Which advertised products are most often a customer’s first buy from you? | ntb-gateway-asins | Weekly |
| How many new customers come with ads, and how many without? | organic-vs-ad-touched-ntb-by-asin | Amazon InsightsWeekly |
| Keywords and search terms | ||
| Which search terms sell the advertised product, and which sell your other products? | keyword-search-term-halo | Weekly |
| Which broad searches start the journeys that end in a purchase? | first-vs-last-search-term | Weekly |
| Campaigns working together | ||
| Which sequences of campaigns lead to a purchase? | path-to-conversion | Weekly |
| Do shoppers reached by Sponsored Products, Brands and Display together buy more often? | ad-product-overlap | Weekly |
| How long after the ad do shoppers buy? | time-to-conversion | Weekly |
| Repeat buyers | ||
| Which product do customers buy next, and how many days later? | cross-sell-next-purchase | Weekly |
| What are new and repeat customers worth over six to twelve months? | repeat-purchase-ltv-cohorts | Amazon InsightsOn demand |
| How long until a customer buys from you again? | time-to-second-purchase | Amazon InsightsOn demand |
Most templates use the data every AMC instance has. Three need Amazon Insights, a paid AMC feature you subscribe to in Amazon’s console, and your AI checks that before anything runs. Results follow Amazon’s 14-day attribution window and privacy thresholds, so small accounts can get fewer rows.
DataDoe signs in to your AMC instance, sends the query, waits for Amazon and hands the result to your AI. The same steps work from the REST API, so a script or a scheduled job can run them too.
amc_query_template_getntb-gateway-asins, checked against your instanceamc_query_validateDry run on Amazon’s side: SQL and time window acceptedamc_query_startSeptember 2026, run on demandamc_query_result_getResult file ready for your AI to readamc_workflows_createntb-gateway-weekly, every MondayDataDoe does not replace AMC. It runs your queries on the same instance, from the AI client where the rest of your Amazon work already happens.
| Checked 20 October 2026 | Amazon’s AMC consoleIn Amazon Ads | DataDoeMCP and REST API |
|---|---|---|
| Where you ask | The AMC console in your Amazon Ads account | Claude, ChatGPT, Cursor or any MCP client, and the REST API |
| Ready-made reports | Amazon’s analytic and audience templates | DataDoe templates for new customers, search-term halo, journeys and repeat buyers, checked against your instance before they run |
| Your own SQL | Written by you, or by Ads Agent, Amazon’s assistant in the console (beta) | Written by your AI against your instance’s live schema and validated before it runs |
| Next to the rest of your Amazon data | AMC signals and the data you upload to AMC | In the same conversation as Seller Central, Vendor Central, Amazon Ads and your product costs, so a result can be judged by profit |
| Schedules | Workflows and schedules in the console | Workflows and schedules from your AI. On a self-service instance they show in the console too |
| Audiences | Build AMC audiences and send them to campaigns | Not in DataDoe: build audiences in Amazon’s console |
| Price | Free for eligible advertisers. Paid features such as Amazon Insights cost extra | AMC stays free from Amazon. DataDoe is $97 a month with a 14-day free trial; AMC results are priced in AI tokens from the plan |
you build audiences, run AMC for one brand and are happy to work in Amazon’s interface.
you want AMC answers in Claude or ChatGPT, judged against sales and profit, for one brand or many client brands, and on a schedule.
Brands connect the self-service instance of their Sponsored Ads account, the same one the AMC console uses. If it does not exist yet, DataDoe creates it after you confirm. Amazon asks the Ads login to accept the AMC terms once per region.
Agencies with an AMC account from Amazon can give each client brand a new dedicated instance inside that account, and keep every client in one DataDoe organization with unlimited Amazon connections.
Paid AMC features such as Amazon Insights belong to one instance, so a brand that already pays for them should keep its self-service instance.
Shared with the AMC console: workflows and results show in both places. Disconnecting only removes DataDoe’s access.
Created in your agency’s AMC account for this brand. Disconnecting deletes the instance with its workflows.
No Amazon Ads API registration and no AMC API code. DataDoe handles both.
Create a DataDoe account and sign in with Amazon. A Seller Central or Vendor Central account with Amazon Ads works, and so does an Amazon Ads account on its own.
On the Accounts page, the organization owner clicks AMC, picks the instance and enables it. DataDoe emails you when it is ready. To run queries, set the account to Read and write.
Step-by-step guideAdd DataDoe to Claude, ChatGPT or any MCP client with this address, then ask your first AMC question. OAuth clients log in for you; the rest pass a key in datadoe-mcp-key.
https://mcp.datadoe.com/mcp/v1First AMC setup feels unfamiliar? Your account manager answers in about 15 minutes, and a free 30-minute engineer call every month can cover your first queries.
Amazon Marketing Cloud (AMC) is a clean room from Amazon Ads, built on AWS Clean Rooms. Each advertiser gets a private instance where SQL queries run over pseudonymized ad exposures, clicks and purchases, and only aggregated results come out. Advertisers use it for questions a campaign report cannot answer, such as which ads bring in new customers or which campaigns work together.
Amazon offers AMC at no cost to eligible advertisers. Some paid features, such as Amazon Insights, cost extra and are subscribed to per instance in Amazon’s console. In DataDoe, AMC is part of the Base plan at $97 a month with a 14-day free trial, and AMC results are priced in AI tokens from the plan. See pricing.
Advertisers running Sponsored Ads can open AMC through self-service, and agencies can hold AMC accounts provisioned by Amazon. In DataDoe you need an Amazon Ads connection on the same marketplace, for a Seller, a Vendor or an Amazon Ads account on its own.
No. The ready-made templates cover the common questions, and your AI client can run them by name. When you need something else, your AI writes the SQL against your instance’s live schema and validates it before anything runs.
Amazon says most queries take at least 15 minutes, while simple counts can finish in under a minute. Amazon allows 30 on-demand runs a day per instance and 10 at the same time. Reports you need regularly should be saved as scheduled workflows, which do not count against the daily limit.
AMC drops rows with too few customers to protect privacy, so small accounts and short periods return less. Ad-attributed results also use a 14-day attribution window, so run a report at least 14 days after the period ends.
No. DataDoe runs AMC queries and workflows and returns their results. Building audiences and sending them to campaigns stays in Amazon’s AMC console.
It is in open beta and available to every DataDoe organization without a request. The organization owner enables it per account on the Accounts page. Read the AMC guide.
Book a short demo and we will walk you through the AMC reports.
Book a demoConnect Amazon Ads, switch on AMC and find out which products win new customers, with their profit beside them.
We use cookies to improve your experience and analyze traffic. By clicking "Accept", you agree to our use of cookies. Read the Cookie Policy.