Alegria RevOps logoAlegria RevOpsAI Revenue Operations for Modern Sales Teams
Sign in

How to build a sales dashboard

A sales dashboard should answer three questions in under ten seconds: are we on track, what changed, and what needs attention today. Everything else is decoration. This guide covers the metrics to include, how to lay them out for reps versus executives, and how Alegria RevOps builds them from live CRM data.

All answers

What should be included in a sales dashboard

Start with outcome metrics, then add the leading indicators that explain them. A dashboard made only of outcome numbers tells you that you missed the target but not why.

LayerMetricsWhy it matters
OutcomeClosed-won revenue, attainment vs quota, win rateTells you whether the period is on track
PipelineOpen pipeline value, coverage ratio, pipeline created this periodPredicts the next one to two periods
VelocityAverage sales cycle, stage conversion, deals slipping close dateExplains why revenue arrives late
ActivityLead response time, meetings booked, next step set on open dealsThe only layer reps can change today
EfficiencyCustomer acquisition cost, revenue per rep, lifetime value to CACTells you whether growth is affordable

Design one dashboard per audience

The single most common failure is one dashboard trying to serve reps, managers and the board. Each audience needs a different time horizon and a different level of aggregation.

  • Rep view: my open deals, deals with no next step, deals slipping, leads awaiting first response. Daily horizon.
  • Manager view: team pipeline coverage, stage conversion by rep, deals at risk, forecast versus commit. Weekly horizon.
  • Executive view: revenue attainment, pipeline created versus consumed, CAC and LTV trend, forecast accuracy. Monthly and quarterly horizon.

Refresh cadence and data quality

A dashboard is only trusted if the numbers reconcile with the CRM. Sync on a schedule you can state out loud, show the last sync time on the page, and flag records missing amount, close date or owner rather than silently excluding them.

Alegria RevOps syncs HubSpot and Salesforce records on a recurring schedule, tracks sync health, and surfaces data-quality exceptions so a stale dashboard is visibly stale instead of quietly wrong.

Common sales dashboard mistakes

  • Too many tiles. If it does not change a decision this week, move it to a report.
  • No comparison. Every number needs a prior period or a target next to it.
  • Vanity activity counts. Calls made is not a metric unless it maps to pipeline created.
  • No owner. Each panel should have a person accountable for acting on it.
  • Manual spreadsheets. If it takes an hour to rebuild, it will stop being rebuilt.

Frequently asked questions

How do I create a sales dashboard?
Pick the three to five decisions the dashboard must support, choose one metric per decision, connect it to live CRM data rather than a manual export, and add a prior-period comparison to every number. Start narrow and add panels only when someone asks a question the dashboard cannot answer.
What should be included in a sales dashboard?
Outcome metrics such as closed-won revenue and win rate, pipeline metrics such as open value and coverage, velocity metrics such as sales cycle length and stage conversion, and activity metrics such as lead response time. Executive dashboards should also carry customer acquisition cost and forecast accuracy.
How often should a sales dashboard refresh?
Rep-facing dashboards should refresh at least daily so next steps and response times are actionable. Executive dashboards can refresh daily but are read weekly. Always display the last sync timestamp so nobody makes a decision on stale data.

Keep reading