Hi Team, We are getting duplicate records in the geographic_view report. Adding details of request and response below: ---------------------------------------------------------------------------------------------------------
Endpoint: https://googleads.googleapis.com/v16/customers/*PLACEHOLDER* /googleAds:searchStream Http Verb: POST Body: {"query":"SELECT geographic_view.country_criterion_id, metrics.clicks FROM geographic_view WHERE segments.date >= '2024-07-01' AND segments.date <= '2024-07-11' ORDER BY geographic_view.country_criterion_id ASC PARAMETERS omit_unselected_resource_names = true","summary_row_setting":"SUMMARY_ROW_WITH_RESULTS"} ----------------------------------------------------------------------------------------------------------------- Response: { "config": { "url": "https://googleads.googleapis.com/v16/customers/PLACE_HOLDER/googleAds:searchStream?", "method": "POST", "data": { "query": "SELECT geographic_view.country_criterion_id, metrics.clicks FROM geographic_view WHERE segments.date >= '2024-07-01' AND segments.date <= '2024-07-11' ORDER BY geographic_view.country_criterion_id ASC PARAMETERS omit_unselected_resource_names = true", "summary_row_setting": "SUMMARY_ROW_WITH_RESULTS" }, "headers": { "Content-Type": "application/json", "developer-token": "PLACE_HOLDER", "client-customer-id": "PLACE_HOLDER", "login-customer-id": "PLACE_HOLDER", "Authorization": "Bearer Token Placeholder", "User-Agent": "google-api-nodejs-client/8.7.0", "x-goog-api-client": "gl-node/20.15.0 auth/8.7.0", "Accept": "application/json" }, "body": "{\"query\":\"SELECT geographic_view.country_criterion_id, metrics.clicks FROM geographic_view WHERE segments.date >= '2024-07-01' AND segments.date <= '2024-07-11' ORDER BY geographic_view.country_criterion_id ASC PARAMETERS omit_unselected_resource_names = true\",\"summary_row_setting\":\"SUMMARY_ROW_WITH_RESULTS\"}", "responseType": "json" }, "data": [ { "results": [ { "metrics": { "clicks": "43" }, "geographicView": { *"countryCriterionId": "2840"* } }, { "metrics": { "clicks": "18" }, "geographicView": { *"countryCriterionId": "2840"* } } ], "fieldMask": "geographicView.countryCriterionId,metrics.clicks", "requestId": "MKaYz8OEyY2osFhb0fMvaQ", "queryResourceConsumption": "7078" }, { "fieldMask": "geographicView.countryCriterionId,metrics.clicks", "summaryRow": { "metrics": { "clicks": "61" } }, "requestId": "MKaYz8OEyY2osFhb0fMvaQ", "queryResourceConsumption": "7329" } ], "headers": { "alt-svc": "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000", "cache-control": "private", "connection": "close", "content-encoding": "gzip", "content-type": "application/json; charset=UTF-8", "date": "Thu, 11 Jul 2024 13:03:14 GMT", "server": "ESF", "transfer-encoding": "chunked", "vary": "Origin, X-Origin, Referer", "x-content-type-options": "nosniff", "x-frame-options": "SAMEORIGIN", "x-xss-protection": "0" }, "status": 200, "statusText": "OK", "request": { "responseURL": "https://googleads.googleapis.com/v16/customers/PLACE_HOLDER/googleAds:searchStream?" } } ----------------------------------------------------------------------------------------- As you can observe in the above request, we are requesting geographic_view.country_criterion_id but we are getting two rows in the response. As per my understanding of the API documentation and replies on the threads in this forum this shouldn't be the case. Request you to please help us understand and resolve this issue. Thanking you in anticipation! Akash Tomar -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/276562fb-c2e7-450b-84f4-38f96c79f8ebn%40googlegroups.com.