Sales Revenue and Performance

Set up sales analytics with dashboards, scorecards and velocity metrics

How do you set up dashboards, rep scorecards and pipeline velocity metrics that your managers use for decisions?

Works sets up one data model in your CRM with one definition for each metric. You choose the KPIs that your decisions depend on. The Sales Performance Analyst agent builds dashboards for managers, reps and leadership. The same agent adds pipeline velocity metrics. Pipeline velocity is how fast your pipeline turns into revenue. You link each metric to a decision.

Published Updated

What you get
Sales analytics in HubSpot · October 2026
Ready for your Head of Sales
3
dashboards on one data model in HubSpot
4
velocity metrics, each tied to a decision
Manager dashboard Live view for your Head of Sales
Rep dashboard · 2 scorecards Activity, stage conversion rate and velocity for each rep
Leadership dashboard Weekly snapshot for your Founder and CEO
Average deal size $70,800 first-year value
Win rate 28%
Average sales cycle length 58 days
Time in each stage Days in the current stage for each of 31 open deals

Your Head of Sales makes sales decisions from current data in HubSpot.

See it run

A sales analytics setup in progress

CRM
HubSpot · 31 open deals
Velocity metrics linked to a decision 3 / 4
Run log
  1. You
    “Set up sales analytics in HubSpot with a manager dashboard, rep scorecards and pipeline velocity metrics.”
    Your instruction
  2. CRM setup used Upstream
    Your HubSpot setup comes from Set Up the CRM. You track your 31 open deals in HubSpot.
  3. Sales performance data used Upstream
    Your sales performance data comes from Track Sales Performance. It is your baseline, the starting numbers that you compare against. Your win rate is 28%. Your average sales cycle length is 58 days.
  4. One data model built Sales Performance Analyst
    You chose quota attainment as a top KPI. Quota attainment is the percentage of the quota that a rep reaches. You chose stage conversion rate as the second top KPI. Stage conversion rate is the percentage of deals that move to the next stage. The Sales Performance Analyst agent built one data model in HubSpot. The data model has one definition for each metric. Your HubSpot data was mostly complete. Your sales team now fills in 3 more fields on each deal.
  5. Dashboards and rep scorecards built Sales Performance Analyst
    The Sales Performance Analyst agent built 3 dashboards in HubSpot from the one data model. The manager dashboard is for your Head of Sales. The rep dashboard has 2 scorecards, one for each rep on your sales team. The leadership dashboard is for your Founder and CEO. You compare each metric with your own trend and your target. You checked the dashboards with real data. They answer the questions that your Head of Sales asks.
  6. You
    Your decision for one velocity metric needed You
    The Sales Performance Analyst agent added 4 velocity metrics to the manager dashboard. You use win rate for coaching decisions. You use deal size and sales cycle length for forecast decisions. You linked 3 of the 4 velocity metrics to a decision. Time in each stage is the number of days that a deal spends in one stage. Choose the decision for time in each stage.
How it works

One data model for every dashboard

You choose the few KPIs that your decisions depend on, for example quota attainment. The Sales Performance Analyst agent builds one data model with one definition for each metric. The Sales Performance Analyst agent builds the dashboards and the rep scorecards from the same data model. Your managers and your sales team then read the same numbers. The Sales Performance Analyst agent adds the velocity metrics. You decide which decision each metric supports.

What it needs
The CRM and the metric definitions
Performance and forecast data
The decisions the analytics must support
A CRM with at least 90 days of activity data
Revenue targets and the quota for each rep
The sales process stages, to calculate the sales cycle length
The sales performance data from Track Sales Performance, as the baseline
What you get

One data model with consistent metric definitions, and dashboards for managers, reps, and leadership. Pipeline velocity metrics that explain changes in the sales number and show problems earlier.

Run sequence

Start to finish

You start from your CRM setup and your sales performance data. Then you and the Sales Performance Analyst agent set up your sales analytics in three parts.

  1. 1
    Sales Metrics and Data Sources

    Agree on one set of metrics

    You choose the few KPIs for your decisions
    You choose metrics that show why each KPI moves
    The Sales Performance Analyst agent builds the data model
    You + Sales Performance Analyst
  2. 2
    Manager Dashboard

    Build the views for each audience

    The Sales Performance Analyst agent builds each dashboard
    The same agent builds a scorecard for each rep
    You check the dashboards against real data
    Sales Performance Analyst + You
  3. 3
    Pipeline Velocity Metric

    Measure pipeline velocity

    The Sales Performance Analyst agent adds four velocity metrics
    You tie each metric to a decision
    You check that managers use the dashboards
    Sales Performance Analyst + You
Before it starts

What Works asks you

A few questions in plain words. The answers set up the run for your business.

