Hi there, Has anyone else noticed a big increase in the amount of time it takes to get keyword performance reports starting on 12/06/2014? The following query (see below) repeated 385 times (once per account) currently takes somewhere around 6 hours to generate ~2GBs of reports. To the best of my knowledge there were no big increases on the number of keywords bid upon, nor were there any changes to the tool that runs these exports for our data warehouse.
I've parsed our logs and attached a graph of the completion time over time.. you can see the big jump on 12/6 and a slow increase ever since. SELECT AccountDescriptiveName, AdGroupId, AdGroupName, AdGroupStatus, ApprovalStatus, AssistClicks, AssistImpressions, AssistImpressionsOverLastClicks, AverageCpc, AverageCpm, AveragePageviews, AveragePosition, AverageTimeOnSite, BiddingStrategyId, BiddingStrategyName, BiddingStrategyType, BidType, BounceRate, CampaignId, CampaignName, CampaignStatus, ClickAssistedConversions, ClickAssistedConversionsOverLastClickConversions, ClickAssistedConversionValue, Clicks, ConversionRate, ConversionRateManyPerClick, Conversions, ConversionsManyPerClick, ConversionValue, Cost, CostPerConversion, CostPerConversionManyPerClick, CpcBid, CpcBidSource, CpmBid, Ctr, Date, DestinationUrl, EnhancedCpcEnabled, FinalAppUrls, FinalMobileUrls, FinalUrls, FirstPageCpc, Id, ImpressionAssistedConversions, ImpressionAssistedConversionsOverLastClickConversions, ImpressionAssistedConversionValue, Impressions, IsNegative, KeywordMatchType, KeywordText, LabelIds, Labels, PercentNewVisitors, PlacementUrl, QualityScore, SearchExactMatchImpressionShare, SearchImpressionShare, SearchRankLostImpressionShare, Status, TopOfPageCpc, TrackingUrlTemplate, UrlCustomParameters, ValuePerConversion, ValuePerConversionManyPerClick, ViewThroughConversions FROM KEYWORDS_PERFORMANCE_REPORT WHERE Impressions >= 1 DURING YESTERDAY -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/fb053cb0-9659-4978-a409-91d264e09732%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.