Amazon Marketing Cloud Certification Answers

How would you adapt this query to limit results to Sponsored Products keyword targeting only?

Latest Update on 26th June, 2023 by Certification Course Answers

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

  1. Adjust FROM statement to: FROM sponsored_products
  2. Adjust WHERE statement to: WHERE match_type IN(‘PHRASE’, ‘BROAD’, ‘EXACT’) AND ad_product_type = ‘sponsored_products’
  3. Add LIMIT clause: LIMIT sponsored_products
  4. Adjust SELECT statement to include the sponsored_products field

Latest Updates

No posts found in this category.