Hi, Are you sure that the report is returning zero rows? I think it's more likely that it's actually returning an error because there are certain field combinations that are not allowed. Please see this other forum post <https://groups.google.com/d/msg/adwords-api/33lf7hvGtGY/bBHU6UbQrg0J> for more details.
In general, you probably want to avoid selecting *every* field that's available for a report, not only because of the field combination issue, but also because selecting every field will make your reports run longer because AdWords will have to retrieve a great deal of data for every row. I'd recommend choosing the fields that are actually of interest to you, and limiting your report request to just include those fields. Thanks, Josh, AdWords API Team On Monday, May 4, 2015 at 1:06:49 AM UTC-4, Sarah Riddell wrote: > > Hi Josh, > > Many thanks for your previous helps & supports. > > Can you help me with this AWQL query? > > SELECT > ExternalCustomerId,CampaignId,AdGroupId,Id,AdNetworkType2,AverageCpc,AverageCpm, > > AveragePageviews, > > AveragePosition,AverageTimeOnSite,BidType,BiddingStrategyType,BounceRate,ClickAssistedConversionValue > > , > > ClickAssistedConversions,ClickAssistedConversionsOverLastClickConversions,ClickConversionRate > > , > Clicks ,ConversionRateManyPerClick ,ConversionValue > ,ConversionsManyPerClick ,ConvertedClicks , > Cost ,CostPerConversionManyPerClick > ,CostPerConvertedClick ,CpcBid ,CriteriaDestinationUrl ,Ctr , > FirstPageCpc ,ImpressionAssistedConversionValue > ,ImpressionAssistedConversions > ,ImpressionAssistedConversionsOverLastClickConversions , > Impressions ,KeywordMatchType > ,PercentNewVisitors,QualityScore ,SearchExactMatchImpressionShare , > SearchImpressionShare,Status > ,TopOfPageCpc,ValuePerConversionManyPerClick,ValuePerConvertedClick , > ViewThroughConversions FROM > KEYWORDS_PERFORMANCE_REPORT DURING 20140424,20150424 > > I want to get above columns from KEYWORDS_PERFORMANCE_REPORT for specific > date. when i run that query it returns all fields value zero. but when i > run below query it returns result as i need. > > SELECT ExternalCustomerId,CampaignId,AdGroupId,Id FROM > KEYWORDS_PERFORMANCE_REPORT DURING 20140424,20150424 > > How can i get all fields form KEYWORDS_PERFORMANCE_REPORT for specific > date (e.g 2015-05-03, 2015-05-04 etc.) ? > > > > > > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/e7651f3d-70f1-41c5-a4a2-1ef891a2def9%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
