Skip to main content

Run AMC queries from Claude

Amazon Marketing Cloud (AMC) is Amazon's clean room: a place where you can analyze detailed advertising signals that never appear in normal reports, with results returned only as aggregates, so no individual shopper is ever identifiable. Working with AMC normally means writing SQL against its tables yourself. With the MixShift plugin, you ask in plain English and Claude handles the SQL.

Before you start

  • Your advertising account needs AMC access (an AMC instance). If you are not sure you have one, ask; the plugin can check.
  • The MixShift plugin installed and signed in. See Connect MixShift to Claude.

How it works

  1. Ask a question in a Claude chat, for example "What AMC instances do I have?" or "Using AMC, how many of last month's purchasers saw both our display ads and our sponsored ads?"
  2. Claude finds your AMC instance, looks at the data sources available in it, and writes the query.
  3. The query runs on Amazon's side. AMC queries are not instant; expect minutes, not seconds. Claude checks progress and tells you when it is done.
  4. Results come back as a downloadable CSV you can open in a spreadsheet or hand to another tool.

Good first questions

  • "List my AMC instances and what data sources they have."
  • "How much did display and sponsored ads overlap for purchasers in the last 30 days?"
  • "Build me a path-to-purchase view: which ad types did buyers touch, in what order?"

Notes

  • Everything here is read-only. Running a query changes nothing in your ad account.
  • Results are aggregated by Amazon's clean-room rules. Very small groups are suppressed by Amazon, so tiny segments can come back empty; that is AMC working as designed.
  • AMC is in beta in the plugin.
  • Connect MixShift to Claude
  • Platform FAQ
Still have questions?
Ask Shifty

Shifty is the MixShift docs assistant. Pick a question or open the chat for anything else.