Many years ago I noticed that reports with conversion information are much slower than reports without conversion information. Check the performance of the query without asking for converted clicks. Maybe that particular account has no conversion trackers set up?
Apart from that, in general you should try reducing the complexity of the query (eg. by removing fields, reducing period etc.) until the performance becomes normal. Then confront Google, it should be easy when you can give them a direction to look. On Wednesday, January 6, 2016 at 8:59:14 AM UTC+1, di...@easyleads.com wrote: > > Hi, > > We encounter a heavy performance issue with ACCOUNT_PERFORMANCE_REPORT on > one of our accounts. > > We understand that the query isn't the simplest in terms of complexity, > but the response time is reasonable for several hundreds of accounts we > tested. > > Query 1 (last year): SELECT Device, AdNetworkType1, Date, Impressions, > Clicks, Cost, ConvertedClicks, AveragePosition, SearchImpressionShare, > ContentImpressionShare FROM ACCOUNT_PERFORMANCE_REPORT DURING 20150101, > 20151231 > Result on the problematic account: 1095 rows retrieved in 21.8 seconds ( > *21.164* seconds spent on the google api call) > Result on one of other accounts: 1095 rows retrieved in 3.49 seconds ( > *2.79* seconds spent on the google api call) > > Query 2 (all time): SELECT Device, AdNetworkType1, Date, Impressions, > Clicks, Cost, ConvertedClicks, AveragePosition, SearchImpressionShare, > ContentImpressionShare FROM ACCOUNT_PERFORMANCE_REPORT DURING 20001101, > 20160106 > Result on the problematic account: 5436 rows retrieved in 42.204 seconds ( > *40.967* seconds spent on the google api call) > Result on one of other accounts: 11013 rows retrieved in 6.543 seconds ( > *4.604* seconds spent on the google api call) > > What could be the reason? > > Thanks > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/6914f12a-9849-4eee-8469-11dbf3d30996%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
