Quota Error: Rate Limit Exceeded

[Anders Lynderup]

Hi

What exactly does this error refer to?

I got this error on sheets where I just get traffic results for the past 30 days.

In total i got this error for 5 data sheets in my excel doc file, but none of them have to many rows with data..

[Davis Jones]

I'm having this same problem and I'm pulling reports from 5 GA properties onto 5 Google Sheets daily

[Philip Walton]

The add-on uses the Core Reporting API under the hood, so it's subject to all the same limits and quota of that API. 

You can read about quota limits here:

https://developers.google.com/analytics/devguides/config/mgmt/v3/limits-quotas

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/ed9a505e-3f38-4199-bdbb-c9e410f28008%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Andrea Rapanaro]

Hi

I have the same issue, and in the API https://developers.google.com/analytics/devguides/reporting/core/v3/coreErrors it states

403 userRateLimitExceeded: indicates that the user rate limit has been exceeded. The maximum rate limit is 10 qps per IP address. The default value set in Google Developers Console is 1 qps per IP address. You can increase this limit in the Google Developers Console to a maximum of 10 qps.

My guess is that it's not about the size, but the Add On is firing all requests in a too short timeframe. The question is: how to tune this?? Any ideas?

[Philip Walton]

Hey Andrea, there probably isn't anything for you to do here. I'm not entirely sure why this suddenly started happening, but it's almost certainly not something you did on your end.

The reports are run by the sheets processor, so what's most likely happening is they all have the same IP address and that "user" is hitting the quota limit.

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/2d2aa50e-ad01-4ade-a5cd-a62cd393ab6b%40googlegroups.com.

[Andrea Rapanaro]

Thanks for the reply. I understand, but what's the solution here?

On Friday, December 18, 2015 at 11:45:30 PM UTC+1, Philip Walton wrote:

Hey Andrea, there probably isn't anything for you to do here. I'm not entirely sure why this suddenly started happening, but it's almost certainly not something you did on your end.

The reports are run by the sheets processor, so what's most likely happening is they all have the same IP address and that "user" is hitting the quota limit.

On Thu, Dec 17, 2015 at 12:49 AM, Andrea Rapanaro <andrea....@ctp.com> wrote:

Hi

I have the same issue, and in the API https://developers.google.com/analytics/devguides/reporting/core/v3/coreErrors it states

403 userRateLimitExceeded: indicates that the user rate limit has been exceeded. The maximum rate limit is 10 qps per IP address. The default value set in Google Developers Console is 1 qps per IP address. You can increase this limit in the Google Developers Console to a maximum of 10 qps.

My guess is that it's not about the size, but the Add On is firing all requests in a too short timeframe. The question is: how to tune this?? Any ideas?

On Monday, November 16, 2015 at 8:36:47 AM UTC+1, Anders Lynderup wrote:

Hi

What exactly does this error refer to?

I got this error on sheets where I just get traffic results for the past 30 days.

In total i got this error for 5 data sheets in my excel doc file, but none of them have to many rows with data..

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.

[Xavier Marchand]

Same issue here, although the reports process very little data. 

From the other post with the same subject line, I understand that you're working on a fix. If you have an ETA at some point, that would be great!

[Philip Walton]

To update everyone one this, what's happening is the Core Reporting API has IP rate limits, and since a lot of people use this add-on, and the actual script is probably only run on a handful of Google servers, these rate limits are being reached.

The Core Reporting API does not currently have an IP whitelist, so the GA team is planning to work on building one. However, it will probably take at least a week, maybe more to implement, test, QA, document, and release the feature.

On Tue, Jan 5, 2016 at 2:44 PM, Xavier Marchand <marchan...@gmail.com> wrote:

Same issue here, although the reports process very little data. 

From the other post with the same subject line, I understand that you're working on a fix. If you have an ETA at some point, that would be great!

On Monday, January 4, 2016 at 9:41:36 AM UTC+1, Andrea Rapanaro wrote:

Thanks for the reply. I understand, but what's the solution here?

On Friday, December 18, 2015 at 11:45:30 PM UTC+1, Philip Walton wrote:

Hey Andrea, there probably isn't anything for you to do here. I'm not entirely sure why this suddenly started happening, but it's almost certainly not something you did on your end.

