PAID_ORGANIC_QUERY_REPORT

[Alejandro Brücher]

I have 2 accounts.

one return data , but he other no. (both with publicity)

why?

this is the code.

-----------------------

  client = adwords.AdWordsClient.LoadFromStorage(Archivo)

  # Initialize appropriate service.

  report_downloader = client.GetReportDownloader(version='v201809')

  fecha=20181201+','+20181204

  # Create report query.

  report_query = (adwords.ReportQueryBuilder()

                  .Select('Month','CampaignName','AdGroupName','KeywordTextMatchingQuery','SearchQuery','Clicks','AveragePosition','AverageCpc','Ctr','Impressions' ,'OrganicImpressions','OrganicClicks','OrganicAveragePosition','CombinedAdsOrganicClicks')

                  .From('PAID_ORGANIC_QUERY_REPORT')

                 .During(fecha)

                  #.WHERE('DATE=20181105')

                  .Build())

  var=report_downloader.DownloadReportAsStringWithAwql(report_query, 'CSV',

            skip_report_header=True, skip_column_header=False,skip_report_summary=True)

  

  var1=StringIO(var)

  df = pd.read_csv(var1, sep=",")

[Bharani Cherukuri (AdWords API Team)]

Hello Alejandro, 

Could you share us the client customer Id, so I can take a look? You can share the details privately using Reply privately to author option. 

Thanks,

Bharani, AdWords API Team