Unable to obtain all the results that I can see in UI

[Arturo Martínez Pacheco]

Im making a query to obtain all the campaigns that are enabled or stopped, like so:

SELECT ...

FROM ad_group_ad WHERE campaign.status IN ('ENABLED', 'PAUSED', 'REMOVED', 'UNKNOWN')

AND ad_group_ad.status IN ('ENABLED', 'PAUSED', 'REMOVED', 'UNKNOWN')

AND campaign.name LIKE "%ES%"

AND segments.date BETWEEN '2022-05-05' AND '2022-05-07'

I validated my query and it is ok, the problem is that it isnt bringing me some campaigns that I can see in the UI, does anyone has experienced something similar?

[Google Ads API Forum Advisor]

Hi Arturo,

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

Moving forward to your concern, it appears that this is specifically about incomplete results that you are getting from the API. That said, since you mentioned "the problem is that it isnt bringing me some campaigns that I can see in the UI", could you provide the complete request and response logs with request ID and request header generated on your end and a screenshot of the Google Ads UI showing these campaigns?

You can provide it 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._5004Q2bBURZ:ref

[Arturo Martínez Pacheco]

Hi! I found that the problem is that the python client library has some bug where a query brings results from the previous query, they are in the same if condition but each report has its own function,. For example:

def get_all_reports(region):

     try:

          if region == "IRELAND":

                get_es_report(region)

                get_un_report(region)

         elif region == "OREGON":

               get_mx_report(region)

The un_report, has some results that are from the es_report, Im using the python library

Best regards

[Google Ads API Forum Advisor]

Hi Arturo,

Thank you for getting back to us.

Moving forward, it seems that this is a client library issue. With this, I would suggest reaching out to the Python client library owner by posting your concern in the Issue Tab on Github as they are more equipped to provide guidance to this issue.