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.
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
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 [email protected] to discuss other options!