Which decisions should your sales analytics support: coaching, hiring, territory, forecast, or all of these?
YouCoaching, capacity, and forecast decisions
Which few KPIs and which diagnostic metrics under them make up your metric framework?
YouQuota attainment and stage conversion rate at the top, velocity under them
Which dashboards do your managers, reps, and leadership each need?
YouSeparate manager, rep, and leadership views on one data model
Which pipeline velocity metrics matter to you: deal size, win rate, sales cycle length, or time in each stage?
YouDeal size, win rate, sales cycle length, and time in each stage
How often should each dashboard refresh: live, daily, or weekly?
YouLive views for daily work, and a weekly snapshot for leadership
What is the smallest useful version to build now, before you add deeper analytics later?
YouCore dashboards now, advanced analytics later
Who runs it

The agents behind this workflow

The Sales Performance Analyst agent builds the data model, the dashboards and the velocity metrics. The Compensation and Territory Planner agent sets quotas from your revenue targets.

Playbook specialist

Compensation and Territory Planner

Owns this area

Designs compensation plans, sets quotas, and plans territories so that pay and targets support the sales strategy.

What it can do
Sets quotas from targets and capacityModels plan cost and quota attainmentLinks pay and targets to the sales strategy
On this workflow

Sales Performance Analyst

Builds the data model, the dashboards, and the velocity metrics for sales analytics

What it can do
Builds one data model with consistent definitionsBuilds dashboards for managers, reps, and leadershipAdds pipeline velocity diagnostic metricsKeeps the forecast, performance tracking, and analytics aligned
Jeanie, your right hand Works Crew

Jeanie leads a core crew of seven that runs your company day to day. They direct the specialist and workflow agents in each playbook, including the ones on this workflow.

Connect your tools

Bring what you already run

Works connects to the apps you already use.

  • Google Sheets This workflow uses Google Sheets.
  • HubSpot The Sales Performance Analyst agent connects to HubSpot.
  • Microsoft Power BI This workflow uses Microsoft Power BI.
  • Salesforce The Sales Performance Analyst agent connects to Salesforce.
  • Tableau The Sales Performance Analyst agent connects to Tableau.
Other apps you can use
Your CRM

or any CRM you use

Your spreadsheet app
  • Microsoft Excel
  • Airtable
  • Smartsheet
  • Zoho Sheet

or any spreadsheet app you use

These are starting points, not a limit. Connect the tools you already use.

Works · AI business OS

One workflow inside your whole business

In Sales, Set Up Sales Analytics is part of the Revenue and Performance work.

Prebuilt playbooks, plus your own
StrategyMarketingSalesCustomer SuccessPartnershipsProducts & ServicesOperationsFinancePeopleLegal & Compliance + Build your own
The Sales playbook
64
Workflows
16
Specialist agents
17
Workflow agents
173
Templates
You're here
Set Up Sales Analytics
One of 64 Sales workflows · run by 1 workflow agent
Templates

What comes with it

Built for this workflow
Sales Analytics Plan DOCX
A document where you plan your sales analytics. It opens in Works after you sign up.
Sales KPI Definitions DOCX
A document with the definition of each sales KPI. It opens in Works after you sign up.
Sales Metrics Catalog XLSX
A sheet where you list your sales metrics. It opens in Works after you sign up.
Pipeline Velocity Diagnostic Model XLSX
A sheet where you model your pipeline velocity. It opens in Works after you sign up.
Also included here
Quota Attainment Tracker XLSX
A sheet where you track quota attainment. It opens in Works after you sign up.
Sales KPI Dashboard Model XLSX
A sheet where you model your sales KPI dashboard. It opens in Works after you sign up.
CRM Field and Stage Inventory XLSX
A sheet where you list the fields and stages in your CRM. It opens in Works after you sign up.
CRM Configuration Plan DOCX
A document where you plan the configuration of your CRM. It opens in Works after you sign up.

Each template opens inside Works after you sign up.

Questions

What people ask

What is pipeline velocity?

Pipeline velocity is how fast your pipeline turns into revenue. You choose the velocity metrics that matter to you. For example, you can track deal size, win rate, sales cycle length and time in each stage. Velocity metrics show why your sales number moves. You can also start with only win rate or only sales cycle length.

Which dashboards do your managers, reps and leadership get?

You decide which dashboards your managers, reps and leadership each need. For example, you can have separate manager, rep and leadership views on one data model. You can also start with one dashboard for everyone. Another choice is a dashboard only for managers. The Sales Performance Analyst agent builds each dashboard that you choose.

How complete must your CRM data be?

You need a CRM with at least 90 days of activity data. You tell the Sales Performance Analyst agent how complete your CRM data is today. Your data can be mostly complete, with a few more fields for your sales team to fill in. If your data has many gaps, you fix the data first.

How often do the dashboards refresh?

You choose how often each dashboard refreshes. For example, you can use live views for daily work and a weekly snapshot for leadership. A live view shows the current data in your CRM. You can also refresh all dashboards once a day. Another choice is to refresh all dashboards once a week.

How do you know that the sales analytics work?

You choose what tells you that the sales analytics work. For example, your managers make decisions on data, not on gut feel. You can also check that managers use the dashboards. Another sign is that you find problems earlier. The goal is sales decisions from current data in the dashboards, not from old reports.

Make your sales decisions from current data

Sign up to set up dashboards, rep scorecards and pipeline velocity metrics for your sales team.

Sign Up