Dara Correia Proving that investment in CRM generates concrete results remains a challenge for many B2B companies. Most already have a CRM platform, some sales reports and dashboards with activity indicators. The problem is that many of these dashboards show movement, but they do not show impact.
A dashboard can indicate how many contacts were created, how many emails were sent, how many calls were logged or how many meetings were booked. These data points are useful for tracking execution, but they rarely answer the questions that matter to leadership: is marketing generating qualified opportunities? Is the pipeline sufficient to achieve the target? Is the sales team converting better? Which channels are creating real revenue? Where is value being lost throughout the funnel?
The difference between a report that gathers dust and a dashboard that influences decisions lies in the metrics selected. In 2026, a CRM should no longer be seen only as a database of contacts and deals. It should operate as the central visibility system for marketing, sales, customer success and revenue.
At Liminal, we help CEOs, CMOs and SME sales teams turn platforms such as HubSpot, Salesforce and Zoho into decision systems. The goal is not to create attractive dashboards. It is to create dashboards that show, with reliable data, where the pipeline starts, where value is lost, which sources generate real opportunities and which actions should be taken to improve results.
The platforms already provide many of the necessary features. HubSpot allows sales reports to be created on topics such as created deals, funnel, forecast, goals, sales velocity, activities and sales performance. Salesforce provides Pipeline Inspection, a consolidated view of pipeline metrics, opportunities, weekly changes, AI insights and sales activity. Zoho CRM allows reports, dashboards and forecasts to be created and uses Zia capabilities to support sales analysis and forecasting.
The technology exists. What is missing, in most cases, is a metrics architecture.
Webinar: How to Use a CRM to Sell More
Quick guide: the 8 best CRM metrics for proving pipeline
The 8 essential metrics for proving pipeline in CRM are:
- MQL to SQL conversion rate
Measures whether leads qualified by marketing are accepted by sales as opportunities with real potential. - Pipeline Coverage Ratio
Shows whether the value of open opportunities is sufficient to cover the sales target, considering the expected win rate. - Pipeline velocity
Measures how much value moves through the funnel over a given period, combining volume, average deal value, win rate and sales cycle length. - Win rate
Indicates the sales team’s effectiveness in converting opportunities into won deals. - Sales cycle length
Shows how long the company takes to turn an opportunity into revenue. - Average deal value
Helps understand whether the company is growing by volume, by value or by opportunity quality. - Revenue attribution by source
Connects revenue and pipeline to the campaigns, channels and touchpoints that contributed to opportunity creation. - Forecast vs. actual
Measures the accuracy of the sales forecast and the team’s ability to predict revenue rigorously.
These metrics should not live in isolation. They should be combined into dashboards by decision profile. Leadership needs forecast, coverage and revenue by source. Sales management needs pipeline by stage, win rate, sales cycle and deals at risk. Marketing needs lead quality, conversion by channel and contribution to pipeline. Operations needs data quality, adoption and CRM consistency.
How we selected the best CRM metrics for pipeline
Selecting CRM metrics is not a question of quantity. It is a question of relevance to business decisions. A dashboard with 30 indicators may seem complete, but it tends to create noise. A dashboard with 6 to 8 well selected indicators forces the team to discuss what really matters.
A metric should only enter an executive dashboard if it helps support a concrete decision. If the number rises or falls, the team should know which action to take. Otherwise, the metric may be interesting, but it is not strategic.
The criteria used to select these 8 metrics are the following:
- Direct link to revenue
The metric should show the path between marketing activity, sales opportunities and revenue. “Generated leads” may be useful, but it does not prove pipeline. “Pipeline created by source” already makes it possible to assess which channels contribute to real opportunities. - Actionability
Each metric should point to a decision. If the MQL to SQL rate falls, the team should review qualification criteria, lead scoring, campaigns or the follow up SLA. If the sales cycle increases, it is necessary to analyse stages, proposals, internal approval or the quality of opportunities. - Leadership understanding
A CEO or CMO should not need technical translation to interpret the dashboard. Metrics such as pipeline coverage, forecast vs. actual and revenue by source are easy to understand and connect directly to management decisions. - Availability in the main platforms
The metrics should be configurable in HubSpot, Salesforce and Zoho, even with different levels of customisation. The aim is to create a structure applicable to most B2B SMEs, without always depending on complex development. - Frequent updating
Pipeline dashboards should reflect the current situation. Monthly reports are useful for historical analysis, but they are not enough to manage opportunities in real time. - Comparison capability
A metric gains strength when it allows periods, sources, teams, products, segments and sales owners to be compared. Without comparison, there is data. With comparison, there is management.
1. MQL to SQL conversion rate
The MQL to SQL conversion rate measures the percentage of marketing qualified leads that are accepted or validated by sales. It is one of the most important metrics for assessing the quality of the handoff between marketing and the sales team.
The formula is simple:
MQL to SQL rate = number of SQLs ÷ number of MQLs × 100
This metric is important because it reveals misalignment. If marketing generates many MQLs, but few are accepted by sales, there may be a problem with segmentation, lead scoring, timing, value proposition or qualification criteria. Geckoboard defines this metric as the percentage of marketing qualified leads that become sales qualified leads and highlights its usefulness in assessing the quality of leads delivered to the sales team.
The dashboard should not show only the global rate. It should segment by source, campaign, product, region, segment and team. A lead coming from organic search may have a different conversion rate from a lead coming from paid advertising, an event, a webinar, a referral or outbound prospecting. The difference between sources is often more important than the global average value.
To configure this metric in the CRM, it is necessary to clearly define what MQL and SQL mean. An MQL can be a contact with company fit and intent signals, such as a demo request, a visit to a pricing page or interaction with bottom of funnel content. An SQL should be a lead accepted by sales, with enough commercial potential for active follow up.
The common mistake is to leave these definitions vague. If marketing and sales do not agree on the meaning of MQL and SQL, the dashboard becomes a battleground. The metric only works when the criteria are shared and documented.
When the MQL to SQL rate worsens, the action should be concrete. It may be necessary to review the ICP, adjust lead scoring, improve forms, qualify leads better before passing them to sales or create a feedback process for rejected leads.
2. Pipeline Coverage Ratio
The Pipeline Coverage Ratio shows whether the company has enough opportunities to achieve the sales target for a given period. It is a critical metric for leadership because it works as an early risk indicator.
The base formula is:
Pipeline Coverage Ratio = total pipeline value ÷ revenue target
If the quarterly target is 100,000 euros and there are 300,000 euros in open opportunities, coverage is 3x. This does not mean that the company will close 300,000 euros. It means that there is three times more value in open opportunities than the defined target.
This metric should be interpreted in relation to the win rate. A team with a 50% win rate may need lower coverage. A team with a 20% win rate needs a higher pipeline volume to achieve the same target. Therefore, the ideal coverage is not universal. It depends on the company’s history, the sales cycle, the segment and the quality of opportunities.
To make the calculation more realistic, a weighted version should be used:
Weighted pipeline = deal value × probability of closing
This logic allows the expected value of the pipeline to be adjusted to the probability of each opportunity closing. It is a common approach in pipeline analysis and forecasting.
The dashboard should show total coverage, weighted coverage, coverage by team, coverage by source and weekly or monthly evolution. It should also exclude old, stalled deals or deals without a next step. Otherwise, the ratio becomes inflated and creates false confidence.
When coverage falls below the defined threshold, the company should not wait for the end of the quarter. It should reinforce demand generation, reactivate old opportunities, accelerate qualified deals or review sales priorities.
3. Pipeline velocity
Pipeline velocity measures how much commercial value moves through the funnel over a given period. It is a powerful metric because it combines four critical dimensions: number of opportunities, average deal value, win rate and sales cycle length.
The most commonly used formula is:
Pipeline velocity = number of opportunities × average deal value × win rate ÷ sales cycle length
The advantage of this metric is that it shows there are several ways to improve growth. The company can increase the number of opportunities, increase the average value, improve the win rate or shorten the sales cycle. Each lever requires a different action.
If the number of opportunities grows but velocity does not increase, there may be a quality problem. If the average value rises but the win rate falls, there may be misalignment between the offer and the customer’s decision capacity. If the cycle increases, there may be friction in the proposal, approval, negotiation or qualification process.
The dashboard should show global velocity, velocity by source, velocity by product, velocity by team and evolution over time. It should also make it possible to compare segments. For example, the enterprise segment may have a higher average value but a longer cycle. The SME segment may close faster, but with a lower value.
This metric requires consistent data. Without deal value, creation date, closing date, stage and final result, the calculation loses credibility. Before configuring this dashboard, it is necessary to ensure CRM discipline.
4. Win rate
The win rate measures the percentage of opportunities won compared with the total number of decided opportunities.
The recommended formula is:
Win rate = won deals ÷ decided deals × 100
Decided deals include won and lost deals. They should not include opportunities that are still open, because that distorts the analysis.
This metric shows the sales effectiveness of the team. However, it should be analysed with context. A global win rate can hide relevant differences between sources, segments, salespeople, products and deal values.
For example, one source may generate few opportunities, but with a very high win rate. Another may generate high volume, but low conversion. One team may have a lower win rate because it works larger and more complex deals. Another may have a higher win rate because it works smaller and faster opportunities.
The dashboard should show global win rate, win rate by source, by owner, by segment, by product and by value band. It should also cross the win rate with loss reasons. Without that reading, the metric shows the result, but it does not explain the cause.
When the win rate falls, the company should investigate whether the problem lies in qualification, value proposition, pricing, competition, timing or the sales approach.
5. Sales cycle length
Sales cycle length measures the average time between opportunity creation and closing. In some models, it may be useful to measure from the first contact, from MQL or from SQL. The important thing is to maintain consistency.
The formula is:
Average sales cycle = sum of days to close ÷ number of closed deals
This metric shows how long the company takes to turn demand into revenue. The longer the cycle, the greater the need for pipeline, the greater the pressure on forecast and the higher the sales cost.
The dashboard should show global average cycle, cycle by stage, cycle by source, cycle by product, cycle by deal value and deals stalled beyond the expected time. HubSpot includes sales reports related to funnel, deals, forecast, goals and sales velocity, which makes it possible to analyse not only how many opportunities exist, but also how they move over time.
This metric helps identify bottlenecks. If deals spend too much time in qualification, criteria may be missing. If they spend too much time in proposal, there may be a lack of urgency, follow up or clarity about the decision process. If they spend too much time in negotiation, there may be a problem with price, authority or perceived value.
When the cycle increases, the answer should not be only to pressure salespeople. It may be necessary to review the proposal structure, automate follow ups, improve sales enablement content, create business case materials or qualify better before moving to proposal.
6. Average deal value
Average deal value shows the average value of won deals. It is essential for understanding whether the company is growing by volume, by value or by opportunity quality.
The formula is:
Average deal value = total revenue from won deals ÷ number of won deals
This metric should be read together with win rate and sales cycle. Increasing the average value can be positive, but if the win rate falls significantly or the cycle becomes too long, the company may be pursuing larger accounts without an adequate sales structure.
The dashboard should show global average value, average value by source, by product, by segment, by salesperson and by value band. Analysis by bands is important because the average can hide extremes. Two very large deals can inflate the average and create a wrong perception of the pipeline reality.
This metric answers a strategic question: is the company growing in a healthy way? If the number of deals increases but the average value falls, there may be pressure on margin and operational capacity. If the average value increases with a controlled cycle and stable win rate, the company may be improving positioning and pipeline quality.
When the average value falls, the team should analyse lead origin, sales proposal, discounts, segmentation and product mix. The problem may be in acquisition, qualification or negotiation.
7. Revenue attribution by source
Revenue attribution by source connects closed deals to the sources, campaigns and touchpoints that contributed to opportunity creation or progression. It is one of the most important metrics for proving marketing impact on pipeline.
The goal is not only to know how many leads came from each channel. The goal is to understand which channels generated qualified pipeline, real opportunities and revenue.
There are several attribution models:
- First touch, which values the contact’s first known source
- Last touch, which values the last interaction before conversion
- Linear, which distributes value across several touchpoints
- U shaped, which values origin and conversion
- W shaped, which values origin, conversion and opportunity creation
- Custom, adapted to the company’s sales cycle
For B2B SMEs, the recommendation is to start simple. First, ensure that all contacts have original source, campaign, creation date and correct association with company and deal. Then, evolve towards multi touch models.
The common mistake is to discuss advanced attribution models without reliable basic data. If the CRM does not connect contacts to companies, companies to deals and deals to campaigns, any attribution dashboard will be fragile.
The dashboard should show leads by source, MQLs by source, SQLs by source, pipeline created by source, closed revenue by source and cost per opportunity. This reading makes it possible to make investment decisions based on revenue, not only volume.
When a source generates many leads and little revenue, it should be reviewed. When a source generates low volume but high value deals, it may deserve more investment.
8. Forecast vs. actual
The forecast vs. actual metric measures the accuracy of the sales forecast. It compares the value predicted for a period with the revenue actually closed.
The formula can be presented as follows:
Forecast accuracy = closed revenue ÷ forecast revenue × 100
This metric is fundamental for leadership because it affects financial planning, hiring, marketing investment and capacity management. A team that forecasts 200,000 euros and closes 100,000 euros has a problem with forecast, qualification or pipeline discipline. A team that forecasts 100,000 euros and closes 200,000 euros also has a problem, because it is managing below reality.
Salesforce highlights Pipeline Inspection as a consolidated view of pipeline metrics, opportunities, weekly changes, AI insights and sales activity. Zoho also provides CRM capabilities with Zia to support analysis, reporting and forecasting.
The dashboard should show initial forecast, updated forecast, closed revenue, absolute difference, percentage difference, forecast by owner, forecast by category and deals that entered or left the forecast.
This metric requires sales maturity. Having opportunities in the CRM is not enough. Stages need clear criteria, probabilities need to be realistic, next steps need to be updated and management needs to distinguish probable pipeline from desired pipeline.
How to structure CRM dashboards by decision profile
One of the most common mistakes in CRM projects is creating a single dashboard for the entire organisation. It seems efficient, but it rarely works. Each function makes different decisions and needs different levels of detail.
Leadership needs to understand whether the company is on track to achieve the target. Sales management needs to know where the pipeline is blocked. Marketing needs to prove whether campaigns generate qualified opportunities. Operations needs to ensure that the data is reliable.
Executive dashboard
The executive dashboard should operate as a revenue control view. It should answer simple questions: are we going to achieve the target? Is there enough pipeline? Which sources generate revenue? Where is the commercial risk?
Recommended metrics:
- Pipeline Coverage Ratio
This metric shows whether there are enough opportunities to achieve the target. It is recommended because it anticipates problems before they appear in revenue. - Forecast vs. actual
Shows whether the team forecasts results rigorously. It is essential for financial planning and resource management. - Closed revenue by source
Makes it possible to understand which channels contribute to revenue and not only to lead generation. - Pipeline created by month
Helps assess whether the funnel is being fed consistently. - Global win rate
Shows overall sales effectiveness, provided it is interpreted with average deal value and sales cycle. - Average deal value
Helps understand whether the company is growing by volume or by opportunity quality. - Average sales cycle
Makes it possible to anticipate pipeline needs and assess friction in the sales process.
Sales management dashboard
The sales management dashboard should manage execution, risk and efficiency. At this level, it is no longer enough to know whether the target is close. It is necessary to understand which opportunities require intervention.
Recommended metrics:
- Pipeline by stage
Shows where opportunities are concentrated. If many are stalled in one stage, there is a bottleneck. - Pipeline by owner
Helps understand workload distribution, individual risk and support needs. - Deals stalled by stage
Identifies pipeline that appears active, but has no real movement. - Win rate by owner
Allows sales performance to be analysed, provided it is crossed with segment, source and average value. - Sales cycle by stage
Shows where the process slows down and where proposal, qualification or follow up needs improvement. - Loss reasons
Turns lost deals into sales learning. - Next activities in open opportunities
A deal without a next step is a risk. This metric enforces sales discipline.
Marketing dashboard
The marketing dashboard should prove contribution to pipeline, not only lead generation. In B2B, marketing cannot be evaluated only by clicks, visits and forms.
Recommended metrics:
- Leads by source
Shows the volume of demand generated by channel. - MQLs by source
Introduces quality and makes it possible to understand which channels attract contacts with a better fit. - MQL to SQL rate
Shows whether sales accepts the leads qualified by marketing. - Pipeline created by campaign
Connects campaigns to sales opportunities with value. - Revenue attributed by source
Makes it possible to defend marketing investment based on revenue. - Cost per lead
Useful for efficiency, but insufficient if analysed in isolation. - Cost per opportunity
More relevant than cost per lead, because it measures how much it costs to generate real pipeline. - Cost per customer
Completes the acquisition profitability analysis.
CRM operations dashboard
The operations dashboard ensures data quality and adoption. It does not exist to impress leadership. It exists to ensure that all other dashboards are reliable.
Recommended metrics:
- Deals without a next step
A deal without a next step is an opportunity without active management. It may be forgotten, stalled or poorly qualified. - Deals without value
Without deal value, there is no reliable pipeline, forecast, coverage or velocity. - Contacts without source
Without source, the company loses the ability to attribute pipeline and revenue to campaigns or channels. - Duplicate companies
Duplicates fragment history, distort reports and harm the 360 degree account view. - Opportunities without associated contact
Without association between deal, contact and company, the sales journey is incomplete. - Deals stalled beyond the SLA
Show opportunities that have exceeded the expected time in a stage and require action. - Records created without owner
A record without an owner creates follow up failures and loss of operational control.
Without this layer, executive dashboards lose trust. Decision quality depends on data quality.
How to configure these metrics in HubSpot, Salesforce and Zoho
HubSpot, Salesforce and Zoho can support pipeline dashboards, but they have different strengths.
HubSpot
HubSpot is particularly strong for teams that want an integrated platform across marketing, sales and service. Its advantage lies in usability, the connection between contacts, companies and deals, sales reports and the ease of creating dashboards without heavy technical dependency. HubSpot sales reports include areas such as created deals, forecast, funnel, goals, activities and sales velocity.
It is a good choice for companies that need to align marketing and sales, track lifecycle stages, measure conversions and create clear dashboards for leadership.
Salesforce
Salesforce is stronger in organisations with greater sales complexity. It allows advanced customisation, multiple pipelines, large teams, forecast hierarchies and detailed reporting. Pipeline Inspection gives sales teams a consolidated view of metrics, opportunities, weekly changes and AI insights.
It is suitable for companies with complex sales processes, long cycles, multiple teams and a need for more robust governance.
Zoho CRM
Zoho CRM offers a competitive cost functionality ratio for SMEs. It allows reports, dashboards, forecasts and automations to be created within a broad ecosystem. Zia adds analysis, report creation and intelligent support capabilities over CRM data.
It is a good option for companies that want a flexible solution, with a good total cost and integration with other Zoho applications.
Comparison table
| Criterion | HubSpot | Salesforce | Zoho CRM | Liminal Consultancy |
| Ease of adoption | High | Medium | Medium | Accelerates adoption and operational design |
| Advanced customisation | Medium | High | Medium/High | Defines data and process architecture |
| Marketing and sales dashboards | High | High | Medium/High | Connects metrics to business decisions |
| Sales forecast | High | Very high | High | Defines forecast criteria and governance |
| Cost for SMEs | Medium | High | Competitive | Helps choose the right solution |
| Configuration dependency | Medium | High | Medium | Reduces the risk of poor implementation |
| RevOps integration | High | High | Medium/High | Designs an integrated revenue model |
Mistakes to avoid when creating pipeline dashboards in CRM
Creating pipeline dashboards is not just about choosing charts. It is about designing a decision system. When that system is poorly thought out, the company starts discussing numbers without context.
- Measuring activity instead of results
Emails sent, calls made and meetings booked can be useful, but they do not prove pipeline. They should be in operational dashboards, not dominate executive dashboards. - Creating generic dashboards
A single dashboard for everyone tends to be superficial or confusing. Each profile needs a different view. - Using outdated data
If salespeople do not update stages, values and next steps, the dashboard no longer represents reality. - Accepting vague stages
Stages such as “under analysis” or “in negotiation” without objective criteria make the forecast unreliable. - Not recording loss reasons
Without loss reasons, the company knows that it lost, but not why. - Separating marketing and sales in the data
If contacts, companies, deals and campaigns are not associated, there is no credible attribution. - Creating overly complex dashboards
More metrics do not mean better management. The dashboard should reduce complexity, not increase it. - Not defining data owners
A CRM needs governance. Without data owners, quality deteriorates quickly.
Why a Marketing Ops consultancy improves CRM dashboards
A Marketing Ops consultancy adds value because it does not look only at the tool. It looks at the process, data, team, reporting and decisions that the CRM must support.
This is where a consultancy such as Liminal differentiates itself. Liminal does not simply configure software. It designs the data architecture, qualification criteria, stage transition rules, dashboards by profile and adoption processes that make the CRM useful for management.
Liminal is a HubSpot Gold Partner and Zoho Authorized Partner, according to information published in its own training and partnership materials. It also presents success stories in which CRM and automation implementation were associated with measurable improvements, such as the Moviter case, with 20% more monthly sales after CRM implementation, and the GoContact case, with a doubling of customers from marketing and a 50% reduction in cost per lead.
These results should not be read as a universal promise. The point is different: CRM generates impact when it is connected to process, data quality, automation, analysis and sales management.
For CEOs and CMOs of SMEs, the question is not only “which CRM should we choose?”. The right question is: what pipeline management system do we want to build?
Conclusion
CRM does not prove pipeline simply by existing. It proves pipeline when the company measures the right conversions, associates marketing with deals, controls data quality and uses dashboards to make weekly decisions.
The 8 metrics presented in this article create the foundation for that visibility. The MQL to SQL rate shows quality. The Pipeline Coverage Ratio shows sufficiency. Pipeline velocity shows pace. The win rate shows effectiveness. The sales cycle shows friction. Average deal value shows potential. Revenue attribution shows the real origin of pipeline. The comparison between forecast and actual shows management maturity.
HubSpot, Salesforce and Zoho can support this model. The difference lies less in the platform and more in the architecture. Without clear processes, qualification criteria, reliable data and dashboards by decision profile, any CRM becomes an underused database.
In 2026, companies that can prove pipeline with reliable data will have an advantage. They will invest better in marketing, prioritise opportunities with greater rigour, anticipate coverage gaps and align teams around revenue.
FAQs about CRM metrics and dashboards for pipeline
What is the most important metric for proving pipeline in a CRM?
It depends on the company’s maturity. For many B2B SMEs, the MQL to SQL conversion rate is one of the first critical metrics, because it shows whether marketing is generating leads that sales considers valid. For more mature teams, Pipeline Coverage Ratio and forecast vs. actual tend to be more relevant for executive management.
How do you calculate pipeline velocity?
Pipeline velocity is calculated by multiplying the number of opportunities by the average deal value and the win rate, then dividing by the average sales cycle length. This metric shows how much commercial value moves through the funnel over a given period.
How many metrics should an executive CRM dashboard have?
An executive dashboard should have between 5 and 8 main metrics. More than that tends to create noise. The goal is not to show everything. It is to show what enables better decisions.
How can marketing prove that it generates pipeline?
Campaigns, sources and contacts must be connected to sales opportunities and revenue. For this, the CRM must have original source, associated campaigns, lifecycle stages, connections between contacts and deals, and dashboards for pipeline created by source.
What is the difference between created pipeline and closed revenue?
Created pipeline represents open sales opportunities with potential value. Closed revenue represents won deals. Pipeline shows future potential. Revenue shows actual result.
How do you know whether the pipeline is sufficient?
Through the Pipeline Coverage Ratio. This metric compares the value of the pipeline with the sales target. It should be adjusted to the company’s historical win rate.
What data is mandatory for reliable CRM dashboards?
The minimum fields include contact source, associated company, associated deal, owner, deal value, stage, creation date, expected close date, next activity, loss reason and final result.
What should be the first dashboard to create?
For most B2B SMEs, the first dashboard should be the executive pipeline dashboard, with coverage, forecast, pipeline by stage, revenue by source, win rate and sales cycle. Then, the operational dashboard should be created to ensure data quality.
Count on Liminal’s CRM specialists
The world of Marketing and Technology is constantly evolving. It is increasingly important to rely on specialists who ensure that innovations are integrated into companies. In addition, for technology to contribute to business success, it is essential to have a strategy that guides the implementation, adoption and evolution of systems.
As MarTech specialists, Liminal offers an integrated vision that combines Technology, Marketing and Strategy. We ensure the successful adoption and implementation of marketing technologies, whether through the impartial choice of the right systems to address the challenges of the company, the adaptation of processes and flows in existing systems, or the development of a CRM & Automation strategy that contributes to business growth.