ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS

[astro.d...@gmail.com]

Hi All,

I am getting this error :

ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'TOTAL_INVENTORY_LEVEL_UNFILLED_IMPRESSIONS

I am trying to us it in Ad-Unit with below dimensions :

[ 'AD_UNIT_NAME','AD_UNIT_ID','DATE','DEVICE_CATEGORY_ID','DEVICE_CATEGORY_NAME','MOBILE_APP_NAME','MOBILE_DEVICE_NAME','MOBILE_INVENTORY_TYPE']

[admanagerapi...@google.com]

Hi,

Upon checking, TOTAL_INVENTORY_LEVEL_UNFILLED_IMPRESSIONS is not compatible with MOBILE_APP_NAME, MOBILE_DEVICE_NAME, MOBILE_INVENTORY_TYPE dimensions. As an alternative, you may create a query in the UI to check the compatibility of the dimensions and metrics.  If it's indeed possible in the UI, then it should also be possible in the API. Also, once you created a query, then you may retrieve it via API using ReportService.getSavedQueriesByStatement.

Let me know if you have further clarifications.

Thanks,
Kevin Soriano, Ad Manager API Team

______________________________________________________________________
 An important reminder: v201805 has been deprecated.

 Give us your feedback:
     Feedback Survey

 Also find us on our blog and discussion group:
     http://googleadsdeveloper.blogspot.com/search/label/ad_manager_api
     https://developers.google.com/ad-manager/api/community

--
You received this message because you are subscribed to the Google Groups "Google Ad Manager API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-doubleclick-for-publishers-api+unsubscribe@googlegroups.com.
To post to this group, send email to google-doubleclick-for-publishers-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-doubleclick-for-publishers-api.
For more options, visit https://groups.google.com/d/optout.

[astro.d...@gmail.com]

Hi,

Thank You! It worked that way. I am now stuck with another situation, when I try to fetch Ad-unit, Line Item and Creative in a query from UI i get the report. However when i am trying using the code it gives error. Here is what i am trying :

report_job = {

        'reportQuery': {

            'dimensions': ['DATE', 'AD_UNIT_NAME', 'LINE_ITEM_NAME', 'CREATIVE_NAME', 'ORDER_NAME',

                           'AD_UNIT_ID', 'LINE_ITEM_ID''CREATIVE_ID','ORDER_ID','AD_EXCHANGE_DEAL_ID','CREATIVE_SIZE'],

            'adUnitView': 'HIERARCHICAL',

            'dimensionAttributes': ['ORDER_AGENCY', 'ORDER_AGENCY_ID', 'ORDER_TRAFFICKER',

                                    'ORDER_TRAFFICKER_ID', 'ORDER_SALESPERSON', 'LINE_ITEM_DELIVERY_INDICATOR',

                                    'LINE_ITEM_DELIVERY_PACING', 'LINE_ITEM_FREQUENCY_CAP',

                                    'LINE_ITEM_START_DATE_TIME', 'LINE_ITEM_END_DATE_TIME',

                                    'LINE_ITEM_COST_TYPE', 'LINE_ITEM_COST_PER_UNIT', 'LINE_ITEM_CURRENCY_CODE',

                                    'LINE_ITEM_GOAL_QUANTITY', 'LINE_ITEM_SPONSORSHIP_GOAL_PERCENTAGE',

                                    'LINE_ITEM_LIFETIME_IMPRESSIONS', 'LINE_ITEM_LIFETIME_CLICKS',

                                    'LINE_ITEM_PRIORITY', 'LINE_ITEM_CONTRACTED_QUANTITY',

                                    'LINE_ITEM_DISCOUNT', 'LINE_ITEM_NON_CPD_BOOKED_REVENUE',

                                    'LINE_ITEM_CREATIVE_START_DATE', 'LINE_ITEM_CREATIVE_END_DATE'],

            'columns': ['TOTAL_CODE_SERVED_COUNT', 

                        'DYNAMIC_ALLOCATION_INVENTORY_LEVEL_IMPRESSIONS',

                        'DYNAMIC_ALLOCATION_INVENTORY_LEVEL_CLICKS',

                        'TOTAL_INVENTORY_LEVEL_IMPRESSIONS', 'TOTAL_INVENTORY_LEVEL_CLICKS',

                        'TOTAL_INVENTORY_LEVEL_CTR', 'TOTAL_INVENTORY_LEVEL_CPM_AND_CPC_REVENUE',

                        'TOTAL_INVENTORY_LEVEL_ALL_REVENUE', 'TOTAL_INVENTORY_LEVEL_WITHOUT_CPD_AVERAGE_ECPM',

                        'TOTAL_INVENTORY_LEVEL_WITH_CPD_AVERAGE_ECPM', 'TOTAL_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS',

                        'TOTAL_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS', 'TOTAL_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS_RATE',

                        'TOTAL_ACTIVE_VIEW_ELIGIBLE_IMPRESSIONS', 'TOTAL_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS_RATE',

                        'TOTAL_ACTIVE_VIEW_REVENUE', 'TOTAL_INVENTORY_LEVEL_UNFILLED_IMPRESSIONS',

                        'VIDEO_VIEWERSHIP_START',

                        'VIDEO_VIEWERSHIP_FIRST_QUARTILE', 'VIDEO_VIEWERSHIP_MIDPOINT',

                        'VIDEO_VIEWERSHIP_THIRD_QUARTILE', 'VIDEO_VIEWERSHIP_COMPLETE'

                        ],

            'dateRangeType': 'YESTERDAY'

        }

    }

And the error :

googleads.errors.GoogleAdsServerFault: [ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'TOTAL_ACTIVE_VIEW_ELIGIBLE_IMPRESSIONS, TOTAL_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS, TOTAL_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS_RATE, TOTAL_ACTIVE_VIEW_REVENUE, TOTAL_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS, TOTAL_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS_RATE, TOTAL_CODE_SERVED_COUNT, TOTAL_INVENTORY_LEVEL_ALL_REVENUE, TOTAL_INVENTORY_LEVEL_UNFILLED_IMPRESSIONS, TOTAL_INVENTORY_LEVEL_WITH_CPD_AVERAGE_ECPM, VIDEO_VIEWERSHIP_COMPLETE, VIDEO_VIEWERSHIP_FIRST_QUARTILE, VIDEO_VIEWERSHIP_MIDPOINT, VIDEO_VIEWERSHIP_START, VIDEO_VIEWERSHIP_THIRD_QUARTILE']

When I tried to remove the fields above, it gives below issues :

googleads.errors.GoogleAdsServerFault: [ReportError.NOT_NULL @ columns]

This error is confusing because i do have few columns in column list.

Not sure how to get Ad-unit, Line-item and Creative deliveries in one report, because in the current set-up one multiple ad-units are referring to same line item which is again having multiple creative. 

[admanagerapi...@google.com]

Hi,

I'm unable to create a report query in the UI with the dimensions, dimension attributes and metrics you've provided. If it's indeed possible in the UI, can you provide the saved query id of the report query, email address of the user who created the saved query and your network code so I can further investigate? You can send these to me via Reply privately to author option.

Thanks,

Kevin Soriano, Ad Manager API Team

______________________________________________________________________
 An important reminder: v201805 has been deprecated.

 Give us your feedback:
     Feedback Survey

 Also find us on our blog and discussion group:
     http://googleadsdeveloper.blogspot.com/search/label/ad_manager_api
     https://developers.google.com/ad-manager/api/community