schedule report didn't run

[Wayne Fu]

I installed the "google-analytics-spreadsheet-add-on" in google spreadsheet → set "Schedule Report" → "Enable reports to run automatically" → run "every hour"

I watch the GA data for 2 domains, but found this add-on stop updating report recnetly:

1 stop on May. 24

1 stop on May. 28

Even yesterday I manually resume to run the report, but found that this add-on still won't automatically run the report until today.

Is there something wrong with this add-on? or should I provide my spreadsheet url for evalutation ?

[Philip Walton]

Did it continue to run after those misses without you doing anything, or did you have to do something to get it to run again? Also, did you get any email errors?

--
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/a901ac22-1c99-47c5-bab2-9731e3de2c0d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Wayne Fu]

1. no, it never run automatically after  those misses. 

2. I have to manually → add-on → Google Analytics → Run Reports, then it will run.

3. I didn't get email error notification

BTW, I've tried new Google Drive and old Google Drive, both are same status as above.

Philip Walton於 2015年6月3日星期三 UTC+8上午12時11分37秒寫道：

Did it continue to run after those misses without you doing anything, or did you have to do something to get it to run again? Also, did you get any email errors?

On Mon, Jun 1, 2015 at 7:31 PM, Wayne Fu <wayn...@gmail.com> wrote:

I installed the "google-analytics-spreadsheet-add-on" in google spreadsheet → set "Schedule Report" → "Enable reports to run automatically" → run "every hour"

I watch the GA data for 2 domains, but found this add-on stop updating report recnetly:

1 stop on May. 24

1 stop on May. 28

Even yesterday I manually resume to run the report, but found that this add-on still won't automatically run the report until today.

Is there something wrong with this add-on? or should I provide my spreadsheet url for evalutation ?

--
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.

[Andy Page]

I'm seeing the same thing.

I have 6 Reports in a spreadsheet and it runs fine manually and up until about 2 weeks ago would run fine every hour.

2 weeks ago I got a report that there was an "internal error". I ran it again manually and it worked. I then disabled all my scheduled triggers and then re-enabled just this one spreadsheet. 

However it still has not run manually and I get no email/warnings.

Not sure what else to try.

Is there any hidden log that the scheduler produces?

[Philip Walton]

On Wed, Jun 3, 2015 at 8:00 AM, Andy Page <andyp...@gmail.com> wrote:

Is there any hidden log that the scheduler produces?

Unfortunately there is no log that I have access to. I've mentioned to the add-ons team that this is happening, and they've said they'll look into it, but that's about all I can do at this point.

If you discover any predictable way to consistently reproduce this issue, that would be very helpful and probably make it a lot easier for them to fix the bug.

 

[Andy Page]

Thanks Philip, quite understand.

Much appreciated. 

At present I'm having to run them manually. I can't seem to get the scheduler working at all :)

I'll try at the weekend to create a simplified spreadsheet with just 1 report and go from there,

[Wayne Fu]

I would provide one way for "add-ons team" to check:

recently Google Data API has changed:

https://developers.google.com/gdata/docs/auth/clientlogin

if this GA add-on use old way of "ClientLogin", maybe this is why cause internal error, and we won't receive the error email notification. Please check if this GA add-on use "OAuth 2.0" instead.


Philip Walton於 2015年6月5日星期五 UTC+8上午6時46分03秒寫道：

[Will Sun]

I'm facing the same issue :(

[Sharon Seymour]

Add me to the list. Working fine a few weeks ago but its just not running anymore on schedule. works fine manually

[Fiona Weston]

I am having this issue also. Is there any fix?

[Robert Kingston]

Hi guys,

We're seeing this issue too. We have a spreadsheet with 20 reports inside. Basically scheduled reports were running fine up until a few weeks ago.

I recieved an error by email stating:

Error message
1 report failed due to errors:
[report-name]: There was an internal error.

I tried setting up scheduling again and it said it worked, but it didn't.

Then I tried setting it up again today and it threw an error message:

ScriptError: This add-on has created too many time-based triggers in this document for this Google user account.

To get around this issue I enter Script editor and clear my triggers. I can Schedule the reports again without issue, but time will tell whether it break again or not.

Cheers,

Rob

[Oleg Sakharov]

We also experienced the same issue. Two reports that were scheduled to run every hours stopped running few weeks ago. Running reports manually worked but didn't help the scheduled process. Today I changed the schedule to once a day and just it first time executed automatically. I'll keep monitoring it, but my theory is that one hour is not enough for some reports to get executed and Google servers just kill the background processes in such case.

