KPI Tree

Attio Metric

CRM

Pipeline Coverage Ratio = Total Open Pipeline Value / Revenue Target

Pipeline coverage ratio measures the total value of open pipeline in Attio divided by the revenue target for a given period. It indicates whether sufficient pipeline exists to achieve the target, accounting for historical win rates and the time remaining to close deals.

Full guide: definition, formula, and benchmarks

Pipeline Coverage Ratio

Pipeline coverage ratio measures the total value of open pipeline in Attio divided by the revenue target for a given period. It indicates whether sufficient pipeline exists to achieve the target, accounting for historical win rates and the time remaining to close deals.

How to calculate pipeline coverage ratio

Pipeline Coverage Ratio = Total Open Pipeline Value / Revenue Target

Why pipeline coverage ratio matters for Attio users

Pipeline coverage is the most fundamental health check for any sales organisation. If coverage drops below the level needed to absorb normal loss and slippage rates, hitting target becomes mathematically improbable. Most organisations need three to four times coverage to hit target, but the exact ratio depends on win rates, deal sizes, and the mix of pipeline stages.

Tracking coverage in Attio over time reveals whether pipeline generation is keeping pace with revenue targets. A declining coverage ratio weeks before quarter-end is a clear signal that additional pipeline generation activity or deal acceleration is needed. This metric converts vague pipeline anxiety into precise, actionable urgency.

Understand and act on pipeline coverage ratio with KPI Tree

Sync Attio deal values and stage data alongside revenue targets in your warehouse. KPI Tree calculates coverage ratios automatically, segmented by rep, team, segment, and time period.

Position pipeline coverage as a top-level health metric in your metric tree. Assign ownership to sales leadership, set threshold alerts when coverage drops below safe levels, and track coverage trajectories over time to predict whether pipeline generation will be sufficient for future quarters.

Get started with your Attio data

Query using MCP
MCP

Pull metrics from Attio directly through the Model Context Protocol.

Data Warehouse
SnowflakeBigQueryDatabricksRedshift

Connect your existing warehouse where Attio data already lands.

Professional Services
FivetranSnowflakedbt

Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.

Related Attio metrics

Pipeline Health Score

CRM

Metric Definition

Pipeline health score is a composite metric that evaluates the overall quality and reliability of the sales pipeline in Attio. It combines deal age distribution, stage balance, activity recency, deal progression velocity, and coverage ratios into a single score that indicates whether the pipeline is likely to convert as expected.

View metric

Sales Pipeline Velocity

CRM

Metric Definition

Pipeline Velocity = (Number of Opportunities x Average Deal Value x Win Rate) / Sales Cycle Length

Pipeline velocity quantifies the rate at which the sales pipeline in Attio converts into revenue. It combines the number of open opportunities, average deal value, win rate, and sales cycle length into a single metric representing the revenue-generating throughput of the pipeline per unit of time.

View metric

Deal Conversion Rate

CRM

Metric Definition

Deal Conversion Rate = (Closed-Won Deals / Total Deals Created) x 100

Deal conversion rate measures the percentage of deals created in Attio that ultimately close as won. It is the broadest measure of pipeline effectiveness, capturing the combined impact of deal qualification, sales execution, competitive positioning, and pricing across the entire sales process.

View metric

Forecast Accuracy

CRM

Metric Definition

Forecast Accuracy = (1 - |Forecasted Revenue - Actual Revenue| / Actual Revenue) x 100

Forecast accuracy measures the percentage deviation between forecasted revenue (based on Attio pipeline data and probability-weighted projections) and actual closed revenue for a given period. It evaluates the reliability of the sales forecasting process and identifies systematic biases like chronic over-forecasting or under-forecasting.

View metric

Empower your team to understand and act on Attio data

Map what drives your metrics, measure progress at any grain, prove what works statistically, and deliver personalised action plans to every team member.

Experience That Matters

Built by a team that's been in your shoes

Our team brings deep experience from leading Data, Growth and People teams at some of the fastest growing scaleups in Europe through to IPO and beyond. We've faced the same challenges you're facing now.

Checkout.com
Planet
UK Government
Travelex
BT
Sainsbury's
Goldman Sachs
Dojo
Redpin
Farfetch
Just Eat for Business