Missing data when downloading AdGroup Performance report

[angie...@simplisafe.com]

So when I download the adgroup performance report from the API, I got fewer ad groups than when I download from the interface. Did I do something wrong? The code is as follow:

def downloadAdGroupReport(start_date, end_date):

  output = io.StringIO()

  # Initialize appropriate service.

  adwords_client = adwords.AdWordsClient.LoadFromStorage()

  report_downloader = adwords_client.GetReportDownloader(version='v201705')

  # Create report query.

  report_query = ('SELECT AdGroupId, AdGroupName, CampaignName, CpcBid, Week, Device, Clicks, AllConversions '

                    'FROM ADGROUP_PERFORMANCE_REPORT '

                    #'WHERE AdGroupStatus IN [ENABLED] '

                    'DURING '+start_date+','+end_date)

  # Write query result to output file

  report_downloader.DownloadReportWithAwql(

      report_query,

      'CSV',

      output,

      client_customer_id='XXX-XXX-XXXX’', # denotes which adw account to pull from

      skip_report_header=True,

      skip_column_header=False,

      skip_report_summary=True,

      include_zero_impressions=False)

  output.seek(0)

  df = pd.read_csv(output)

  return df

[Peter Oliquino]

Hi Angie,

In order to better identify if there are indeed discrepancies between the AdWords API and AdWords UI reports, could you provide your clientCustomerId and the AdWords UI screenshot of the Ad Group level report that you were viewing? You may reply to me using the Reply privately to author option for the details.

Thanks and regards,

Peter

AdWords API Team