KPI Tree

Attio Metric

CRM

Deal age distribution analyses the spread of open deals in Attio by their age (days since creation or days in current stage). It categorises deals into age buckets and compares the distribution against historical close patterns to identify deals that have exceeded normal timelines and may be stale or at risk.

Deal Age Distribution

Deal age distribution analyses the spread of open deals in Attio by their age (days since creation or days in current stage). It categorises deals into age buckets and compares the distribution against historical close patterns to identify deals that have exceeded normal timelines and may be stale or at risk.

Why deal age distribution matters for Attio users

Stale pipeline is one of the most common causes of forecast misses. Deals that have been open significantly longer than the average sales cycle are statistically much less likely to close, yet they often remain in the pipeline at full value, inflating coverage ratios and creating false confidence. Deal age distribution exposes this hidden risk by showing exactly how much pipeline sits beyond normal close timelines.

This analysis also drives pipeline hygiene. When teams can see that 30% of their pipeline is over 90 days old, they are forced to confront whether those deals are genuinely progressing or simply sitting idle. This visibility creates the accountability needed to either re-engage stale deals or remove them from the pipeline, leading to more accurate forecasts and healthier pipeline metrics.

Understand and act on deal age distribution with KPI Tree

Sync Attio deal records with creation dates and stage change timestamps into your warehouse. KPI Tree calculates deal age, categorises deals into distribution buckets, and compares against historical close-time benchmarks.

Add deal age distribution as a pipeline health metric in your metric tree. Assign ownership to sales managers responsible for pipeline hygiene, set alerts when the proportion of aged pipeline exceeds healthy thresholds, and track distribution shifts period-over-period to verify that pipeline cleanup efforts are having the intended effect.

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

Deal Velocity Analysis

CRM

Metric Definition

Deal velocity analysis examines the speed at which deals progress through pipeline stages in Attio. It measures time-in-stage at each transition, identifies stages where deals decelerate, and compares velocity across segments, deal sizes, and reps to surface factors that accelerate or slow the sales process.

View metric

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 Cycle Length

CRM

Metric Definition

Sales Cycle Length = Average(Close Date - Deal Creation Date)

Sales cycle length measures the average number of days from deal creation in Attio to a closed-won outcome. It captures the full duration of the active sales process and reveals how efficiently deals move through the pipeline from qualification to close.

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