Google CM - Standard Report with floodlightVariableDimension Suddenly failing

[Ivan Hernandez]

Hi Support team.

We've been working with Standard report with floodlightVariableDimension3 dimension, this was working until yesterday with the API request

{

    "kind": "dfareporting#report",

    "ownerProfileId": "{{profile_id}}",

    "accountId": "{{google_account_id}}",

    "name": "test",

    "type": "STANDARD",

    "criteria": {

        "dateRange": {

            "kind": "dfareporting#dateRange",

            "startDate": "2025-04-01",

            "endDate": "2025-04-01"

        },

        "dimensions": [

            {"kind": "dfareporting#dimension","name": "date"},

            {"kind": "dfareporting#dimension","name": "advertiserId"},

            {"kind": "dfareporting#dimension","name": "advertiser"},

            {"kind": "dfareporting#dimension","name": "activityId"},

            {"kind": "dfareporting#dimension","name": "activity"},

            {"kind": "dfareporting#dimension","name": "activityGroupId"},

            {"kind": "dfareporting#dimension","name": "activityGroup"},

            {"kind": "dfareporting#dimension","name": "campaignId"},

            {"kind": "dfareporting#dimension","name": "campaign"},

            {"kind": "dfareporting#dimension","name": "placementId"},

            {"kind": "dfareporting#dimension","name": "placement"},

            {"kind": "dfareporting#dimension","name": "floodlightVariableDimension3"}

        ],

        "metricNames": [

            "activityClickThroughConversions",

            "activityViewThroughConversions",

            "totalConversions"

        ],

        "dimensionFilters": [

            {"kind": "dfareporting#dimensionValue",

                "dimensionName": "advertiser",

                "id": "{{advertiser_id}}",

                "matchType": "EXACT"

            },

            {

                "dimensionName": "floodlightConfigId",

                "value": "{{floodlight_config_id}}",

                "matchType": "EXACT",

                "kind": "dfareporting#dimensionValue"

            }

        ]

    }

} 

Today it's start failing with error.

{

    "error": {

        "code": 400,

        "message": "The combination of dimensions, metrics, and filters in your report is invalid.",

        "errors": [

            {

                "message": "The combination of dimensions, metrics, and filters in your report is invalid.",

                "domain": "global",

                "reason": "invalid"

            }

        ]

    }

}

Is there any change on API side? or how can we fix this?

Please let me know if any additional details are need.

[DCM API (DoubleClick Campaign Mgr)]

Hi,

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

Not all reporting fields work together. There is likely some combination of dimensions, metrics, or filters you've listed that is not valid. Since determining which fields work together can be quite tricky, we normally suggest using the Report Builder UI to help. The UI will automatically limit you to only valid combinations of fields. Once your report is created from the UI, you can use the API to run and make edits to it.

You can use Reports compatibleFields to determine which fields can be combined with the ones already in your report. Please note, not all dimensions, metrics, and filters can be used together. You could try removing some fields and then adding them back one by one while passing the report into Reports compatibleFields: query to determine where the incompatibility is. Please refer to this guide for more details on determining the field compatibility while creating reports via API. The API request is different from the UI request. Try to remove the advertiser filter from 'dimensionFilters'; the request should work.

If the issue remains the same, kindly include the complete API request (body & URL with path param values) and response in your response.

You can send the details via the 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-19 23:45:50Z GMT] This message is in relation to case "ref:!00D1U01174p.!500Ht01u4hvk:ref" (ADR-00330428)