Scheduled Analytics Report
What is a scheduled analytics report?
How do I create a scheduled analytics report workflow?
What types of reports can I schedule?
What notification options are available for scheduled analytics reports?
What is a scheduled analytics report workflow?
A scheduled analytics report workflow allows users to schedule and send a saved analytics spreadsheet report to their email inbox. The frequency and recipients (licensed and unlicensed users) can be customized. The report will be sent to the email addresses as a downloadable .CSV file.
Create a Scheduled Analytics Report Workflow
Users with "Workflows: All Access" or "Workflows: Create" permission will be able to create Workflows.
Additionally, a user must be listed as either the owner or viewer of a saved spreadsheet report in order to select the report to be scheduled.
Creators will be able to edit and delete workflows they create.
Users with "Workflows: All Access" permission will be able to edit and delete all workflows. Users with "Workflows: Edit" permission will be able to edit all workflows or edit workflows that users they manage created depending on the level of access.
1. Open the left navigation and click Workflows. Alternatively access workflows through the quick actions button > Create a Notification.
2. Click the + Create Workflow button.
3. Click Create on the Scheduled Analytics Report tile.
Don't see the Scheduled Analytics option? The "analytics" and "analytics: saved reports" features are required for use. If analytics and saved reports are included in your package, the feature can be enabled by any user with system admin permissions. Enable Feature: Open the left navigation and click Administration > Features. Locate the Analytics and Analytics: Saved Reports feature, and toggle "On". Click the Update Features button to save.
4. Complete the create workflow form:
Details
Workflow Name
The name will be displayed within Ambition and on scheduled report notifications.
Description
Optional. Description is visible on the manage workflows page and can be helpful to provide context on the behavior the workflow is recognizing.
Active Status
Active = the scheduled analytics report will run on the set recurrence schedule.
Inactive = the scheduled analytics report will be disabled and the report will no longer run on the set recurrence. Inactive workflows are not deleted and can be set back to active at the appropriate time.
Analytics Report
Select a saved spreadsheet report.
You will be able to select saved spreadsheets reports where you are listed as either the owner or a viewer of the report.
Recurrence
Establish the Initial Event
Set the start date, start time, and time zone to indicate when the workflow should begin running.
The scheduled report in the image above would first send on March 11th at 1:00pm Eastern.
Establish Frequency of Each Recurring Event
Repeats Every
Select the appropriate number and time frame to indicate how often the workflow needs to run.
Time frame options:
- Day - Workflow will run every day of the week, even weekends
- Week - Select a specific day or multiple days of the week for the workflow to run
- Month - Workflow will run once per month on a designated day
- Year - Workflow will run once per year on a designated day
Establish When the Recurrence Ends
Workflows will continue on indefinitely based on their recurrence schedule unless an end is specified.
Workflows can end after a certain number of occurrences or end on a specific date.
Expected Occurrences
Based on the recurrence selection above, a preview of expected occurrences will generate. Ensure the dates and frequencies aligns with your expectations.
Actions
Send Email
View an example of a scheduled report email here.
| Send Email - Action Options | Action Description |
| Send an email to myself |
Workflow will be sent to the workflow creator's email address. |
| Send an email to a user or multiple users |
Workflow will be sent to the selected user's email address. Additional hierarchy options will appear to allow you to designate which group(s) of Ambition users you want to receive the email alert. Learn more about hierarchy options here. User > All = Every active Ambition user will be notified of the workflow via email. Users > Within = You will be prompted to select one or more groups within Ambition. All users within the selected group(s) will be notified via email. Only members, and not managers, of the selected groups will be notified. User > Custom - You will be prompted to manually select which specific users will be notified will be notified of the workflow via email. |
| Send an email to the following (Custom Email Address) |
An email will be sent to the input email address. Use for any one/any group/distribution list who needs to receive workflow updates, but DOES NOT have an Ambition account. ex. salesteam@yourcompany.com or vpsales@yourcompany.com Pro Tip: Ensure that any distributions lists have the proper protocols adjusted to allow Ambition emails to be received. |
Log
| Log - Action Options | Action Description |
|
Log |
Send workflow to internal log for troubleshooting purposes. Logs can be viewed under the "Jobs" tab in the manage workflow view. (Workflows: All Access permission required) You will be able to see the workflow name and the time the workflow ran to ensure that your workflow logic is performing as expected before sharing the workflow with end users. |
5. Click Create Workflow.
Comments
0 comments
Please sign in to leave a comment.