Analyze HubSpot Deal Stage Velocity and Bottlenecks from CSV

How to export HubSpot deal stage duration columns

HubSpot automatically tracks timestamp and duration properties for every stage in your pipeline (available on Professional and Enterprise subscriptions as of October 2026): Date entered [stage ID], Date exited [stage ID], Latest time in [stage ID], and Cumulative time in [stage ID].

1. In HubSpot, go to CRM > Deals and click Edit columns in the top right of the table.
2. Search for Cumulative time in and check every stage in your pipeline, plus Days to close, Create Date, Close Date, Deal Stage, Amount, and Deal Owner.
3. Click Export, choose CSV, and select Properties and associations in your view (the default option under Customize).

Three deal velocity formulas and SQL equivalents

1. Median vs. Average Days per Stage (Avoiding Outlier Skew)

One neglected deal that sat in "Proposal Sent" for 240 days before being closed-lost will distort your HubSpot average stage duration. Always compare MEDIAN days in stage between Closed Won deals and Closed Lost deals.

xmetric / Tableau formula (converting seconds/hours to days):

MEDIAN([Cumulative time in Proposal (Seconds)] / 86400.0)

SQL equivalent:

SELECT
  "Deal Stage" AS outcome_group,
  COUNT(*) AS deals,
  ROUND(MEDIAN("Cumulative time in Discovery" / 86400.0), 1) AS median_days_discovery,
  ROUND(MEDIAN("Cumulative time in Demo" / 86400.0), 1) AS median_days_demo,
  ROUND(MEDIAN("Cumulative time in Proposal" / 86400.0), 1) AS median_days_proposal,
  ROUND(MEDIAN("Days to close"), 1) AS median_total_days_to_close
FROM hubspot_deals
WHERE "Deal Stage" IN ('Closed Won', 'Closed Lost')
GROUP BY 1;

2. Stalled Open Deal Detector (FIXED LOD by Stage Benchmark)

Flag any currently open deal that has already spent more days in its current stage than 75% of historically Closed Won deals ever spent in that stage.

xmetric / Tableau formula ([Won Stage Benchmark Days]):

{ FIXED : PERCENTILE(IF [Deal Stage] = 'Closed Won' THEN [Days in Current Stage] END, 0.75) }

xmetric / Tableau formula ([Stalled Risk Flag]):

IF [Deal Stage] != 'Closed Won'
   AND [Deal Stage] != 'Closed Lost'
   AND DATEDIFF('day', [Date entered Current Stage], TODAY()) > [Won Stage Benchmark Days]
THEN 'Stalled (>P75 Won Cycle)'
ELSE 'On Track'
END

3. Sales Velocity Dollars per Day

Combine deal count, average deal value (Amount), win rate, and median sales cycle length into the classic RevOps velocity metric: how many dollars of new ARR each rep's pipeline produces per day.

xmetric / Tableau formula:

(COUNTD([Record ID]) * AVG([Amount]) * [Win Rate])
/ NULLIF(MEDIAN([Days to close]), 0)

Limits of HubSpot's native stage time reports

• Skipped stages show as blank/null: If a rep creates a deal directly in "Proposal" and skips "Discovery" and "Demo", HubSpot leaves Cumulative time in Discovery blank (and while a deal is currently in a stage for the first time, its Cumulative time in [stage ID] value remains blank until the deal leaves the stage). Do not wrap skipped stages in ZN() when computing median stage duration, or skipped deals will pull your median down toward zero. Keep nulls as NULL so MEDIAN() only evaluates deals that actually completed that stage.
• Formatting differences between CSV and XLSX exports: Depending on your HubSpot export settings, Cumulative time in [Stage] may export as HH:mm:ss text strings or raw seconds/minutes. If you get text, convert it to seconds with a calculated field before taking the median.