awql with AUDIENCE_PERFORMANCE_REPORT excludes zero impressions (Python Library)

[Alex Fung]

Hi there,


I am using awql with report service and I found out that awql with AUDIENCE_PERFORMANCE_REPORT does not fetch audience/criteria with zero impressions.


query = "SELECT Criteria,Id,AdGroupId,Impressions FROM AUDIENCE_PERFORMANCE_REPORT"


According to the API doc: All of the fields that I selected are zero impressions compatible.

Thanks,

Alex

[Peter Oliquino]

Hi Alex,

My apologies as I am not that much familiar with Python. However, in the reporting example in Python, have you tried adding something similar to "include_zero_impressions=True" in the report_downloader? If the issue persists, kindly provide your complete report definition so I could look into the issue further.

Best regards,

Peter

AdWords API Team

[Alex Fung]

Thanks for the quick reply!

I am able to fetch zero impressions data with the non awql way:

    report = {

          'reportName': report_name,

          'dateRangeType': duration if duration else 'ALL_TIME',

          'reportType': report_name,

          'downloadFormat': 'TSV',

          'selector': {

              'fields': columns if type(columns) is list else columns.split(',')

          },

        

    

      }

    stream = report_downloader.DownloadReportAsStream(report, skip_report_header=True, skip_column_header=False,skip_report_summary=True,include_zero_impressions=True)

I think it is a awql report bug in the Python library .

I guess at the meantime I will use the old way of report definition.

Thanks,

Alex