Found in AI answers?Get a free review
Theory Road.
← PerspectivesE-commerce

Amazon Marketing Cloud: What It Is and the Queries Worth Running.

Amazon Marketing Cloud lets a brand ask its own questions of event-level Amazon ad and purchase data. It is powerful and easy to misuse. Here is how it works, the queries that pay, and how to tell if you are ready.

By Theory RoadSeptember 21, 202611 min read

Amazon Marketing Cloud (AMC) is a privacy-safe clean room, hosted on AWS, where an advertiser writes SQL against event-level data about its own Amazon ad impressions, clicks and conversions, and gets back aggregated results only. It answers questions the standard Ads console reports cannot, such as which combinations of ad types lead to a purchase and how long that takes. It is free to use for eligible advertisers, but it is only as useful as the questions you ask and the decisions you make with the answers.

We query AMC for our own Amazon brands, so this guide is written from the query editor. It covers what AMC is and is not, access requirements, the queries we run first, AMC audiences, and a plain test for whether a brand is ready.

What Amazon Marketing Cloud Actually Is.

A clean room is a controlled environment where two parties' data can be analyzed together without either side seeing the other's raw records. In AMC, Amazon provides pseudonymized, event-level signals for your campaigns: impressions and clicks from Sponsored Products, Sponsored Brands, Sponsored Display and Amazon DSP, plus conversion events such as detail page views, add to carts and purchases. Each AMC instance only contains data for the advertiser accounts connected to it.

You never see a row about one shopper. You write a query, AMC runs it, and the output is aggregated. Any row that represents too few distinct users is dropped or suppressed before you see it, and there are further protections against queries designed to single people out. This is the single most important thing to understand: AMC answers questions about groups, and small groups disappear from the output.

Access Requirements.

AMC began as a tool for Amazon DSP advertisers, usually reached through an agency or Amazon's managed service. Amazon has since broadened access so that many Sponsored Ads advertisers can open an AMC instance from the Amazon Ads console. Eligibility, regions and the exact sign-up path change over time, so check the current requirements in the console rather than trusting an old checklist.

In practice you need three things beyond eligibility: advertiser accounts connected to the instance, someone who can write and debug SQL, and enough ad volume that your questions return rows. AMC itself does not charge a fee to run queries, though Amazon sells optional paid insight add-ons, and your time is the real cost. If you are weighing whether to staff this in house, our guide to what a real Amazon marketing agency engagement looks like covers the skills involved.

The Queries Worth Running First.

AMC ships with an instructional query library: templates written by Amazon that you copy, adjust dates and filters on, and run. Start there. Writing from scratch is for the second month. These are the questions we answer first on any account.

First AMC queries and the decision each one informs
QueryQuestion it answersDecision it changes
Path to purchaseWhich sequences of ad types did buyers see before purchasingWhether upper-funnel formats earn budget alongside Sponsored Products
Time to conversionHow many days pass between first ad exposure and purchaseLookback windows for remarketing and how long to wait before judging a campaign
New-to-brand by campaignWhich campaigns bring in buyers new to the brandWhich campaigns to scale for growth versus keep for harvesting
Sponsored Ads and DSP overlapHow many buyers were reached by both, and how they convertWhether DSP adds new reach or pays twice for the same shoppers
Frequency and conversionHow conversion rate changes with the number of impressionsFrequency caps on DSP and Sponsored Display

Path to purchase groups converting users by the combination of ad types they were exposed to and reports conversion rate for each combination. It is the query that tells you whether shoppers who saw a Sponsored Brands video and then a Sponsored Products ad buy at a higher rate than those who saw Sponsored Products alone. Time to conversion measures the gap between first exposure and purchase, which is how you set a sensible remarketing lookback instead of guessing. New-to-brand in AMC can be cut in ways the console cannot, for example by combinations of campaigns. Overlap between Sponsored Ads and DSP shows how much of your DSP audience also saw your search ads, which is the core question behind any DSP budget.

Running Your First Query, Step by Step.

Open the instance and check the data.
In the Amazon Ads console, open Amazon Marketing Cloud and confirm which advertiser accounts are connected. Run a simple count of impressions by ad type by week for a recent period to confirm data is flowing for every ad type you expect.
Copy a template from the library.
In the instructional query library, find the path to purchase template. Copy it to your workspace rather than editing the original, and read the notes that explain each table and parameter.
Set the date range and filters.
Choose a range long enough to hold real volume. Filter to the advertiser and, if needed, the campaigns you care about. Keep the grouping wide on the first run.
Run and read the output.
Execute the query and wait for it to finish. Check how many rows returned and whether groups you expected were suppressed. Missing rows usually mean the slice was too small, not that nothing happened.
Narrow, then save.
Tighten one dimension at a time and rerun. When a version answers the question cleanly, save it with a descriptive name and schedule it to run weekly or monthly so you are comparing like with like.
Write down the decision.
Before anyone opens the result, write down the budget or audience decision it is meant to inform. If the result would not change a decision, stop running it.

