# GTM Metric

Monitor pipeline health and progression

Track the distribution and value of opportunities across sales stages. Identify bottlenecks, predict revenue timing, and optimize stage progression rates.

### Open Opportunities by Stage Dashboard

Live Preview

| Metric                   | Value  | Change  |
|--------------------------|--------|---------|
| Total Open Opps          | 285    | +14%    |
| Pipeline Value           | $4.8M  | +14.3%  |
| Weighted Pipeline        | $2.1M  | +16.7%  |
| Avg Deal Size            | $16,842| +0.25%  |

Trend Analysis: Current  
Connected to Salesforce  
Updated 2m ago

## Why Open Opportunities by Stage Matters

Essential insights for optimizing your go-to-market strategy

- **Key Insight #1**: Monitor stage conversion rates to identify sales process bottlenecks
- **Key Insight #2**: Weighted pipeline provides more accurate revenue forecasting
- **Key Insight #3**: Track velocity through each stage to optimize sales processes

## How to Calculate

### Formula

Count and Value of Opportunities by Sales Stage

### Benchmarks

- **Industry Average**: Balanced distribution
- **Good Performance**: Healthy progression
- **Excellent Performance**: No bottlenecks

### Trend Analysis

Jan	Feb	Mar	Apr
0	75	150	225	300

## Implementation Guide

How to track this metric effectively with Airbook's integrated platform

1. **Connect Your Data**  
   Connect your CRM, marketing tools, and analytics platforms with Airbook's 150+ connectors. Data syncs automatically and gets transformed into analysis-ready tables.
2. **Build Your Analysis**  
   Use our collaborative workspace to calculate this metric with SQL or no-code tools. Create segments, time periods, and cohort analyses across all your data sources.
3. **Track & Act**  
   Build auto-refreshing dashboards, set up threshold alerts, and track trends over time. Share insights across teams and trigger actions based on your metrics.

## Effortless, direct connections

## Access clean, actionable data from business tools, databases, and data warehouses—anytime, anywhere

.svg)

## Ready to Track Open Opportunities by Stage?

Connect your data sources, automate open opportunities by stage calculations, and get real-time insights to optimize your business growth.