Which of these exploratory queries would allow you to generate a list of all Amazon DSP creative active during your chosen time window?
SELECT creative, creative_id, SUM (impressions) AS impressions FROM sponsored_ads_traffic GROUP BY 1,2
SELECT creative, creative_id, SUM (impressions) AS impressions FROM dsp_impressions WHERE creative IS LIVE GROUP BY 1,2
SELECT creative, creative_id, SUM (impressions) AS impressions FROM amazon_attributed_events_by_traffic_time GROUP BY 1,2
SELECT creative, creative_id, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1,2
Correct Answer
SELECT creative, creative_id, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1,2
Topics in this question
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 94 Amazon Marketing Cloud questions →Related Amazon Marketing Cloud questions
- 1Considering the amazon_attributed_events_ tables contain ad-attributed conversions across all of your Amazon Ads media, which of the following fields would allow you to aggregate them by sponsored ads vs. Amazon DSP?
- 2Since the amazon_attributed_events_* tables contain ad-attributed conversions across all of your Amazon Ads media, you can aggregate them by sponsored ads vs. Amazon DSP using the __________.
- 3Which of these statements is false regarding the amazon_attributed_events_by_conversion_time table?
- 4Where can you find the details of the entities (Amazon DSP, sponsored ads, etc.) linked to an AMC Instance?
- 5Why should you wait until 14 days after the end date of your query date range to run analyses that leverage the amazon_attributed_events_by_traffic_time table?
- 6What is the Amazon Ads attribution lookback window?