This UI component is considered the day-to-day operating room for the analytics practitioner and is used to author and execute SQL queries, as well as download the results.
Instructional query library (IQL)
Paid features (beta)
Query editor
Instance info
Correct Answer
Query editor
About the Amazon Marketing Cloud Certification
The Amazon Marketing Cloud Certification covers Amazon's clean-room analytics environment: how AMC data is structured, writing SQL queries against it, and turning results such as overlap and path-to-conversion analysis into audience and media decisions.
Exam guide and all 95 Amazon Marketing Cloud questions →Related Amazon Marketing Cloud questions
- 1Which panel within the AMC UI contains a repository of Amazon-authored SQL templates along with use cases, instructions and examples of query results.
- 2Why is it considered a good best practice to exclude NULL user_id values from reach and frequency queries?
- 3Which event table can be used when attributing conversions to your campaign using custom logic (e.g., 28 day lookback window)?
- 4The _________________ panel within AMC is a repository of Amazon-authored SQL templates and includes associated use cases, instructions, and a guide to interpret the results.
- 5The submitted queries table provides details of the query executed and a link to download your aggregated report as a _______ when it’s ready.
- 6Columns in the HIGH and VERY_HIGH aggregation threshold categories cannot be used when applying ____________ to your query.