Which table should you use in a query meant to help you choose new Amazon audiences that may benefit your Amazon DSP campaign performance?
amazon_audiences
dsp_audiences
dsp_impressions_by_user_segments
dsp_impressions_by_matched_segments
Correct Answer
dsp_impressions_by_user_segments
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
- 1If you run multiple Amazon DSP and sponsored ads campaigns and reached similar audiences, which query can help you understand your customers’ conversion paths that have the highest conversion rate?
- 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
- 3Rule-based audience creation leverages a separate set of tables than those utilized for AMC reporting.
- 4Which table would you leverage for a query when your objective is to understand how your current audience strategy is performing for your campaigns?
- 5You can activate AMC rule-based audiences on _____________.
- 6Which of the following statements about AMC lookalike (LAL) audiences is false?