Skip to Content
SottoHelp

Reports and targets

Read and set targets, build custom reports, and deliver reports to Slack, email or Google Sheets.

Open Markdown

Select and copy the page

Clipboard access is unavailable. Copy the selected text using your device’s Copy command.

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

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

SettingOptions
MetricRevenue (won amount) / Deals won / New deals / Completed activities / Meetings
ScopeWhole workspace / Team / Member
PeriodMonth / Quarter (picking a month selects the quarter that contains it)
PipelineA 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).
  • 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

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

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

  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.

On this page