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/fb053cb0-9659-4978-a409-91d264e09732%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
