Hi Ian, If you can use the "Reply to Author" option to share your API MCC customer id and developer token with me, I can investigate this further at our end.
Cheers, Anash P. Oommen, AdWords API Advisor. On Wednesday, January 21, 2015 at 12:44:24 AM UTC+5:30, Ian Knox wrote: > > 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. 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/d398978f-a598-4043-be03-8044cdaafe34%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
