# Reports and targets (/docs/en/reports)

<AppLink path="/reports" label="Open Reports" />

Open **Reports** under **Customers and deals** in the sidebar. **Targets and progress** comes first, followed by the pipeline status, deals by stage, numbers per owner, funnels, and finally your saved reports.

## Targets and progress [#targets-and-progress]

For this month and this quarter, each target shows attainment, a progress bar, actual against target, and pace (Ahead / On track / Behind).

| Setting | Options |
| --- | --- |
| Metric | Revenue (won amount) / Deals won / New deals / Completed activities / Meetings |
| Scope | Whole workspace / Team / Member |
| Period | Month / Quarter (picking a month selects the quarter that contains it) |
| Pipeline | A specific pipeline, or all |

Revenue targets are an amount and a currency; the others are counts. Only organization admins can add, edit and delete targets. Admins see every target; others see the workspace targets, their own, and their teams'.

Actuals are counted as follows, using only records the viewer can read:

- **Revenue and deals won:** Counted in the period when the deal entered a won stage. Revenue is converted to the base currency (see [currencies and conversion](/docs/en/currency)).
- **New deals:** Deals created in the period.
- **Completed activities:** Tasks completed in the period.
- **Meetings:** Recorded meetings that started in the period.

Pace compares the actual with the share of the period's business days that have passed. Business days are Monday to Friday in Japan time; public holidays are not treated differently.

## Build a custom report [#build-a-custom-report]

Select **Create report** and choose the **Custom** type. It takes three steps:

1. **What the report is about**
2. **Data and measure:** Choose the object, up to two ways to group (dates are grouped by day, week, month or quarter), the measure (count, or the sum, average, minimum or maximum of a number or amount), the period (last 7, 30 or 90 days, this month, this quarter, this year, or custom dates), and a comparison with the previous period or the start of the period. Deals can be narrowed by pipeline, and you can add the same conditions as in views.
3. **Name and description**

A preview with the current settings is always shown on the right. Amounts show the original amounts per currency and the total converted to the base currency. Reports use current record values and include only records the viewer can read. A note appears if the read limit is reached.

Saved reports can be exported as CSV.

## Schedule delivery [#schedule-delivery]

In the report editor, under **Scheduled delivery**, choose Don't deliver, Daily, or Weekly (Mondays), and a delivery channel: Slack, Email or Google Sheets. Email recipients must be members of your organization. Only the report's owner can change its delivery.

### Deliver to Google Sheets [#deliver-to-google-sheets]

1. Connect Google Sheets in **Settings › Integrations** first. Sotto writes with the account you connected.
2. Choose **New spreadsheet** or **Existing spreadsheet**. A new one is created in your Google Drive on the first delivery. For an existing one, paste its URL.
3. Each delivery clears and rewrites the tab named after the report. The first row holds the report name, period, generation time and base currency, followed by a blank row and the table.

The delivery log under the delivery settings shows the status of recent deliveries and why any failed. Failed deliveries are retried on the next run. For connecting services, see [connecting your tools](/docs/en/integrations).