Open up the schedule page and click Create schedule.
At a minimum you must choose:
- The report which should be generated whenever the schedule runs (1)
- When the schedule should run (e.g. Every Monday/Thursday at 8 AM) (2)
- The email recipients, or the Google Drive where the report will be exported (3)
Different options will appear depending on whether you choose Email or Google Drive.
Choose the file format, either CSV, Excel, PDF or HTML.
Contact us at email@example.com if you need to customize the email body, subject, sender name, sender email or the name of the attached report file for a specific schedule.
The above selections are also possible at the store level through the Settings - Schedules tab.
Google Drive schedule
When choosing Google Drive, the report is exported as a Google Sheet every time the schedule runs.
Several behaviors are offered:
Better Reports places some limitations on scheduled runs:
- If a schedule is run manually (run button) then the report will cut off at 1 million rows
- If a schedule runs once a day or less then the report will cut off at 100,000 rows
- If a schedule runs more than once a day then the report will cut off at 10,000 rows
Note - Rows are counted as populated cells for matrix reports.
There are also hard limitations specific to Excel and Google Sheets:
- Excel files have a limit of 1 million rows
- Google Sheets have a limit of 10 million cells
Should you need reports to run with more rows, we recommend reducing the frequency of your scheduled runs or adding filters to your report. If these limitations don't work for your needs, please reach out to us at firstname.lastname@example.org to discuss other options!
Locale Settings and Exports