Run AMC queries from Claude

Amazon Marketing Cloud (AMC) is a clean room from Amazon: 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 Install the plugin.

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 the Amazon 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 the AMC clean-room rules. Very small groups are suppressed by Amazon, so tiny segments can come back empty; that is AMC working as designed.

Related

• Install the plugin
• Skill catalog
• Plugin FAQ