Report generation fails when paid search external dimensions are requested

[Pawel Lewtak]

Hi,

I'm trying to create a report that'd contain any of "paid search external" dimensions and total conversions to check if I get valid response from API.

Report generation request looks good and after few checks for the status it always returns "FAILED" in the end. What could be the cause for it?

Report fails to be generated regardless of exact field used: paidSearchExternalAdGroupId, paidSearchExternalAdId, paidSearchExternalCampaignId, paidSearchExternalKeywordId.

Endpoint used along with body content are below:

https://www.googleapis.com/dfareporting/v3.5/userprofiles/5451566/reports
{
    "floodlightCriteria": {
        "dimensionFilters": [
            {
                "kind": "dfareporting#dimensionValue",
                "dimensionName": "advertiser",
                "matchType": "EXACT",
                "id": "9426372"
            }
        ],
        "dateRange": {
            "startDate": "2022-03-22",
            "endDate": "2022-03-23",
            "kind": "dfareporting#dateRange"
        },
        "dimensions": [
            {
                "kind": "dfareporting#sortedDimension",
                "name": "paidSearchExternalKeywordId"
            }
        ],
        "floodlightConfigId": {
            "dimensionName": "floodlightConfigId",
            "value": "9420715"
        },
        "metricNames": [
            "totalConversions"
        ]
    },
    "name": "SupermetricsQuery",
    "type": "FLOODLIGHT"
}

https://www.googleapis.com/dfareporting/v3.5/userprofiles/5451566/reports/935776353/run?synchronous=true

Response:
{
  "kind": "dfareporting#file",
  "etag": "pTigzOEb6s0igcFpm2pSHciB63E",
  "reportId": "935776353",
  "id": "3646215173",
  "lastModifiedTime": "1648713978000",
  "status": "FAILED",
  "fileName": "",
  "dateRange": {
    "kind": "dfareporting#dateRange",
    "startDate": "2022-03-22",
    "endDate": "2022-03-23"
  }
}

Kind regards,

Paweł

[DCM API (DoubleClick Campaign Mgr)]

Hello Pawel,

 

Michael here from DCM API Team.

 

Would you be able to share with us the pair of request body & API Response from the creation of the report in question? Additionally, share with us the DCM Account ID for us to have a closer look at the issue.

You may send the requested details privately via "Reply To Author" button.

As a side note, I have remove the first post from the forum as it contains sensitive information.

Regards,

Michael Angelo DCM API Team

ref:_00D1U1174p._5004Q2ZINQs:ref