Sales reporting: the dashboards and KPIs that matter

Most small teams don’t have a reporting problem because they lack data. They have one because nobody agreed on what to look at, how to calculate it or when to look. The result is a dashboard full of charts and a Monday meeting that still runs on gut feel.

This guide gives you ten KPIs with plain formulas, shows how to read funnel and lead source reports, and lays out a simple weekly and monthly reporting rhythm you can run in under an hour.

Why reporting matters for small teams

Selling time is scarce. In Salesforce’s fifth State of Sales survey of 7,775 sales professionals in 38 countries, fielded in 2022, reps said they spent just 28% of their week actually selling. That’s vendor research and a few years old, but the point holds: every hour spent building spreadsheets is an hour not spent with customers. Good reporting should take minutes to read and point to a decision.

Demand is also harder to come by. In the Federal Reserve Banks’ 2024 Small Business Credit Survey, which collected 7,653 responses from US firms with 1–499 employees, 57% named reaching customers and growing sales as an operational challenge, up from 53% the year before. When leads are hard-won, knowing which ones convert matters more.

The 10 KPIs small teams should watch

Pick a reporting period (usually a calendar month) and calculate every KPI for the same period. Write the definitions down where the team can see them.

KPI	Formula	What it tells you
New leads	Count of leads created in the period	Whether demand is growing
Lead-to-customer rate	Leads that became won deals ÷ leads created	How well you turn interest into revenue
Win rate	Deals won ÷ (deals won + deals lost)	How often you close once a deal is real
Average deal size	Revenue won ÷ deals won	Whether you’re selling bigger or smaller jobs
Sales cycle length	Average of (close date − created date) for won deals	How long cash takes to arrive
Pipeline value	Sum of open deal values	How much is in play
Weighted pipeline	Sum of (deal value × stage probability)	A realistic view of what’s likely to close
Revenue won	Sum of values of deals marked won	Sales results for the period
First response time	Median of (first outbound contact − lead created)	How fast leads hear from you
Activities per rep	Calls, emails, texts and meetings logged ÷ reps	Effort, as context for results

A few notes on getting these right:

• Win rate excludes open deals. Including them drags the number down and makes it swing with pipeline size.
• Use the median for response time. One lead that sat over a long weekend shouldn’t hide the fact that most leads hear back in ten minutes.
• Separate revenue won from cash collected. A roofing contractor might win a $20,000 job in March and collect in May. Track both, and label them.
• Stage probabilities need to be honest. Weighted pipeline is only as good as the probabilities you set. Our guide to sales forecasting explains how to calibrate them from your own win history.

You can add more later: quote acceptance rate, average discount, revenue per rep. But start with ten you trust.

Funnel conversion

A funnel report shows how many records make it from one stage to the next. It’s the fastest way to see where deals leak.

Say a home services company had this month:

Stage	Count	Conversion from previous stage
New leads	200	—
Contacted	170	85%
Estimate booked	90	53%
Quote sent	70	78%
Won	28	40%

The biggest drop is between contacted and estimate booked. That’s where to look first: maybe the first call doesn’t ask for the appointment, or the leads from one source aren’t serious. Fixing a 53% step usually pays more than squeezing a 78% step.

To make funnel reports useful:

• Define clear exit criteria for each stage so “Contacted” means the same thing for everyone. Our guide to sales pipeline management covers stage design.
• Record lost reasons. A funnel tells you where deals die; lost reasons tell you why.
• Compare the funnel month over month rather than reading one month in isolation.

Lead source performance

Lead source reporting answers a simple question: where do your best customers come from?

For each source, track:

Metric	Formula
Leads by source	Count of leads per source
Source conversion rate	Won deals from source ÷ leads from source
Revenue by source	Sum of won deal values from source
Cost per lead	Spend on source ÷ leads from source
Return on spend	Revenue from source ÷ spend on source

Spend usually lives in your ad accounts or bookkeeping, so bring that number in yourself. The rest should come straight from the CRM.

Source reporting breaks down quickly when sources are labeled inconsistently. Google’s own documentation notes that UTM values are case sensitive, so “Facebook” and “facebook” become two different sources. Agree on naming rules and capture the source automatically wherever you can. Our guide to lead source tracking walks through UTM parameters and click IDs in detail.

A realtor might find that open-house sign-ins produce many leads but few closings, while past-client referrals produce few leads and most of the revenue. That’s not a reason to stop open houses, but it is a reason to follow up referrals within the hour.

Rep activity and performance

Rep reports help managers coach, not just rank. For each rep, look at:

• Leads assigned and worked. Is anyone sitting on untouched leads?
• Conversion rate and win rate. Who turns conversations into deals?
• Revenue won and average deal size. Who closes bigger jobs?
• Activities logged. Calls, messages and meetings, as context.
• First response time. Who replies fast, and who doesn’t?

Read these together. A rep with low activity and a high win rate may be cherry-picking leads. A rep with high activity and a low win rate may need help with qualification or the close. Rewarding raw activity counts tends to produce more low-quality outreach, so use them to diagnose rather than as the goal.

Weekly vs monthly reporting

Different questions need different rhythms.

Review	Weekly (30 minutes)	Monthly (60 minutes)
Purpose	Act on specific deals and leads	Spot trends and change the process
Look at	Open pipeline, stalled deals, overdue tasks, untouched leads, this week’s appointments	All ten KPIs, funnel conversion, lead source performance, rep performance, forecast vs actual
Output	A next step and owner for every stuck deal	One or two process changes to try next month

Keep the weekly meeting about deals, not slides. Open the pipeline, sort by stalled deals, and agree on a next action for each. Save the bigger questions (should we drop a lead source, change a stage, adjust pricing?) for the monthly review, when you have enough data to see a pattern.

Keep the data clean

Every report depends on what people enter. Make these non-negotiable:

1. Every lead has a source.
2. Every deal has a value, an owner and an expected close date.
3. Deals move stages when they meet the exit criteria, not at the end of the month.
4. Lost deals get a lost reason.
5. Duplicates get merged, so one customer doesn’t count as three leads.

How Exa helps

Exa’s analytics cover the KPIs in this guide: new leads, pipeline value, weighted pipeline, revenue and win rate, plus a monthly revenue forecast (won, weighted and best case), funnel conversion from lead to won deal, rep performance (leads, conversions, revenue and activities) and lead source performance with conversion rates. A billing snapshot shows outstanding, overdue and collected amounts, so revenue won and cash collected stay separate. Every report works for any date range.

Because deals carry values, stage probabilities, owners, expected close dates and lost reasons, and leads carry source attribution with UTM parameters and click IDs, the numbers come from the records your team already works in. You can also ask the AI assistant questions like “What was our win rate by source last quarter?” and get the answer with a chart.

Final thoughts

Good sales reporting is a habit, not a dashboard. Agree on ten KPIs and their formulas, review deals weekly and trends monthly, and keep stages, sources and lost reasons clean. Do that for a quarter and you’ll know where your revenue comes from, where deals leak and what to fix next.