How to Build a Sales Dashboard

Define Your Dashboard Audience and Goals

A dashboard that tries to serve everyone serves no one. Start by defining who will use it and what decisions it should drive.

1. Identify the primary audience. An SDR manager needs activity metrics and pipeline creation data. A CRO needs pipeline coverage, forecast accuracy, and revenue attainment. Build separate views for each audience.
2. For each audience, list the top 3-5 questions they need answered daily or weekly:

Audience	Key Questions
SDR Manager	Are reps hitting activity targets? How much pipeline did we create this week? Which reps need coaching?
AE Manager	What is our pipeline coverage ratio? Which deals are at risk? Are we on track to hit quota?
CRO / VP Sales	What is our forecast for the quarter? How does pipeline compare to last quarter? Where are we losing deals?

3. Resist the urge to add “nice to have” metrics. Every chart on the dashboard should drive a specific action. If a metric does not change what someone does, remove it.

Select the Right Metrics

Choose metrics that are leading indicators (predictive) over lagging indicators (retrospective) wherever possible.

1. Build your dashboard around these core metric categories:

Category	Metrics	Update Frequency
Pipeline Health	Pipeline value, pipeline coverage ratio, pipeline by stage, average deal size	Daily
Activity	Calls made, emails sent, meetings booked, demos completed	Daily
Velocity	Average days in each stage, overall sales cycle length, stage-to-stage conversion rates	Weekly
Forecast	Weighted pipeline, commit vs. best case, forecast accuracy vs. prior quarters	Weekly
Attainment	Quota attainment by rep, team attainment, revenue closed	Weekly

2. Include comparisons. Show current period versus prior period and current period versus target. Raw numbers without context are hard to interpret.
3. Add a pipeline waterfall chart showing how pipeline changed week over week: new pipeline added, pipeline moved forward, pipeline pushed out, and pipeline lost. This is the single most useful chart for a sales leader.

Design for Clarity

A well-designed dashboard is understood in under 10 seconds. A poorly designed one gets ignored.

1. Use a top-down layout. Put the most important metrics (quota attainment, pipeline coverage) at the top. Put supporting detail (activity metrics, deal-level data) below.
2. Limit each dashboard to 6-8 charts. If you need more, create a second dashboard for drill-down analysis.
3. Use consistent color coding: green for on-track, yellow for at risk, red for behind. Apply the same thresholds across all charts so the team builds intuition over time.
4. Include filters for time period, team, and individual rep. Managers need the ability to zoom in on a specific rep without leaving the dashboard.
5. Add a “last updated” timestamp so users trust the data is current.

Build, Launch, and Iterate

Ship a version 1 quickly, then improve based on feedback.

1. Build version 1 in your BI tool (Looker, Tableau, Power BI, or even a well-structured spreadsheet). Focus on getting the data right, not making it beautiful.
2. Share the dashboard with 3-5 power users for one week. Ask them: What is missing? What is confusing? What do you never look at?
3. Incorporate feedback and launch to the full team. Walk through the dashboard in a team meeting so everyone understands what each metric means and how to interpret it.
4. Schedule a monthly dashboard review. Check whether the metrics are still relevant, the data is accurate, and the team is actually using it. A dashboard that nobody opens is not a dashboard.