Which AMC tables would be required for determining the Amazon-attributed conversion volumes per frequency bucket (including Amazon DSP traffic only)?
dsp_impressions_by_matched_segments, amazon_attributed_events_*
dsp_impressions_by_user_segments, amazon_attributed_events_*
dsp_impressions, amazon_attributed_events_*
Correct Answer
dsp_impressions, amazon_attributed_events_*
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 95 Amazon Marketing Cloud questions →Related Amazon Marketing Cloud questions
- 1Within the amazon_attributed_events_* tables, Amazon Ads will only attribute conversion events to click events for sponsored ads CPC (cost-per-click) campaigns.
- 2SELECT total_impressions SUM (impressions) AS device_type FROM campaign, supply_source GROUP BY 1,2,3 SELECT campaign, supply_source, SUM (impressions) AS impressions FROM device_type GROUP BY 1,2 SELECT campaign, supply_source, device_type, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1,2,3 The correct answer is: SELECT campaign, supply_source, device_type, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1,2,3 Explanation: The correct query to get the total impressions delivered per campaign, per supply source, and per device type is: SQL SELECT campaign, supply_source, device_type, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1, 2, 3 ✅ Explanation of the Query This is a standard and efficient SQL query structure for use in Amazon Marketing Cloud (AMC) .Multiple correct
- 3Since 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 __________.
- 4Considering 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?
- 5Which field in the amazon_attributed_events_ tables should you leverage if you want to understand more about which product or pixel your conversion events are associated with?
- 6If you want to understand more about which product or pixel your conversion events are associated with, which field in the amazon_attributed_events_* tables should you leverage?