How would you adapt this query to obtain cost and impression metrics by supply_source? SELECT device_type, operating_system, SUM(total_cost)/100000 AS total_cost_dollars, ((SUM(total_cost)/100000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1,2

Advertisement

Here is the answer of the question: How would you adapt this query to obtain cost and impression metrics by supply_source? SELECT device_type, operating_system, SUM(total_cost)/100000 AS total_cost_dollars, ((SUM(total_cost)/100000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1,2

  • SELECT supply_source, SUM(total_cost)/100000000 AS total_cost_dollars, ((SUM(total_cost)/100000000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_inventory GROUP BY 1
  • SELECT supply_source, SUM(total_cost)/100000 AS total_cost_dollars, ((SUM(total_cost)/100000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1,2
  • *SELECT supply_source, SUM(total_cost)/100000 AS total_cost_dollars, ((SUM(total_cost)/100000)/SUM(impressions))1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1

The above question is related to “Amazon Marketing Cloud Certification Exam“. You can find all the updated questions and answers related to to “Amazon Marketing Cloud Certification Exam” on the “Amazon Marketing Cloud Certification Exam Answers” page. If you find the update in question or answers, do comment on this page and let us know. We will update the answers as soon as possible.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top