The reports are run by the sheets processor, so what's most likely happening is they all have the same IP address and that "user" is hitting the quota limit.

On Thu, Dec 17, 2015 at 12:49 AM, Andrea Rapanaro <andrea....@ctp.com> wrote:

Hi

I have the same issue, and in the API https://developers.google.com/analytics/devguides/reporting/core/v3/coreErrors it states

403 userRateLimitExceeded: indicates that the user rate limit has been exceeded. The maximum rate limit is 10 qps per IP address. The default value set in Google Developers Console is 1 qps per IP address. You can increase this limit in the Google Developers Console to a maximum of 10 qps.

My guess is that it's not about the size, but the Add On is firing all requests in a too short timeframe. The question is: how to tune this?? Any ideas?

On Monday, November 16, 2015 at 8:36:47 AM UTC+1, Anders Lynderup wrote:

Hi

What exactly does this error refer to?

I got this error on sheets where I just get traffic results for the past 30 days.

In total i got this error for 5 data sheets in my excel doc file, but none of them have to many rows with data..

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/2d2aa50e-ad01-4ade-a5cd-a62cd393ab6b%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/c44738f9-bbdc-4a46-a1cb-e7836d17732f%40googlegroups.com.

[a...@peytz.dk]

Hi

the limits and quota page contains this:

If your application makes all API requests from a single IP address (i.e. on behalf of your users) you should consider using the userIP or quotaUser parameters with each request to get full QPS quota for each user. See the query parameters summary for details.

And again from google documentation (https://developers.google.com/analytics/devguides/reporting/realtime/v3/parameters#callback):

quotaUser Lets you enforce per-user quotas from a server-side application even in cases when the user's IP address is unknown. This can occur, for example, with applications that run cron jobs on App Engine on a user's behalf.

   

I don't think we need to wait for a fix from GA team, we just need to update the implementation a little bit.

[Philip Walton]

Thanks, but the apps-scripts framework already implements the quotaUser parameter, so that was already in place and it was still an issue.

However, the fix for this went live last week, so you should stop seeing quota errors when using this add-on.

--

You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/09344486-014c-4b3a-a36b-fc407350e9bc%40googlegroups.com.

[mscellan...@gmail.com]

I received Quota Error: User Rate Limit Exceeded.  Did anybody else experience this error since "the fix" was implemented?  Appreciate any help to solve this issue.

[Philip Walton]

So, you're receiving a different error. I know the names are kinda confusing, but the "fix" went out for the error: "Quota Error: Rate Limit Exceeded" and the error you got was "Quota Error: User Rate Limit Exceeded".

The error you got indicates that you personally are using more quota than you're allowed.

To figure out if this is legit or not, I'll need more info from you:

- Did you get this error from a scheduled report or from just running the reports in Sheets?

- How many reports are in the spreadsheet you're getting the error from?

- Are you running reports for more than one spreadsheet at the same time?

On Thu, Feb 25, 2016 at 10:49 AM, <mscellan...@gmail.com> wrote:

I received Quota Error: User Rate Limit Exceeded.  Did anybody else experience this error since "the fix" was implemented?  Appreciate any help to solve this issue.

--

You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/3c94b937-0c14-417e-a888-0f3aff669470%40googlegroups.com.

[mscellan...@gmail.com]

Haha, OK.  I have 4 Sheets that are grabbing data from Google Analytics.  I haven't changed anything recently and they've been running smoothly for the past 2 or 3 months since they were created.  To answer your questions:

-Error was from scheduled report

-I have 12 GA reports in Sheets that are scheduled for daily refresh.

-Yes.  Is it possible to circumvent the error by scheduling the refresh at different times?  

[Philip Walton]

To be honest this error confuses me as well. Technically it means you're making more than 10 requests in a single second, which uses up your quota. And since the add-on makes all requests in series, it's not clear how that could happen.

Scheduling your requests to run at different times couldn't hurt, but if they've been running successfully for months then there's probably something else going on.

I wouldn't worry too much about it unless it starts happening almost every time they run.

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/fbc2b1d9-879b-4412-b9e9-931183ad2058%40googlegroups.com.