What Is Lead Velocity Rate?
Lead velocity rate is a forward-looking growth metric that measures the month-over-month percentage growth in qualified leads entering the pipeline, giving revenue teams a leading indicator of future ARR before bookings are recognized. Most teams track it from a CRM export that requires cleanup to isolate qualified leads by period without double-counting leads that change stages.
See the exact formula, which CRM columns to use, and how to handle stage changes that would otherwise inflate or deflate the monthly count.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountWhat this export contains
| lead_id |
| created_date |
| qualified_date |
| lead_stage |
| source |
| owner_email |
| mql_date |
| sql_date |
| deal_value |
| period_month |
What usually goes wrong with it
Qualified date vs created date ambiguity
CRM exports include both created_date and qualified_date — using the wrong date column shifts the entire lead count to an incorrect period, overstating or understating velocity.
DataMimi Datamimi identifies the correct qualification date field by comparing mql_date and qualified_date columns and flagging which is non-null across the dataset.
Stage definitions change over time
When the lead_stage taxonomy is updated mid-year (e.g., 'Marketing Qualified' renamed to 'MQL'), historical exports show different stage labels for the same qualification event.
DataMimi It normalizes lead_stage labels using a mapping table so renamed stages match their historical equivalents before period counts are calculated.
Leads counted multiple times across periods
A lead that moves from MQL to SQL and back to MQL within the same period can appear in multiple period buckets depending on how the export is filtered.
DataMimi It deduplicates leads by lead_id within each period_month so a lead that changes stages multiple times counts only once per period.
Common questions
What is lead velocity rate?
Lead velocity rate (LVR) is the month-over-month percentage change in qualified leads, calculated as (current month qualified leads − prior month qualified leads) divided by prior month qualified leads.
Why is lead velocity rate a leading indicator?
Because qualified leads convert to revenue with a predictable lag — tracking the month-over-month change in leads tells you whether next quarter's pipeline is growing before bookings are recognized.
What is a good lead velocity rate benchmark?
A positive LVR in line with your revenue growth target is the benchmark; a company targeting 30% ARR growth needs at least 30% LVR to maintain pipeline coverage assuming conversion rates hold.
How do I track lead velocity rate in a spreadsheet?
Create a monthly summary table with qualified lead counts per period_month, then calculate the percentage change month-over-month using a simple formula across the count column.
How much does Datamimi cost?
Datamimi offers a Free plan at $0/month (40 credits, no credit card required), Lite at $9/month (400 credits), Starter at $24/month (1,500 credits, up to 3 simultaneous files), Pro at $59/month (5,000 credits with rollover), and Team at $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