What formula would you use to calculate Amazon DSP CPM using the fields available in dsp_impressions?
(SUM (total_cost)/100000)/ (SUM (impressions)) *1000 AS avg_cpm
((SUM (spend)/100000000)/SUM (impressions)) *1000 AS avg_cpm
((SUM (total_cost)/100000)/SUM (impressions))/1000 AS avg_cpm
Correct Answer
((SUM (spend)/100000000)/SUM (impressions)) *1000 AS avg_cpm
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
- 1Within the amazon_attributed_events_* tables, Amazon Ads will only attribute conversion events to click events for sponsored ads CPC (cost-per-click) campaigns.
- 2Considering 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?
- 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 __________.
- 4Where can you find the details of the entities (Amazon DSP, sponsored ads, etc.) linked to an AMC Instance?
- 5Which of these exploratory queries would allow you to generate a list of all Amazon DSP creative active during your chosen time window?
- 6This 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.