Advertisement
Here is the answer of the question: What formula would you use to calculate Amazon DSP CPM using the fields available in dsp_impressions?
- (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 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.
Subscribe to our mailing list and get interesting stuff and updates to your email inbox.