[Paul Stebbings]

I'm getting the same issue. I had reports scheduled to run hourly and they got knocked out about a couple of weeks ago. I received an email

"The Google Analytics Spreadsheet add-on encountered an error while attempting to run the scheduled reports in the following spreadsheet:
https://docs.google.com/spreadsheets/xyz

Error message
1 report failed due to errors:

'Report name': Backend Error"

This knocked out all the other reports in the spreadsheet from updating. The date settings for the report were set using '=TODAY()' and cell containing '=TODAY()'-7. The date in the reports tab hadn't updated, I can't remember whether the date had updated in the actual report configuration or not.

I'm using this add on to embed the reports into a dashboard which I now can't rely on to update automaticall. Any word on a diagnosis, and a timeframe of a potential fix??

Paul

[Philip Walton]

Hey Paul, is this your only spreadsheet that has scheduling or do you have a few? If you have more than this one, has all scheduling stopped?

The one thing I've heard from a few people that seems to help is to just make a copy of the sheet and re-enable scheduling. Let me know if that doesn't work.

--

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/0cd68487-ed44-49ae-be34-e82e400e3721%40googlegroups.com.

[Philip Walton]

If you use the "Spreadsheet URL" feature, you can output report data to a separate spreadsheet and thus decouple the report config sheet from your report dashboards.

That way, if you have to make a copy, you don't lose any work.

On Wed, Sep 30, 2015 at 1:27 AM, Paul Stebbings <pauldst...@gmail.com> wrote:

Hi Philip,

No I've got two that I'm using at the moment but only one of them stopped working. Actually - thinking about it - that's not true they both stopped working but I only had an error relating to one of the reports in one of the spreadsheets.

I could create a copy but what there's no guarantee that the copy wouldn't stop scheduling. That's addressing a symptom rather than being a cure. Also I've got possible 20 graphs/reports embedded into an intranet from the failing spreadsheet which I'd like to avoid reembedding and getting the scaling to fit.

The specific report that

Thanks,

Paul 

[si...@gomentor.com]

I am also having this issue. My hourly scheduled reports isn't working anymore. It used to work, but now it only works by running the report manually. I havne't changed anything. What can I do to fix it?

[si...@gomentor.com]

Update: Still having the issue. Now I received emails about the error. It is "There was an internal error" for all of the goals it should run reports on. I don't know what to do with it.

[Philip Walton]

Yesterday there were some general problems with the API that were affecting the add-on, but those seemed to have been solved. I believe they were unrelated to 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/cac2ba31-a8bd-4b89-9809-91cd5bf48c39%40googlegroups.com.

[mikela...@gmail.com]

Any updates on this?  I have a rather large spreadsheet pulling a couple dozen reports to automatically populate a dashboard widgets on Google MySites, and the thought of needing to copy the spreadsheet and remap all of the dashboard fields makes we want to go play in traffic.

[Philip Walton]

As I've mentioned to others on this thread, if you use the "Spreadsheet URL" function to output results to separate sheets, you won't need to worry about remapping results if you ever have to copy a spreadsheet.

I know it's not an ideal solution, but until someone can reproduce this issue (I can't), this bug is going to remain a problem.

--

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/9f5d6da3-2429-4522-a7d2-46242a9a3de2%40googlegroups.com.

[Philip Walton]

I don't have an official update on this, but I've heard that in a recent release of apps-scripts, a lot of triggers bugs were fixed. Hopefully that means this issue was fixed with them. Please follow up here if schedule reports continue to randomly stop working.

On Monday, November 23, 2015 at 10:47:47 AM UTC-8, Philip Walton wrote:

As I've mentioned to others on this thread, if you use the "Spreadsheet URL" function to output results to separate sheets, you won't need to worry about remapping results if you ever have to copy a spreadsheet.

I know it's not an ideal solution, but until someone can reproduce this issue (I can't), this bug is going to remain a problem.

On Mon, Nov 23, 2015 at 10:21 AM, <mikela...@gmail.com> wrote:

Any updates on this?  I have a rather large spreadsheet pulling a couple dozen reports to automatically populate a dashboard widgets on Google MySites, and the thought of needing to copy the spreadsheet and remap all of the dashboard fields makes we want to go play in traffic.

On Monday, June 1, 2015 at 10:31:43 PM UTC-4, Wayne Fu wrote:

