Marked increase in time taken to generate keyword performance reports

[Ian Knox]

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

[Anash P. Oommen (AdWords API Team)]

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.

[Ian Knox]

Thanks Anash,
I think I just sent you what you asked for although there's no confirmation that the message was sent in the forum interface.  
Shoot me an e-mail directly at iknox [at] info [dot] com if it didn't go through and I'll follow up out-of-band.

Ian