AMC Audiences.

AMC is not only for analysis. You can define an audience with a query, for example shoppers who added a product to cart but did not purchase within a window, or buyers of one product who have not bought a complementary one, and send it to Amazon DSP. Amazon has also extended AMC audiences to Sponsored Ads in some forms, such as audience targeting in Sponsored Display and audience bid adjustments. Check the console for what is supported on your account, because this area changes.

Audience queries follow the same privacy rules: the audience itself must be large enough to be activated, and you never see who is in it. The practical limit is the same as for analysis. A small brand's cart abandoners in a short window may be too few to use.

An AMC query that does not change a budget, a bid, or an audience is a research project, not marketing.

What Usually Goes Wrong.

  • Slicing too finely on the first run and concluding AMC has no data, when the rows were suppressed by the aggregation threshold.
  • Opening AMC for an account that runs only Sponsored Products at modest spend, where the console reports already answer the useful questions.
  • Treating path to purchase as causal proof. Shoppers who see more ad types are often already more interested, so compare against holdouts or at least read it with that bias in mind.
  • Running interesting queries once and never scheduling them, so there is no trend and no comparison over time.
  • Mixing data from different advertiser accounts or date ranges without noting it, and then comparing results that were never like for like.
  • Building audiences that are too narrow to activate, then waiting on campaigns that never serve.

When a Brand Is Ready for AMC.

A brand is ready for AMC when three things are true. It runs at least two or three Amazon ad types, usually Sponsored Products plus Sponsored Brands or Sponsored Display, and ideally DSP. It spends steadily enough that weekly groups by ad type hold real volume. And it has a question the console cannot answer, such as whether upper-funnel spend is producing new customers or just taking credit for sales Sponsored Products would have made.

If none of that is true, the better use of the same hours is usually the basics: clean Sponsored Products structure, strong listings, and Brand Analytics. AMC rewards maturity. It does not create it.

Where the Clean Room Stops and the Work Begins.

AMC gives you a query editor and a library. The work is deciding which questions matter, writing SQL that respects the privacy rules and returns usable rows, scheduling queries so trends are visible, turning the answers into budget moves across Sponsored Ads and DSP, and building audiences large enough to activate. It is analyst work tied to media buying, and the value only appears when the same people do both. That combined analysis and media work is what we do through Amazon DSP and Marketing Cloud management.

What is Amazon Marketing Cloud used for?

Amazon Marketing Cloud is used to analyze event-level Amazon advertising and conversion data with SQL and get aggregated answers the standard reports do not give, such as path to purchase across ad types, time from first exposure to purchase, and overlap between Sponsored Ads and DSP. It is also used to build custom audiences for DSP and some Sponsored Ads formats.

Is Amazon Marketing Cloud free?

Running queries in Amazon Marketing Cloud does not carry a usage fee for eligible advertisers. Amazon offers optional paid insight add-ons, and the practical cost is the analyst time to write, check and act on queries. Media bought with AMC audiences, such as DSP campaigns, is paid for as normal advertising spend.

Do you need Amazon DSP to use AMC?

Not anymore in many cases. AMC started as a DSP-linked tool, but Amazon has opened access to many Sponsored Ads advertisers through the Amazon Ads console. You still get the most out of it when DSP runs alongside Sponsored Ads, because overlap and path-to-purchase questions need several ad types to be meaningful.

Do you need to know SQL to use Amazon Marketing Cloud?

You need at least one person who can read and edit SQL. The instructional query library covers common questions, so many teams start by adjusting templates rather than writing from scratch. Debugging suppressed rows, joining tables correctly and building audiences all require real SQL comfort, which is why AMC is often run by an analyst or agency.

Why does my AMC query return no results?

The most common reason is the aggregation threshold. AMC suppresses any output row that represents too few distinct users, so fine slices by day, campaign and ASIN often come back empty. Widen the date range, group by ad type or week instead of day, and remove filters until rows appear, then narrow carefully.

Work with us

Let’s talk about what’s next.

A short note on where the business is and where it needs to go. A senior partner replies within one business day.

t@theoryroad.com

Step 1 of 2

How can we help you get found?

What do you need help with?

Next: name, email and budget. That’s it.