I installed the "google-analytics-spreadsheet-add-on" in google spreadsheet → set "Schedule Report" → "Enable reports to run automatically" → run "every hour"

I watch the GA data for 2 domains, but found this add-on stop updating report recnetly:

1 stop on May. 24

1 stop on May. 28

Even yesterday I manually resume to run the report, but found that this add-on still won't automatically run the report until today.

Is there something wrong with this add-on? or should I provide my spreadsheet url for evalutation ?

--
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.

[João Correia]

Hi,

I'm having the same issue, scheduled reports don't run. Any idea on how to fix this?

Thanks

Joao

[Michael Lauwers]

try turning off the scheduling altogether, refreshing the page, then scheduling it fresh all over again.  That seemed to work for me.  Than again I might have just gotten lucky.  

On Tue, Jan 26, 2016 at 8:02 PM, João Correia <jcor...@blastam.com> wrote:

Hi,

I'm having the same issue, scheduled reports don't run. Any idea on how to fix this?

Thanks

Joao

On Friday, January 15, 2016 at 12:03:50 PM UTC-8, Philip Walton wrote:

I don't have an official update on this, but I've heard that in a recent release of apps-scripts, a lot of triggers bugs were fixed. Hopefully that means this issue was fixed with them. Please follow up here if schedule reports continue to randomly stop working.

On Monday, November 23, 2015 at 10:47:47 AM UTC-8, Philip Walton wrote:

As I've mentioned to others on this thread, if you use the "Spreadsheet URL" function to output results to separate sheets, you won't need to worry about remapping results if you ever have to copy a spreadsheet.

I know it's not an ideal solution, but until someone can reproduce this issue (I can't), this bug is going to remain a problem.

On Mon, Nov 23, 2015 at 10:21 AM, <mikela...@gmail.com> wrote:

Any updates on this?  I have a rather large spreadsheet pulling a couple dozen reports to automatically populate a dashboard widgets on Google MySites, and the thought of needing to copy the spreadsheet and remap all of the dashboard fields makes we want to go play in traffic.

On Monday, June 1, 2015 at 10:31:43 PM UTC-4, Wayne Fu wrote:

I installed the "google-analytics-spreadsheet-add-on" in google spreadsheet → set "Schedule Report" → "Enable reports to run automatically" → run "every hour"

I watch the GA data for 2 domains, but found this add-on stop updating report recnetly:

1 stop on May. 24

1 stop on May. 28

Even yesterday I manually resume to run the report, but found that this add-on still won't automatically run the report until today.

Is there something wrong with this add-on? or should I provide my spreadsheet url for evalutation ?

--
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.

[Andy Page]

Yep, that's exactly what I did a few weeks ago and that seems to have fixed my issue.

On Wednesday, 27 January 2016 14:33:22 UTC, Michael Lauwers wrote:

try turning off the scheduling altogether, refreshing the page, then scheduling it fresh all over again.  That seemed to work for me.  Than again I might have just gotten lucky.  

On Tue, Jan 26, 2016 at 8:02 PM, João Correia <jcor...@blastam.com> wrote:

Hi,

I'm having the same issue, scheduled reports don't run. Any idea on how to fix this?

Thanks

Joao

On Friday, January 15, 2016 at 12:03:50 PM UTC-8, Philip Walton wrote:

I don't have an official update on this, but I've heard that in a recent release of apps-scripts, a lot of triggers bugs were fixed. Hopefully that means this issue was fixed with them. Please follow up here if schedule reports continue to randomly stop working.

On Monday, November 23, 2015 at 10:47:47 AM UTC-8, Philip Walton wrote:

As I've mentioned to others on this thread, if you use the "Spreadsheet URL" function to output results to separate sheets, you won't need to worry about remapping results if you ever have to copy a spreadsheet.

I know it's not an ideal solution, but until someone can reproduce this issue (I can't), this bug is going to remain a problem.

On Mon, Nov 23, 2015 at 10:21 AM, <mikela...@gmail.com> wrote:

Any updates on this?  I have a rather large spreadsheet pulling a couple dozen reports to automatically populate a dashboard widgets on Google MySites, and the thought of needing to copy the spreadsheet and remap all of the dashboard fields makes we want to go play in traffic.

On Monday, June 1, 2015 at 10:31:43 PM UTC-4, Wayne Fu wrote:

I installed the "google-analytics-spreadsheet-add-on" in google spreadsheet → set "Schedule Report" → "Enable reports to run automatically" → run "every hour"

