Scheduled Report Exports¶
Overview¶
Scheduled exports email a report to a list of recipients at a fixed interval, as a CSV and/or JSON attachment. They are configured in the portal under Configuration → Export, which has two screens:
- Reports: the current way to configure exports. Each export is a named job for one report, and an account can have as many jobs as it needs (for example, a daily Missed Calls export to the reception team and a monthly Usage Charges export to finance).
- Global Reports: the older screen. It holds a single export configuration per report for the whole account. It is kept for the accounts that already use it; new exports should be created under Reports.
Both screens require the Exportable Reports section of the Configuration permissions in the user's role. Users with read-only access to that section can see the exports but not create, edit or delete them.
Exportable Reports¶
| Report | Available to | Queue selection |
|---|---|---|
| Users Activity | All accounts | |
| Users Charges | All accounts | |
| Outbound Calls | All accounts | |
| Inbound Calls | All accounts | |
| Missed Calls | All accounts | Yes |
| Usage Charges | All accounts | |
| Queues Activity | Accounts with Contact Center | Yes |
| Agents Activity | Accounts with Contact Center | Yes |
| All Calls | Accounts with Contact Center | Per filter group |
| Calls History | Accounts with Contact Center | |
| Queues Calls | Accounts with Contact Center | Yes |
| Queues Outbound Calls | Accounts with Contact Center | |
| Campaigns Activity | Accounts with Contact Center | |
| CX Conversations | Accounts with CX Channels (Reports screen only) | |
| CX Channels Activity | Accounts with CX Channels (Reports screen only) |
Reports that are not in this list (for example DIDs Activity, CDRs or the PIN reports) cannot be scheduled; they are downloaded from the report page itself. See Reports documentation.
Creating an Export¶
- Go to Configuration → Export → Reports and click Add.
- Enter a Name (required) and, optionally, a Description.
- Select the Report.
- Leave Enabled on to start sending it.
- Choose the file format: Single CSV File, Single JSON File, or both. An enabled export must produce at least one of them.
- Choose the Interval (see below).
- Select the Recipients. Recipients are chosen from the email addresses of the account's portal users.
- Set the report-specific options, if any (see below), and save.
The list shows each export's name, description, report, interval, files, recipients and status, and lets you edit or delete it. To pause an export without deleting it, turn Enabled off.
Changing the report of an existing export clears the options that belonged to the previous report (queue selection, filter groups, grouping).
Intervals and Period Covered¶
| Interval | Period covered by each email |
|---|---|
| Every minute | Since the previous delivery |
| Every hour | Since the previous delivery |
| Every day | Since the previous delivery |
| Every week | Since the previous delivery |
| Every two weeks | Since the previous delivery |
| Every first day of the month | The previous calendar month (1st 00:00 to last day 23:59:59), in the account's timezone |
- When an export is enabled, the first report is sent right away, covering one interval back from that moment. After that, each delivery follows the interval.
- Exports are sent overnight, in the platform's maintenance window. A Missed Calls export can instead be sent at a time of day you choose; see Missed Calls: Agents, Follow-up Status and Send Time.
- Dates in the reports and in the file names use the account's timezone.
- Exports have no "run now" button and no delivery history in the portal; to receive a report on demand, download it from the report page.
Report-Specific Options¶
Queue selection (Queues Activity, Agents Activity, Queues Calls, Missed Calls): limit the export to the selected queues. Leaving it empty exports all queues. For Missed Calls, selecting queues leaves out the missed calls that never reached a queue.
Agents, Follow-up Status and Send Time (Missed Calls, Reports screen only): see Missed Calls: Agents, Follow-up Status and Send Time.
Grouping (Queues Activity): turn on Group and choose a Group Period (15 min, 30 min, 1 h, 2 h, 6 h or 12 h) to split the queue statistics into time slots.
All Calls options: - Count: by user or by call. - Filter groups: one or more groups combined with OR (Add OR group). Each group sets the call Type (All Calls, Queue Only, Direct Only), the Queues (for queue calls), the Direction (Any, Inbound, Outbound), the Network (All Networks, On-net, Off-net) and Queue Call Attempts (one entry per call, or every attempt). - Only count a queue call for the agent who answered it (when counting by user).
Missed Calls: Agents, Follow-up Status and Send Time¶
A Missed Calls export has three extra options on the Reports screen. All are optional; leaving them at their defaults sends the whole Missed Calls report, as any other export.
Agents¶
Select one or more users in Agents to send the Recipients only the missed calls of those agents. A supervisor, for example, can receive the missed calls of agents A and B, and with Follow-up Status set to Not followed up, only the callers still pending. Agents are listed by name and extension.
- Which calls belong to an agent:
- A missed direct call belongs to the user it rang.
- A missed queue call belongs to every agent the queue rang for that call. If the caller hung up before any agent's phone rang, the call belongs to nobody and is not sent.
- If Queues are selected, only the missed calls of those queues are sent, and missed direct calls are left out.
- The file: a CSV with the columns of the Missed Calls report's CSV download plus an Agents column, right after Callee Ext, naming the selected agents each call belongs to. A queue call that rang several of the selected agents is one row, with all of them in the Agents column. A period with no matching call still sends the file, with its header only.
- CSV only: selecting agents turns Single JSON File off and locks it.
- Recipients are required, as for any export.
Follow-up Status¶
Follow-up Status narrows the export the same way the filter of the same name does in Analytics → Missed Calls, with or without Agents, and in both the CSV and the JSON file:
- All calls (the default): every missed call, followed up or not.
- Followed up only: the calls with Yes in the Followed Up column.
- Not followed up: the calls with No in the Followed Up column.
A call is followed up when someone in the account called the number back and the call connected, or the same number called again and someone answered. It does not matter which user did it. When the same number was missed more than once, a call back counts for the most recent of those missed calls.
Only what happened within the period the export covers counts. With a daily export, a call returned after the period's end, the next morning for example, still appears as not followed up, and it does not appear again in the next export, because each export covers only the calls missed in its own period. With Followed up only, a short period therefore lists only the calls returned within it.
Send Time¶
With the Every day, Every week, Every two weeks or Every first day of the month interval, a Send Time can be set. The export is then sent at that time of day, in the account's timezone, instead of overnight. Send Time is not offered for Every minute and Every hour.
- When it is sent: Every day sends every day at the Send Time. Every week and Every two weeks send every 7 or 14 days, counted from the first email, at the Send Time. Every first day of the month sends on the 1st at the Send Time.
- Period covered:
- Every day, Every week and Every two weeks: the 1, 7 or 14 days that end at the Send Time. With a daily Send Time of 13:00, the email sent today at 13:00 covers yesterday 13:00 to today 12:59:59. A call at exactly 13:00 is in the next email. If an email could not be sent (for example, during a platform outage), the next one covers everything since the last email that was sent.
- Every first day of the month: the previous calendar month, in the account's timezone.
- Saving an export with a Send Time does not send it right away, unlike other exports. The first email goes out at the next Send Time (for a monthly export, on the next 1st). The only exception is saving it within an hour after the Send Time when that email has not been sent yet: it is then sent at once.
In the list of exports, an export with a Send Time shows its interval as, for example, Every week at 14:00.
Exports set up with "Send each user their own unreturned missed calls": this option has been replaced by Agents. Such an export has no Recipients, so it no longer sends anything. Edit it, add the Recipients and, to keep listing only pending calls, select the Agents and set Follow-up Status to Not followed up.
Global Reports Screen¶
Configuration → Export → Global Reports (titled "Global Exportable Reports") lists every exportable report on a single page, in a Reports section and, for accounts with Contact Center, a Contact Center section. Each report has the same format, interval, recipients and report-specific options described above, and a report is sent when at least one file format is turned on. A single Save stores the whole page. CX Channels reports and the Missed Calls Agents, Follow-up Status and Send Time options are not available on this screen.
File Formats and Delivery¶
- Exports are delivered by email only, as attachments.
- CSV: the same columns as the report's CSV download.
- JSON: the same records in JSON. For Usage Charges, the JSON is an object with a
callsarray and atotalsobject (total calls, total minutes, total amount). - PDF is not available for scheduled exports.