python-3.xgoogle-ads-apigoogle-dfpgoogle-ad-manager

Wrong CPM and revenue value Google AdManager Report API

I am trying to pull report from google ad manager using API

  report_job = {
  'reportQuery': {
      'dimensions': ['AD_EXCHANGE_DATE', 'AD_EXCHANGE_COUNTRY_NAME'],
      'columns': ['AD_EXCHANGE_AD_REQUESTS', 'AD_EXCHANGE_IMPRESSIONS',
                  'AD_EXCHANGE_ESTIMATED_REVENUE','AD_EXCHANGE_AD_ECPM'],
      'dateRangeType': 'LAST_WEEK',
      'timeZoneType': 'AD_EXCHANGE',  # Run in pacific time
      'adxReportCurrency': 'USD'
  }
  }

I suspect the downloaded report has very wired ECPM and Revenue values. as below

enter image description here

Please help if i am doing something wrong, as the ECPM has to be very low and the revenue as well.

Solution

  • "Money values are always specified in terms of micros which are a millionth of the fundamental currency unit. For US dollars, $1 is 1,000,000 micros."

    From the AdManager API official documentation here: https://developers.google.com/ad-manager/api/reference/v202008/LineItemService.Money#microAmount