I watch the GA data for 2 domains, but found this add-on stop updating report recnetly:

1 stop on May. 24

1 stop on May. 28

Even yesterday I manually resume to run the report, but found that this add-on still won't automatically run the report until today.

Is there something wrong with this add-on? or should I provide my spreadsheet url for evalutation ?

--
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.

[Seif Fendukly]

We have the same problem. I've tried copying to a new spreadsheet and it doesn't work. I've tried about everything and it seems to be some fatal error with the plugin.

Anyone have any fix yet?

[Philip Walton]

Hey Seif,

This is not a problem with the add-on (if it was, I would fix it), it's a problem with the underlying scheduling system in Apps Scripts. I've filed a few bugs internally for this, but it's been hard for the team to reliably reproduce the issue and thus it's hard to say what's causing it.

The best way you can help is try to find a way to reliably reproduce the failure, i.e. does it always happen after a certain number of days? Does it only happen if running a certain number of reports? Does it only happen in conjunction with other add-ons you may have installed?

If you want to go further than that, you can email me (privately) a link to the spreadsheet as well as the time the scheduled report stopped running. You can figure out the time by looking at the previous time it ran and adding the interval to that (does that make sense?).

Beyond that, there's not really anything I can do (unfortunately) since I don't control the apps scripts team or the priority in which they fix bugs.

Philip

--

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/15dd1be3-b076-4799-a9d0-6e12674a7dd2%40googlegroups.com.

[Lee Acton]

I set up a main sheet that collated 8 reports and have had nothing but issues with the scheduler for the last 3 months it appears to stop on random sheets. If I manually restart them they work and I have checked the scheduler is setup correctly and they all are. Is there a date on when this will be fixed?

Regards

Lee

[Josh Bernstein]

