Now I have all the data I need. Let me compile the comprehensive analysis. Let me consolidate all unique deals from both queries and categorize them by year and outcome.
Let me now carefully merge both result sets (deduplicating by entity_id) and compile the analysis.
All unique deals with Crewline as competitor (from either closed_lost_competitor_name or competitor_company):
I'll categorize by close_date year, treating "this year" as 2026 and "last year" as 2025. I'll also note any deals still open or with close dates after today (2026-09-22).
Let me organize this systematically:
Crewline Competitor Analysis: Win Rate – 2025 vs. 2026 (YTD)
Summary
I combined all deals where Crewline appeared in either the competitor_company or closed_lost_competitor_name fields, deduplicated them, and categorized by close date year.
2025 (Last Year) — Closed Deals
| Metric | Value |
|---|---|
| Total Closed Deals | 41 |
| Won | 13 |
| Lost | 28 |
| Win Rate | 31.7% |
| Won Amount | $262,191 |
| Lost Amount | $755,554 |
| Total Closed Amount | $1,017,745 |
Deals Won in 2025 (13)
| Deal | Amount | Owner | Close Date |
|---|---|---|---|
| Cinderbrook Point Group - Dalecrest Point Group | $49,740 | Logan Ingram | Apr 1 |
| Evermere Point Group - New Deal | $32,520 | — | Mar 5 |
| Foxhaven Point Group - New Deal | $1,452 | Logan Ingram | Mar 28 |
| Greenwick Point Group - Northwillow Point Solutions | $6,660 | Adrian Jessop | Jun 30 |
| Hawthorn Point Group - Ironmere Park Group fbA | $16,038 | — | Aug 6 |
| Ironmere Point Group - New Deal | $11,160 | Bailey Jessop | Aug 30 |
| Jadecrest Point Group - Bellhaven Ridge Group fbA | $24,386 | — | Sep 30 |
| Cinderbrook Ridge Group - Dalecrest Ridge Group | $9,776 | Bailey Jessop | Oct 7 |
| Evermere Ridge Group - Foxhaven Ridge Group | $3,600 | Bailey Jessop | Oct 29 |
| Greenwick Ridge Group - Hawthorn Ridge Group fbA | $22,400 | — | Oct 30 |
| Ironmere Ridge Group - Northwillow Point Solutions | $21,360 | Charlie Jessop | Oct 31 |
| Jadecrest Ridge Group - New Deal | $13,950 | Adrian Jessop | Nov 25 |
| Ashmere Grove Group - New Deal | $10,640 | Adrian Jessop | Dec 2 |
Deals Lost in 2025 (28)
Includes deals closed as closedlost, [record ID], and [record ID] (all appear to be closed-lost/disqualified stages). Key losses include:
Bellhaven Grove Group ($150,000) – Logan Ingram
Hazelwick Point Construction ($136,000) – Logan Ingram
Cinderbrook Grove Group ($52,140) – Logan Ingram
Dalecrest Grove Group ($51,138) – Charlie Jessop
Fernwick Heath Group ($150,700) – (no owner)
Evermere Grove Group ($47,150) – (no owner)
Foxhaven Grove Group ($44,800) – Adrian Jessop
2026 (This Year, YTD through Sep 22) — Closed Deals
| Metric | Value |
|---|---|
| Total Closed Deals | 21 |
| Won | 1 |
| Lost | 20 |
| Win Rate | 4.8% |
| Won Amount | $20,275 |
| Lost Amount | $508,893 |
| Total Closed Amount | $529,168 |
Deals Won in 2026 (1)
| Deal | Amount | Owner | Close Date |
|---|---|---|---|
| Greenwick Grove Group - New Deal | $20,275 | Bailey Jessop | Jan 2 |
Deals Lost in 2026 (20)
Major losses include:
Ironmere Grove Group ($100,000) – Adrian Jessop
Fernwick Point Solutions ($75,000) – Adrian Jessop
Jadecrest Grove Group ($69,430) – Charlie Jessop
Ashmere Bay Group ($58,060) – Adrian Jessop
Bellhaven Bay Group ($35,000) – Bailey Jessop
Cinderbrook Bay Group ($34,560) – Drew Jessop
Dalecrest Bay Group ($29,188) – Eden Jessop
1 Deal Still Open in 2026
| Deal | Amount | Owner | Close Date | Stage |
|---|---|---|---|---|
| Evermere Bay Group - New Deal | $26,140 | Frankie Jessop | Sep 30 | Decision Maker Bought In |
(Close date is Sep 30, 2026 — still in the future, so this deal is not yet resolved.)
Year-over-Year Comparison
| Metric | 2025 | 2026 (YTD) | Change |
|---|---|---|---|
| Total Closed Deals | 41 | 21 | — |
| Wins | 13 | 1 | ▼ 92% fewer |
| Losses | 28 | 20 | — |
| Win Rate | 31.7% | 4.8% | ▼ 26.9 pp |
| Won Revenue | $262,191 | $20,275 | ▼ 92% |
| Lost Revenue | $755,554 | $508,893 | — |
| Avg Deal Size (Won) | $20,169 | $20,275 | Flat |
| Avg Deal Size (Lost) | $26,984 | $25,445 | Flat |
Key Observations
Win rate against Crewline has plummeted — from 31.7% in 2025 down to just 4.8% in 2026 YTD. This is a dramatic decline.
Volume is also down — Only 21 Crewline-competitive deals have closed in 2026 vs. 41 in all of 2025, though the year isn't over yet.
Only one win all year — Hawthorn Grove Group closed on Jan 2, 2026. There have been zero wins against Crewline in the last ~9 months.
One active deal remains — Lindenmere Ridge Construction ($26,140) is at "Decision Maker Bought In" stage with a Sep 30 close date. Conversations show this may actually be a prospect that left Crewline and is coming to Beamline Workforce (based on Jordan Ellis's email today about Lindenmere Ridge Construction switching due to Crewline's failed implementation).
Conversation insights suggest Crewline weaknesses exist but aren't being capitalized on:
Crewline has implementation and customer success failures (Lindenmere Ridge Construction case, Kestrelwood Ridge Services still in implementation nightmare)
Prospects are coming back after bad Crewline experiences (Casey Ellis's Slack: "this was a deal lost to Crewline and they came back because they hated Crewline")
Crewline's pricing is roughly $22/user/month for Payroll/HR/Benefits + $2 for Expense Management
Adrian Jessop acknowledged Beamline Workforce needs CC reimbursements and better mobile/expense management to compete
Top reps losing to Crewline in 2026: Charlie Jessop (4 losses), Adrian Jessop (3 losses), Drew Jessop (2 losses), Bailey Jessop (2 losses)
⚠️ Caveats
2026 is only ~9 months in, so the comparison is partial-year vs. full-year. Even accounting for that, the trajectory is concerning.
The competitor_company field captures deals where Crewline was a known competitor during the sales process, while closed_lost_competitor_name specifically tags the competitor for closed-lost deals. I included both to give the fullest picture.
I also excluded 2024 deals from the analysis (there were ~10 with Crewline) since you asked for this year vs. last year.
Would you like me to dig deeper into any particular angle — such as by rep, by pipeline/channel, by deal size, or look at conversation patterns for what's driving the losses?