← All checklists
Amazon Marketing Cloud
AMC query review
A review standard for queries before they run in a live advertiser instance.
Verify the official Amazon Ads documentation before making business-critical changes.
Checklist
- P0
1. Check live queries for required aggregation and appropriate GROUP BY clauses.
Live instances do not allow raw event-level output.
- P0
2. Explicitly review time windows, UTC, and data latency.
Unclear time logic distorts comparisons and performance KPIs.
- P0
3. Validate tables, columns, and join logic against the current AMC schema.
Unavailable or incorrectly joined fields cause errors or incorrect results.
- P0
4. Run the query with synthetic data in the Sandbox first.
Syntax, schema, and logic issues are found before production runs.
- P1
5. Define the output destination — UI, S3, or schedule — before the run.
This makes it clear where the result will be checked and processed.
- P2
6. Save the query as a named workflow if it will be reused or scheduled.
This reduces manual variants and simplifies maintenance.
Primary sources
This checklist summarises publicly available documentation; it does not replace product-specific Amazon approval.