Amazon Marketing Cloud Certification Answers

What formula would you use to calculate Amazon DSP CPM using the fields available in dsp_impressions?

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

What formula would you use to calculate Amazon DSP CPM using the fields available in dsp_impressions?

  1. (SUM(total_cost)/100000)/(SUM(impressions))*1000 AS avg_cpm
  2. ((SUM(spend)/100000000)/SUM(impressions))*1000 AS avg_cpm
  3. ((SUM(total_cost)/100000)/SUM(impressions))/1000 AS avg_cpm

Latest Updates

No posts found in this category.