I have a query for creating a report. How I can apply a filter for custom dimensions

[Дмитрий Сергеевич]

I have a query for creating a report. How I can apply a filter for custom dimensions ('customDimensionKeyIds': [160412,112192]) ?

report_job["reportQuery"] = {

                   'dimensions': [

                       'DATE',

                        'CUSTOM_DIMENSION'

                   ],

                   'adUnitView': 'FLAT',

                   'columns': [

                       'TOTAL_LINE_ITEM_LEVEL_IMPRESSIONS'

                   ],

                    'dimensionAttributes': [],

                   'customFieldIds': [],

                   'customDimensionKeyIds': [160412,112192],

                   'startDate': {

                       'year': 2019,

                       'month': 11,

                       'day': 10

                   },

                   'endDate': {

                       'year': 2019,

                       'month': 11,

                       'day': 16

                   },

                   'dateRangeType': 'CUSTOM_DATE',

                   'statement': {

                       'query': " where request_type in ('123')",

                       'values': []

                   },

                   'includeZeroSalesRows': False,

                   'adxReportCurrency': None,

                   'timeZoneType': 'PUBLISHER'

               }

[Ad Manager API Forum Advisor Prod]

Hi Dmitriy,

 

I’m afraid that using custom dimensions to filter reports is currently unsupported in the Ad Manager API. You may confirm this by creating a saved query in the UI by including the "Custom dimensions" dimension, and then add a filter for the specific custom dimension. Afterwards, you may try to retrieve it via API to confirm if it is indeed supported. For now, you may use the UI in order to achieve what you want to do. You may follow our blog and release notes for future updates on this topic.

 

Let me know if you have further clarifications

 

Regards,

Kevin Soriano, Ad Manager API Team

ref:_00D1U1174p._5001UOCrbw:ref