Hello, With a bit of experimentation, I was able to figure out what was going on. Specify your query just as you did before. However, you will need to explicitly set includeZeroImpressions to true in the header of the request. Your data will then appear. It looks like you're using Python, so here's a Python example of setting those headers:
with open <https://www.google.com/url?sa=D&q=https%3A%2F%2Fwww.google.com%2Furl%3Fsa%3DD%26q%3Dhttp%3A%2F%2Fdocs.python.org%2Flibrary%2Ffunctions.html%26usg%3DAFQjCNHRBwpcZVIR-dfE_S0YKMDqM1iUsQ%23open>(path <https://codesearch.corp.google.com/#piper///depot/google3/third_party/py/googleads/opensource/examples/adwords/v201506/reporting/download_criteria_report_with_awql.py&ct=xref_jump_to_def&cl=GROK&l=41&gsn=path>, 'w') as output_file <https://codesearch.corp.google.com/#piper///depot/google3/third_party/py/googleads/opensource/examples/adwords/v201506/reporting/download_criteria_report_with_awql.py&ct=xref_usages&gs=py:google3.third_party.py.googleads.opensource.examples.adwords.v201506.reporting.download_criteria_report_with_awql.main&output_file:third_party/py/googleads/opensource/examples/adwords/v201506/reporting/download_criteria_report_with_awql.py%231740&l=52&gsn=output_file>: report_downloader <https://codesearch.corp.google.com/#piper///depot/google3/third_party/py/googleads/opensource/examples/adwords/v201506/reporting/download_criteria_report_with_awql.py&ct=xref_jump_to_def&cl=GROK&l=43&gsn=report_downloader>.DownloadReportWithAwql( report_query <https://codesearch.corp.google.com/#piper///depot/google3/third_party/py/googleads/opensource/examples/adwords/v201506/reporting/download_criteria_report_with_awql.py&ct=xref_jump_to_def&cl=GROK&l=46&gsn=report_query>, 'CSV', output_file <https://codesearch.corp.google.com/#piper///depot/google3/third_party/py/googleads/opensource/examples/adwords/v201506/reporting/download_criteria_report_with_awql.py&ct=xref_jump_to_def&cl=GROK&l=52&gsn=output_file>, skip_report_header=False <https://www.google.com/url?sa=D&q=https%3A%2F%2Fwww.google.com%2Furl%3Fsa%3DD%26q%3Dhttp%3A%2F%2Fdocs.python.org%2Flibrary%2Fconstants.html%26usg%3DAFQjCNEWPBsS5iGj-IDGgL7KNVdYFlrzaA%23False>, skip_column_header=False <https://www.google.com/url?sa=D&q=https%3A%2F%2Fwww.google.com%2Furl%3Fsa%3DD%26q%3Dhttp%3A%2F%2Fdocs.python.org%2Flibrary%2Fconstants.html%26usg%3DAFQjCNEWPBsS5iGj-IDGgL7KNVdYFlrzaA%23False>, skip_report_summary=False <https://www.google.com/url?sa=D&q=https%3A%2F%2Fwww.google.com%2Furl%3Fsa%3DD%26q%3Dhttp%3A%2F%2Fdocs.python.org%2Flibrary%2Fconstants.html%26usg%3DAFQjCNEWPBsS5iGj-IDGgL7KNVdYFlrzaA%23False>, include_zero_impressions=T <https://www.google.com/url?sa=D&q=https%3A%2F%2Fwww.google.com%2Furl%3Fsa%3DD%26q%3Dhttp%3A%2F%2Fdocs.python.org%2Flibrary%2Fconstants.html%26usg%3DAFQjCNEWPBsS5iGj-IDGgL7KNVdYFlrzaA%23False>rue) If you're using another language, check out our client library examples <https://developers.google.com/adwords/api/docs/clientlibraries> for v201506 to see how to set headers when downloading reports. Happy coding, Nadine, AdWords API Team On Wednesday, July 8, 2015 at 7:32:53 AM UTC-4, GD wrote: > > Hi Nadine, > > While this is certainly a solution, what I'm trying to point out above is > that the behavior changed. We were using these calls to generate reports > about the account structure and thus dont want to use metric fields. > Before, you could request such reports with Date, now you cant? > > On Tuesday, July 7, 2015 at 7:55:24 PM UTC+2, Nadine Sundquist (AdWords > API Team) wrote: >> >> Hi, >> >> With the Keywords Performance Report, you need to have at least one field >> with the *Behavior *of type *Metric* such as the Impressions >> <https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report#impressions> >> field. >> Can you please give that a try to see if things behave as expected? >> >> Thanks, >> Nadine, AdWords API Team >> >> On Tuesday, July 7, 2015 at 1:34:01 PM UTC-4, Nadine Sundquist (AdWords >> API Team) wrote: >>> >>> Hello, >>> >>> Thanks for pointing this out. The behavior you're showing and the >>> documentation definitely don't match. I'll talk to the engineers to see >>> what the intended behavior is, and I'll get back to you as soon as I have >>> news. >>> >>> Best, >>> Nadine, AdWords API Team >>> >>> On Tuesday, July 7, 2015 at 8:43:06 AM UTC-4, GD wrote: >>>> >>>> Hi! >>>> >>>> I think you (accidentally?) changed the behavior regarding Date field >>>> in KPR visavi zero impression rows. >>>> >>>> See below examples: >>>> >>>> In [34]: report_downloader.DownloadReportAsStreamWithAwql( >>>> 'SELECT CampaignId, AdGroupId, Id, *Date* FROM >>>> KEYWORDS_PERFORMANCE_REPORT DURING 20150707,20150707', >>>> file_format='CSV').readlines()[0:5] >>>> >>>> Out[34]: >>>> ['"KEYWORDS_PERFORMANCE_REPORT (Jul 7, 2015)"\n', >>>> 'Campaign ID,Ad group ID,Keyword ID,Day\n', >>>> 'Total, --, --, --\n'] >>>> >>>> *If we remove Date from the query, we get many lines* >>>> >>>> In [35]: report_downloader.DownloadReportAsStreamWithAwql( >>>> 'SELECT CampaignId, AdGroupId, Id FROM >>>> KEYWORDS_PERFORMANCE_REPORT DURING 20150707,20150707', >>>> file_format='CSV').readlines()[0:5] >>>> Out[35]: >>>> ['"KEYWORDS_PERFORMANCE_REPORT (Jul 7, 2015)"\n', >>>> 'Campaign ID,Ad group ID,Keyword ID\n', >>>> '263993268,9713724108,50982934788\n', >>>> '263991948,9713602068,3001111864\n', >>>> '156554148,6752305908,50981848068\n'] >>>> >>>> This used to produce the same answer. Is this something you could fix >>>> or is this the new normal? In that case, Docs should be updated so that it >>>> states Date does not support zero impression rows. >>>> >>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/29956a09-2f51-4a00-921a-6c09f6954f27%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