We're having the same issues, however i'm only consistently seeing this occur with our sheets that contain 22 and 34 reports within them.  Of the 10 Report sheets, these two seem to fail each day(i.e. i look in the morning and they haven't run since the prior day.  They may update a few times after i manually run the add-on, but come the next day they more than likely will not have run overnight.).  They also happen to be the largest report segments we run.

Each report within the 2 main problem sheets is using:

Start/End Date Calculations
Up to 5 Metrics

Up to 3 Dimensions
Sort

Filter

Segments

Sampling level: High

All reports feed external sheets for display, so we aren't losing data, but it can be confusing if we don't realize a report didn't run.  A helpful tip for anyone running a dashboard is to incorporate the "Last Run On" report field into your dashboard.

We do not have any other add-ons.

Best,

Josh B.

Looking forward to this being resolved, so please let me know if you'd like any additional information.

On Monday, March 14, 2016 at 12:19:32 PM UTC-7, Philip Walton wrote:

Hey Seif,

This is not a problem with the add-on (if it was, I would fix it), it's a problem with the underlying scheduling system in Apps Scripts. I've filed a few bugs internally for this, but it's been hard for the team to reliably reproduce the issue and thus it's hard to say what's causing it.

The best way you can help is try to find a way to reliably reproduce the failure, i.e. does it always happen after a certain number of days? Does it only happen if running a certain number of reports? Does it only happen in conjunction with other add-ons you may have installed?

If you want to go further than that, you can email me (privately) a link to the spreadsheet as well as the time the scheduled report stopped running. You can figure out the time by looking at the previous time it ran and adding the interval to that (does that make sense?).

Beyond that, there's not really anything I can do (unfortunately) since I don't control the apps scripts team or the priority in which they fix bugs.

Philip

On Mon, Mar 14, 2016 at 9:47 AM, Seif Fendukly <se...@conversionista.se> wrote:

We have the same problem. I've tried copying to a new spreadsheet and it doesn't work. I've tried about everything and it seems to be some fatal error with the plugin.

Anyone have any fix yet?

On Tuesday, June 2, 2015 at 4:31:43 AM UTC+2, Wayne Fu wrote:

I installed the "google-analytics-spreadsheet-add-on" in google spreadsheet → set "Schedule Report" → "Enable reports to run automatically" → run "every hour"

I watch the GA data for 2 domains, but found this add-on stop updating report recnetly:

1 stop on May. 24

1 stop on May. 28

Even yesterday I manually resume to run the report, but found that this add-on still won't automatically run the report until today.

Is there something wrong with this add-on? or should I provide my spreadsheet url for evalutation ?

--
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.

[Sean McAlister]

I am having the same issue which is causing issues.  I've got multiple reports built (over 100), tons of work and just noticed that they are not updating hourly.
It's random.  Some reports update, others do not.

Can't pinpoint what the issue is for replication on Dev side.  But would be great to get this fixed.

Any updates?

[Philip Walton]

Yes, I do have an update.

I just heard from the add-ons team that they've implemented better logging. So if anyone has a spreadsheet with scheduling enabled that failed to run, please send me a link to the spreadsheet URL as well as the time it was supposed to run but didn't.

I'll forward that on to the add-on's team, which will hopefully help them diagnose the problem.

Note that the new logging went live today, so these failures will have to have happened today or at some point going forward (failures from the past aren't helpful to them unfortunately).

--

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/1ea8fbbf-3ffb-41a9-bd26-fe3d154f70c8%40googlegroups.com.

[Philip Walton]

Sean, I passed your sheet along to some people on the add-ons team and they don't see any evidence of scheduled reports ever having run for that sheet in the last 7 days.

Are you saying the the scheduling stopped or are you saying the first scheduled reports never ran?

On Thu, Apr 7, 2016 at 4:26 AM, Sean McAlister <seanmca...@gmail.com> wrote:

Hey Philip, thanks.

As I indicated, I've got a ton of sheets, some that include sensitive data that I can't share.  However, here's a link to one of the main sheets.  It's scheduled to update hourly and hasn't updated since I manually pushed it yesterday.

https://docs.google.com/spreadsheets/d/12V86RyzNeFghEZQlq85C_iP1GXZAoWDCd9d3xrdpQ2A/edit?usp=sharing

[Sean McAlister]

Im saying its hit and miss. Some of my sheets up date as scheduled. Others like the one I shared with you sometimes update and sometimes do not.

When they do update it seems to be somewhat sporadic vs at the scheduled time.

I appreciate the support, love this addon...the whole point of us using it is for these auto updates :)

Could the fact that the sheet is shared be impacting anything?

--
Sent from Gmail Mobile

[Philip Walton]

Sean, like I said I need to provide the add-ons team an actual example of a failure. For clarification, here's what I need:

1. The URL of a spreadsheet that was successfully running scheduled reports

2. The time of the last successful report and the time of the report that failed (you can get this time from the "Last Run On" value in the report sheet).

Alternatively, if the scheduled reports were enabled but *never* ran, I need:

1. The URL of the spreadsheet for which scheduling was turned on, but the reports never ran.

2. The best approximation you can give me of when the reports should have run.

BTW (and this applies to anyone reading), you don't need to share the sheet with the world, just the sheet URL is sufficient for the add-ons team to inspect their logs. And if you don't want to email this whole group, just email me individually.

[Nathan Brunetti]

I'm not able to find the "Last Run On" value in the reports sheet. Can you describe where that is?

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

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/1ea8fbbf-3ffb-41a9-bd26-fe3d154f70c8%40googlegroups.com.

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

[Philip Walton]

Just do a search for that text in the sheet.

"Edit" > "Find and Replace"

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/1ea8fbbf-3ffb-41a9-bd26-fe3d154f70c8%40googlegroups.com.

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

--
Sent from Gmail Mobile

--
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/15435653-a3ad-4cfd-a7ad-970e11c6ccc0%40googlegroups.com.

[Nathan Brunetti]

I was able to find it and all of my reports say they were last run on 5/18/2016 13:32:10.

Is this what you were looking for? Do you want a link to one of the reports?

Thanks,

Nathan

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/1ea8fbbf-3ffb-41a9-bd26-fe3d154f70c8%40googlegroups.com.

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

--
Sent from Gmail Mobile

--
You received this message because you are subscribed to a topic in the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-analytics-spreadsheet-add-on/L1k-zKpJplM/unsubscribe.
To unsubscribe from this group and all its topics, 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/15435653-a3ad-4cfd-a7ad-970e11c6ccc0%40googlegroups.com.

[Philip Walton]

To provide an update on this issue:

A fix for one of the two bugs causing this issue went live earlier today. However, the fix will not affect existing schedules, so if you're experience this problem, you'll need to disable and re-enable scheduling to get the fix. To be on the safe site, it's probably best to just do this regardless:

1. Open up the scheduling dialog, uncheck "Enable reports to run automatically" and click "Save"
2. Open up the scheduling dialog, check "Enable reports to run automatically", set your desired schedule, and click "Save".

If after doing this you still encounter failure, please report them directly to me and include the following information:

1) A link to the sheet that failed to update.
2) The email address off the owner of the sheet.
3) The date/time of the last known scheduled run (not manual run).
4) The frequency with which scheduled reports are supposed to run.
5) Whether or not the schedule dialog indicates that scheduling is currently enabled.

