Huge latency when querying GEO_PERFORMANCE_REPORT

[Luis]

Hi there,

We have started to notice huge latencies when querying the GEO_PERFORMANCE_REPORT for certain accounts of our customers with significant activity / data.

We are using the Java SDK on version 4.1.0 (v2018010) and in order to avoid timeouts we have increased the property ReportDownloadedTimeout to 6 minutes, as some of the queries for certain ad account take even up to 5 minutes.

Is there any kind of issue that may affect only to certain ad accounts when query querying the GEO_PERFORMANCE_REPORT? I'll be happy to privately provide you with some ad account ids where we are seeing this huge response times. 

Many thanks in advance,

Luis

[googleadsapi...@google.com]

Hello Luis, 

Could you please confirm if you're still facing an issue? The report download requests may time out on extremely large data sets. There is no explicit data size limit; however, due to a variety of factors, the server may return an error if the report is too large. If so, could you try the report with a shorter date range or use predicates to break up the report request into multiple, smaller requests. If you're still having an issue, could you share us the complete report definition along with the timestamp and CID, so I can take a look? You can reply back via Reply privately to author option. 

Thanks,

Bharani, AdWords API Team

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@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 and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@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/25eda7f9-0db6-4618-bd25-c7938535b2d8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Luis]

Hi Bharani,

We are sorry to insist, but this is issue has started to damage our reputation. Many of our customers are complaining about it, and even a couple of them have decided to switch to a different reporting tool.

We decided to set the ReportDownloadedTimeout to 5 minutes, a more than reasonable value to have a simple query for a short date range completed. However in the last 2 days we have seen hundreds of timeouts for the following basic query:

<reportDefinition xmlns="https://adwords.google.com/api/adwords/cm/v201809">

<selector>

<fields>Country/Territory</fields>

<fields>Impressions</fields>

<fields>Clicks</fields>

<fields>Cost</fields>

</selector>

<reportName>GEO_PERFORMANCE_REPORT</reportName>

<reportType>GEO_PERFORMANCE_REPORT</reportType>

<dateRangeType>LAST_MONTH</dateRangeType>

<downloadFormat>CSV</downloadFormat>

</reportDefinition>

The strange thing is that this query is just one of many queries in a report for the same ad account, including multiple levels like account, campaign, ad group, ads, keywords and some other. For the rest of levels the queries are served almost instantaneously, and it only gets stuck for GEO_PERFORMANCE_REPORT, even though in many cases in the result set there is only one country.

We have made some tests in local environments setting the ReportDownloadedTimeout to 10 minutes, and we kept on receiving timeouts.

We are seeing this issue with many ad accounts, including the following ones: 8288984184,  

7565976286, 1114516196, 3628262848, 8713160172, 5307407306, 5868186930, 1931259100, 8653251000, 7564793223, 4732128939, 3803450091, 5929009380, 2655252409, 3617905552, and 4189160692.

Hope you can solve this issue very soon, as it is really impacting our business.

[Jean-Fabrice Rabaute]

Hi,

We are seeing the same high latency errors, started 24 hours ago.

It seems to happen on the GEO_PERFORMANCE_REPORT table.

I can reproduce the timeout all the time by running this query on some of the accounts I have access to:

----------------------

select

CityCriteriaId, Clicks, Impressions, Cost, CountryCriteriaId

from GEO_PERFORMANCE_REPORT

during LAST_MONTH

----------------------

Using LAST_7_DAYS works fine (it takes around 2 seconds to get back the answer).

Using LAST_30_DAYS works fine (it takes around 2 seconds to get back the answer).

Using LAST_MONTH hangs and returns an error (I'm using the official PHP library).

Using the adwords UI directly, I see the same problem (by selecting last month for the report). It hangs...

(tested with the https://www.awql.me service for the awql queries).

Our code hasn't changed on our side, and all the other queries are working correctly.

Please can you confirm there are problems on your side?

Thank you.

[Jean-Fabrice Rabaute]

Hi Bharani,

I sent you a private message with the account ID I've used to generate the problem with the awql query. It fails all the time using this query.

I don't think there is more traffic on this account thatn in 2018, so that is really strange that it's starting to fail right now.

Please keep the thread posted about your findings.

Thanks.

[googleadsapi...@google.com]

Hello all, 

Thank you for sharing the details privately. I have passed this information to our Engineering team. I will keep you posted on the updates.  

Regards,

Bharani, AdWords API Team

[al...@trueclicks.com]

We see the same problem here. This report took around 60-90 seconds to download, it takes now more than 2 hours and fails.

[Ian P]

Chiming in we are the same issue.

[googleadsapi...@google.com]

Hello Ian, 

Could you please confirm if you're downloading the GEO_PERFORMANCE_REPORT and seeing the issue? If so, this is a known issue and our team is looking into this. If not, could you please share the API SOAP logs so I can troubleshoot this further? You can reply back via Reply privately to author option.

Thanks,

Bharani, AdWords API Team

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/

--

--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@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 and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@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/ab12628a-90d4-4fe2-9f99-b6b5fc7254ed%40googlegroups.com.

[Ian P]

Hi Luis,

Yes, confirmed it is the GEO_PERFORMANCE_REPORT. If I impose more strict limitations on the report I can get it in a little under 2 minutes, but it's not usable for our report.

Thanks,

Ian

On Wednesday, January 23, 2019 at 3:46:41 PM UTC-5, Luis wrote:

[googleadsapi...@google.com]

Hello All,

I just wanted to give an update that we are actively working on this. It appears to be affecting just this report and only specific customers. We are working on trying to find the source of the issue, which appears to be a bit tricky. I'll give updates as soon as I have more news.

Best,

Nadine Sundquist, AdWords API Team
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Also find us on our blog and discussion group:
    http://googleadsdeveloper.blogspot.com/search/label/adwords_api
    https://developers.google.com/adwords/api/community/

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--

--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@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 and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@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/4ace3794-b334-456f-a363-97a94ce528bb%40googlegroups.com.

[wij...@trueclicks.com]

Hi there,

Just curious if this has been fixed as we run into similar time out issues.

Thanks!

[googleadsapi...@google.com]

Hello,

Yes, it was recently fixed. So, you should be seeing better performance on this. If it's still persisting for you, could you start a new forum thread with some information of what is going on specifically for you? You may have a narrow case that may be affecting you at the moment.

Thanks,

Nadine Sundquist, AdWords API Team
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    http://googleadsdeveloper.blogspot.com/search/label/adwords_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/5bb2665d-1fe0-424a-9915-25e052761d93%40googlegroups.com.