Latest:
Amazon Marketing Cloud Certification 

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

Editorial Staff
  • (SUM(total_cost)/100000)/(SUM(impressions))*1000 AS avg_cpm
  • ((SUM(spend)/100000000)/SUM(impressions))*1000 AS avg_cpm
  • ((SUM(total_cost)/100000)/SUM(impressions))/1000 AS avg_cpm

The correct answer is:

  • ((SUM(spend)/100000000)/SUM(impressions))*1000 AS avg_cpm

🎓 Get all the latest and 100% correct Amazon Marketing Cloud Certification Exam Answers

You May Also Like

Why is it considered a good best practice to exclude NULL user_id values from reach and frequency queries?

Editorial Staff 0

New-to-brand metrics are only relevant for __________.

Editorial Staff 0

Where can you find the details of the entities (Amazon DSP, sponsored ads, etc.) linked to an AMC Instance?

Editorial Staff 0