Amazon Marketing Cloud Certification Answers
Which of these exploratory queries would allow you to generate a list of all Amazon DSP creative active during your chosen time window?
Latest Update on 27th June, 2023 by Certification Course Answers
Which of these exploratory queries would allow you to generate a list of all Amazon DSP creative active during your chosen time window?
- SELECT creative, creative_id, SUM(impressions) AS impressions FROM sponsored_ads_traffic GROUP BY 1,2
- SELECT creative, creative_id, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1,2
- SELECT creative, creative_id, SUM(impressions) AS impressions FROM dsp_impressions WHERE creative IS LIVE GROUP BY 1,2
- SELECT creative, creative_id, SUM(impressions) AS impressions FROM amazon_attributed_events_by_traffic_time GROUP BY 1,2