# Scheduled Report Exports

Source: https://docs.qvoice.net/admin/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](https://docs.qvoice.net/admin/reports-doc/#download-and-export).

## Creating an Export

1. Go to **Configuration → Export → Reports** and click **Add**.
2. Enter a **Name** (required) and, optionally, a **Description**.
3. Select the **Report**.
4. Leave **Enabled** on to start sending it.
5. Choose the file format: **Single CSV File**, **Single JSON File**, or both. An enabled export must produce at least one of them.
6. Choose the **Interval** (see below).
7. Select the **Recipients**. Recipients are chosen from the email addresses of the account's portal users.
8. 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](https://docs.qvoice.net/admin/report-exports/#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](https://docs.qvoice.net/admin/report-exports/#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 `calls` array and a `totals` object (total calls, total minutes, total amount).
- PDF is not available for scheduled exports.