[Margo Affleck]

[Jorge Cunha]

hI,

Must be flag in error control to stop report scheduling to run on error infinitive, this is on user level because  I got to internal errors on 2 worksheet but i have a bunched that stop working on schedule.

Here is on off them  https://docs.google.com/spreadsheets/d/1leayNNuaNjRJd047XMmrJ-PYqA5JskTocf13yw5JyNg/edit#gid=1931438947

Can you please see

BR

Jorge

On Thursday, April 7, 2016 at 3:50:26 AM UTC+1, Philip Walton wrote:

Yes, I do have an update.

I just heard from the add-ons team that they've implemented better logging. So if anyone has a spreadsheet with scheduling enabled that failed to run, please send me a link to the spreadsheet URL as well as the time it was supposed to run but didn't.

I'll forward that on to the add-on's team, which will hopefully help them diagnose the problem.

Note that the new logging went live today, so these failures will have to have happened today or at some point going forward (failures from the past aren't helpful to them unfortunately).

On Wed, Apr 6, 2016 at 7:46 PM, Sean McAlister <seanmca...@gmail.com> wrote:

I am having the same issue which is causing issues.  I've got multiple reports built (over 100), tons of work and just noticed that they are not updating hourly.
It's random.  Some reports update, others do not.

Can't pinpoint what the issue is for replication on Dev side.  But would be great to get this fixed.

Any updates?

--
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.

[ric...@opened.io]

I can confirm that Michael Lauwers' fix works

He said, "try turning off the scheduling altogether, refreshing the page, then scheduling it fresh all over again.  That seemed to work for me.  Than again I might have just gotten lucky."

[Jorge Cunha]

Just confiming that stoping the schedule and closing spreadsheet, first. Then I turned on again before I recommend cleanning the cache of the chrome browser.

Thank you all

[jeffr...@gmail.com]

Is this pretty much how it is?  The cache trick and turning schedule on and off works sometimes but even if it does its at most 72 hours.  

At this point im trying to find a script that will click the run reports menu item b/c thats the only reliable way to get these to refresh.  

My guess is the more reports you are refreshing the less reliable this plugin scheduler will be.  

[Philip Walton]

As I've stated before, this issue is unrelated to the Google Analytics Spreadsheet Add-on, it's an issue with the underlying scheduling used by app scripts, so there's nothing I can change to make the situation better.

What I *can* do is report occurrences of failures to the apps scripts team to help them investigate, so if you send those to me, I'll pass them on. Follow the instructions I mentioned here:

https://groups.google.com/d/msg/google-analytics-spreadsheet-add-on/L1k-zKpJplM/FqdWAD70AwAJ

 

--
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.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/bab1145b-9e82-4b79-9985-00cbd459563c%40googlegroups.com.

[Lallu Vemula]

Is the option to schedule reports deprecated in GA 360 connected to G-sheets? I attempted to automatically update the data, but it's not functioning as expected. Consequently, I've been manually running the reports.

On Monday 16 October 2017 at 23:00:11 UTC+5:30 Philip Walton wrote:

On Sun, Oct 15, 2017 at 4:06 PM, <jeffr...@gmail.com> wrote:

Is this pretty much how it is?  The cache trick and turning schedule on and off works sometimes but even if it does its at most 72 hours.  

At this point im trying to find a script that will click the run reports menu item b/c thats the only reliable way to get these to refresh.  

My guess is the more reports you are refreshing the less reliable this plugin scheduler will be.  

As I've stated before, this issue is unrelated to the Google Analytics Spreadsheet Add-on, it's an issue with the underlying scheduling used by app scripts, so there's nothing I can change to make the situation better.

What I *can* do is report occurrences of failures to the apps scripts team to help them investigate, so if you send those to me, I'll pass them on. Follow the instructions I mentioned here:

https://groups.google.com/d/msg/google-analytics-spreadsheet-add-on/L1k-zKpJplM/FqdWAD70AwAJ

 

--
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.

[Kristen Poff]

I have 4 Google Sheets reports scheduled to update daily 6-7am and they aren't updating. I have tried everything and they still won't run.