Why is this query unsuitable for assembling a rule-based audience of those who have completed a conversion event? SELECT user_id FROM conversions
The query requires a WHERE clause to specify the relevant conversion event type(s)
The query cannot include user_id as a dimension within the final SELECT statement
The query does not leverage an audience-specific table
The query requires a GROUP BY statement
Correct Answer
The query does not leverage an audience-specific table
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
- 1Rule-based audience creation leverages a separate set of tables than those utilized for AMC reporting.
- 2You can activate AMC rule-based audiences on _____________.
- 3Which statement about rule-based audiences is incorrect?
- 4How 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
- 5Which table would you leverage for a query when your objective is to understand how your current audience strategy is performing for your campaigns?
- 6If 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?