Create AMC workflow (SQL)
amc_create_workflowSave an AMC SQL workflow on an instance to analyze clean-room advertising data using SQL queries.
Instructions
Save an AMC SQL workflow on an instance. AMC SQL queries clean-room event tables (impressions, clicks, conversions); aggregation thresholds apply — queries returning user-level data are rejected by AMC.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| entityId | Yes | AMC entity id (Amazon-Advertising-API-AdvertiserId header), e.g. ENTITY1ABC… | |
| marketplaceId | Yes | Marketplace id (Amazon-Advertising-API-MarketplaceId header), e.g. ATVPDKIKX0DER for amazon.com | |
| instanceId | Yes | ||
| workflowId | Yes | Your identifier for this workflow. | |
| sqlQuery | Yes | AMC SQL. |