Complete pipeline analysis from STJ Medical CRM exports — Prospects & Patients
Prospect Market Share — Post Mar 11
Patient Market Share — Post Mar 11
| Week | Us Prosp | Helix Prosp | Us Share | Us Patients | Helix Patients | Us HMO | Helix HMO |
|---|---|---|---|---|---|---|---|
| Mar 11–17 | 50 | 99 | 34% | 2 | 1 | 8 | 30 |
| Mar 18–24 | 84 | 116 | 42% | 1 | 3 | 23 | 30 |
| Mar 25–31 | 71 | 101 | 41% | 8 | 8 | 23 | 24 |
| Apr 1–7 | 98 | 137 | 42% | 4 | 9 | 17 | 26 |
| Apr 8–14 | 189 | 159 | 54% | 2 | 8 | 37 | 31 |
| Apr 15–21 | 254 | 222 | 53% | 1 | 4 | 52 | 50 |
| Apr 22–28 | 175 | 222 | 44% | 2 | 17 | 23 | 50 |
April Prospect Share — Nearly Equal
April Patient Share — Helix Dominates 4:1
| Stage | Count | % |
|---|---|---|
| Bad (Non-Insulin) | 250 | 34.9% |
| Private (HMO) | 129 | 18.0% |
| Bad (Ineligible State) | 94 | 13.1% |
| Duplicate Prospect | 44 | 6.1% |
| High CoPay/High DED | 35 | 4.9% |
| BAD INSURANCE | 27 | 3.8% |
| Insurance ID Correction | 27 | 3.8% |
| TEST | 25 | 3.5% |
| In Chase | 24 | 3.4% |
| Other stages | 61 | 8.5% |
| TOTAL WASTE | 388 | 54.2% |
| Stage | Count | % |
|---|---|---|
| Bad (Non-Insulin) | 264 | 35.7% |
| Private (HMO) | 157 | 21.2% |
| Duplicate Prospect | 106 | 14.3% |
| High CoPay/High DED | 50 | 6.8% |
| In Chase | 47 | 6.4% |
| SOS (K CODE) | 21 | 2.8% |
| Bad (Denied by Patient) | 16 | 2.2% |
| NEED MD | 12 | 1.6% |
| Bad (Ineligible State) | 11 | 1.5% |
| Other stages | 56 | 7.5% |
| TOTAL WASTE | 381 | 51.5% |
| Month | Total Prospects | Non-Insulin | Rate |
|---|---|---|---|
| Sep 2025 | 12 | 2 | 16.7% |
| Oct 2025 | 255 | 42 | 16.5% |
| Nov 2025 | 640 | 31 | 4.8% |
| Dec 2025 | 515 | 26 | 5.0% |
| Jan 2026 | 864 | 48 | 5.6% |
| Feb 2026 | 339 | 15 | 4.4% |
| Mar 2026 | 255 | 5 | 2.0% |
| Apr 2026 | 716 | 250 | 34.9% |
| Stage | Count |
|---|---|
| Insurance ID Correction | 206 |
| In Chase | 29 |
| SOS (K CODE) | 18 |
| Alicia's Pending | 7 |
| NEED MD | 7 |
| SOS Verification (WC) | 6 |
| Final Verification | 4 |
| Pre-Authorization + Other | 4 |
| Stage | Count |
|---|---|
| Insurance ID Correction | 54 |
| In Chase | 49 |
| SOS (K CODE) | 38 |
| NEED MD | 12 |
| New Prospect | 5 |
| SOS Verification (WC) | 5 |
| Alicia's Pending | 4 |
| Final Verification + Other | 7 |
| Channel | Prospects | % of Total |
|---|---|---|
| Google Ads (GA - MM) | 867 | 94.1% |
| STJ Website | 26 | 2.8% |
| Facebook (FB - MM) | 18 | 2.0% |
| Bing | 7 | 0.8% |
| Other | 3 | 0.3% |
| Payer | Count | % |
|---|---|---|
| Medicare | 11 | 55% |
| Humana | 5 | 25% |
| Aetna | 3 | 15% |
| United Healthcare | 1 | 5% |
| Payer | Count | % |
|---|---|---|
| Medicare | 33 | 66% |
| Humana | 7 | 14% |
| United Healthcare | 4 | 8% |
| Aetna | 1 | 2% |
| Other (5 payers) | 5 | 10% |
| Month | Us Prosp | Helix Prosp | Us Patients | Helix Patients | Us HMO | Helix HMO | Us Non-Ins % |
|---|---|---|---|---|---|---|---|
| Sep 2025 | 12 | 0 | 1 | 0 | 1 | 0 | 16.7% |
| Oct 2025 | 255 | 0 | 3 | 0 | 54 | 0 | 16.5% |
| Nov 2025 | 640 | 357 | 13 | 2 | 145 | 62 | 4.8% |
| Dec 2025 | 515 | 394 | 36 | 8 | 94 | 78 | 5.0% |
| Jan 2026 | 864 | 0 | 53 | 9 | 156 | 0 | 5.6% |
| Feb 2026 | 339 | 0 | 23 | 0 | 63 | 0 | 4.4% |
| Mar 2026 | 255 | 318 | 18 | 12 | 63 | 84 | 2.0% |
| Apr 2026 | 716 | 740 | 9 | 38 | 129 | 157 | 34.9% |