Duplicates with Google Campaign Manager

Gabriel Castellanos

unread,

Sep 1, 2023, 3:57:00 PM9/1/23

to Google's Campaign Manager 360 API Forum

I would like to know how to avoid duplicates in Google Campaign Manager, because I'm getting a lot of duplicated rows

Endpoint: https://www.googleapis.com/dfareporting/v4/userprofiles/{{profile_id}}/reports?alt=json

Body:

{

    "kind": "dfareporting#report",
    "ownerProfileId": "{{profile_id}}",
    "accountId": "{{account_id}}",
    "name": "improvado_report",
    "type": "STANDARD",
    "criteria": {
        "dateRange": {
            "kind": "dfareporting#dateRange",
            "startDate": "2023-07-23",
            "endDate": "2023-07-23"
        },
        "dimensions": [
            {
                "kind": "dfareporting#dimension",
                "name": "advertiser"
            },
            {
                "kind": "dfareporting#dimension",
                "name": "advertiserId"
            },
            {
                "kind": "dfareporting#dimension",
                "name": "campaign"
            },
            {
                "kind": "dfareporting#dimension",
                "name": "campaignId"
            },
            {
                "kind": "dfareporting#dimension",
                "name": "city"
            },
            {
                "kind": "dfareporting#dimension",
                "name": "country"
            },
            {
                "kind": "dfareporting#dimension",
                "name": "creative"
            },
            {
                "kind": "dfareporting#dimension",
                "name": "creativeId"
            },
            {
                "kind": "dfareporting#dimension",
                "name": "site"
            },
            {
                "kind": "dfareporting#dimension",
                "name": "siteId"
            },
            {
                "kind": "dfareporting#dimension",
                "name": "date"
            },
            {
                "kind": "dfareporting#dimension",
                "name": "state"
            },
            {
                "kind": "dfareporting#dimension",
                "name": "activity"
            }

        ],
        "metricNames": [
            "activeViewEligibleImpressions",
            "activeViewMeasurableImpressions",
            "activeViewViewableImpressions",
            "activityClickThroughConversions",
            "activityClickThroughRevenue",
            "activityViewThroughConversions",
            "activityViewThroughRevenue",
            "clickRate",
            "clicks",
            "impressions",
            "mediaCost",
            "totalConversions",
            "totalConversionsRevenue"
        ],
        "dimensionFilters": [
            {
                "kind": "dfareporting#dimensionValue",
                "dimensionName": "advertiser",
                "id": "{{advertiser_id}}",
                "matchType": "EXACT"
            }
        ]
    }
}

When I get the response file I get some rows with the same metrics values, I have tried to put more dimension to see If I missed one that is making this behavior but I always get the same duplicated metrics values

DCM API (DoubleClick Campaign Mgr)

unread,

Sep 4, 2023, 4:00:58 AM9/4/23

to google-doubleclick-...@googlegroups.com

Hello,

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

By reviewing your concern, I understand that you are receiving the duplicate rows while generating the report using the DCM API. Kindly share the following details to investigate further:

DCM Account Id.
Report Id / Query Id.
Complete API response body.
The downloaded report file where you are observing the duplicate rows.
Screenshot from the report file (please point out the rows where it is getting duplicated).
Can you confirm that you are facing the same issue while using the UI?
User profile Id.

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

This message is in relation to case "ref:_00D1U1174p._5004Q2oAGbU:ref"

Thanks,

DCM API Team

Message has been deleted

DCM API (DoubleClick Campaign Mgr)

unread,

Oct 5, 2023, 4:04:44 AM10/5/23

to ro...@gravitydata.co, google-doubleclick-...@googlegroups.com

Hello Ronak,

Thank you for getting back to us.

I would like to inform you that we do not have visibility to your older conversation. I understand that you are facing some issues while using the DCM API. Can you please provide the detailed description of the issue and kindly share the following details to investigate further:

DCM Account ID.
User profile Id.
Complete JSON request and response logs.
Error screenshots (if any).

Reply all

Reply to author

Forward