CM360 API Report Generation Failure

[datateam muenchen]

Dear CM360 API Team,

currently we have a problem with the Report Generation trough API.

We are generating a new report via POST request

POST /dfareporting/v4/userprofiles/{profileId}/reports

{
    "criteria": {
        "dateRange": {
            "endDate": "2025-08-12",
            "startDate": "2025-08-12"
        },
        "dimensionFilters": [
            {
                "dimensionName": "advertiserId",
                "matchType": "EXACT",
                "value": "{advertiserId}"
            }
        ],
        "dimensions": [
            {
                "name": "paidSearchCampaignId"
            },
            {
                "name": "activity"
            },
            {
                "name": "date"
            }
        ],
        "metricNames": [
            "paidSearchActions"
        ]
    },
    "format": "csv",
    "name": "Report",
    "type": "STANDARD"
}

Afterwards we are running the report:

POST /dfareporting/v4/userprofiles/{profileId}/reports/{reportId}/run

Normally we then receive a report "status" and i allready done the cloud storage path "urls.apiUrl".

If the report is still queued or processing we try to fetch the report status with exponential backoff via

GET /dfareporting/v4/userprofiles/{profileId}/reports/{reportId}

For some reports the later two request do not return a status or an apiurl and we can therefore not download the report. The returned json looks like following:

{
  "id": "...",
  "ownerProfileId": "...",
  "accountId": "...",
  "subAccountId": "...",
  "name": "...",
  "kind": "dfareporting#report",
  "type": "STANDARD",
  "etag": ""456d617a51f1cc081108e80088668bf99308b07a"",
  "lastModifiedTime": "1755072038000",
  "format": "CSV",
  "criteria": {
    "dateRange": {
      "startDate": "2025-08-12",
      "endDate": "2025-08-12",
      "kind": "dfareporting#dateRange"
    },
    "dimensions": [
      {
        "name": "paidSearchCampaignId",
        "kind": "dfareporting#sortedDimension"
      },
      {
        "name": "activity",
        "kind": "dfareporting#sortedDimension"
      },
      {
        "name": "date",
        "kind": "dfareporting#sortedDimension"
      }
    ],
    "metricNames": [
      "paidSearchActions"
    ],
    "dimensionFilters": [
      {
        "dimensionName": "advertiserId",
        "value": "...",
        "matchType": "EXACT",
        "kind": "dfareporting#dimensionValue",
        "etag": ""40fb2a72354c58523d264dc9ce38774f5c360a5c""
      }
    ]
  }
}

In the interface the report is generated and loading but we cannot download it programmatically. This is a very critical error as our customer reports are not working like that. Can you please support, why the returned jsons are not generated with the expected values?

Best

Maurus

[DCM API (DoubleClick Campaign Mgr)]

Hi,

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

To check the status of a specific report file, use the files.get method, providing the file ID. The status field in the response will indicate the file's processing status (e.g., "PROCESSING", "REPORT_AVAILABLE"). Once the status is "REPORT_AVAILABLE", the file is ready to download.

Additionally, you can use the Download Report Files, which allows you to download report files, which are the result of running a Report Builder report. 

It also enables direct file access through a link. Depending on your download needs, there are two methods to download the files:

1. Direct download — Use Files.get with the alt=media parameter.
2. Download files in a browser — Use the browserUrl from the Files resource.

For both methods, you'll need some prerequisite information:

• Report ID: The ID of the report to which the file belongs. You can get this by creating a new report or looking up an existing report.
• File ID: The ID of the file you want to download. You can find this after running the report or by querying the list of existing files.

The remaining sections of the guide will provide detailed instructions on how to download these files via the Files resource.

If you still can't download the file, please provide the following information so we can investigate further.

• The report ID and file ID.
• The Profile ID used during the API request.
• The user email/service account email used for authenticating the API query.
• Relevant uncropped DCM UI screenshot(s) showing the report's availability.

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

 

Thanks,
 

DCM API Team

Feedback
How was our support today?

               
[2025-08-13 18:39:58Z GMT] This message is in relation to case "ref:!00D1U01174p.!500Ht01syxcH:ref" (ADR-00329820)

[datateam muenchen]

Dear Google Support,

thank you. Fetching the status and the url from the file endpoint instead of the report endpoint worked. Probably the issues was, that the working reports all were able to run synchronously while the other were available asynchronously.

Best

Maurus