Columns not supported for requested dimensions, API incompatibility

[Jamie Druce]

Hi there,

I have been building and running a report daily via API for a while now, and have recently developed a need to add a new column (TOTAL_AD_REQUESTS).

However, adding this column throws the error: ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'TOTAL_AD_REQUESTS'

I attempted to build the report in the UI to see what the problem might be, but the UI allows this report to run just fine. So testing retrieval of this saved report via the API told me that isCompatibleWithApiVersion equals false.

I understand that not all aspects of the reporting UI is compatible with the API, but am just looking to understand where this incompatibility lies, as all the dimentions and columns i'm requesting are listed in the API documentation. 
Is there a direct conflict between two fields that im not aware of? for example. (that is mentioned or not mentioned somewhere in the docs).

Request Info:
Im using the PHP SDK v58.0
API version v202208

Report type: Historical
Date range: 7 days

ReportQueryAdUnitView: HIERARCHICAL

Dimensions: DATE, AD_UNIT_NAME

Columns: TOTAL_AD_REQUESTS, TOTAL_LINE_ITEM_LEVEL_ALL_REVENUE, TOTAL_LINE_ITEM_LEVEL_IMPRESSIONS, TOTAL_LINE_ITEM_LEVEL_CLICKS, TOTAL_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS, VIDEO_VIEWERSHIP_FIRST_QUARTILE, VIDEO_VIEWERSHIP_MIDPOINT, VIDEO_VIEWERSHIP_THIRD_QUARTILE, VIDEO_VIEWERSHIP_COMPLETE

I am also filtering out two ADVERTISER_ID's

[Ad Manager API Forum Advisor]

Hi Jamie,

Please refer to this email and ignore the previous communication which was having a formatting problem.

Upon checking from my end, I can confirm that "Total ad requests" is not compatible with the Advertiser filter. You may remove the Advertiser filter to add the Total ad requests dimension in the Ad Manager 360 (UI). For the mentioned errors, you may refer to the Reporting Basics documentation where it suggests that:

Why do I get the error ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS for my report?
Not all combinations of columns and dimensions are supported in Ad Manager. For complex reports, it may be easier to build a valid report in the UI and then retrieve it with the ReportService.getSavedQueriesByStatement method.

Why isn't my saved report compatible with the API?
Certain reporting features aren't available in the API. This includes columns, dimension attributes, dimensions, and date range types. For incompatible date range types, you can save the report with a supported type to make it retrievable, then alter the ReportQuery to meet your desired fixed date range.

After following all the steps, if you are still observing the same error then please share the following details to investigate further. You can send the required information via Reply privately to the author option, or a direct private reply to this email.

• Complete SOAP request and response logs (SOAP logging must be enabled) of the report.
• Screenshots of the Report Builder from UI.
• Screenshots from the UI of the report you had generated.
• Network Code.
• User Email.

Regards,

Chekurthi Ad Manager API Team

ref:_00D1U1174p._5004Q2dnZYY:ref

[Jamie Druce]

Ah thank you!

I know its difficult to do from a technical perspective and have the API surface it, but having insight into what the clash is, is invaluable.

Cheers