After some investigation we've figured out that the degradation is caused by competitive metrics.
Query: SELECT Device, AdNetworkType1, Date, Impressions, Clicks, Cost, ConvertedClicks, AveragePosition FROM ACCOUNT_PERFORMANCE_REPORT DURING 20001101, 20160106 5333 rows retrieved in 4.56 seconds (3.539 seconds spent on the google api call). Query: SELECT Device, AdNetworkType1, Date, Impressions, Clicks, Cost, ConvertedClicks, AveragePosition, SearchImpressionShare FROM ACCOUNT_PERFORMANCE_REPORT DURING 20001101, 20160106 5439 rows retrieved in 36.01 seconds (34.729 seconds spent on the google api call). Query: SELECT Device, AdNetworkType1, Date, Impressions, Clicks, Cost, ConvertedClicks, AveragePosition, SearchImpressionShare, ContentImpressionShare FROM ACCOUNT_PERFORMANCE_REPORT DURING 20001101, 20160106 5439 rows retrieved in 51.798 seconds (50.568 seconds spent on the google api call). Note that the last two queries return more rows, this is because querying these fields causes the report to include zero impressions. Adding Impressions>0 condition reduces the number of rows, but doesn't improve the performance. Are there any known performance issues with these metrics? If so - are you going to fix it? Thanks. On Thursday, January 7, 2016 at 12:09:27 AM UTC+2, Nadine Sundquist (AdWords API Team) wrote: > > Hi Assaf, > > I haven't heard of any issues with reporting currently. If you find that > this issue is persisting, please click *Reply privately to author* in the > forum, and send me one customer ID where your are having problems and one > customer ID where you aren't having problems. That way I can try > reproducing it from my end. Once I catch it in the act, it'll be a lot > easier for me to find the source of the issue. > > Thanks, > Nadine, AdWords API Team > > On Wednesday, January 6, 2016 at 11:21:39 AM UTC-5, Assaf Frank wrote: >> >> I would like to add that these reports* ran OK up to a couple of days >> ago.* >> Now the same reports seem to be taking too much time so we get an >> exception - com.google.api.ads.adwords.lib.utils.ReportException: >> Problem sending data to report download server >> >> Is there currently an issue with the reporting on large accounts causing >> the report to fail? >> >> Thanks. >> >> On Wednesday, January 6, 2016 at 9:59:14 AM UTC+2, [email protected] >> 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 [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 https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/c1c77775-8fd2-4201-9945-8c1f4f0ceca7%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
