Re: AWQL Reporting slowdown?
Starting December 23rd/24th, I have seen a significant *speed up* in the reporting API responses. Anyone else noticed this? It is still not back to the pre-September 7 levels, but there is a noticeable 20% or more improvement. Could the API team do more of this magic that happened? Thanks :) On Thursday, December 21, 2017 at 11:29:13 PM UTC+1, chris.s...@outlook.com wrote: > > > > On Monday, 11 September 2017 17:01:38 UTC+2, AdWordsApiUser wrote: >> >> Hi Team, >> >> We're noticing a significant slowdown in the throughput of the AWQL >> Reporting using the API since last week, where we're spending about 30%-40% >> more time than usual. Is this a known issue, or something that is being >> changed? Any insights will be appreciated. >> >> Cheers, and have a great week ahead! >> >> MG >> > > The response times for various parts of the API are in constant > fluctuation, with some responses taking around 200ms on some days, and over > 79 seconds other days. What is going on? Why is it so unstable? > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/ef9eb92c-0f57-4453-a539-25b2d6ca8813%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
On Monday, 11 September 2017 17:01:38 UTC+2, AdWordsApiUser wrote: > > Hi Team, > > We're noticing a significant slowdown in the throughput of the AWQL > Reporting using the API since last week, where we're spending about 30%-40% > more time than usual. Is this a known issue, or something that is being > changed? Any insights will be appreciated. > > Cheers, and have a great week ahead! > > MG > The response times for various parts of the API are in constant fluctuation, with some responses taking around 200ms on some days, and over 79 seconds other days. What is going on? Why is it so unstable? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/c6d6afd9-3cfb-495b-935b-d5feab8081aa%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Yes, the reporting API is still extremely slow and I doubt anything will change in near future. On Monday, December 11, 2017 at 5:32:23 PM UTC+1, Dorian Kind wrote: > > Hi all, > > I was just wondering whether the situation is still the same for you? On > our end, the reporting slowdown first encountered in September seems to be > permanent. > > Thanks for your feedback and best regards, > Dorian > > On Tuesday, 7 November 2017 11:50:10 UTC+1, Tomas R wrote: >> >> It's a bit like a closed loop: >> 1) Reporting API does not support sorters and paging, so you end up >> getting data you don't really need which increases response time. >> 2) All the requests are super slow anyway, so you have to implement >> caching with multi-threading. The slower it gets, the more threads you use. >> Multiple companies hammering reporting API this way, obviously doesn't >> improve API performance. >> 3) Finally from time-to-time the API stops responding in timely fashion >> at all or starts throwing 500 errors (happens relatively often these days) >> and *the engineers* apply some temporary work-around which doesn't solve >> the real issue and we are back at point 1. >> > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/01fd9042-0884-45fa-8504-44c6c0ddb5b9%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Hi all, I was just wondering whether the situation is still the same for you? On our end, the reporting slowdown first encountered in September seems to be permanent. Thanks for your feedback and best regards, Dorian On Tuesday, 7 November 2017 11:50:10 UTC+1, Tomas R wrote: > > It's a bit like a closed loop: > 1) Reporting API does not support sorters and paging, so you end up > getting data you don't really need which increases response time. > 2) All the requests are super slow anyway, so you have to implement > caching with multi-threading. The slower it gets, the more threads you use. > Multiple companies hammering reporting API this way, obviously doesn't > improve API performance. > 3) Finally from time-to-time the API stops responding in timely fashion at > all or starts throwing 500 errors (happens relatively often these days) and > *the > engineers* apply some temporary work-around which doesn't solve the real > issue and we are back at point 1. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/01efaa45-86f9-4497-beda-23c2ea663f59%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
It's a bit like a closed loop: 1) Reporting API does not support sorters and paging, so you end up getting data you don't really need which increases response time. 2) All the requests are super slow anyway, so you have to implement caching with multi-threading. The slower it gets, the more threads you use. Multiple companies hammering reporting API this way, obviously doesn't improve API performance. 3) Finally from time-to-time the API stops responding in timely fashion at all or starts throwing 500 errors (happens relatively often these days) and *the engineers* apply some temporary work-around which doesn't solve the real issue and we are back at point 1. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/042afa7c-a4f5-494a-9355-8e882f9f1057%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Hi Michael, Any updates on this? It appears that some particular accounts are affected more badly than others. If I find something specific I will send it across. Thanks. MG On Wednesday, October 18, 2017 at 5:50:42 PM UTC+5:30, Michael Cloonan (AdWords API Team) wrote: > > Hello, > > Thanks for the extra context. I will relay this to the team and I will > share here when I have any updates. > > Regards, > Mike, Adwords API Team > > On Wednesday, October 18, 2017 at 5:53:17 AM UTC-4, AdWordsApiUser wrote: >> >> I don't have numbers prior to September 7, because we did not do per call >> timing tests before the apparent slowdown. >> >> A nightly job, that pulled the same query for many thousand accounts, >> would complete by 11AM. Starting September 7, it now runs till 5 PM. >> Something happened between Sep 6 and Sep 7. This is the second slowdown >> after the one that happened about 6 months ago (which was discussed in >> detail in this forum as well) >> >> Cheers, >> MG >> >> >> >> On Tuesday, October 17, 2017 at 6:01:00 PM UTC+5:30, Michael Cloonan >> (AdWords API Team) wrote: >>> >>> Hello, >>> >>> Thanks for the answers to my questions, AdWordsApiUser. For the last >>> question, can you give the real-time it takes to run reports previously and >>> now, rather than just how much slower it is relatively to before? >>> >>> Regards, >>> Mike, AdWords API Team >>> >>> On Tuesday, October 17, 2017 at 3:02:12 AM UTC-4, Dorian Kind wrote: On Monday, 16 October 2017 20:28:44 UTC+2, AdWordsApiUser wrote: > > > @Dorian, do you use TSV format by any chance? I keep suspecting that > it is something to do with TSV format reports, but I am not able to prove > it in experiments with a hundred or so reports. > No, we use CSV reports exclusively. >>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/40d383e2-b1b7-441f-9ecc-efa07943e80f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Hello, Thanks for the extra context. I will relay this to the team and I will share here when I have any updates. Regards, Mike, Adwords API Team On Wednesday, October 18, 2017 at 5:53:17 AM UTC-4, AdWordsApiUser wrote: > > I don't have numbers prior to September 7, because we did not do per call > timing tests before the apparent slowdown. > > A nightly job, that pulled the same query for many thousand accounts, > would complete by 11AM. Starting September 7, it now runs till 5 PM. > Something happened between Sep 6 and Sep 7. This is the second slowdown > after the one that happened about 6 months ago (which was discussed in > detail in this forum as well) > > Cheers, > MG > > > > On Tuesday, October 17, 2017 at 6:01:00 PM UTC+5:30, Michael Cloonan > (AdWords API Team) wrote: >> >> Hello, >> >> Thanks for the answers to my questions, AdWordsApiUser. For the last >> question, can you give the real-time it takes to run reports previously and >> now, rather than just how much slower it is relatively to before? >> >> Regards, >> Mike, AdWords API Team >> >> On Tuesday, October 17, 2017 at 3:02:12 AM UTC-4, Dorian Kind wrote: >>> >>> On Monday, 16 October 2017 20:28:44 UTC+2, AdWordsApiUser wrote: @Dorian, do you use TSV format by any chance? I keep suspecting that it is something to do with TSV format reports, but I am not able to prove it in experiments with a hundred or so reports. >>> >>> No, we use CSV reports exclusively. >>> >> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/f89e0b19-cb0d-47ba-af1f-4a2a73a673d9%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
I don't have numbers prior to September 7, because we did not do per call timing tests before the apparent slowdown. A nightly job, that pulled the same query for many thousand accounts, would complete by 11AM. Starting September 7, it now runs till 5 PM. Something happened between Sep 6 and Sep 7. This is the second slowdown after the one that happened about 6 months ago (which was discussed in detail in this forum as well) Cheers, MG On Tuesday, October 17, 2017 at 6:01:00 PM UTC+5:30, Michael Cloonan (AdWords API Team) wrote: > > Hello, > > Thanks for the answers to my questions, AdWordsApiUser. For the last > question, can you give the real-time it takes to run reports previously and > now, rather than just how much slower it is relatively to before? > > Regards, > Mike, AdWords API Team > > On Tuesday, October 17, 2017 at 3:02:12 AM UTC-4, Dorian Kind wrote: >> >> On Monday, 16 October 2017 20:28:44 UTC+2, AdWordsApiUser wrote: >>> >>> >>> @Dorian, do you use TSV format by any chance? I keep suspecting that it >>> is something to do with TSV format reports, but I am not able to prove it >>> in experiments with a hundred or so reports. >>> >> >> No, we use CSV reports exclusively. >> > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/3b050f95-6be6-4e4a-9599-5e1147a35799%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Hello, Thanks for the answers to my questions, AdWordsApiUser. For the last question, can you give the real-time it takes to run reports previously and now, rather than just how much slower it is relatively to before? Regards, Mike, AdWords API Team On Tuesday, October 17, 2017 at 3:02:12 AM UTC-4, Dorian Kind wrote: > > On Monday, 16 October 2017 20:28:44 UTC+2, AdWordsApiUser wrote: >> >> >> @Dorian, do you use TSV format by any chance? I keep suspecting that it >> is something to do with TSV format reports, but I am not able to prove it >> in experiments with a hundred or so reports. >> > > No, we use CSV reports exclusively. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/2e80c1a2-01b1-47d9-936f-94391378852c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
On Monday, 16 October 2017 20:28:44 UTC+2, AdWordsApiUser wrote: > > > @Dorian, do you use TSV format by any chance? I keep suspecting that it is > something to do with TSV format reports, but I am not able to prove it in > experiments with a hundred or so reports. > No, we use CSV reports exclusively. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/ed644b40-c3bc-4fd2-a647-b60f9a1d0b1b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
We are currently using AdWords reporting, Analytics Reporting API v4 and Facebook Ads Insights reporting API. On average AdWords reporting is approximately at least twice as slow as Analytics Reporting (usually more) and usually three times as slow as Facebook Ads Insights API. And yes, we have standard access. I am pretty sure there should be a way for you to improve the situation. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/2457764f-1f98-4f2b-ab52-b02fa714b02c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Some more info: - Is this across all report types, or is there a specific report type where you're seeing the slower behavior? It appears across all report types - Do you see more rows get returned or anything else changed in the content of the reports? No Change - For a single report, how long did it take previously and how long does it take now? When pulling reports in bulk, we are roughly getting half the throughput compared to earlier. I'm talking about thousands of accounts. On Monday, October 16, 2017 at 11:58:44 PM UTC+5:30, AdWordsApiUser wrote: > > I have been running tests the last couple of weeks. > > Unfortunately, as I do not have a snapshot of what throughput we used to > get earlier, all I have been trying with is different settings: GZIP, > no-GIP, different download formats (as reported in another thread), but > nothing seems to affect performance. Our reports have become slower > significantly since around September 7th. I would highly appreciate if > someone could help us with this - we can keep increasing the parallelism, > but that is not the way we want to go - we'll stress the API system, and > likely run into rate issues. I am happy to share any details that might > help with the technical investigation. At a scale of thousands of accounts, > the speed difference really makes a difference. > > @Dorian, do you use TSV format by any chance? I keep suspecting that it is > something to do with TSV format reports, but I am not able to prove it in > experiments with a hundred or so reports. > > Regards, > MG > > > > On Thursday, September 28, 2017 at 7:12:06 PM UTC+5:30, Dorian Kind wrote: >> >> Hello, >> >> FWIW, we also have experienced somewhat of a performance degradation in >> the reporting infrastructure. >> >> We have one job in particular that collects a number of KPIs and >> structural data for a few hundred accounts using non-AWQL report >> definitions, and up until September 7th its run time was always in the >> order of ~200 minutes. Starting from September 8th however, this job now >> takes more than double that time, usually between 400 and 500 minutes for >> the same number of accounts. It's not a problem for us as the functionality >> is not time-critical, but it definitely became slower. >> >> The timing suggests that it could be the same issue as described >> by AdWordsApiUser in the original post. >> >> Best regards, >> Dorian >> >> On Wednesday, 27 September 2017 14:38:11 UTC+2, Michael Cloonan (AdWords >> API Team) wrote: >>> >>> Hello, >>> >>> No changes were made that should affect reporting speed, so I have some >>> followup questions to see if we can determine the root cause here. >>> >>> - Is this across all report types, or is there a specific report type >>> where you're seeing the slower behavior? >>> - Do you see more rows get returned or anything else changed in the >>> content of the reports? >>> - For a single report, how long did it take previously and how long does >>> it take now? >>> >>> Regards, >>> Mike, AdWords API Team >>> >>> On Tuesday, September 26, 2017 at 8:02:13 AM UTC-4, Michael Cloonan >>> (AdWords API Team) wrote: Hello, No updates yet. I will follow up with the team to see what they've found so far. I will post here when I have any information to share. Regards, Mike, AdWords API Team On Tuesday, September 26, 2017 at 5:00:47 AM UTC-4, AdWordsApiUser wrote: > > Any updates on this? Thanks! > > On Thursday, September 21, 2017 at 12:32:37 PM UTC+5:30, > AdWordsApiUser wrote: >> >> I saw this new thread mentioning the slowdown in TSV reports - we use >> TSV reports exclusively - probably that is the issue - >> https://groups.google.com/forum/?utm_medium=email_source=footer#!topic/adwords-api/lnuRYUwohNw >> >> A swift resolution will be appreciated :-) >> >> MG >> >> >> On Tuesday, September 19, 2017 at 8:04:09 PM UTC+8, Michael Cloonan >> (AdWords API Team) wrote: >>> >>> Hello, >>> >>> No, that will not be necessary; you specifically specified AWQL so I >>> wanted to know if you had done any tests narrowing that down. >>> >>> When you say your "job", you mean that your job runs multiple >>> reports that, in aggregate, used to take 8 hours and now take 16, >>> right? >>> It's not a single report taking that long? >>> >>> I will pass along the details you sent privately to our engineering >>> team to investigate in the meanwhile. >>> >>> Regards, >>> Mike, AdWords API Team >>> >>> On Monday, September 18, 2017 at 5:53:21 PM UTC-4, AdWordsApiUser >>> wrote: Hi Michael, Thanks for your reply. We only use AWQL styled queries, so I don't know right now if that could be the reason. Do you suggest that we try using the definition styled reports and
Re: AWQL Reporting slowdown?
I have been running tests the last couple of weeks. Unfortunately, as I do not have a snapshot of what throughput we used to get earlier, all I have been trying with is different settings: GZIP, no-GIP, different download formats (as reported in another thread), but nothing seems to affect performance. Our reports have become slower significantly since around September 7th. I would highly appreciate if someone could help us with this - we can keep increasing the parallelism, but that is not the way we want to go - we'll stress the API system, and likely run into rate issues. I am happy to share any details that might help with the technical investigation. At a scale of thousands of accounts, the speed difference really makes a difference. @Dorian, do you use TSV format by any chance? I keep suspecting that it is something to do with TSV format reports, but I am not able to prove it in experiments with a hundred or so reports. Regards, MG On Thursday, September 28, 2017 at 7:12:06 PM UTC+5:30, Dorian Kind wrote: > > Hello, > > FWIW, we also have experienced somewhat of a performance degradation in > the reporting infrastructure. > > We have one job in particular that collects a number of KPIs and > structural data for a few hundred accounts using non-AWQL report > definitions, and up until September 7th its run time was always in the > order of ~200 minutes. Starting from September 8th however, this job now > takes more than double that time, usually between 400 and 500 minutes for > the same number of accounts. It's not a problem for us as the functionality > is not time-critical, but it definitely became slower. > > The timing suggests that it could be the same issue as described > by AdWordsApiUser in the original post. > > Best regards, > Dorian > > On Wednesday, 27 September 2017 14:38:11 UTC+2, Michael Cloonan (AdWords > API Team) wrote: >> >> Hello, >> >> No changes were made that should affect reporting speed, so I have some >> followup questions to see if we can determine the root cause here. >> >> - Is this across all report types, or is there a specific report type >> where you're seeing the slower behavior? >> - Do you see more rows get returned or anything else changed in the >> content of the reports? >> - For a single report, how long did it take previously and how long does >> it take now? >> >> Regards, >> Mike, AdWords API Team >> >> On Tuesday, September 26, 2017 at 8:02:13 AM UTC-4, Michael Cloonan >> (AdWords API Team) wrote: >>> >>> Hello, >>> >>> No updates yet. I will follow up with the team to see what they've found >>> so far. I will post here when I have any information to share. >>> >>> Regards, >>> Mike, AdWords API Team >>> >>> On Tuesday, September 26, 2017 at 5:00:47 AM UTC-4, AdWordsApiUser wrote: Any updates on this? Thanks! On Thursday, September 21, 2017 at 12:32:37 PM UTC+5:30, AdWordsApiUser wrote: > > I saw this new thread mentioning the slowdown in TSV reports - we use > TSV reports exclusively - probably that is the issue - > https://groups.google.com/forum/?utm_medium=email_source=footer#!topic/adwords-api/lnuRYUwohNw > > A swift resolution will be appreciated :-) > > MG > > > On Tuesday, September 19, 2017 at 8:04:09 PM UTC+8, Michael Cloonan > (AdWords API Team) wrote: >> >> Hello, >> >> No, that will not be necessary; you specifically specified AWQL so I >> wanted to know if you had done any tests narrowing that down. >> >> When you say your "job", you mean that your job runs multiple reports >> that, in aggregate, used to take 8 hours and now take 16, right? It's >> not a >> single report taking that long? >> >> I will pass along the details you sent privately to our engineering >> team to investigate in the meanwhile. >> >> Regards, >> Mike, AdWords API Team >> >> On Monday, September 18, 2017 at 5:53:21 PM UTC-4, AdWordsApiUser >> wrote: >>> >>> Hi Michael, >>> >>> Thanks for your reply. We only use AWQL styled queries, so I don't >>> know right now if that could be the reason. Do you suggest that we try >>> using the definition styled reports and compare performance? As I >>> mentioned earlier, my job that used to get over in 8 hours now takes 16. >>> >>> Cheers, >>> MG >>> >>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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
Re: AWQL Reporting slowdown?
Hello, FWIW, we also have experienced somewhat of a performance degradation in the reporting infrastructure. We have one job in particular that collects a number of KPIs and structural data for a few hundred accounts using non-AWQL report definitions, and up until September 7th its run time was always in the order of ~200 minutes. Starting from September 8th however, this job now takes more than double that time, usually between 400 and 500 minutes for the same number of accounts. It's not a problem for us as the functionality is not time-critical, but it definitely became slower. The timing suggests that it could be the same issue as described by AdWordsApiUser in the original post. Best regards, Dorian On Wednesday, 27 September 2017 14:38:11 UTC+2, Michael Cloonan (AdWords API Team) wrote: > > Hello, > > No changes were made that should affect reporting speed, so I have some > followup questions to see if we can determine the root cause here. > > - Is this across all report types, or is there a specific report type > where you're seeing the slower behavior? > - Do you see more rows get returned or anything else changed in the > content of the reports? > - For a single report, how long did it take previously and how long does > it take now? > > Regards, > Mike, AdWords API Team > > On Tuesday, September 26, 2017 at 8:02:13 AM UTC-4, Michael Cloonan > (AdWords API Team) wrote: >> >> Hello, >> >> No updates yet. I will follow up with the team to see what they've found >> so far. I will post here when I have any information to share. >> >> Regards, >> Mike, AdWords API Team >> >> On Tuesday, September 26, 2017 at 5:00:47 AM UTC-4, AdWordsApiUser wrote: >>> >>> Any updates on this? Thanks! >>> >>> On Thursday, September 21, 2017 at 12:32:37 PM UTC+5:30, AdWordsApiUser >>> wrote: I saw this new thread mentioning the slowdown in TSV reports - we use TSV reports exclusively - probably that is the issue - https://groups.google.com/forum/?utm_medium=email_source=footer#!topic/adwords-api/lnuRYUwohNw A swift resolution will be appreciated :-) MG On Tuesday, September 19, 2017 at 8:04:09 PM UTC+8, Michael Cloonan (AdWords API Team) wrote: > > Hello, > > No, that will not be necessary; you specifically specified AWQL so I > wanted to know if you had done any tests narrowing that down. > > When you say your "job", you mean that your job runs multiple reports > that, in aggregate, used to take 8 hours and now take 16, right? It's not > a > single report taking that long? > > I will pass along the details you sent privately to our engineering > team to investigate in the meanwhile. > > Regards, > Mike, AdWords API Team > > On Monday, September 18, 2017 at 5:53:21 PM UTC-4, AdWordsApiUser > wrote: >> >> Hi Michael, >> >> Thanks for your reply. We only use AWQL styled queries, so I don't >> know right now if that could be the reason. Do you suggest that we try >> using the definition styled reports and compare performance? As I >> mentioned earlier, my job that used to get over in 8 hours now takes 16. >> >> Cheers, >> MG >> >> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/827031be-dce3-4ad3-8522-3fd60dc957de%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Let me run some tests and gather more data over the weekend to support my case. I'll update with my findings. On Wednesday, September 27, 2017 at 6:08:11 PM UTC+5:30, Michael Cloonan (AdWords API Team) wrote: > > Hello, > > No changes were made that should affect reporting speed, so I have some > followup questions to see if we can determine the root cause here. > > - Is this across all report types, or is there a specific report type > where you're seeing the slower behavior? > - Do you see more rows get returned or anything else changed in the > content of the reports? > - For a single report, how long did it take previously and how long does > it take now? > > Regards, > Mike, AdWords API Team > > On Tuesday, September 26, 2017 at 8:02:13 AM UTC-4, Michael Cloonan > (AdWords API Team) wrote: >> >> Hello, >> >> No updates yet. I will follow up with the team to see what they've found >> so far. I will post here when I have any information to share. >> >> Regards, >> Mike, AdWords API Team >> >> On Tuesday, September 26, 2017 at 5:00:47 AM UTC-4, AdWordsApiUser wrote: >>> >>> Any updates on this? Thanks! >>> >>> On Thursday, September 21, 2017 at 12:32:37 PM UTC+5:30, AdWordsApiUser >>> wrote: I saw this new thread mentioning the slowdown in TSV reports - we use TSV reports exclusively - probably that is the issue - https://groups.google.com/forum/?utm_medium=email_source=footer#!topic/adwords-api/lnuRYUwohNw A swift resolution will be appreciated :-) MG On Tuesday, September 19, 2017 at 8:04:09 PM UTC+8, Michael Cloonan (AdWords API Team) wrote: > > Hello, > > No, that will not be necessary; you specifically specified AWQL so I > wanted to know if you had done any tests narrowing that down. > > When you say your "job", you mean that your job runs multiple reports > that, in aggregate, used to take 8 hours and now take 16, right? It's not > a > single report taking that long? > > I will pass along the details you sent privately to our engineering > team to investigate in the meanwhile. > > Regards, > Mike, AdWords API Team > > On Monday, September 18, 2017 at 5:53:21 PM UTC-4, AdWordsApiUser > wrote: >> >> Hi Michael, >> >> Thanks for your reply. We only use AWQL styled queries, so I don't >> know right now if that could be the reason. Do you suggest that we try >> using the definition styled reports and compare performance? As I >> mentioned earlier, my job that used to get over in 8 hours now takes 16. >> >> Cheers, >> MG >> >> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/63c5033c-0f99-45dc-9e68-4ee1130f17a0%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Hello, No changes were made that should affect reporting speed, so I have some followup questions to see if we can determine the root cause here. - Is this across all report types, or is there a specific report type where you're seeing the slower behavior? - Do you see more rows get returned or anything else changed in the content of the reports? - For a single report, how long did it take previously and how long does it take now? Regards, Mike, AdWords API Team On Tuesday, September 26, 2017 at 8:02:13 AM UTC-4, Michael Cloonan (AdWords API Team) wrote: > > Hello, > > No updates yet. I will follow up with the team to see what they've found > so far. I will post here when I have any information to share. > > Regards, > Mike, AdWords API Team > > On Tuesday, September 26, 2017 at 5:00:47 AM UTC-4, AdWordsApiUser wrote: >> >> Any updates on this? Thanks! >> >> On Thursday, September 21, 2017 at 12:32:37 PM UTC+5:30, AdWordsApiUser >> wrote: >>> >>> I saw this new thread mentioning the slowdown in TSV reports - we use >>> TSV reports exclusively - probably that is the issue - >>> https://groups.google.com/forum/?utm_medium=email_source=footer#!topic/adwords-api/lnuRYUwohNw >>> >>> A swift resolution will be appreciated :-) >>> >>> MG >>> >>> >>> On Tuesday, September 19, 2017 at 8:04:09 PM UTC+8, Michael Cloonan >>> (AdWords API Team) wrote: Hello, No, that will not be necessary; you specifically specified AWQL so I wanted to know if you had done any tests narrowing that down. When you say your "job", you mean that your job runs multiple reports that, in aggregate, used to take 8 hours and now take 16, right? It's not a single report taking that long? I will pass along the details you sent privately to our engineering team to investigate in the meanwhile. Regards, Mike, AdWords API Team On Monday, September 18, 2017 at 5:53:21 PM UTC-4, AdWordsApiUser wrote: > > Hi Michael, > > Thanks for your reply. We only use AWQL styled queries, so I don't > know right now if that could be the reason. Do you suggest that we try > using the definition styled reports and compare performance? As I > mentioned earlier, my job that used to get over in 8 hours now takes 16. > > Cheers, > MG > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/578b1bcd-5694-4f79-993f-470ac05f50aa%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Hello, No updates yet. I will follow up with the team to see what they've found so far. I will post here when I have any information to share. Regards, Mike, AdWords API Team On Tuesday, September 26, 2017 at 5:00:47 AM UTC-4, AdWordsApiUser wrote: > > Any updates on this? Thanks! > > On Thursday, September 21, 2017 at 12:32:37 PM UTC+5:30, AdWordsApiUser > wrote: >> >> I saw this new thread mentioning the slowdown in TSV reports - we use TSV >> reports exclusively - probably that is the issue - >> https://groups.google.com/forum/?utm_medium=email_source=footer#!topic/adwords-api/lnuRYUwohNw >> >> A swift resolution will be appreciated :-) >> >> MG >> >> >> On Tuesday, September 19, 2017 at 8:04:09 PM UTC+8, Michael Cloonan >> (AdWords API Team) wrote: >>> >>> Hello, >>> >>> No, that will not be necessary; you specifically specified AWQL so I >>> wanted to know if you had done any tests narrowing that down. >>> >>> When you say your "job", you mean that your job runs multiple reports >>> that, in aggregate, used to take 8 hours and now take 16, right? It's not a >>> single report taking that long? >>> >>> I will pass along the details you sent privately to our engineering team >>> to investigate in the meanwhile. >>> >>> Regards, >>> Mike, AdWords API Team >>> >>> On Monday, September 18, 2017 at 5:53:21 PM UTC-4, AdWordsApiUser wrote: Hi Michael, Thanks for your reply. We only use AWQL styled queries, so I don't know right now if that could be the reason. Do you suggest that we try using the definition styled reports and compare performance? As I mentioned earlier, my job that used to get over in 8 hours now takes 16. Cheers, MG -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/25c53082-20fc-4caf-a8b0-e6d6254030c3%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Any updates on this? Thanks! On Thursday, September 21, 2017 at 12:32:37 PM UTC+5:30, AdWordsApiUser wrote: > > I saw this new thread mentioning the slowdown in TSV reports - we use TSV > reports exclusively - probably that is the issue - > https://groups.google.com/forum/?utm_medium=email_source=footer#!topic/adwords-api/lnuRYUwohNw > > A swift resolution will be appreciated :-) > > MG > > > On Tuesday, September 19, 2017 at 8:04:09 PM UTC+8, Michael Cloonan > (AdWords API Team) wrote: >> >> Hello, >> >> No, that will not be necessary; you specifically specified AWQL so I >> wanted to know if you had done any tests narrowing that down. >> >> When you say your "job", you mean that your job runs multiple reports >> that, in aggregate, used to take 8 hours and now take 16, right? It's not a >> single report taking that long? >> >> I will pass along the details you sent privately to our engineering team >> to investigate in the meanwhile. >> >> Regards, >> Mike, AdWords API Team >> >> On Monday, September 18, 2017 at 5:53:21 PM UTC-4, AdWordsApiUser wrote: >>> >>> Hi Michael, >>> >>> Thanks for your reply. We only use AWQL styled queries, so I don't know >>> right now if that could be the reason. Do you suggest that we try using the >>> definition styled reports and compare performance? As I mentioned earlier, >>> my job that used to get over in 8 hours now takes 16. >>> >>> Cheers, >>> MG >>> >>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/e0230a45-e0c8-4375-9c87-747c3b97546a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
I saw this new thread mentioning the slowdown in TSV reports - we use TSV reports exclusively - probably that is the issue - https://groups.google.com/forum/?utm_medium=email_source=footer#!topic/adwords-api/lnuRYUwohNw A swift resolution will be appreciated :-) MG On Tuesday, September 19, 2017 at 8:04:09 PM UTC+8, Michael Cloonan (AdWords API Team) wrote: > > Hello, > > No, that will not be necessary; you specifically specified AWQL so I > wanted to know if you had done any tests narrowing that down. > > When you say your "job", you mean that your job runs multiple reports > that, in aggregate, used to take 8 hours and now take 16, right? It's not a > single report taking that long? > > I will pass along the details you sent privately to our engineering team > to investigate in the meanwhile. > > Regards, > Mike, AdWords API Team > > On Monday, September 18, 2017 at 5:53:21 PM UTC-4, AdWordsApiUser wrote: >> >> Hi Michael, >> >> Thanks for your reply. We only use AWQL styled queries, so I don't know >> right now if that could be the reason. Do you suggest that we try using the >> definition styled reports and compare performance? As I mentioned earlier, >> my job that used to get over in 8 hours now takes 16. >> >> Cheers, >> MG >> >> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/f2c22542-daf8-4703-8fa7-f1b658c7920c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Hello, No, that will not be necessary; you specifically specified AWQL so I wanted to know if you had done any tests narrowing that down. When you say your "job", you mean that your job runs multiple reports that, in aggregate, used to take 8 hours and now take 16, right? It's not a single report taking that long? I will pass along the details you sent privately to our engineering team to investigate in the meanwhile. Regards, Mike, AdWords API Team On Monday, September 18, 2017 at 5:53:21 PM UTC-4, AdWordsApiUser wrote: > > Hi Michael, > > Thanks for your reply. We only use AWQL styled queries, so I don't know > right now if that could be the reason. Do you suggest that we try using the > definition styled reports and compare performance? As I mentioned earlier, > my job that used to get over in 8 hours now takes 16. > > Cheers, > MG > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/6ab9ae6b-a410-43ca-b00d-0767ea88eeb0%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Hi Michael, Thanks for your reply. We only use AWQL styled queries, so I don't know right now if that could be the reason. Do you suggest that we try using the definition styled reports and compare performance? As I mentioned earlier, my job that used to get over in 8 hours now takes 16. Cheers, MG -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/a89839e7-8e34-4047-a291-b2e2f2766d0f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Hello, Are you only seeing this issue with AWQL reports, or are you seeing the same issue if you run reports with the definition-style selector as well? I'm curious if it's AWQL-specific or if the slowdown is general to all reporting. Regards, Mike, AdWords API Team On Monday, September 18, 2017 at 3:07:58 AM UTC-4, AdWordsApiUser wrote: > > Hi Shwetha, > > I sent you the details in a private message. Does the version of API we > use affect the speed? > > Thanks, > MG > > On Friday, September 15, 2017 at 1:32:20 AM UTC+8, Shwetha Vastrad > (AdWords API Team) wrote: >> >> Hi, >> >> There isn't an ongoing issue that should be affecting report download >> latency via AdWords API. Could you provide the report definitions and the >> clientCustomerId where you observe the report download latency has >> increased? Could you also provide an approximate time when you started >> seeing this increase? >> >> Thanks, >> Shwetha Vastrad >> AdWords API Team. >> > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/f943c293-d13b-4cc3-a197-e8f2b1ee0005%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Hi Shwetha, I sent you the details in a private message. Does the version of API we use affect the speed? Thanks, MG On Friday, September 15, 2017 at 1:32:20 AM UTC+8, Shwetha Vastrad (AdWords API Team) wrote: > > Hi, > > There isn't an ongoing issue that should be affecting report download > latency via AdWords API. Could you provide the report definitions and the > clientCustomerId where you observe the report download latency has > increased? Could you also provide an approximate time when you started > seeing this increase? > > Thanks, > Shwetha Vastrad > AdWords API Team. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/d9bcc944-86f7-48ea-b0ce-0009904dec58%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Hi, There isn't an ongoing that should be affecting report download latency via AdWords API. Could you provide the report definitions and the clientCustomerId where you observe the report download latency has increased? Could you also provide an approximate time when you started seeing this increase? Thanks, Shwetha Vastrad AdWords API Team. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/eebf5592-8458-490b-a3b2-e35a1d64f808%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Hi, I am seeing it as well. Can you tell us if there is an actual issue on your end? On Monday, September 11, 2017 at 8:35:56 PM UTC+2, Shwetha Vastrad (AdWords API Team) wrote: > > Hi, > > Could you provide the report definitions and the clientCustomerId for > which you observed reduced throughput for AdWords API report download? > Please use *Reply privately to author* when responding > > Thanks, > Shwetha, AdWords API Team. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/ae10d5dd-1785-4da9-bb9f-4ba732f6943f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: AWQL Reporting slowdown?
Hi, Could you provide the report definitions and the clientCustomerId for which you observed reduced throughput for AdWords API report download? Please use *Reply privately to author* when responding Thanks, Shwetha, AdWords API Team. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/617af39b-982c-4a9e-af65-5505c972a8d2%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
