Amazon Marketing Cloud Certification
Leverage AMC SQL analytics for advanced audience insights and campaign measurement
78 practice questions
Page 3 of 4
Which signals are not available within AMC?
3 answer options
Why is this query unsuitable for assembling a rule-based audience of those who have completed a conversion event? SELECT user_id FROM conversions
4 answer options
What formula would you use to calculate Amazon DSP CPM using the fields available in dsp_impressions?
3 answer options
Which event table can be used when attributing conversions to your campaign using custom logic (e.g., 28 day lookback window)?
4 answer options
Which of the following statements is true about using queries within the instructional query library?
3 answer options
What is an AMC sandbox?
3 answer options
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.
4 answer options
What can Amazon shopping insights be used for?
3 answer options
The _________________ panel within AMC is a repository of Amazon-authored SQL templates and includes associated use cases, instructions, and a guide to interpret the results.
4 answer options
The submitted queries table provides details of the query executed and a link to download your aggregated report as a _______ when it’s ready.
4 answer options
Which of these analyses can be accomplished with an overlap query?
3 answer options
What is SQL optimization in the context of AMC?
4 answer options
This panel provides access to additional subscription-based insights from Amazon or third parties; these insights can be joined with your Amazon Ads events that are already available in AMC.
4 answer options
New-to-brand metrics are only relevant for __________.
4 answer options
The __________ field functions as a grouping indicator for the impression and any associated clicks, view events, or conversion events.
4 answer options
Overlap analyses enable you to generate insights by comparing different groups of __________ values in isolation and when overlapped.
4 answer options
How would you adapt this query to limit results to Sponsored Products keyword targeting only? SELECT ad_product_type, targeting, customer_search_term, match_type, SUM (spend)/100000000 AS total_cost_dollars, ((SUM (spend)/100000000)/SUM (impressions)) *1000 AS avg_cpm, SUM (impressions) AS impressions, SUM (clicks) AS clicks, (SUM (clicks)/SUM (impressions)) AS ctr FROM sponsored_ads_traffic WHERE match_type IN (‘PHRASE’, ‘BROAD’, ‘EXACT’) GROUP BY 1,2,3,4
4 answer options
The _________ field contains the pseudonymous ad identifier associated with a given impression. It is often used in calculations to understand unique reach volumes.
4 answer options
Which of these queries will only include purchase records from the underlying table?
3 answer options
Which AMC tables would be required for determining the Amazon-attributed conversion volumes per frequency bucket (including Amazon DSP traffic only)?
3 answer options