Queries after AdWords to google-ads API migration

[Abhishek Kushwaha]

• I am getting duplicates when pulling the data using the python package for the google-ads api for the clicks performance report. I am using the SearchStreaming method and inserting each batch into the DB as it comes. No changes at all. So is there any bug in the python package?
• Are the tables contextual, i.e. is it the intended behaviour that when the METRO field is null, there is no data for the GEO Table?  Likewise, for the Keyword table, when no keyword is available, there is no data.Earlier in the Adwords reports account and campaigns were getting listed even if keyword or metro field corresponding to it was null
  
  Thanks!
  

[Google Ads API Forum Advisor]

Hi Abhishek,

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

Moving forward to your concerns:

• "I am getting duplicates when pulling the data using the python package for the google-ads api for the clicks performance report. I am using the SearchStreaming method and inserting each batch into the DB as it comes. No changes at all. So is there any bug in the python package?" - So our team can better check and investigate this issue which is you getting duplicates, could you provide the complete request and response logs with request ID and request header generated on your end?
• "Are the tables contextual, i.e. is it the intended behaviour that when the METRO field is null, there is no data for the GEO Table?  Likewise, for the Keyword table, when no keyword is available, there is no data.Earlier in the Adwords reports account and campaigns were getting listed even if keyword or metro field corresponding to it was null" - For this,  "Are the tables contextual, i.e. is it the intended behaviour that when the METRO field is null, there is no data for the GEO Table?  Likewise, for the Keyword table, when no keyword is available, there is no data.", could you please give more context about this? With regard to, "Earlier in the Adwords reports account and campaigns were getting listed even if keyword or metro field corresponding to it was null", could you also provide your request and response so our team can better check this? Also, kindly note that AdWords API has already sunset last April 27, 2022. With this, you may check this blog post for more information.

You can provide the requested logs via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Regards,

Carmela Google Ads API Team

ref:_00D1U1174p._5004Q2bdSIv:ref