Report Subscriptions
Any report or list with an Export button can be emailed to you on a schedule. The report arrives as an attachment, using the filters the list had when you subscribed.
Subscribing to a report
- Open the report or list and set the filters you want (search, status, date range and so on).
- Click Export and choose Subscribe to this report... (the last item in the menu).
- In the window that opens, set the name, frequency and format, then click Subscribe.
Give it a name you will recognise in the email and in your list of subscriptions, especially when you subscribe to the same report with different filters.
Reports are sent overnight by email to the email address on your user profile. Each report is run as you, so it only contains the records you can see with your permissions. It covers every location you have access to, whichever location you have selected when you subscribe. A report includes up to 10,000 rows.
You can have up to 5 active subscriptions. To add another, cancel one first; cancelled subscriptions don't count.
Reports stop being sent while your user is inactive or your account is inactive or suspended.
If you are subscribed to more than one report, you get a single email each night with all of that night's reports attached. A report with no rows is listed in the email as "Empty - Not Attached" and nothing is attached for it. If every report due that night has no rows, no email is sent.
Frequency and format
- Frequency: Daily, Weekly or Monthly.
- Day: for Weekly, the day of the week. For Monthly, the day of the month from 1st to 28th. The field is hidden for Daily.
- Format: Excel (.xlsx) or CSV (.csv).
Date ranges
A subscription saves the filters the list has at the time you subscribe. If the list is filtered on a relative date range, the range moves with each send. A "Last Month" subscription sent in November covers October.
If the list is filtered on fixed dates (a custom date range, or a preset that has no relative meaning), you can't subscribe, because every email would repeat the same dates. Choose a relative range such as Last Month or Last 7 Days, then subscribe again.
Managing your subscriptions
Open your user menu, choose Edit Profile and go to the Subscriptions tab. Administrators see the same tab when they edit a user on the Users page, and can manage that user's subscriptions.
The list shows:
- Name: hover over it to see the report and the filters saved with it.
- Schedule and File: how often it is sent, and XLSX or CSV (hover for the full format name).
- Last Sent: when the report was last sent, or Never.
- Status: Active, Cancelled, or Failed when the subscription is active but its last send failed; hover over Failed to see the error.
Use the Status filter to show Active, Inactive or All subscriptions.
Row actions:
- Edit (or double-click the row): change the name, frequency, day and format. The saved filters can't be changed. To change them, subscribe again from the report with the new filters and cancel the old subscription.
- View sends: see the send history.
- Cancel: stops the subscription from being sent, after you confirm. A cancelled subscription can be reactivated.
- Reactivate: starts a cancelled subscription sending again, as long as it stays within the limit of 5 active subscriptions.
Send history
View sends lists each time the subscription was processed:
- Sent: the date.
- Status: Sent, Empty - not attached (the report had no rows), or Failed.
- Email: the address it was sent to.
- Size: the size of the attachment.
- Error: the reason, if it failed.
Unsubscribing from the email
Each report listed in the subscription email has an Unsubscribe link. Click it to cancel that subscription. You need to be signed in to CWS as the subscribed user for it to work. A subscription cancelled this way can be reactivated from the Subscriptions tab.