Paid features tables are only available in advertiser instances.
True
False
Correct Answer
False
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 of the following statements about paid features (beta) is false?
- 2Which AMC tables would be required for determining the Amazon-attributed conversion volumes per frequency bucket (including Amazon DSP traffic only)?
- 3Super Power Batteries, a consumer-packaged goods brand, is new to AMC and wants to learn more about what tables are available to query. Where in the AMC UI can they find this information?
- 4Within the amazon_attributed_events_* tables, Amazon Ads will only attribute conversion events to click events for sponsored ads CPC (cost-per-click) campaigns.
- 5SELECT supply_source, SUM (total_cost)/100000000 AS total_cost_dollars, ((SUM (total_cost)/100000000)/SUM (impressions)) *1000 AS avg_cpm, SUM (impressions) AS impressions FROM dsp_inventory GROUP BY 1 SELECT supply_source, SUM (total_cost)/100000 AS total_cost_dollars, ((SUM (total_cost)/100000)/SUM (impressions)) *1000 AS avg_cpm, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1,2 SELECT supply_source, SUM (total_cost)/100000 AS total_cost_dollars, ((SUM (total_cost)/100000)/SUM (impressions)) *1000 AS avg_cpm, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1 The correct answer is: SELECT supply_source, SUM (total_cost)/100000 AS total_cost_dollars, ((SUM (total_cost)/100000)/SUM (impressions)) *1000 AS avg_cpm, SUM (impressions) AS impressions FROM dsp_impressions GROUP BY 1 Explanation: That’s the correct query. Here is an explanation of the adaptation and why it works: The adapted query focuses on aggregating the desired metrics at the supply_source level, utilizing fields available in the dsp_impressions table: SQL SELECT supply_source, SUM(total_cost) / 100000 AS total_cost_dollars, ((SUM(total_cost) / 100000) / SUM(impressions)) * 1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1 🔍 Explanation of Changes The core principle of the adaptation is to replace the previous grouping dimensions with the single dimension required: supply_source .Multiple correct
- 6Since 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 __________.