time out

[Siya Zhang]

If I schedule about 30 reports to run it will receive time out error. Is there a way I can  change the time out setting? 

Also what does empty response mean? 

Thanks all!

[Alex Bloemendal]

Am encountering the same, on a sheet with multiple reports that used to run well. 

When I remove some reports and stick to one... it works...

Did google add a time-out? or less capacity? 

Op donderdag 7 april 2016 18:43:16 UTC+2 schreef Siya Zhang:

[Eduardo Cereto Carvalho]

There was no new timeouts added to the add-on. Any addons are subjected to apps script limit of 6 minutes to run scripts. If you have multiple queries and they take longer than 6 minutes you might see an error or timeout.

What we recommend is that you try to simplify your queries or simply break it into multiple spreadsheets.

The Analytics API, can also be going through a slower period and this can cause the add on to timeout more frequently. Again this is not something specific to the add-on, and not something the add-on will handle.

In this cases waiting a few minutes and trying again can make it work. But to make it run more reliably we recommend splitting into smaller spreadsheets.

--
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/5e4dc2fd-9e83-41b0-96c0-788cef054093%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

-- Eduardo

[Bloemendal, Alex]

Hi Eduardo,

 

Even when I put it into a separate speadsheet (completely clean!), with (basic) settings below in screenshot, it does not work.

Removing the segment solves the issue, but using this segment is the purpose of this sheet… and…it used to work… have seen output…

 

Any help or tips?

 

Thanks!

 

Alex

 

Ps: we are a GA-premium user. If I need to contact someone at Google instead of using this group, plz advize J

 

[Eduardo Cereto Carvalho]

Your problem doesn't seem to be a timeout. Perhaps something wrong with your query or maybe your query returns no data. Does this query work if you try it on Query Explorer?

--

-- Eduardo

[Bloemendal, Alex]

Works without a problem in query explorer. Slow but works…

Does not work via google sheets

 

Variables in both cases

·         Property: ga:110353424

·         Start date april 1st this year

·         End date “yesterday”

·         Metrics: ga: sessions, ga:pageviews, ga:transactions (and in query explorer, even more metrics can be used and it is still working!)

·         Dimentions: ga:date

·         Sort empty

·         Filters empty

·         Segment (gaid::-7 (build in segment, direct traffic)

 

So I would say this is not a complex one, only a lot of data :0)

If I remove segment in sheets, the query works fine.

 

 

 

 

 

Van: Eduardo Cereto Carvalho <ece...@google.com>
Datum: dinsdag 10 mei 2016 17:33
Aan: Alex Bloemendal <abloe...@Wehkamp.nl>, "google-analytics-...@googlegroups.com" <google-analytics-...@googlegroups.com>
Onderwerp: Re: [google-analytics-spreadsheet-add-on] Re: time out

 

Your problem doesn't seem to be a timeout. Perhaps something wrong with your query or maybe your query returns no data. Does this query work if you try it on Query Explorer?

 

On Tue, May 10, 2016, 6:10 AM Bloemendal, Alex <abloe...@wehkamp.nl> wrote:

Hi Eduardo,

 

Even when I put it into a separate speadsheet (completely clean!), with (basic) settings below in screenshot, it does not work.

Removing the segment solves the issue, but using this segment is the purpose of this sheet… and…it used to work… have seen output…

 

Any help or tips?

 

Thanks!

 

Alex

 

Ps: we are a GA-premium user. If I need to contact someone at Google instead of using this group, plz advize J

 

Fout! Bestandsnaam niet opgegeven.

--

-- Eduardo