Which value is not available for Sponsored Products?
user_id
engagement_scope
purchases
campaign_id
Correct Answer
campaign_id
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
- 1Which signals are not available within AMC?
- 2How would you adapt this query to limit results to Sponsored Products keyword targeting only? SELECT ad_product_type, targeting, customer_search_term, match_type, SUM (spend)/100000000 AS total_cost_dollars, ((SUM (spend)/100000000)/SUM (impressions)) *1000 AS avg_cpm, SUM (impressions) AS impressions, SUM (clicks) AS clicks, (SUM (clicks)/SUM (impressions)) AS ctr FROM sponsored_ads_traffic WHERE match_type IN (‘PHRASE’, ‘BROAD’, ‘EXACT’) GROUP BY 1,2,3,4
- 3What types of Sponsored Products records will have spend metrics?
- 4This table contains impression and click events from Sponsored Products (SP), Sponsored Brands (SB), and Sponsored Display (SD) campaigns.
- 5Since 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 __________.
- 6Where can you find the details of the entities (Amazon DSP, sponsored ads, etc.) linked to an AMC Instance?