CRM Reports for Small Teams: The 5 Pipeline Reports That Actually Matter
Most CRM reporting is built for a VP of Sales with forty reps. A founder or three-person agency needs five reports and fifteen minutes a week. Here is which five, how to read them, and what they cost in Gmail CRMs.
Most CRM reporting is designed for a VP of Sales who manages forty reps and presents to a board: forecast categories, weighted pipeline, quota attainment by region. If you are a founder, a freelancer or a three-person agency, none of that answers your Monday-morning questions: how much is in play, where are deals getting stuck, and what did I forget to follow up?
That mismatch is why so many small teams set up a pipeline and never open the reports tab. This guide covers the five reports that do answer those questions, how to read each one, the common misreadings, and a 15-minute weekly review that uses them. The method works in any CRM; we show where each report lives in Teamopipe, our own product.
The five reports that matter for a 1–10 person team
1. Pipeline value by stage
The question it answers: how much business is in play right now, and where is it sitting?
How to read it: a healthy small-team pipeline looks like a funnel, with more deals in early stages than late ones. If most of your value sits in Proposal sent, you are not short of leads, you are short of closing. If it is all in New lead, you have a qualification problem, or nothing has been updated in a month.
Common misreading: treating total pipeline value as a forecast. $120,000 in pipeline is not $120,000 of revenue. Even a rough rule such as "we close about a third of what reaches proposal" beats the raw total. If your CRM supports stage probabilities, a probability-weighted value does this for you.
2. Stage conversion
The question it answers: of the deals that reached each stage, what share moved on to the next?
How to read it: look for the biggest drop. Most small teams find one stage where half the deals die, and that is where to spend the next month: a better qualifying call, a shorter proposal, a tighter follow-up cadence. It also exposes stages that do nothing. If almost every deal passes straight through "Needs analysis," delete the stage.
Common misreading: comparing months that each have ten deals. Small numbers swing wildly. Read conversion over at least a rolling quarter.
3. Stale deals
The question it answers: which open deals has nobody touched?
How to read it: this is less a report than a to-do list. Every open deal should have a recent email, note or scheduled task. Anything with none of those for two weeks is stale. Sort by value and work from the top.
Common misreading: assuming stale means dead. Often it means "we forgot." A one-line check-in revives a surprising share. The deals that stay silent after that are the ones to close as lost.
4. Won and lost by period, with reasons and average deal size
The question it answers: are we closing more, why do we lose, and is each win getting bigger or smaller?
How to read it: compare won count, won value and average deal size month by month. Flat count with rising average means you are moving upmarket; rising count with falling average means the opposite. Both can be fine if they are deliberate. Read lost reasons next to the wins: three losses to "went with a cheaper option" in a quarter is a pricing signal.
Common misreading: celebrating one large deal as a trend. One $40,000 win in a month of $2,000 deals makes the average meaningless. Look at the median, or simply at the list.
5. Results by owner
The question it answers: who is closing, who is stuck, and where does each person's pipeline drop off?
How to read it: filter the same reports by owner. For a small team this tells you whether a quiet pipeline is a demand problem or a capacity problem. If one person's deals all stall at the same stage, that is a coaching conversation, not a leaderboard.
Common misreading: using it as a ranking. In a three-person team, public rankings mostly produce busywork and resentment. Use it to spot capacity problems, not to rank people.
What reporting costs in Gmail CRMs
Reporting is often gated behind a higher tier, so the plan you need for reports is not the headline price. Per user per month, as listed on each vendor's pricing page in October 2026:
| Tool | Plan with reports | Annual / monthly | 3 users, yearly | 5 users, yearly |
|---|---|---|---|---|
| Teamopipe | Growth | $29 / $39 | $1,044 | $1,740 |
| Streak | Pro | $49 / $59 | $1,764 | $2,940 |
| Copper | Professional | $59 / $69 | $2,124 | $3,540 |
| NetHunt | Business | $60 | $2,160 | $3,600 |
Two honest caveats. Streak Pro buys a mature product with years of polish, and NetHunt Business bundles sequences, automation and LinkedIn integration alongside reports. If you need those anyway, the gap is smaller than the table suggests. See the Streak, NetHunt and Copper comparisons.
Getting these reports in Teamopipe
If you have read that Teamopipe has no built-in reporting, that is out of date. The reporting dashboard is included on the Growth and Pro plans, and it reads the same pipeline data your deal cards carry in Gmail, with no separate sync step. Here is where each report lives:
- Headline cards: open deals, won and lost this period, and win rate.
- Pipeline value by stage (report 1), with a probability-weighted value if you set stage probabilities.
- Stage conversion (report 2), showing how far deals get through each pipeline.
- Stale deals (report 3): an alert bar listing open deals with no activity past your threshold, 14 days by default, sorted by idle days with the value at risk. Change the threshold in Settings → Workspace.
- Won and lost (report 4) over any period, with lost reasons.
- Owner filter (report 5): every number filters by pipeline, period and owner.
A data-quality bar also flags deals missing an owner or a value, so your totals are not quietly understated. The reporting overview in our help centre explains each number, and the reporting feature page has screenshots.
What it does not do: there is no custom report builder or cohort analysis. If those are must-haves, you will outgrow the built-in dashboard.
The 14-day trial includes Growth features, so you can see these reports on your own pipeline before you pay. No card is needed.
Start your free 14-day trial
An affordable alternative to Streak and other complex CRMs.
When to go further: Google Sheets and Looker Studio
Eventually you may want a question the built-in reports do not answer, such as revenue by lead source crossed with deal size, or CRM data combined with invoicing data. The standard small-team route is CRM → Google Sheets → Looker Studio.
Get your deals into a sheet, one row per deal, with columns for stage, value, created date, closed date, outcome and owner. A CSV export works for a one-off. For a live feed, a Zapier step that appends a row whenever a deal is created or updated keeps the sheet current; Teamopipe includes Zapier and a public API on every plan. Then point Looker Studio, which is free, at the sheet and build whatever charts you need.
A warning: a Looker Studio dashboard is a project, not a feature. Budget an afternoon to build it and an hour a month to keep it honest. For most teams under ten people, the built-in reports cover what actually gets looked at. Another option is to ask Claude or ChatGPT about your pipeline through an MCP connection, which for some teams replaces a dashboard altogether.
Reports are only as good as your stage discipline
Every report above depends on deals being in the right stage. If half your team moves deals to Proposal when the proposal is sent and the other half when it is accepted, your conversion report is noise.
Three habits fix most of it. Write a one-line definition of what must be true for a deal to enter each stage, and keep it next to the pipeline. Close lost deals promptly; a pipeline where nothing is ever lost is one where the won-lost report lies. And keep stages few. Five or six is plenty for almost any small team. Our guide to building a sales pipeline that converts goes deeper on stage design.
The 15-minute weekly review
Pick a fixed slot, ideally Monday morning, and run the reports in this order:
- Stale deals, 3 minutes. Send a check-in or close as lost for anything at the top of the list.
- Pipeline by stage, 2 minutes. Does the shape look like a funnel, and does the total match your sense of the business?
- Stage conversion, 3 minutes. Has the worst drop-off stage changed?
- Won and lost, 3 minutes. Are you on pace, and did one deal distort the average? Any new pattern in lost reasons?
- By owner, 2 minutes. Is anyone, including you, carrying more than they can follow up?
Spend the last two minutes writing down one thing to change this week. Done weekly, that beats any dashboard you open once a quarter.
FAQ
Which CRM reports does a small business actually need?
Five cover most of it: pipeline value by stage, stage conversion, stale deals, won and lost by period with reasons and average deal size, and the same numbers filtered by owner.
What is a stage conversion report?
It shows, for each pipeline stage, what share of deals moved on to the next stage. It is the fastest way to find the stage where most deals die.
What counts as a stale deal?
An open deal with no recent activity, typically no email, note, field update or stage change for 14 days. Teamopipe flags these automatically on the Growth and Pro plans and lets you change the threshold.
Does Teamopipe have built-in reporting?
Yes. The reporting dashboard is included on the Growth and Pro plans. It covers headline cards, pipeline value by stage, stage conversion, won and lost deals with reasons, stale deals and an owner filter.
Which Gmail CRM plans include reports?
As of October 2026: Teamopipe Growth at $29 per user per month (annual), Streak Pro at $49 with standard reports, Copper Professional at $59 and NetHunt Business at $60.
How often should a small team review pipeline reports?
Weekly, in a fixed 15-minute slot. More often produces noise on a small pipeline; less often lets stale deals go unnoticed.
