Your sales director doesn't need more data. They need the right data.
90% of the sales dashboards we see at B2B companies in Mexico show two things: number of calls and total pipeline value. That's not a dashboard — it's a mirage. It doesn't tell you whether you'll hit your target, where deals are stuck, or how long they've been sitting there.
The metrics that matter are the ones that let you predict the month's close, not the ones that tell you what already happened.
The 10 pipeline metrics that actually matter
1. Pipeline velocity
The formula is simple: (opportunities x average ticket x win rate) / sales cycle in days. This number tells you how much revenue your pipeline generates per day. If it drops, you have a problem before it shows up in your closed deals.
2. Win rate by stage
It's not enough to know your overall win rate. You need to know where deals are falling off. If 60% are lost between proposal and negotiation, the problem isn't prospecting — it's your commercial proposal.
3. Average ticket (deal size)
Monitoring whether your average ticket is going up or down tells you if you're attracting the right type of client. A consistently declining ticket indicates that your campaigns are capturing lower-value leads. Check whether your acquisition strategy is aligned with your target ticket.
4. Cycle time (time to close)
How many days does a deal take from entering the pipeline to closing? According to Salesforce benchmarks, the average B2B sales cycle is 60-90 days. If yours exceeds 120, there's friction in your sales process.
5. Stage-to-stage conversion rate
Measure the conversion rate from each stage to the next. If you have 100 leads and only 10 make it to a meeting, your qualification rate is 10%. This helps you identify exactly where to optimize.
6. Lead response time
The time it takes your team to respond to a new lead. According to HubSpot, leads contacted within the first 5 minutes are 21x more likely to convert. If your team takes 48 hours, you've already lost them.
7. Pipeline coverage ratio
Your total pipeline divided by your sales target. The general rule is to maintain 3x coverage — if your target is $1M MXN, you need $3M in pipeline. Below 2.5x and you're in the danger zone.
8. Aging deals
Opportunities that have been sitting for more than 2x your average cycle without advancing. If your normal cycle is 60 days and you have 15 deals over 120 days old, those deals are probably already dead. They're artificially inflating your pipeline.
9. No-show rate
The percentage of scheduled meetings where the prospect doesn't show up. If it exceeds 20%, your qualification process is weak or your value proposition isn't generating enough urgency.
10. Revenue attribution by channel
Where are the deals that actually close coming from? Not the leads — the closed deals. A well-configured CRM lets you track this from the source. Without this metric, you can't make informed marketing investment decisions.
The weekly dashboard that works
You don't need enterprise BI. With Looker Studio connected to your CRM, you can have a functional dashboard in a day. Here's what it should show:
| Section | Metrics | Review frequency |
|---|---|---|
| Executive summary | Total pipeline, coverage ratio, velocity | Weekly |
| Conversion funnel | Conversion rate by stage, new leads vs qualified | Weekly |
| At-risk deals | Aging deals, deals with no activity in 7+ days | Weekly |
| Performance by rep | Win rate, cycle time, average ticket | Biweekly |
| Attribution | Revenue by source channel, CPL by channel | Monthly |
The review cadence
The dashboard is useless if nobody looks at it. Implement this cadence:
- Monday (15 min): Quick review — total pipeline, new leads, deals to close this week
- Thursday (30 min): Funnel review — where deals are stuck, what they need to move forward
- First Monday of the month (1 hour): Deep review — win rate, cycle time, attribution, next month's forecast
The B2B sales funnel has specific stages you need to respect. If your pipeline doesn't reflect them, your metrics will be noise.
The 5 red flags you can't ignore
- Pipeline coverage below 2x. You won't hit your target — activate demand generation campaigns now.
- Win rate declining for 2+ consecutive months. Something changed in your market, your competition, or your value proposition.
- Cycle time increasing without a clear reason. This may indicate you're attracting less qualified leads or that your sales process has new friction points.
- More than 30% of your pipeline is aging deals. Clean your pipeline. Those deals won't close and they're distorting your forecast.
- Revenue attribution concentrated in a single channel. If 80% of your sales come from referrals, you don't have a marketing system — you have luck. You need a system that diversifies your acquisition channels.
The minimum you need to get started
You don't need Salesforce or a RevOps team. You need:
- A CRM with a visual pipeline — Kommo, GoHighLevel, or HubSpot work for teams of 3-15 salespeople
- Defined pipeline stages — with clear criteria for what a deal needs to advance
- A Looker Studio dashboard — connected to your CRM via API or Google Sheets as a bridge
- 30 minutes per week — to review metrics and make decisions
At De Marketing, we configure your CRM, build your dashboard, and walk you through weekly reviews until the system runs on its own. If your sales director can't answer "how are we tracking?" in 30 seconds, schedule a diagnostic and we'll fix it.
Want to implement this in your company?
Book a free diagnostic and we'll show you how to apply this to your operation.
Book a Diagnostic
