"cityId" field

[Gabriel Castellanos]

Hi support team.

Some time ago I asked here about a problem with duplicates including the "city" field in my API calls, you helped me verifying that the same information were shown through a report in the UI, and then I asked the reason of this behavior to the product team by your suggestion.

The product team told me that we could have more than one city with the same name in the same country, that could be the reason for duplicates but actually they are not because are for different cities geographically.

So then I started to look for a field to include in my API calls to make the diffence between the cities and for any reason or lucky I tried "cityId" field in my call and I got a successful response and a CSV file with this field included making the difference that I wanted between cities.

All seems to be good but the problem is that in the Google Campaign Manager documentation the "cityId" is not included anywhere for the dfareporting endopint, I can only see the "city" field and that's all, so I'm concern to include "cityId" field in my API calls If is not included in the documentation because I don't know If this is because is deprecated or It will be soon, I've asked this to the product support and they told me that in the UI the "cityId" field doesn't exis.

The question, for API reports is it ok to use the "cityId" field? 

This is how I request, I include "cityId" as the last dimension as you can see:

URL: 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": "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"

},

{

"kind": "dfareporting#dimension",

"name": "city"

},

{

"kind": "dfareporting#dimension",

"name": "cityId"

}

],

"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"

}

]

}

}

[DCM API (DoubleClick Campaign Mgr)]

Hi Team,

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

To investigate further we would need the following information from you :

• DCM Account ID
• Report ID
• Profile ID used in request call.
• Request body & URL with path param values.
• Generated report.

 You can send the details via Reply privately to the author option, or direct private reply to this email.

 

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

Thanks,
 

DCM API Team

 

[DCM API (DoubleClick Campaign Mgr)]

Hi Team,

Thank you for getting back to us.

I have raised your concern with the rest of our team and one of my teammates will get back to you once we have an update.

[Maurice AMSI]

please cc me at mpo...@autoadgroup.net

CM Report ID: Report ID: 1153023035
CM File ID: 4297299609
I see 4,417 impressions serving in the “New York” dma.
I see 34,019 impressions serving in less than 11 hours. in all combined DMA’s that are NOT Naples
That is too many to be a simple discrepancy.

CM360 Advertiser ID: 9250844
CM Campaign ID: 22408494 
If you look at all the ads, such as
FMIN-OTT30Sec-OTTDevices (C&D)

Ad ID: 559859034
That ad alone served 1,140 impressions in the New York DMA within the past 10 hours.

You’ll see the ads are targeting the targeting template
https://campaignmanager.google.com/trafficking/#/accounts/796079/advertisers/9250844/targetingtemplates
And the targeting template is ONLY targeting the Naples/Fort-Myers DMA. Nothing else.

Additionally, in dv360/dbm
https://campaignmanager.google.com/trafficking/#/accounts/796079/campaigns/22408494/explorer/ads/559936474?statuses=0;2&cm=eyJwcm9maWxlSWQiOjQyOTAxNjIsImxpc3RVcmwiOiIvYWNjb3VudHMvNzk2MDc5L2NhbXBhaWducz9zdGF0dXM9MSZhcmNoaXZlZD1mYWxzZSIsImNyaXRlcmlhIjp7InEiOiIiLCJzb3J0Ijoic3RhcnREYXRlIiwiZGVzYyI6dHJ1ZSwic3RhdHVzIjoiMSIsImFkdmVydGlzZXJHcm91cElkcyI6IiIsImFkdmVydGlzZXJJZHMiOiIiLCJlbmREYXRlRnJvbSI6IiIsImVuZERhdGVUbyI6IiIsInN0YXJ0RGF0ZUZyb20iOiIiLCJzdGFydERhdGVUbyI6IiIsInN1YmFjY291bnRJZCI6MCwiYXR0ciI6ImlkO25hbWU7YWR2ZXJ0aXNlci5pZDthZHZlcnRpc2VyLm5hbWU7YWR2ZXJ0aXNlci5zdXNwZW5kZWQ7c3RhcnREYXRlO2VuZERhdGU7YXJjaGl2ZWQ7YWR2ZXJ0aXNlckdyb3VwSWQ7c3ViYWNjb3VudElkO2RlZmF1bHRMYW5kaW5nUGFnZUlkO2V4dGVybmFsSWQiLCJ0eiI6IkFtZXJpY2EvTmV3X1lvcmsiLCJ0YWtlIjoxMDAsInNraXAiOjAsImFyY2hpdmVkIjpmYWxzZX19&co=0&placementId=369251778

The line items that are using those ads,
are EXLCUDING the New York DMA/City/State.

 

So if, in CM, I am ONLY targeting a targeting template with 1 singular DMA,
and in DV360, I am only targeting 1 dma, and EXCLUDING all other DMA’s and states and countryies…


how on earth am I serving 4,417 impressions serving in the “New York” dma.
and/or  34,019 impressions serving in all combined DMA’s that are NOT Naples?

--
You received this message because you are subscribed to the Google Groups "Google's Campaign Manager 360 API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-doubleclick-for-ad...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-doubleclick-for-advertisers-api/fPQWN000000000000000000000000000000000000000000000S1OW0Y00gaqxYMp3Sh2CdzvEZhlSjg%40sfdc.net.