Skip to main content
  • Updated

Sending and Scheduling Reports

  1. Jump to

  2. Use Case Information
  3. Send a Report Once (Library)
  4. Send a Report Once (Explore or Dashboard)
  5. Schedule a Recurring Report (Library)
  6. Schedule a Recurring Report (Explore or Dashboard)
  7. Editing a Schedule

 

Get data out of your platform with a couple of clicks by using the send and schedule feature in the Reporting Hub. 

Use Case Information

Sending and Scheduling reports allows you to share your data outside of the platform via email or other forms of delivery. You can choose to send data on demand or schedule reports as a "set and forget" reporting strategy. Library reports, as well as Looks and Dashboards you've created from Explore, can be sent a single time or scheduled to be sent at a regular cadence.

When configured, you can control the following:

  • Communicating key information about platform activity more easily via email.
  • Providing information to a broader audience, especially those who might not regularly access the platform.
  • Providing information to a variety of other systems via webhook, SFTP, or Amazon S3.

Note

Schedules created can only be seen, edited, or deleted by the creator. If all recipients unsubscribe from a scheduled email delivery, that schedule is deleted.

 

To send a report once from the Reporting Hub Library:

  1. Click Reporting Hub > Library and navigate to the report you'd like to send.
  2. Click the three dot menu (kebab) in the top right of the report area.
  3. Click Schedule Delivery.
    LibraryKebab_AdminView.jpg
  4. You'll see a menu of customization options, including Settings, Filters, and Advanced Options.
  5. In Settings: Choose Recurrence > Send now.
    SendNow_Settings_Screen_Admin_View.png
  6. Under Destination, select from Email, Webhook, Amazon S3, or SFTP. Complete the relevant fields, based on the destination.
    • If Email is chosen, add email address(es).
    • If Webhooks is chosen, enter the Webhook URL.
    • If AmazonS3 is chosen, enter the Bucket, Optional Path, Access Key, Secret Key, and Region (optional).
    • If SFTP is chosen, enter the address, username, and password.
  7. Under Format, choose PDF, CSV zip file, or PNG visualization.
  8. Under Filters, optionally change report filters, like date, role type, or learner (different for every report).
    SendNow_Filters_Screen_Admin_View.png
  9. Under Advanced Options, optionally add a custom message to be sent with the report, and review other available options.
    SendNow_Advanced_Options_Screen_Admin_View.png
  10. Click Send Now.

To send a report once from a Look or Dashboard in Reporting Hub Explore:

  1. Click Reporting Hub > Explore > Looks or Dashboard tab and navigate to the the report you'd like to send.
  2. Click the gear icon at the top right of the page.
    Gear_Admin_View.jpg
  3. In the Title field, create a title for your report.
  4. In the section titled Where should this data go?, select a destination for the report, including Email, Webhook, Amazon S3, or SFTP. Complete the relevant fields, based on the destination.
    • If Email is chosen, add email address(es). Optionally include a custom message.
    • If Webhook is chosen, enter the Webhook URL.
    • If Amazon S3 is chosen, enter the Bucket, Optional Path, Access Key, Secret Key, and Region (optional)
    • If SFTP is chosen, enter the address, username, and password. Under Format, choose the desired report format.
  5. Under Filters, optionally alter report filters.
  6. Under Advanced Options, review and apply relevant options.
  7. Click Send.
    SendOptions_AdminView.jpg

To schedule a report from the Reporting Hub Library at a regular recurrence:

  1. Click Reporting Hub > Library and navigate to the report you'd like to schedule.
  2. Click the three dot menu (kebab) in the top right of the report area.
  3. Click Schedule delivery.
    LibraryKebab_AdminView.jpg
  4. In Settings, choose Recurrence > Select the recurrence, day, and time.
    Settings_Screen_Admin_View.jpg
  5. Under Destination, select from Email, Webhook, Amazon S3, or SFTP. Complete the relevant fields, based on the destination.
    • If Email is chosen, add email address(es).
    • If Webhooks is chosen, enter the Webhook URL.
    • If Amazon S3 is chosen, enter the Bucket, Optional Path, Access Key, Secret Key, and Region (optional).
    • If SFTP is chosen, enter the address, username, and password.
  6. Under Format, choose PDF, CSV zip file, or PNG visualization.
  7. Under Filters, optionally alter report filters, like date, role type, or learner (different for every report).
    Filters_Screen_Admin_View.jpg
  8. Under Advanced Options, optionally add a custom message and review other available options.
    Advanced_options_Admin_View.jpg
  9. Click Save.

To schedule a report from a Look or Dashboard in Reporting Hub Explore:

  1. Click Reporting Hub > Explore > Looks or Dashboard tab and navigate to the the report you'd like to schedule.
  2. Click the gear icon in the top right of the report area.
    Gear_Admin_View.jpg
  3. Click Schedule. Give your schedule a name in the name field.
  4. In the section titled Where should this data go?, select a destination for the report, including Email, Webhook, Amazon S3, or SFTP. Complete the relevant fields, based on the destination.
    • If Email is chosen, add email address(es). Optionally include a custom message.
    • If Webhook is chosen, enter the Webhook URL.
    • If Amazon S3 is chosen, enter the Bucket, Optional Path, Access Key, Secret Key, and Region (optional).
    • If SFTP is chosen, enter the address, username, and password.
  5. Under Format, choose the desired report format.
  6. In the Trigger section, choose Repeating interval. Review and select delivery schedule options that range from by minute to monthly or by specific months or days. You can also select the time at which you want the report to be delivered.
  7. Delivery Schedule: You can set a schedule for a variety of cadences ranging from monthly to by the minute.
  8. Under Filters, optionally alter report filters.
  9. Under Advanced Options, review and apply relevant options.
  10. Optionally, click Send Test if you would like to see how this report will appear when sent to email.
    ReportingHub_ScheduleTest_AdminView.png
  11. Click Save All.
    ScheduleOptions_AdminView.jpg

Editing or Deleting a Schedule

Google Looker only allows the schedule creator to edit, duplicate, or delete a schedule.

  1. Log in using the schedule creator's credentials.
  2. Go to Reporting Hub, then choose the specific report for the schedule you'd like to edit. For example, if you'd like to edit the schedule for a custom dashboard, go to Reporting Hub > Explore > Dashboards tab > click into the custom dashboard.
  3. Click the three dot icon (kebab) and choose Schedule Delivery.
    • If a schedule already exists for the report and you are logged in as the creator, all saved schedules will display here.
  4. Click the three dot icon (kebab) next to the schedule you'd like to edit or delete.
  5. Choose to Edit, Duplicate, or Delete the schedule.

Send&Schedule_EditDelete.gif

Related articles