Have you created any new heavy queries lately? (thousands of cells of results), or do you have any huge Google Sheets files that have large amounts of data in them from Supermetrics queries?
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.
Normally Google provides more time to users with G Suite business account. If you are not using G Suite, upgrading to that can help.
Tips and tricks for trigger issues
1. Remove unnecessary triggers / files
You should check if you have any files with triggers that 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. See all your triggers in Add-ons > Supermetrics > Schedule refresh & emailing > Manage triggers in all your files.
2. Delete and re-create
Please try fixing the malfunctioning trigger following these steps:
- Open the Sheet with refresh issues
- Delete the existing trigger(s)
- Open the Supermetrics sidebar, and refresh each query in the sheet one-by-one by clicking the blue Refresh button in sidebar (easiest in SupermetricsQueries hidden sheet, where you can open queries row by row)
- After all refreshes are done manually, re-create the trigger(s)
3. Combine new results with old to lighten queries
If the triggers don't run on time, please check your hidden SupermetricsQueries sheet. There's a column called "Execution time" that tells you if the query takes a long time to run (measured in seconds). If that number is high, please consider using the "Combine new results with old" setting for the query in the Options panel of Supermetrics sidebar. Follow the below steps to activate it:
- Run the query manually so that you see all the results you want (any date range you need)
- Click on any of the cells containing results from that query
- That query should be now open in the sidebar —> Click “Modify”
- Change the date range to "Last X days" and set days to 7 (or some other short range between 1-30)
- Turn on “Combine new results with old” from Options dropdown in the sidebar
- Make sure that you have any time dimension selected in your query (Date, Month, Year)
- Click “Apply changes”
4. Duplicate your report
If none of the above methods solve the issue, there may be something wrong with the sheet, and creating a duplicate can help. For example, if another person has set up triggers for your spreadsheet (anyone with Edit access could do it if they had a Supermetrics license or trial), and their Supermetrics license has expired, it could result in no triggers working for that file. Creating a copy of the file solves this.
After taking the steps
Please monitor the performance of the triggers after you've tried the suggested fixes.
If the trigger issues persists, please create a support ticket, and in it please provide details on how your triggers are behaving, the type they are (refresh/email) and since when the problems have existed. Also remember to provide your account id (Google email).