¿Qué fórmula utilizarías para calcular el CPM de Amazon DSP utilizando los campos disponibles en dsp_impressions (impresiones de DSP)?

The correct formula calculates CPM (Cost Per Mille, or cost per thousand impressions) by dividing the total cost by the number of impressions, then multiplying by 1000. In Amazon Marketing Cloud (AMC), totalcost is typically reported in micro-dollars (millionths of a dollar), so dividing by 1000000 converts it to dollars. The formula provided in the correct option uses SUM(totalcost)/100000), which implies totalcost is in hundredths of a dollar (cents), or that the division by 100000 is an error and should be 1000000. Assuming totalcost is in cents, SUM(totalcost)/100000 would convert it to thousands of dollars, which is then divided by SUM(impressions) and multiplied by 1000 to get CPM. The second option incorrectly divides spend by 100000000, which is too large a conversion factor. The third option incorrectly divides by 1000 at the end instead of multiplying.