2026 YTD Overview Jan – Apr 2026
Total Leads
32,203
By lead created date
SQLs
815
Counts as SQL = 1
Opportunities
401
Opp Counts as Opp = 1
Closed Won
206
Stage = Closed Won
Lead Conv. Rate
3.6%
SQLs ÷ eligible leads (22,753)
Opp Conv. Rate
44.2%
Closed Won ÷ eligible opps (466)
Sales & Marketing Alignment Notes
Data Definitions
- Lead Any lead received in Salesforce.
- MQL Any lead that passes the lead scoring and lead grading threshold rating to be passed through to an inside sales rep, meaning it meets a preliminary qualification. Lead grading is yet to be implemented. Lead scoring began 5/7.
- SQL Any lead that converts to an opportunity.
- OPP Any opportunity that reaches Proposal status or greater — Negotiation, Application Submitted, Boarding, or Closed Won.
- Closed Won Any opportunity that reaches the Closed Won stage.
Reminders & Known Data Caveats
- Some leads still come through without Original Lead Source Detail and/or Campaign information. We are using other available field information to fill in the gaps when that happens, but RevOps is partnering with marketing to ensure consistency moving forward.
- SQL count is likely underrepresented by 10–15% with 5 inside reps still not converting leads to opportunities as trained.
- OPP count is likely underrepresented by 10–15% due to 3–5 inside reps not converting leads at the right time and not using opportunity stages as trained. RevOps was able to back into opp numbers by exporting all field tracking data for a better capture rate.
- Paid lists and large list uploads will be removed from MQL count (per Yoshie and team, 5/6).
- The current lead scoring model is set at 15, which is acknowledged as a low threshold (recommended over time: 50, per marketing). Without grading in place, a lower score was necessary while we slowly ramp up and evaluate what is and isn't working.
- Test leads, test opportunities, field sales pilot user leads, and Kyle Harding CPA leads have been removed from the data set.
Funnel by Month Two views: all-by-created-date and mixed date basis
View 1 — All Metrics by Lead Created Date
Every number in this view is counted by the date the lead was created. Use this to understand what came into the top of the funnel each month.
By Lead Created Date
| Month | Leads Created | SQLs Created | Opps Created | Closed Won Created |
|---|
View 2 — Blended Date Basis (Mixed)
Leads are counted by lead created date · SQLs and Opps are counted by converted date · Closed Won is counted by close date. Use this to see what actually happened in the pipeline each month.
| Month ▶ click to expand by source | Leads Created | SQLs Converted | Opps Converted | Closed Won Close Date |
|---|
View 3 — Blended Date Basis by Lead Source (Mixed)
Same blended date basis as View 2 — totals per lead source, click any row to see the month-by-month breakdown.
| Lead Source ▶ click to expand by month | Leads Created | SQLs Converted | Opps Converted | Closed Won Close Date |
|---|
Lead Volume by Month & Source Leads counted by lead created date · click legend items to show/hide sources
Facebook and Paid List dominate volume — use the log scale toggle to reveal trends in smaller sources, or click any legend label to hide/show individual lines.
Y-axis:
Funnel by Lead Source Detail Leads → SQL → Opp → Closed Won with conversion rates · all by Lead Created Date
| Lead Source Detail | Leads | SQLs | Opps | Closed Won | Lead Conv. Rate | Opp Conv. Rate |
|---|
SQLs & Opps by Converted Date Activity counted by when the lead was converted, not when it was created
How to read this section: The "Funnel by Month" above counts everything by lead created date. This section counts SQLs and Opps by their converted date — showing when activity actually happened in the sales pipeline, regardless of when the original lead came in.
SQLs by Converted Date
| Month | SQLs |
|---|
Opps by Converted Date
| Month | Opps |
|---|
Created Date vs Converted Date — Side-by-Side
Conversion Rates by Month By Lead Created Date
Lead Conv. Rate — SQLs ÷ eligible leads
Opp Conv. Rate — Closed Won ÷ eligible opps
Turnaround Time (TAT) by Lead Source Closed Won + Closed Lost only · days
Overall TAT = Close Date − Lead Created Date ·
Opp TAT = Close Date − Opportunity Created Date
Average TAT by Lead Source (days)
| Lead Source Detail | Records | Overall TAT (days) | Opp TAT (days) | ||||
|---|---|---|---|---|---|---|---|
| Avg | Median | Range | Avg | Median | Range | ||
Lead Disqualification Reasons
By Month
| Month | Total | No Reply | Not Interested | Bad Data | Others |
|---|
By Lead Source Detail
| Lead Source Detail | Total | No Reply | Not Interested | Bad Data | Temp Lead | Do Not Contact | Non-Sales | Long-Term F/U | Duplicate | Prohibited | Fraud |
|---|
Closed Lost Reasons Stage = Closed Lost · 260 total opportunities
Overall
| Reason | Count |
|---|
By Lead Source Detail
| Lead Source Detail | Total | No Reply | Not Interested | Lost to Competitor | Pricing | Long-Term F/U | No Docs | Fraud | No Reason | Other |
|---|
Top 10 Key Takeaways Jan – Apr 2026 · Data-driven highlights
01
Internal Referral drives the vast majority of Closed Won
Internal Referral accounts for just 1.3% of total leads (413 of 32,203) but produces 150 of 206 Closed Won deals — 73% of all revenue. Its lead-to-SQL rate is 73.4% vs. 3.6% overall, and its opp-to-win rate is 78.1% vs. 44.2% overall. This is the highest-quality source by a wide margin.
02
Facebook & Paid List generate 67% of leads but almost no pipeline
Together, Facebook (12,457) and Paid List (9,018) make up 67% of all leads yet produce only 127 SQLs (15.6% of total), zero closed won deals from Paid List, and only 2 from Facebook. Paid List's lead conversion rate is 0.1% — these leads are unlikely to justify their cost without significant qualification changes.
03
Pipeline is accelerating fast when measured by close date
Closed Won by close date shows a near-doubling trend: Jan: 14 → Feb: 34 → Mar: 60 → Apr: 98. This is a much more optimistic growth picture than the created-date view (Jan: 26, Feb: 53, Mar: 68, Apr: 59), which plateaus. The close-date view reflects real revenue recognition and points to strong momentum heading into Q2.
04
April converted activity reveals a significant pipeline lag
SQLs by converted date jumped 168% from March to April (158 → 424), and Opps jumped 118% (98 → 214) — while lead volume only grew 4% (10,404 → 10,825). This confirms a 1–3 month lag between lead creation and conversion. April's conversion activity is largely attributable to leads that entered the funnel in February and March.
05
Opp conversion rate is trending strongly upward
The opportunity-to-close rate has improved every single month: Jan 29.2% → Feb 35.8% → Mar 51.5% → Apr 60.2%. This suggests the sales team is getting better at qualifying opportunities, or that the mix of opportunities is shifting toward higher-intent sources. Either way, the direction is a strong positive signal.
06
No Reply is the #1 reason leads AND opps are lost
No Reply accounts for 45% of all disqualified leads (9,890 of 21,949) and is also the top closed lost reason at 34% (88 of 260 lost opps). The problem persists all the way through the funnel — from initial outreach to late-stage deals. This points to a systemic follow-up or contact cadence issue, especially for Facebook and Paid List sources.
07
Internal Referral closes 4× faster than Facebook
Internal Referral has an average Overall TAT of 12 days and Opp TAT of 9 days. Facebook averages 49 days overall and 43 days for the opp stage. Apollo is the slowest at 65.5 days. Faster cycles from higher-quality sources mean less sales effort per dollar of revenue — another argument for investing in referral channel growth.
08
Google and Lead Aggregator are the most productive paid channels
Among paid/inbound sources, Google converts at 3.6% lead-to-SQL and 33.3% opp-to-win, producing 24 Closed Won deals. Lead Aggregator converts at 15.2% lead-to-SQL (the highest of any non-referral source) with 4 Closed Won. Both have TATs under 30 days avg. In contrast, Apollo's 0.2% conversion rate and 65-day TAT suggest a poor fit for the current strategy.
09
Prior Customer & Upsell channels show strong conversion but limited scale
Prior Customer converts at 28.4% lead-to-SQL (Upsell) and 50% opp-to-win (Upsell), indicating high intent. Upsell has the fastest TAT outside Internal Referral at 8.8 days avg. However, these sources are volume-constrained (473 and 413 leads respectively). Growing the existing customer base for upsell/cross-sell represents a high-efficiency opportunity if lead volume can be increased.
10
March disqualifications spiked — driven by Temp Lead data entry
Total disqualifications jumped from 5,253 in February to 8,811 in March (+68%). The primary driver was 1,419 "Temp Lead for New Hire" entries, nearly all from Prior Customer — a data quality issue, not a market signal. Stripping out Temp Lead entries, the underlying disqualification volume was roughly consistent with prior months. This category should be excluded from headline disq metrics going forward.