Solved

Schedule refresh not working

Dental Marketing Australia

started a topic over 3 years ago

Hi I've added a trigger for schedule refresh but it's not updating the data.

I set it up at 12:30pm for a 1pm refresh, waited an hour but no data was updated.

Screen Shot ...

(139 KB)

Heidi Virta
said over 3 years ago

Hi,

Thanks for contacting us. Sorry for the issue with triggers.

Currently Google Sheets is the one running scheduled refreshes on sheets and it sets limits on how long these processes can run per hour. Usually this time is around 6 minutes or so. As this runtime is shared between all your sheets that use triggers, with many files and queries refreshing at the same time, they are not always be completed in time and they are instead pushed to the next hour. This is the most common reason for delays with triggers.

You should check if you have any files that use triggers which you do not need anymore. Triggers in those files might be delaying your scheduled refreshes. Also, please check if there are any such files in you recycle bin. Remove them permanently as triggers on those remain usually active regardless of their location. Please find all your triggers by navigating in Sheets to Add-ons > Supermetrics > Schedule refresh & emailing > Manage triggers in all your files.

Best regards,

Supermetrics team
D

Dental Marketing Australia
said over 3 years ago

Ok, i'm not sure if thats the issues though, I mean how long should it really take I've been waiting hours for it to update.

I've tried pressing the process all triggers now button and it still doesn't update - is that what's causing the email triggers I've got setup on completely different sheets to all be sent?....

I've only just started using Supermetrics so only have 2 triggers setup.
Heidi Virta
said over 3 years ago

Hi,

if a query is updated within one hour before the trigger is supposed to run (or the Process all triggers button is clicked) then nothing will update as the results are cached.

If you have emailing triggers, the Process all triggers now -button presses will trigger the email send. It literally processes all triggers.

My advice is, set up the triggers as you want them to be and give them at least one trigger run cycle to see if they really work (in other words at least 24 hours with daily triggers). Avoid manual refreshes on the sheet if possible.

Best,
Heidi / Supermetrics
D

Dental Marketing Australia
said over 3 years ago

Hi Heidi,

Ok great thank you, I did that and the schedule worked! =)
K

Katrina Teves
said 6 months ago

We have set the refresh schedule every 12AM. In the last 2 days, it hasn't been refreshing and we have to manually do it every 10AM Sydney. Kindly advice.
N

Nebiat Ibssa
said 6 months ago

Hi Katrina,

Sorry to hear about the issue with scheduled refreshes. If the refreshes were working and stopped at a certain date/time, we recommend to do the following in general:
1. Delete the trigger
2. Manually refresh the queries
3. Create a new schedule refresh

But there might be other reasons that can cause this in which we need to investigate further. And the investigation requires some sensitive information exchange so could you kindly send us a private ticket from here https://support.supermetrics.com/support/tickets/new

Best regards,
Supermetrics team
N

Nebiat Ibssa
said 6 months ago

NOTE:

Please send us a private ticket from here https://support.supermetrics.com/support/tickets/new for any schedule refresh related issues as those type of issues require further investigations.

Best regards, Supermetrics Team

Didn't find what you were looking for?

Start a new topic

Schedule refresh not working

Topics in this forum

Didn't find what you were looking for?