Strategy Goals and Metrics

Set up the metrics dashboard with correct data and a weekly review

How do you set up a dashboard for your key metrics and review it each week?

Key metrics are the few numbers that best show how your business performs. The Performance Reporting Analyst agent maps each metric to its data source. The same agent builds one dashboard with correct data first and formatting second. You check each number against its source. Each week, your leadership team decides actions from the dashboard.

Published Updated

What you get
Metrics dashboard · Fenwright Systems
Each number checked against its source
7
key metrics, each checked against its source
2
data sources, HubSpot and Google Sheets
Annual recurring revenue (ARR), the yearly value of all subscriptions Finance spreadsheet in Google Sheets · automatic
Average contract value, the yearly value of one customer contract HubSpot · automatic
Win rate, the share of deals you win HubSpot · automatic
Sales cycle, the days from first meeting to signed deal HubSpot · automatic
New customers won in the last 12 months HubSpot · automatic
Annual churn, the share of customers you lose each year By hand each month · Head of Customer Success
Revenue per employee, your ARR divided by your 140 people Partly automatic · you enter the number of people by hand
Weekly leadership team review Monday at 9:00, 30 minutes, dashboard on screen

Each metric also has a trend line, with an on-track summary at the top.

See it run

Metrics dashboard for Fenwright Systems, in progress

Key metrics on the dashboard
7 · Five automatic, one partly automatic, one by hand
Metrics checked against their source 5 / 7
Run log
  1. You
    “Set up one dashboard for the seven key metrics. Use HubSpot and the finance spreadsheet in Google Sheets. Schedule a weekly leadership team review.”
    Your instruction
  2. 7 metrics mapped to a source Performance Reporting Analyst
    The Performance Reporting Analyst agent mapped each of your seven key metrics to its data source. Five metrics come from HubSpot or your finance spreadsheet in Google Sheets. Their data can be pulled automatically. Revenue per employee is partly automatic, because you enter the number of people by hand. You named the Head of Customer Success to enter annual churn by hand each month. You found a HubSpot sales dashboard that you can reuse.
  3. Google Sheets chosen and tested Performance Reporting Analyst
    You chose the simplest tool that connects to every data source. That tool is Google Sheets, which you already use. Your Revenue Operations Manager will maintain the dashboard. The Performance Reporting Analyst agent tested the HubSpot connection with one metric, win rate. Win rate showed correct data on 8 October.
  4. You
    5 of 7 metrics checked You
    The Performance Reporting Analyst agent builds the dashboard in two phases. In phase 1, every metric shows correct data, with plain formatting. In phase 2, the same agent adds trend lines and a summary at the top. The same agent finished phase 1 on 12 October. You check each metric against its source for September. So far, 5 of 7 metrics match their source. You are checking annual recurring revenue and annual churn next.
    •
  5. You
    Weekly review time needed You
    Choose a fixed time each week for the leadership team review. You schedule the review before the dashboard is complete. For each metric, your team notes whether it improves or declines, its likely cause and one action for the week. The Performance Reporting Analyst agent then schedules the review. The same agent prepares the first review.
  6. Key metrics used Upstream
    Your key metrics come from Choose Key Metrics.
  7. Financial metrics used Upstream
    Your financial metrics come from Track Key Financial Metrics.
How it works

Correct data first, formatting second

For each metric, the Performance Reporting Analyst agent records whether its data can be pulled automatically, partly automatically or only by hand. You name one person to enter each metric collected by hand. Before the full build, the same agent tests that one metric shows correct data. Before launch, you check each metric against its source for the latest period. You also choose how often you refresh the dashboard data, for example at least daily.

What it needs
A list of your key metrics with the data source for each one
Access to your CRM, accounting, and analytics tools
A chosen dashboard tool, or the tools you already have
The available times of the leadership team for the weekly review
What you get

A live dashboard that shows correct data for every metric, checked against its source, on the simplest tool that connects to the sources. A recurring weekly leadership team review that is in use.

Run sequence

Start to finish

You start from your key metrics and your financial metrics. Then you and the Performance Reporting Analyst agent build your metrics dashboard in four parts.

  1. 1
    Data Source Map

    Map where each number comes from

    Performance Reporting Analyst confirms each data source
    Some metrics can only be entered by hand
    You name who enters each manual metric
    Performance Reporting Analyst + You
  2. 2
    Dashboard Tool Choice

    Choose the simplest dashboard tool

    The tool must connect to every source
    You name the person who maintains it
    Performance Reporting Analyst tests one metric first
    You + Performance Reporting Analyst
  3. 3
    Working Dashboard

    Build the dashboard in two phases

    In phase 1, every metric shows correct data
    Performance Reporting Analyst adds trend lines in phase 2
    You check each metric against its source
    Performance Reporting Analyst + You
  4. 4
    Weekly Review Schedule

    Schedule the weekly leadership review

    You choose a fixed time each week
    You set what the review covers
    Performance Reporting Analyst prepares the first review
    You + Performance Reporting Analyst
Before it starts

What Works asks you

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

