Required Datapoints
- Date of MQL Status Change
- Date of Opportunity Created
- CRM / Lead Object Tracking
Opportunity Creation Velocity (from MQL) measures the average time it takes for a marketing-qualified lead (MQL) to convert into a sales opportunity. It helps track lead progression speed and sales-readiness alignment.
Opportunity Creation Velocity is a key indicator of pipeline acceleration and lead handoff efficiency, reflecting how quickly MQLs convert into sales-qualified opportunities after initial marketing engagement.
The relevance and interpretation of this metric shift depending on the model or product:
A faster velocity indicates strong sales/marketing alignment and timely follow-up. A slower trend often uncovers weak MQL scoring, response delays, or unclear buyer intent.
By segmenting by cohort — such as channel, persona, industry, or content source — you surface opportunities to prioritize high-intent leads, adjust SLAs, or refine outreach triggers.
Opportunity Creation Velocity informs:
These are the main factors that directly impact the metric. Understanding these lets you know what levers you can pull to improve the outcome
Actionable ideas to optimize this KPI, from fast, low-effort wins to strategic initiatives that drive measurable impact.
Activities commonly tied to improving or operationalizing this KPI.
| Activity | Description |
|---|---|
| Lead Handoff | Lead Handoff focuses on a structured process for transferring ownership of a qualified lead or prospect from one team—such as Marketing, Product, or Sales Development—to another, including Sales, Account Executives, or Customer Success. It helps teams translate strategy into repeatable execution. Relevant KPIs include Opportunity Creation Velocity (from MQL) and Time to First Meeting. |
| SDR Workflows | SDR Workflows involves a structured set of processes and best practices that Sales Development Representatives (SDRs) use to engage, nurture, and qualify prospects in alignment with a company’s Go-To-Market (GTM) strategy. It coordinates execution across touchpoints so teams can move users or accounts toward the target outcome. Relevant KPIs include Opportunity Creation Velocity (from MQL). |
| Opportunity Management | Opportunity Management is a structured approach to moving potential customer engagements through key stages of the sales or customer journey pipeline. It makes the motion operational through ownership, routines, and cross-functional follow-through. Relevant KPIs include Opportunity Creation Velocity (from MQL). |
| Sales Process Optimization | Sales Process Optimization focuses on the strategic and ongoing enhancement of sales processes to boost efficiency, effectiveness, and alignment with an organization’s go-to-market approach. It improves performance by removing friction, testing changes, and scaling what works. Relevant KPIs include Average Sales Cycle Length and Opportunity Creation Velocity (from MQL). |
Avg. time from MQL to Opportunity: 5.4 days
This KPI is associated with the following stages in the AAARRR (Pirate Metrics) funnel:
This KPI is classified as a lagging Indicator. It reflects the results of past actions or behaviors and is used to validate performance or assess the impact of previous strategies.
This role is directly accountable for the KPI and is expected to drive progress and decisions around it.
These roles contribute directly to performance and typically partner on execution, reporting, or optimization.
These leading indicators influence this KPI and act as early signals that forecast future changes in this KPI.
These lagging indicators confirm, quantify, or amplify this KPI and help explain the broader business impact on this KPI after the fact.
How this KPI is structured in Cube.js, including its key measures, dimensions, and calculation logic for consistent reporting.
cube('LeadConversion', { sql: `SELECT * FROM lead_conversion`,
joins: { Opportunity: { relationship: 'hasOne', sql: `${CUBE}.lead_id = ${Opportunity}.lead_id` } },
measures: { opportunityCreationVelocity: { sql: `DATEDIFF(day, ${CUBE}.mql_status_change_date, ${Opportunity}.opportunity_created_date)`, type: 'avg', title: 'Opportunity Creation Velocity (from MQL)', description: 'Average time in days for an MQL to convert into a sales opportunity.' } },
dimensions: { leadId: { sql: `lead_id`, type: 'string', primaryKey: true },
mqlStatusChangeDate: { sql: `mql_status_change_date`, type: 'time', title: 'Date of MQL Status Change' } }})cube('Opportunity', { sql: `SELECT * FROM opportunity`,
dimensions: { leadId: { sql: `lead_id`, type: 'string', primaryKey: true },
opportunityCreatedDate: { sql: `opportunity_created_date`, type: 'time', title: 'Date of Opportunity Created' } }})Note: This is a reference implementation and should be used as a starting point. You’ll need to adapt it to match your own data model and schema