Duplicates with Google Campaign Manager

[Ronak Pahadia]

Hello Team, We are getting duplicates in the report which we want to avoid, can you share some insight on this, or the right combination of dimensions to avoid duplicates.

I tried adding multiple dimensions but failing everytime to generate unique records.

{
    "id": null,
    "ownerProfileId": "******",
    "accountId": "******",
    "name": "******",
    "fileName": "*******",
    "kind": "dfareporting#report",
    "type": "STANDARD",
    "etag": null,
    "lastModifiedTime": null,
    "format": "CSV",
    "criteria": {
        "dateRange": {
            "relativeDateRange": "LAST_90_DAYS",
            "kind": "dfareporting#dateRange"
        },
        "dimensions": [
            {
                "name": "date",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "campaign",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "campaignId",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "site",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "siteId",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "placement",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "placementId",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "advertiser",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "advertiserId",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "creative",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "creativeId",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "activity",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "activityId",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "packageRoadblock",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "packageRoadblockId",
                "kind": "dfareporting#sortedDimension"
            },
            {
                "name": "city",
                "kind": "dfareporting#sortedDimension"
            },
{
                "name": "campaignExternalId",
                "kind": "dfareporting#sortedDimension"
            }
        ],
        "metricNames": [
            "impressions",
            "clicks",
            "mediaCost",
            "totalConversions",
            "richMediaVideoFirstQuartileCompletes",
            "richMediaVideoMidpoints",
            "richMediaVideoThirdQuartileCompletes",
            "richMediaVideoCompletions",
            "richMediaVideoPlays"
        ],
        "dimensionFilters": [
            {
                "dimensionName": "advertiser",
                "id": "********",
                "matchType": "EXACT",
                "kind": "dfareporting#dimensionValue",
                "etag": "\"********\""
            },
            {
                "dimensionName": "advertiser",
                "id": "********",
                "matchType": "EXACT",
                "kind": "dfareporting#dimensionValue",
                "etag": "\"********\""
            },
            {
                "dimensionName": "advertiser",
                "id": "********",
                "matchType": "EXACT",
                "kind": "dfareporting#dimensionValue",
                "etag": "\"********\""
            },
            {
                "dimensionName": "advertiser",
                "id": "********",
                "matchType": "EXACT",
                "kind": "dfareporting#dimensionValue",
                "etag": "\"********\""
            },
            {
                "dimensionName": "advertiser",
                "id": "********",
                "matchType": "EXACT",
                "kind": "dfareporting#dimensionValue",
                "etag": "\"********\""
            },
            {
                "dimensionName": "advertiser",
                "id": "********",
                "matchType": "EXACT",
                "kind": "dfareporting#dimensionValue",
                "etag": "\"********\""
            },
            {
                "dimensionName": "advertiser",
                "id": "********",
                "matchType": "EXACT",
                "kind": "dfareporting#dimensionValue",
                "etag": "\"********\""
            },
            {
                "dimensionName": "advertiser",
                "id": "********",
                "matchType": "EXACT",
                "kind": "dfareporting#dimensionValue",
                "etag": "\"********\""
            },
            {
                "dimensionName": "advertiser",
                "id": "********",
                "matchType": "EXACT",
                "kind": "dfareporting#dimensionValue",
                "etag": "\"********\""
            },
            {
                "dimensionName": "advertiser",
                "id": "********",
                "matchType": "EXACT",
                "kind": "dfareporting#dimensionValue",
                "etag": "\"********\""
            },
            {
                "dimensionName": "advertiser",
                "id": "********",
                "matchType": "EXACT",
                "kind": "dfareporting#dimensionValue",
                "etag": "\"********\""
            },
            {
                "dimensionName": "advertiser",
                "id": "********",
                "matchType": "EXACT",
                "kind": "dfareporting#dimensionValue",
                "etag": "\"********\""
            }
        ]
    },
    "schedule": {
        "active": false,
        "repeats": "DAILY",
        "every": 1,
        "startDate": "2023-06-23",
        "expirationDate": "2023-09-21",
        "timezone": "Asia/Dubai"
    },
    "delivery": {
        "emailOwner": false
    }
}

[DCM API (DoubleClick Campaign Mgr)]

Hi,

Thank you for contacting the DCM API support team.

I see that you have already raised this concern on another thread with the subject "Duplicates with Google Campaign Manager” and we have already responded there for this issue. To avoid multiple threads on the same issue, please take a look at that thread.

 

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

Thanks,
 

DCM API Team

[Ronak Pahadia]

Hello Team,

I have gone through my other conversation but didn't find any solution for this, in that case can u share me the link of it so that I can look.
Also, I have prepared the details of profile ID, report ID, API, response and other which is required to debug but let me look into the link that you will share for the solution, if that helps then I will skip passing the details.

Regards,

Ronak

[DCM API (DoubleClick Campaign Mgr)]

Hi Team,

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

I see that you have already raised this concern on another thread with the subject 'Duplicates with Google Campaign Manager', and we have already responded there for this issue. To avoid multiple threads on the same issue, please take a look at that thread and continue the discussion on the same for further updates on the issue.