How to combine Activity and Paid search dimensions

[Roman Vinogradov]

Hi,

Is it possible to request PaidSearch and Activity dimensions in one report? We are trying to pull such combination, but get an error: "The combination of dimensions, metrics, and filters in your report is invalid"

Full request:

{
    "name": "stat_report",
    "type": "STANDARD",
    "criteria": {
        "dateRange": {
            "startDate": "2020-03-30",
            "endDate": "2020-04-20"
        },
        "dimensions": [
            {
                "name": "dfa:paidSearchAdvertiserId"
            },
            {
                "name": "dfa:paidSearchAdvertiser"
            },
            {
                "name": "dfa:paidSearchCampaignId"
            },
            {
                "name": "dfa:paidSearchCampaign"
            },
            {
                "name": "dfa:paidSearchAdGroupId"
            },
            {
                "name": "dfa:paidSearchAdGroup"
            },
            {
                "name": "dfa:activityId"
            }
        ],
        "metricNames": [
            "dfa:paidSearchClicks",
            "dfa:paidSearchCost",
            "dfa:paidSearchImpressions",
            "dfa:paidSearchRevenue",
            "dfa:paidSearchClickRate",
            "dfa:paidSearchAveragePosition",
            "dfa:paidSearchAverageDfaTransactionAmount",
            "dfa:paidSearchAverageCostPerTransaction",
            "dfa:paidSearchAverageCostPerAction",
            "dfa:paidSearchActions",
            "dfa:paidSearchActionConversionPercentage",
            "dfa:paidSearchSpendPerTransactionRevenue",
            "dfa:paidSearchTransactionConversionPercentage",
            "dfa:paidSearchTransactionRevenuePerSpend",
            "dfa:paidSearchTransactions",
            "dfa:paidSearchVisits"
        ]
    }
}

Response:

{
    "error": {
        "errors": [
            {
                "domain": "global",
                "reason": "invalid",
                "message": "The combination of dimensions, metrics, and filters in your report is invalid."
            }
        ],
        "code": 400,
        "message": "The combination of dimensions, metrics, and filters in your report is invalid."
    }
}

Thank you!

[DCM API (DoubleClick Campaign Mgr)]

Hi there,

Thank you for reaching out to us. 

You could use the Report Builder UI to create reports which will constantly update as you add fields, to let you know which can be used together. If the fields you added on the UI is not compatible, then this is not compatible on the API as well. You may also want to check this guide for more details on determining the field compatibility while creating reports via API.

Regards,
Teejay Pimentel
DCM API Team

ref:_00D1U1174p._5001UaSm8E:ref