For each key metric, can the number be pulled from its source automatically, partly automatically, or only by hand?
YouMark each metric as automatic, partly automatic, or manual, based on its source
Who will enter the number for each metric that can only be collected by hand?
YouName one person and a weekly time to enter each manual metric
What matters most to you in a dashboard tool?
YouChoose the simplest tool that connects to every required source, not the most powerful
Do you want to test that one metric connects and shows correct data before you build the full dashboard?
YouYes, test that one metric shows correct data before building the rest
What fixed time each week will you hold the leadership team review?
YouA fixed weekly 15 to 30 minute slot, booked before the build ends
What should the weekly review cover for each metric?
YouEach metric: improving or declining, likely cause, and one action this week
Who runs it

The agents behind this workflow

The Performance Reporting Analyst agent maps your data sources, builds the dashboard and prepares the weekly review. You make each choice and check each number.

Playbook specialist

Performance Reporting Analyst

Owns this area

Builds the dashboards and review schedules that keep goals visible and each goal owner accountable.

What it can do
Build a live metrics dashboardCollect metrics from connected sourcesDesign review meetings and agendas
On this workflow

Performance Reporting Analyst

Builds a live metrics dashboard connected to the real data sources and sets up the weekly review that uses it

What it can do
Map each metric to a source and a pull methodConnect CRM, accounting, and analytics dataBuild the dashboard with correct data first and formatting secondCheck each metric against its source for the latest periodSchedule and prepare the weekly leadership team review
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 The Performance Reporting Analyst agent connects to Google Sheets.
  • HubSpot The Performance Reporting Analyst agent connects to HubSpot.
  • Xero Accounting The Performance Reporting Analyst agent connects to Xero Accounting.
Other apps you can use
Your spreadsheet app
  • Microsoft Excel
  • Airtable
  • Smartsheet
  • Zoho Sheet

or any spreadsheet app you use

Your CRM

or any CRM you use

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

Connect your work

The workflows before your metrics dashboard

Starts from
Key metrics definitions from Choose Key Metrics · you show your key metrics in one dashboard
Financial metrics from Track Key Financial Metrics · you use your financial metrics in this workflow
This workflow makes
Metrics dashboard
Set Up the Metrics Dashboard · once

Linked cards are live pages. The others are part of the Strategy playbook in Works.

Works · AI business OS

One workflow inside your whole business

In Strategy, Set Up the Metrics Dashboard is part of the Goals and Metrics work.

Prebuilt playbooks, plus your own
StrategyMarketingSalesCustomer SuccessPartnershipsProducts & ServicesOperationsFinancePeopleLegal & Compliance + Build your own
The Strategy playbook
73
Workflows
19
Specialist agents
42
Workflow agents
238
Templates
You're here
Set Up the Metrics Dashboard
One of 73 Strategy workflows · run by 1 workflow agent
Templates

What comes with it

Built for this workflow
Dashboard Review Cadence Planner XLSX
A sheet where you plan how often you review your dashboard. It opens in Works after you sign up.
Dashboard Data-Source Map DOCX
A document where you map the data source of each metric. It opens in Works after you sign up.
Metrics Tracking Workbook XLSX
A workbook where you track your metrics. It opens in Works after you sign up.
Also included here
Metric Catalog Tracker XLSX
A sheet where you track your list of metrics. It opens in Works after you sign up.
Metric Definitions Library DOCX
A document where you keep the definition of each metric. It opens in Works after you sign up.
Metric Tree Map DOCX
A document where you draw how your metrics link to each other. It opens in Works after you sign up.
Input-Metric Tree DOCX
A document where you draw your input metrics, the numbers your team can change directly. It opens in Works after you sign up.
North Star Trend Tracker XLSX
A sheet where you track the trend of your north star metric, the one number that grows when your customers succeed. It opens in Works after you sign up.
Market Intelligence Workbook XLSX
A workbook where you track what you learn about your market. It opens in Works after you sign up.

Each template opens inside Works after you sign up.

Questions

What people ask

Which dashboard tool should you choose?

You choose the simplest tool that connects to every data source your metrics need. You can start with free tools you already use, such as Google Sheets. You can pay for a tool when free tools cannot connect. You also name the person who maintains the dashboard. That person must be able to run the tool without expert help.

Why build the dashboard in two phases?

In phase 1, the Performance Reporting Analyst agent makes every metric show correct data, even with plain formatting. You check each metric against its source before launch. In phase 2, the same agent adds trend lines and readable formatting. You can then read the dashboard at a glance. For example, you can add an on-track summary at the top.

What does the weekly review cover?

In the weekly leadership team review, your team decides actions from the dashboard numbers. You choose a fixed time each week, for example 15 to 30 minutes on Monday morning. You schedule the review before the dashboard is complete. For each metric, your team can note whether it improves or declines, its likely cause and one action.

How do you use AI to set up a metrics dashboard?

The Performance Reporting Analyst is an AI agent. It maps each metric to its data source. It connects your CRM, accounting and analytics data. It builds the dashboard with correct data first and formatting second. It checks each metric against its source. It schedules and prepares the weekly leadership team review. You choose the tool and the review time.

See correct numbers for your key metrics in one place

Sign up to set up your metrics dashboard.

Sign Up