Dimension combination issue when creating reports with CM360 API

[泰明彦]

Hello

I would like to ask a question regarding the API for creating a new report in CM360 (https://developers.google.com/doubleclick-advertisers/rest/v4/reports/insert).

When specifying the dimensions in the Report object of the request body with the following three columns: operatingSystem, platformType, and browserPlatform, I receive the error below, and the report cannot be created.  

Error details:
Status Code: 400
Response body:
{
    'message': 'The combination of dimensions, metrics, and filters in your report is invalid.',
    'domain': 'global',
    'reason': 'invalid'
}

  The error message indicates that "the combination of dimensions(operatingSystem, platformType, and browserPlatform) is invalid." However, I can create a report containing these three columns as dimensions from the CM360 UI, so I suspect that this may not be an actual invalid combination but an issue with the API validation.

Therefore, I would like to ask the following:

• Could this issue be caused by a problem with the API validation?
• If so, would it be possible to fix this issue in the API?
• If not, what should I modify to resolve it?

For reference, I have attached the full request where the issue occurs (body.json).

Additionally, here is some information regarding our environment:

Environment information:

• API Version: dfareporting v4
• Language: Python 3.12

Thanks

[DCM API (DoubleClick Campaign Mgr)]

Hi,

Thank you for reaching out to the DCM API support team.

I understand that you are facing issues while creating the report. The error indicates that there is incompatibility in terms of the provided dimensions, metrics and filters and all dimensions and metrics won't be compatible while generating the report. You can use the  reports.compatibleFields.query method, to verify the fields that are compatible to be selected in the respective sections of a report criteria. 

• Could this issue be caused by a problem with the API validation?

           The issue is with incompatibility or invalid combinations.

• If so, would it be possible to fix this issue in the API?

          Yes, it is possible to fix the issue.

• If not, what should I modify to resolve it?

         You can try removing some fields and then add them back one by one while passing the report into reports.compatibleFields.query to determine where the incompatibility is.

 

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

Thanks,
 

DCM API Team

                                     
 

[泰明彦]

What I would like to understand is why the combination of dimensions, which is possible to create in the CM360 UI, is considered invalid when using the API.

I also tried using the  reports.compatibleFields.query API. For example, when I provide a report with only operatingSystem as the dimension, the response does not include  browserPlatform in the reachReportCompatibleFields.dimensions . This confirms that the API deems these two dimensions as incompatible.

However, I believe this incompatibility, along with the validation, may be a bug in the API.

As a reference, here is the report ID for a report created via the CM360 UI, which includes all three dimensions ( operatingSystem, platformType, and browserPlatform  ):

Report ID: 1339466824

In our business, we run approximately 20 campaigns per month, and we currently create all the reports for these campaigns manually through the UI. It would be highly inconvenient if we cannot automate this process via the API, so I would appreciate it if you could investigate this issue.

2024年10月23日水曜日 0:32:50 UTC+9 DCM API (DoubleClick Campaign Mgr):

[DCM API (DoubleClick Campaign Mgr)]

Hi, 

I understand that you’re facing an issue where certain dimension combinations that are valid in the CM360 UI are marked as incompatible in the API. Specifically, you've noted that when using the 'reports.compatibleFields.query', dimensions like 'operatingSystem' and 'browserPlatform' are causing errors despite being compatible in the UI.

To help us investigate this further and understand the root of the issue, could you please provide the following details:

• DCM Account ID- You can find under your profile icon in your Campaign Manager 360 UI. You can also find it in the Account section, which is located under the Admin drop-down.
• Profile ID used in the execution/request call
• Request body & URL endpoint request with path param values
• Complete API JSON request and response showing the issue or error encountered(as in the provided request body the necessary details are redacted).

[DCM API (DoubleClick Campaign Mgr)]

Hi,

Please ignore my previous email.

I understand that you’re facing an issue where certain dimension combinations that are valid in the CM360 UI are marked as incompatible in the API. Specifically, you've noted that when using the 'reports.compatibleFields.query' API, dimensions like 'operatingSystem' and 'browserPlatform' are causing errors despite being compatible in the UI.

To help us investigate this further and understand the root of the issue, could you please provide the following details:

• DCM Account ID- You can find under your profile icon in your Campaign Manager 360 UI. You can also find it in the Account section, which is located under the Admin drop-down.
• Profile ID used in the execution/request call
• Request body & URL endpoint request with path param values
• Complete API JSON request and response showing the issue or error encountered(as in the provided request body the necessary details are redacted).

You can send the details via Reply privately to the author option, or direct private reply to this email.