Dashboard Metrics
All formulas and calculations for dashboard KPIs.
GTM Health Score
Range: 0-100
Formula:
GTM Health Score = (Velocity × 0.40) + (Activity × 0.35) + (Quality × 0.25)Velocity Score (40%)
Velocity = ((meetings_booked + conversions) / targets) × 100Measures revenue-generating output.
Activity Score (35%)
Activity = ((leads_captured + outreach_done) / targets) × 100Measures pipeline-building activity.
Quality Score (25%)
Quality = (reply_rate / benchmark_reply_rate) × 100Measures engagement effectiveness.
Status Thresholds
| Score | Color | Status |
|---|---|---|
| 80-100 | Green | Excellent |
| 60-79 | Yellow | Healthy |
| 0-59 | Red | Needs Attention |
North Star Metric (Meetings)
Formula:
Progress % = (Total Meetings Booked / Monthly Target) × 100Color Thresholds
| Progress | Color |
|---|---|
| 100%+ | Green |
| 75-99% | Yellow |
| 50-74% | Orange |
| 0-49% | Red |
Revenue Metrics
Net Revenue
Net Revenue = One-time Revenue + First-month MRR (new conversions)MRR (Monthly Recurring Revenue)
MRR = SUM(mrr_amount) for active customersActive = billing started AND not churned.
ARR (Annual Recurring Revenue)
ARR = MRR × 12MRR Growth
MRR Growth % = ((Current MRR - Previous MRR) / Previous MRR) × 100Trend Calculation
All trend indicators use:
Trend % = ((Current Period - Previous Period) / Previous Period) × 100| Result | Display |
|---|---|
| Positive | Green ↑ |
| Negative | Red ↓ |
| Zero | Gray → |
Main Metrics Row
| Metric | Source | Calculation |
|---|---|---|
| Contacts Sourced | Leads table | COUNT where captured_at in period |
| Emails Sent | Campaign performance | SUM of emails_sent |
| Outreach | Daily reports | SUM of personalized_outreach |
| Replies | Campaign + Reports | SUM of replies |
| Meetings | Daily reports | SUM of meetings_booked |
| Conversions | Leads table | COUNT where converted_at in period |