Urgent: Duplicate records from Google Ads API

[Ivy Liu]

Hi Google Ads API team,

We have seen duplicate many duplicate records from the API since Sep 8.

We didn't expereince such issue before. This new issue has increased our data sync volume by many times and causes our data sync to fail.

The table that has seen the most duplicate records is campaign_with_geo.

This is the custom query we use.

SELECT campaign.id, campaign.name, campaign.status, campaign.advertising_channel_type, segments.geo_target_state, segments.geo_target_county, segments.geo_target_region, segments.geo_target_city, metrics.clicks, metrics.conversions, metrics.conversions_value, metrics.cost_micros, metrics.impressions FROM geographic_view WHERE metrics.cost_micros > 0 PARAMETERS omit_unselected_resource_names=true

Could you advise what has changed from Google API's end, and how shall we proceed?

Best,

Ivy

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

Based on the information provided, I understand that you are seeing duplicate records from the API since Sep 8. I can confirm that there are no changes made from the Google Ads API perspective. Also, I can confirm that there are no issues with the Google Ads API. The Geographic View includes all metrics aggregated at the country level, one row per country. It reports metrics at either actual physical location of the user or an area of interest. If other segment fields are used, you may get more than one row per country. 

Could you please share with us the uncropped UI screenshot along with the complete API logs (request and response with request-id and request header) generated at your end.

If you are using a client library and haven't enabled the logging yet, I would request you to enable logging for the specific client library that you are using. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag.

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._5004Q2okIDA:ref"

Thanks,

Google Ads API Team