Report Query - DP_ECPM field

[Jessyca Moraes]

We need to collect the total average eCPM. Consulting the API documentation, we understood that it would be the DP_ECPM column.

However, when we run the Report Query, it gives an error regarding the currency we requested: [ReportError.CURRENCY_CODE_NOT_SUPPORTED_FOR_REQUESTED_REPORT @ ; trigger:'BRL; DP_ECPM']

Removing this currency specification continues to give an error, but of: [ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'DP_ECPM', ReportError.COLUMN_VIEW_NOT_ALLOWED @ columns; trigger:'DP_ECPM']

report_job = {

    'reportQuery': {

        'dimensions': ['AD_UNIT_NAME','DATE','HOUR'],

        'adUnitView': 'FLAT',

        'columns': ['DP_ECPM'],

        'dateRangeType': 'CUSTOM_DATE',

        'startDate': start_date,

        'endDate': end_date,

        'statement': {'query': f"WHERE HOUR = {today_date_previous_hour.hour} AND LINE_ITEM_TYPE <> 'HOUSE'"}#,

        #'reportCurrency': 'BRL'

    }

}

I tested removing some of the dimensions, but the problem remained.

[Ad Manager API Forum Advisor]

Hi,

Thank you for contacting the Ad Manager API support team.

Kindly allow me to raise this issue with the rest of our team and one of our colleagues will reach out to you once we have an update on this.

 

This message is in relation to case "ref:!00D1U01174p.!5004Q02tJ6nj:ref" (ADR-00236833)

Thanks,
 

Ad Manager API Team

 

[Ad Manager API Forum Advisor]

Hi Jessyca,

The Column to use for total average eCPM is TOTAL_LINE_ITEM_LEVEL_WITHOUT_CPD_AVERAGE_ECPM. The DP_ prefixed columns are for Ad Connector reports which may not be enabled on your network.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02tJ6nj:ref" (ADR-00236833)

Thanks,
 

Chris Seeley Ad Manager API Team