Reporting 2.0 - Delivery and Scheduling

The Delivery option lets you send the report to yourself and other users via email and to an FTP folder. You can also schedule report delivery once, daily, weekly, or monthly.

To access Reporting 2.0, go to Reports > Reporting 2.0.

Queue this report on a schedule

When this option is toggled on, users can queue reports on a schedule on behalf of shared users. Shared users are then able to download the queued report.

To set the report schedule, use the options in the Schedule Parameters section to set the time, date, and frequency on which you want the report to run.

Once the report is scheduled, a snapshot of the report can be found in the Report Queue interface on the Reporting 2.0 homepage at the scheduled time.

If the report has been published to dashboards, the widgets that are using this report will also be refreshed automatically. Note: The snapshot is available by clicking the queue report or download icon for a report on the Reporting 2.0 homepage.

Report Delivery via Email

To set report delivery via email, toggle on the Deliver to Email option. This enables the Delivery Parameters section to appear at the bottom of the panel.

To set the delivery schedule, use the options in the Schedule Parameters section to set the time, date, and frequency of the report schedule. See Report Scheduling.

Select the output format in the Report Output Format section In Delivery Parameters

Use the Email Recipients options to send the report to yourself and/or additional users. When sending the report to additional users, you can choose to include the users in automated running of the report by selecting the following option in the Select Users flyout:

  • Include in Automation - When this option is checked, automation for report queuing will run on behalf of up to 20 shared users, which means the shared users will automatically receive a refreshed report whenever the report is scheduled to run. This option is not available for organizational units (OU) or for users who are subordinates of the shared user. This option only functions if the Queue this report on a schedule option is toggled on in the Automation Settings panel.

The report is delivered to the user's email that is in their user record. You can remove users by clicking the X to the left of the user's name.

Note: If the report exceeds 25 MB, a link to download the report is sent to the recipient. The report is available to download via the link for 21 days. SSO is not supported for the link.

Report Delivery to FTP

To schedule report delivery to your FTP folder, toggle on the Deliver to FTP option.

In the Schedule Parameters section, set the time, date, and frequency of the report schedule. See Report Scheduling.

Select the output format in the drop-down and choose whether to check the Send as a Zip file option.

The row limit for delivery to an FTP folder is 1,000,000.

Report Scheduling

Note: When setting up delivery via email, if you would also like to deliver via FTP, the schedule will be the same for both. Email scheduling cannot be set up separately from FTP scheduling.

You can also schedule a one-time delivery or deliver the report daily, weekly, or monthly.

Edit Report Schedule

When you update the schedule for a previously scheduled report, the old schedule will no longer apply. The report will be delivered to any users who are included in the delivery settings based on the new schedule. This prevents duplicate reports from being sent.

Note: If you update the schedule while the report is currently processing for delivery, then it is possible that two reports will be sent. The report that is based on the first schedule will send once it is done processing. Then, the report will be sent again at the updated delivery time. However, once the updated report is sent, the report will no longer be sent at the old delivery time.

Deadbox Settings

Report delivery will respect Deadbox Settings in Pilot and Stage environments when a deadbox has been configured on the backend. Report delivery will stop for inactive users. When the report owner is inactive, report delivery will stop for all report recipients.

Report delivery is resumed when/if the user or report owner becomes active again.

Note: A "deadbox" is an email address that can be set up as a global override for all users so that all system emails are sent to the deadbox address.