How 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
Choose an answer
Tap an option to check your answer.
Correct answer: Adjust WHERE statement to: WHERE match_type IN('PHRASE', 'BROAD', 'EXACT') AND ad_product_type =.
Why this is the answer
The correct answer is to adjust the WHERE statement to include AND adproducttype = 'SPONSOREDPRODUCTS'. This is because the adproducttype column in AMC's sponsoredadstraffic table differentiates between various ad products, such as Sponsored Products, Sponsored Brands, and Sponsored Display. To specifically filter for Sponsored Products, you must explicitly add this condition to your WHERE clause. The LIMIT clause is used to restrict the number of rows returned by the query, not to filter by ad product type.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed