What Is Deal Velocity?

Deal velocity is a sales pipeline metric that measures how fast opportunities move through the funnel — typically expressed as the number of days from opportunity creation to closed-won. A declining trend signals that deals are stalling at a specific stage, that deal size has shifted upward, or that a qualification change is adding complexity.

Upload your CRM opportunity export to Datamimi and get deal velocity by stage, rep, and deal size in one session.

What this export contains

Opportunity ID
Stage
Created Date
Close Date
Days in Stage
Deal Amount
Sales Rep
Product Line

What usually goes wrong with it

  • Days-to-close calculation requires both Created Date and Close Date

    Many CRM exports provide Stage entry and exit dates separately — computing total close time requires summing Days in Stage across all stages for each opportunity.

    DataMimi Datamimi computes total close time by summing Days in Stage across all stages for each Opportunity ID, even when stage dates are stored separately.

  • Won and lost deals must be separated for meaningful benchmarks

    Including lost opportunities in average close-time calculations inflates the figure — velocity benchmarks should be computed on closed-won deals only.

    DataMimi It filters the velocity calculation to closed-won opportunities only, with a separate output for lost-deal stage distribution.

  • Deal size skews the average significantly

    Enterprise deals in the $100K+ range take 4-6x longer than SMB deals — averaging across all deal sizes produces a benchmark that is meaningless for either segment.

    DataMimi It segments the calculation by Deal Amount range automatically, producing separate benchmarks for SMB, mid-market, and enterprise tiers.

Common questions

What is deal velocity and how is it different from sales cycle length?

Deal velocity measures how fast individual opportunities move through the pipeline, typically in days from creation to close. Sales cycle length is the average of that figure across all closed-won deals in a period. They measure the same underlying thing — velocity is the per-deal view, cycle length is the aggregate.

What is a good deal velocity benchmark for B2B SaaS?

SMB deals under $10K ACV typically close in 14-30 days. Mid-market deals ($10K-$100K ACV) typically close in 30-90 days. Enterprise deals above $100K ACV often take 90-180 days or more. These benchmarks vary significantly by sales motion and product complexity.

How do I track deal velocity in a spreadsheet?

Add a Days to Close column: =Close_Date - Created_Date. Average this column filtered to Stage = 'Closed Won' for your benchmark. Segment by Deal Amount range using AVERAGEIFS to separate SMB from enterprise. Monitor the trend monthly — a rising average signals pipeline health problems.

What does Datamimi cost?

Free plan: $0/month, 40 credits, no credit card required. Lite: $9/month, 400 credits. Starter: $24/month, 1,500 credits, up to 3 simultaneous files. Pro: $59/month, 5,000 credits with rollover. Team: $199/month, 20,000 credits, 5 users.

Try it with your own file

DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.

Ask about your file

More in AI spreadsheet analysis