Yesterday closed at 102 enrollments ($2.32M enrolled debt) vs the trailing 20-day average +12.8%. Month-to-date enrolled debt stands at $35.47M against a $46.00M goal. Largest day-over-day mover: Paid Social.
As-of windows: D0 = Fri Jul 24 · D0-1 = last 2 workdays · D0-4 = last 5 workdays
| Metric | Value | 20-day avg | vs avg | Last week | vs LW |
|---|---|---|---|---|---|
| Leads | 2,111 | 2,165 | -2.5% | 1,986 | +6.3% |
| Contact rate | 54.5% | 55.0% | -0.5pp | 53.9% | +0.6pp |
| Qualified rate | 44.8% | 40.9% | +3.9pp | 40.6% | +4.2pp |
| Enrollments | 102 | 90 | +12.8% | 101 | +1.0% |
| Enrolled debt | $2,321,224 | $2,026,327 | +14.6% | $2,310,829 | +0.4% |
| Metric | Value | 20-day avg | vs avg | Last week | vs LW |
|---|---|---|---|---|---|
| Leads | 4,219 | 4,330 | -2.6% | 4,160 | +1.4% |
| Contact rate | 54.7% | 55.0% | -0.3pp | 55.0% | -0.4pp |
| Qualified rate | 44.3% | 40.8% | +3.5pp | 40.1% | +4.2pp |
| Enrollments | 198 | 181 | +9.3% | 200 | -1.0% |
| Enrolled debt | $4,459,666 | $4,057,457 | +9.9% | $4,547,361 | -1.9% |
| Metric | Value | 20-day avg | vs avg | Last week | vs LW |
|---|---|---|---|---|---|
| Leads | 10,908 | 10,845 | +0.6% | 10,787 | +1.1% |
| Contact rate | 54.3% | 55.0% | -0.8pp | 55.3% | -1.0pp |
| Qualified rate | 42.0% | 40.8% | +1.2pp | 39.9% | +2.0pp |
| Enrollments | 491 | 454 | +8.0% | 474 | +3.6% |
| Enrolled debt | $11,105,765 | $10,159,054 | +9.3% | $10,636,081 | +4.4% |
| Metric | Today | Mean | Std dev | Z |
|---|---|---|---|---|
| Leads | 2,111 | 2,165 | 89 | -0.6 |
| Enrollments | 102 | 90 | 12 | +0.9 |
| Enrolled debt | $2,321,224 | $2,026,327 | $312,130 | +0.9 |
| Contact rate | 54.5% | 55.0% | 1.4% | -0.4 |
| Enroll rate | 19.8% | 18.6% | 2.5% | +0.5 |
| Metric | This wk | Last wk | WoW |
|---|---|---|---|
| Leads | 10,908 | 10,787 | +1.1% |
| Qualified | 2,487 | 2,383 | +4.4% |
| Enrollments | 491 | 474 | +3.6% |
| Enrolled debt | $11,105,765 | $10,636,081 | +4.4% |
Source extract freshness
2026-07-24 06:05 ET
2026-07-24 06:05 ET
Fact rows loaded
560 (expected 560)
560 (expected 560)
Report totals vs source extract
variance 0.00%
variance 0.00%
Workday calendar
80 business days; 3 holidays excluded
80 business days; 3 holidays excluded
Duplicate lead keys
0 found
0 found
Daily rateMean±2σ limits
How to read this: the daily rate wanders around its mean (18.7%); only points beyond the dashed ±2σ limits deserve a meeting. Latest point (19.8%) is inside the limits.
Tier 1Tier 2Tier 3Tier 4
| Date | Tier 1 | Tier 2 | Tier 3 | Tier 4 | Total |
|---|---|---|---|---|---|
| Thu 06/25 | 90.1% | 81.9% | 75.8% | 63.7% | 77.9% |
| Fri 06/26 | 74.2% | 75.9% | 69.3% | 61.7% | 70.3% |
| Mon 06/29 | 80.2% | 76.5% | 68.5% | 61.6% | 71.7% |
| Tue 06/30 | 78.2% | 73.4% | 66.8% | 65.2% | 70.9% |
| Wed 07/01 | 86.3% | 73.9% | 74.2% | 63.9% | 74.6% |
| Thu 07/02 | 88.0% | 72.3% | 75.5% | 64.1% | 75.0% |
| Mon 07/06 | 84.9% | 75.4% | 73.8% | 71.0% | 76.2% |
| Tue 07/07 | 85.2% | 73.7% | 70.1% | 61.2% | 72.5% |
| Wed 07/08 | 84.7% | 79.9% | 72.4% | 70.9% | 77.0% |
| Thu 07/09 | 83.7% | 74.7% | 72.6% | 64.7% | 73.9% |
| Fri 07/10 | 83.7% | 80.8% | 71.0% | 71.8% | 76.8% |
| Mon 07/13 | 85.6% | 84.9% | 76.7% | 68.1% | 78.8% |
| Tue 07/14 | 85.1% | 73.9% | 77.3% | 74.8% | 77.8% |
| Wed 07/15 | 82.7% | 80.3% | 70.6% | 67.8% | 75.3% |
| Thu 07/16 | 74.9% | 79.4% | 76.0% | 60.0% | 72.6% |
| Fri 07/17 | 79.4% | 76.6% | 70.8% | 63.3% | 72.5% |
| Mon 07/20 | 79.4% | 76.6% | 76.1% | 67.1% | 74.8% |
| Tue 07/21 | 81.5% | 80.6% | 67.5% | 67.0% | 74.1% |
| Wed 07/22 | 76.5% | 74.4% | 68.6% | 69.2% | 72.2% |
| Thu 07/23 | 84.9% | 77.7% | 77.0% | 62.4% | 75.5% |
| Fri 07/24 | 81.1% | 76.4% | 70.0% | 64.9% | 73.1% |
| May baseline | 80.0% | 77.2% | 71.0% | 65.5% | 73.4% |
| June baseline | 82.3% | 77.4% | 72.2% | 65.3% | 74.3% |
| July baseline | 82.8% | 77.2% | 73.0% | 66.6% | 74.9% |
| Date | Tier 1 | Tier 2 | Tier 3 | Tier 4 | Total |
|---|---|---|---|---|---|
| Thu 06/25 | 73.4% | 66.7% | 61.8% | 51.9% | 63.5% |
| Fri 06/26 | 60.5% | 61.8% | 56.5% | 50.3% | 57.3% |
| Mon 06/29 | 65.4% | 62.3% | 55.8% | 50.2% | 58.4% |
| Tue 06/30 | 63.7% | 59.8% | 54.4% | 53.1% | 57.8% |
| Wed 07/01 | 70.3% | 60.2% | 60.5% | 52.1% | 60.8% |
| Thu 07/02 | 71.7% | 58.9% | 61.5% | 52.2% | 61.1% |
| Mon 07/06 | 69.1% | 61.4% | 60.1% | 57.8% | 62.1% |
| Tue 07/07 | 69.4% | 60.1% | 57.1% | 49.9% | 59.1% |
| Wed 07/08 | 69.0% | 65.1% | 59.0% | 57.8% | 62.7% |
| Thu 07/09 | 68.2% | 60.8% | 59.2% | 52.7% | 60.2% |
| Fri 07/10 | 68.2% | 65.9% | 57.8% | 58.5% | 62.6% |
| Mon 07/13 | 69.7% | 69.2% | 62.5% | 55.5% | 64.2% |
| Tue 07/14 | 69.3% | 60.2% | 63.0% | 60.9% | 63.4% |
| Wed 07/15 | 67.4% | 65.4% | 57.5% | 55.3% | 61.4% |
| Thu 07/16 | 61.0% | 64.7% | 62.0% | 48.9% | 59.1% |
| Fri 07/17 | 64.7% | 62.4% | 57.7% | 51.5% | 59.1% |
| Mon 07/20 | 64.7% | 62.4% | 62.0% | 54.6% | 60.9% |
| Tue 07/21 | 66.4% | 65.7% | 55.0% | 54.6% | 60.4% |
| Wed 07/22 | 62.3% | 60.6% | 55.9% | 56.4% | 58.8% |
| Thu 07/23 | 69.2% | 63.3% | 62.7% | 50.9% | 61.5% |
| Fri 07/24 | 66.1% | 62.2% | 57.0% | 52.9% | 59.5% |
| May baseline | 65.2% | 62.9% | 57.9% | 53.3% | 59.8% |
| June baseline | 67.1% | 63.1% | 58.8% | 53.2% | 60.5% |
| July baseline | 67.5% | 62.9% | 59.4% | 54.3% | 61.0% |
| Date | Tier 1 | Tier 2 | Tier 3 | Tier 4 | Total |
|---|---|---|---|---|---|
| Thu 06/25 | 56.7% | 51.6% | 47.7% | 40.1% | 49.0% |
| Fri 06/26 | 46.7% | 47.8% | 43.6% | 38.8% | 44.2% |
| Mon 06/29 | 50.5% | 48.2% | 43.1% | 38.8% | 45.1% |
| Tue 06/30 | 49.2% | 46.2% | 42.1% | 41.0% | 44.6% |
| Wed 07/01 | 54.3% | 46.5% | 46.7% | 40.3% | 47.0% |
| Thu 07/02 | 55.4% | 45.5% | 47.5% | 40.4% | 47.2% |
| Mon 07/06 | 53.4% | 47.5% | 46.5% | 44.7% | 48.0% |
| Tue 07/07 | 53.6% | 46.4% | 44.1% | 38.5% | 45.7% |
| Wed 07/08 | 53.3% | 50.3% | 45.6% | 44.6% | 48.5% |
| Thu 07/09 | 52.7% | 47.0% | 45.7% | 40.7% | 46.5% |
| Fri 07/10 | 52.7% | 50.9% | 44.7% | 45.2% | 48.4% |
| Mon 07/13 | 53.9% | 53.4% | 48.3% | 42.9% | 49.6% |
| Tue 07/14 | 53.6% | 46.5% | 48.7% | 47.1% | 49.0% |
| Wed 07/15 | 52.1% | 50.6% | 44.4% | 42.7% | 47.4% |
| Thu 07/16 | 47.2% | 50.0% | 47.9% | 37.8% | 45.7% |
| Fri 07/17 | 50.0% | 48.3% | 44.6% | 39.8% | 45.7% |
| Mon 07/20 | 50.0% | 48.2% | 47.9% | 42.2% | 47.1% |
| Tue 07/21 | 51.3% | 50.8% | 42.5% | 42.2% | 46.7% |
| Wed 07/22 | 48.1% | 46.9% | 43.2% | 43.6% | 45.4% |
| Thu 07/23 | 53.5% | 48.9% | 48.5% | 39.3% | 47.5% |
| Fri 07/24 | 51.0% | 48.1% | 44.1% | 40.8% | 46.0% |
| May baseline | 50.4% | 48.6% | 44.7% | 41.2% | 46.2% |
| June baseline | 51.8% | 48.8% | 45.5% | 41.1% | 46.8% |
| July baseline | 52.1% | 48.6% | 45.9% | 41.9% | 47.1% |
| Date | Tier 1 | Tier 2 | Tier 3 | Tier 4 | Total |
|---|---|---|---|---|---|
| Thu 06/25 | 40.1% | 36.4% | 33.7% | 28.3% | 34.6% |
| Fri 06/26 | 33.0% | 33.7% | 30.8% | 27.4% | 31.2% |
| Mon 06/29 | 35.7% | 34.0% | 30.4% | 27.4% | 31.9% |
| Tue 06/30 | 34.7% | 32.6% | 29.7% | 29.0% | 31.5% |
| Wed 07/01 | 38.3% | 32.9% | 33.0% | 28.4% | 33.1% |
| Thu 07/02 | 39.1% | 32.1% | 33.5% | 28.5% | 33.3% |
| Mon 07/06 | 37.7% | 33.5% | 32.8% | 31.5% | 33.9% |
| Tue 07/07 | 37.9% | 32.8% | 31.1% | 27.2% | 32.2% |
| Wed 07/08 | 37.6% | 35.5% | 32.2% | 31.5% | 34.2% |
| Thu 07/09 | 37.2% | 33.2% | 32.3% | 28.7% | 32.9% |
| Fri 07/10 | 37.2% | 35.9% | 31.5% | 31.9% | 34.1% |
| Mon 07/13 | 38.0% | 37.7% | 34.1% | 30.3% | 35.0% |
| Tue 07/14 | 37.8% | 32.9% | 34.4% | 33.2% | 34.6% |
| Wed 07/15 | 36.7% | 35.7% | 31.4% | 30.1% | 33.5% |
| Thu 07/16 | 33.3% | 35.3% | 33.8% | 26.7% | 32.3% |
| Fri 07/17 | 35.3% | 34.1% | 31.5% | 28.1% | 32.2% |
| Mon 07/20 | 35.3% | 34.0% | 33.8% | 29.8% | 33.2% |
| Tue 07/21 | 36.2% | 35.8% | 30.0% | 29.8% | 33.0% |
| Wed 07/22 | 34.0% | 33.1% | 30.5% | 30.7% | 32.1% |
| Thu 07/23 | 37.7% | 34.5% | 34.2% | 27.8% | 33.6% |
| Fri 07/24 | 36.0% | 33.9% | 31.1% | 28.8% | 32.5% |
| May baseline | 35.5% | 34.3% | 31.6% | 29.1% | 32.6% |
| June baseline | 36.6% | 34.4% | 32.1% | 29.0% | 33.0% |
| July baseline | 36.8% | 34.3% | 32.4% | 29.6% | 33.3% |
Rates are simple per-cell ratios; cohort tables use an average-of-days convention, so cohort totals can differ from pooled ratios.
Tier 1Tier 2Tier 3Tier 4
| Date | Tier 1 | Tier 2 | Tier 3 | Tier 4 | Total |
|---|---|---|---|---|---|
| Thu 06/25 | 62.7% | 64.9% | 52.5% | 46.0% | 56.5% |
| Fri 06/26 | 68.2% | 60.1% | 49.1% | 39.8% | 54.3% |
| Mon 06/29 | 69.7% | 57.1% | 49.9% | 35.9% | 53.1% |
| Tue 06/30 | 80.7% | 62.6% | 59.0% | 51.6% | 63.5% |
| Wed 07/01 | 68.1% | 63.8% | 49.8% | 37.3% | 54.7% |
| Thu 07/02 | 63.4% | 63.0% | 48.5% | 39.0% | 53.5% |
| Mon 07/06 | 60.8% | 56.4% | 53.7% | 34.0% | 51.2% |
| Tue 07/07 | 56.6% | 62.2% | 46.2% | 36.5% | 50.3% |
| Wed 07/08 | 68.1% | 59.6% | 42.8% | 49.1% | 54.9% |
| Thu 07/09 | 74.0% | 60.6% | 51.0% | 47.0% | 58.1% |
| Fri 07/10 | 66.0% | 61.3% | 57.8% | 42.1% | 56.8% |
| Mon 07/13 | 72.3% | 57.8% | 49.5% | 34.7% | 53.6% |
| Tue 07/14 | 64.6% | 58.4% | 54.3% | 36.4% | 53.4% |
| Wed 07/15 | 66.9% | 57.4% | 50.6% | 40.9% | 54.0% |
| Thu 07/16 | 69.4% | 58.7% | 42.1% | 39.4% | 52.4% |
| Fri 07/17 | 69.8% | 55.8% | 49.2% | 39.5% | 53.6% |
| Mon 07/20 | 69.8% | 62.5% | 49.6% | 35.8% | 54.4% |
| Tue 07/21 | 73.1% | 59.1% | 51.9% | 44.6% | 57.2% |
| Wed 07/22 | 72.3% | 50.3% | 50.0% | 39.5% | 53.0% |
| Thu 07/23 | 69.7% | 69.2% | 57.2% | 50.7% | 61.7% |
| Fri 07/24 | 75.3% | 65.8% | 53.6% | 47.4% | 60.5% |
| May baseline | 65.7% | 57.8% | 49.4% | 38.0% | 52.7% |
| June baseline | 70.2% | 61.3% | 51.3% | 40.3% | 55.7% |
| July baseline | 68.3% | 60.1% | 50.5% | 40.8% | 54.9% |
| Date | Tier 1 | Tier 2 | Tier 3 | Tier 4 | Total |
|---|---|---|---|---|---|
| Thu 06/25 | 51.1% | 52.9% | 42.8% | 37.5% | 46.1% |
| Fri 06/26 | 55.5% | 49.0% | 40.0% | 32.4% | 44.2% |
| Mon 06/29 | 56.8% | 46.5% | 40.6% | 29.2% | 43.3% |
| Tue 06/30 | 65.8% | 51.0% | 48.1% | 42.1% | 51.7% |
| Wed 07/01 | 55.5% | 52.0% | 40.6% | 30.4% | 44.6% |
| Thu 07/02 | 51.6% | 51.3% | 39.5% | 31.8% | 43.6% |
| Mon 07/06 | 49.5% | 45.9% | 43.7% | 27.7% | 41.7% |
| Tue 07/07 | 46.1% | 50.7% | 37.6% | 29.7% | 41.0% |
| Wed 07/08 | 55.5% | 48.5% | 34.9% | 40.0% | 44.7% |
| Thu 07/09 | 60.3% | 49.4% | 41.6% | 38.3% | 47.4% |
| Fri 07/10 | 53.8% | 49.9% | 47.1% | 34.3% | 46.3% |
| Mon 07/13 | 58.9% | 47.1% | 40.3% | 28.3% | 43.6% |
| Tue 07/14 | 52.6% | 47.6% | 44.2% | 29.7% | 43.5% |
| Wed 07/15 | 54.5% | 46.8% | 41.2% | 33.3% | 44.0% |
| Thu 07/16 | 56.5% | 47.9% | 34.3% | 32.1% | 42.7% |
| Fri 07/17 | 56.9% | 45.5% | 40.1% | 32.2% | 43.7% |
| Mon 07/20 | 56.9% | 50.9% | 40.4% | 29.2% | 44.3% |
| Tue 07/21 | 59.6% | 48.2% | 42.3% | 36.3% | 46.6% |
| Wed 07/22 | 58.9% | 41.0% | 40.8% | 32.2% | 43.2% |
| Thu 07/23 | 56.8% | 56.4% | 46.6% | 41.3% | 50.3% |
| Fri 07/24 | 61.4% | 53.6% | 43.7% | 38.6% | 49.3% |
| May baseline | 53.5% | 47.1% | 40.3% | 31.0% | 43.0% |
| June baseline | 57.2% | 49.9% | 41.8% | 32.8% | 45.4% |
| July baseline | 55.6% | 49.0% | 41.1% | 33.3% | 44.7% |
| Date | Tier 1 | Tier 2 | Tier 3 | Tier 4 | Total |
|---|---|---|---|---|---|
| Thu 06/25 | 39.5% | 40.9% | 33.1% | 28.9% | 35.6% |
| Fri 06/26 | 42.9% | 37.9% | 30.9% | 25.0% | 34.2% |
| Mon 06/29 | 43.9% | 35.9% | 31.4% | 22.6% | 33.5% |
| Tue 06/30 | 50.8% | 39.4% | 37.1% | 32.5% | 40.0% |
| Wed 07/01 | 42.9% | 40.2% | 31.3% | 23.5% | 34.5% |
| Thu 07/02 | 39.9% | 39.7% | 30.5% | 24.6% | 33.7% |
| Mon 07/06 | 38.3% | 35.5% | 33.8% | 21.4% | 32.3% |
| Tue 07/07 | 35.6% | 39.1% | 29.1% | 22.9% | 31.7% |
| Wed 07/08 | 42.9% | 37.5% | 27.0% | 30.9% | 34.6% |
| Thu 07/09 | 46.6% | 38.1% | 32.1% | 29.6% | 36.6% |
| Fri 07/10 | 41.6% | 38.6% | 36.4% | 26.5% | 35.8% |
| Mon 07/13 | 45.5% | 36.4% | 31.2% | 21.8% | 33.7% |
| Tue 07/14 | 40.7% | 36.8% | 34.2% | 22.9% | 33.6% |
| Wed 07/15 | 42.1% | 36.2% | 31.9% | 25.7% | 34.0% |
| Thu 07/16 | 43.7% | 37.0% | 26.5% | 24.8% | 33.0% |
| Fri 07/17 | 44.0% | 35.2% | 31.0% | 24.9% | 33.8% |
| Mon 07/20 | 44.0% | 39.3% | 31.2% | 22.5% | 34.3% |
| Tue 07/21 | 46.0% | 37.2% | 32.7% | 28.1% | 36.0% |
| Wed 07/22 | 45.6% | 31.7% | 31.5% | 24.9% | 33.4% |
| Thu 07/23 | 43.9% | 43.6% | 36.0% | 31.9% | 38.9% |
| Fri 07/24 | 47.4% | 41.4% | 33.7% | 29.9% | 38.1% |
| May baseline | 41.3% | 36.4% | 31.1% | 23.9% | 33.2% |
| June baseline | 44.2% | 38.6% | 32.3% | 25.3% | 35.1% |
| July baseline | 43.0% | 37.8% | 31.8% | 25.7% | 34.6% |
| Date | Tier 1 | Tier 2 | Tier 3 | Tier 4 | Total |
|---|---|---|---|---|---|
| Thu 06/25 | 27.9% | 28.9% | 23.4% | 20.4% | 25.1% |
| Fri 06/26 | 30.3% | 26.7% | 21.8% | 17.7% | 24.1% |
| Mon 06/29 | 31.0% | 25.4% | 22.2% | 16.0% | 23.6% |
| Tue 06/30 | 35.9% | 27.8% | 26.2% | 23.0% | 28.2% |
| Wed 07/01 | 30.3% | 28.3% | 22.1% | 16.6% | 24.3% |
| Thu 07/02 | 28.2% | 28.0% | 21.6% | 17.3% | 23.8% |
| Mon 07/06 | 27.0% | 25.1% | 23.9% | 15.1% | 22.8% |
| Tue 07/07 | 25.2% | 27.6% | 20.5% | 16.2% | 22.4% |
| Wed 07/08 | 30.3% | 26.5% | 19.0% | 21.8% | 24.4% |
| Thu 07/09 | 32.9% | 26.9% | 22.7% | 20.9% | 25.8% |
| Fri 07/10 | 29.3% | 27.2% | 25.7% | 18.7% | 25.2% |
| Mon 07/13 | 32.1% | 25.7% | 22.0% | 15.4% | 23.8% |
| Tue 07/14 | 28.7% | 26.0% | 24.1% | 16.2% | 23.7% |
| Wed 07/15 | 29.7% | 25.5% | 22.5% | 18.2% | 24.0% |
| Thu 07/16 | 30.8% | 26.1% | 18.7% | 17.5% | 23.3% |
| Fri 07/17 | 31.0% | 24.8% | 21.9% | 17.6% | 23.8% |
| Mon 07/20 | 31.0% | 27.8% | 22.0% | 15.9% | 24.2% |
| Tue 07/21 | 32.5% | 26.3% | 23.1% | 19.8% | 25.4% |
| Wed 07/22 | 32.2% | 22.4% | 22.2% | 17.6% | 23.6% |
| Thu 07/23 | 31.0% | 30.8% | 25.4% | 22.5% | 27.4% |
| Fri 07/24 | 33.5% | 29.2% | 23.8% | 21.1% | 26.9% |
| May baseline | 29.2% | 25.7% | 22.0% | 16.9% | 23.4% |
| June baseline | 31.2% | 27.2% | 22.8% | 17.9% | 24.8% |
| July baseline | 30.3% | 26.7% | 22.4% | 18.1% | 24.4% |
Rates are simple per-cell ratios; cohort tables use an average-of-days convention, so cohort totals can differ from pooled ratios.
Tier 1Tier 2Tier 3Tier 4
| Date | Tier 1 | Tier 2 | Tier 3 | Tier 4 | Total |
|---|---|---|---|---|---|
| Thu 06/25 | 48.6% | 30.7% | 24.1% | 21.4% | 31.2% |
| Fri 06/26 | 44.6% | 27.3% | 25.9% | 10.2% | 27.0% |
| Mon 06/29 | 48.3% | 30.9% | 27.0% | 5.9% | 28.0% |
| Tue 06/30 | 46.4% | 25.1% | 17.9% | 7.7% | 24.3% |
| Wed 07/01 | 45.0% | 39.8% | 16.3% | 10.4% | 27.9% |
| Thu 07/02 | 28.2% | 37.7% | 19.8% | 7.8% | 23.4% |
| Mon 07/06 | 35.9% | 34.2% | 17.2% | 18.9% | 26.5% |
| Tue 07/07 | 71.7% | 39.3% | 22.7% | 12.5% | 36.6% |
| Wed 07/08 | 41.2% | 33.0% | 24.0% | 11.8% | 27.5% |
| Thu 07/09 | 35.2% | 23.6% | 11.0% | 4.2% | 18.5% |
| Fri 07/10 | 44.2% | 31.4% | 22.2% | 4.0% | 25.5% |
| Mon 07/13 | 50.6% | 30.3% | 11.7% | 14.5% | 26.8% |
| Tue 07/14 | 57.2% | 26.7% | 17.1% | 22.1% | 30.8% |
| Wed 07/15 | 56.7% | 35.9% | 17.4% | 14.3% | 31.1% |
| Thu 07/16 | 54.2% | 33.9% | 25.1% | 8.3% | 30.4% |
| Fri 07/17 | 59.1% | 37.5% | 25.0% | 8.4% | 32.5% |
| Mon 07/20 | 55.8% | 33.6% | 18.3% | 11.1% | 29.7% |
| Tue 07/21 | 58.8% | 36.9% | 17.9% | 12.1% | 31.4% |
| Wed 07/22 | 51.8% | 29.8% | 22.5% | 13.5% | 29.4% |
| Thu 07/23 | 40.7% | 30.0% | 18.2% | 8.3% | 24.3% |
| Fri 07/24 | 57.2% | 35.3% | 20.7% | 10.4% | 30.9% |
| May baseline | 46.5% | 33.9% | 21.4% | 9.9% | 27.9% |
| June baseline | 46.3% | 32.7% | 20.9% | 10.4% | 27.6% |
| July baseline | 49.6% | 33.5% | 19.2% | 11.3% | 28.4% |
| Date | Tier 1 | Tier 2 | Tier 3 | Tier 4 | Total |
|---|---|---|---|---|---|
| Thu 06/25 | 39.6% | 25.0% | 19.7% | 17.5% | 25.4% |
| Fri 06/26 | 36.3% | 22.3% | 21.1% | 8.3% | 22.0% |
| Mon 06/29 | 39.4% | 25.2% | 22.0% | 4.8% | 22.8% |
| Tue 06/30 | 37.8% | 20.4% | 14.6% | 6.3% | 19.8% |
| Wed 07/01 | 36.7% | 32.4% | 13.3% | 8.5% | 22.7% |
| Thu 07/02 | 23.0% | 30.7% | 16.2% | 6.3% | 19.1% |
| Mon 07/06 | 29.3% | 27.8% | 14.0% | 15.4% | 21.6% |
| Tue 07/07 | 58.4% | 32.1% | 18.5% | 10.2% | 29.8% |
| Wed 07/08 | 33.6% | 26.9% | 19.5% | 9.6% | 22.4% |
| Thu 07/09 | 28.7% | 19.2% | 9.0% | 3.4% | 15.1% |
| Fri 07/10 | 36.0% | 25.6% | 18.1% | 3.3% | 20.7% |
| Mon 07/13 | 41.2% | 24.7% | 9.5% | 11.8% | 21.8% |
| Tue 07/14 | 46.6% | 21.7% | 13.9% | 18.0% | 25.1% |
| Wed 07/15 | 46.2% | 29.3% | 14.2% | 11.7% | 25.3% |
| Thu 07/16 | 44.2% | 27.7% | 20.5% | 6.7% | 24.8% |
| Fri 07/17 | 48.2% | 30.6% | 20.4% | 6.9% | 26.5% |
| Mon 07/20 | 45.5% | 27.4% | 14.9% | 9.0% | 24.2% |
| Tue 07/21 | 47.9% | 30.1% | 14.6% | 9.9% | 25.6% |
| Wed 07/22 | 42.2% | 24.3% | 18.3% | 11.0% | 24.0% |
| Thu 07/23 | 33.2% | 24.4% | 14.8% | 6.8% | 19.8% |
| Fri 07/24 | 46.6% | 28.8% | 16.9% | 8.5% | 25.2% |
| May baseline | 37.9% | 27.6% | 17.4% | 8.1% | 22.7% |
| June baseline | 37.7% | 26.6% | 17.0% | 8.4% | 22.5% |
| July baseline | 40.4% | 27.3% | 15.7% | 9.2% | 23.2% |
| Date | Tier 1 | Tier 2 | Tier 3 | Tier 4 | Total |
|---|---|---|---|---|---|
| Thu 06/25 | 30.6% | 19.3% | 15.2% | 13.5% | 19.7% |
| Fri 06/26 | 28.1% | 17.2% | 16.3% | 6.4% | 17.0% |
| Mon 06/29 | 30.4% | 19.4% | 17.0% | 3.7% | 17.6% |
| Tue 06/30 | 29.2% | 15.8% | 11.3% | 4.9% | 15.3% |
| Wed 07/01 | 28.3% | 25.0% | 10.3% | 6.5% | 17.5% |
| Thu 07/02 | 17.7% | 23.8% | 12.5% | 4.9% | 14.7% |
| Mon 07/06 | 22.6% | 21.5% | 10.8% | 11.9% | 16.7% |
| Tue 07/07 | 45.2% | 24.8% | 14.3% | 7.9% | 23.0% |
| Wed 07/08 | 25.9% | 20.8% | 15.1% | 7.4% | 17.3% |
| Thu 07/09 | 22.1% | 14.8% | 6.9% | 2.7% | 11.6% |
| Fri 07/10 | 27.8% | 19.8% | 14.0% | 2.5% | 16.0% |
| Mon 07/13 | 31.9% | 19.1% | 7.3% | 9.1% | 16.9% |
| Tue 07/14 | 36.0% | 16.8% | 10.8% | 13.9% | 19.4% |
| Wed 07/15 | 35.7% | 22.6% | 11.0% | 9.0% | 19.6% |
| Thu 07/16 | 34.2% | 21.4% | 15.8% | 5.2% | 19.1% |
| Fri 07/17 | 37.2% | 23.6% | 15.8% | 5.3% | 20.5% |
| Mon 07/20 | 35.1% | 21.1% | 11.5% | 7.0% | 18.7% |
| Tue 07/21 | 37.1% | 23.2% | 11.3% | 7.6% | 19.8% |
| Wed 07/22 | 32.6% | 18.8% | 14.2% | 8.5% | 18.5% |
| Thu 07/23 | 25.6% | 18.9% | 11.5% | 5.2% | 15.3% |
| Fri 07/24 | 36.0% | 22.2% | 13.0% | 6.5% | 19.5% |
| May baseline | 29.3% | 21.3% | 13.4% | 6.2% | 17.6% |
| June baseline | 29.2% | 20.6% | 13.1% | 6.5% | 17.3% |
| July baseline | 31.2% | 21.1% | 12.1% | 7.1% | 17.9% |
| Date | Tier 1 | Tier 2 | Tier 3 | Tier 4 | Total |
|---|---|---|---|---|---|
| Thu 06/25 | 21.6% | 13.7% | 10.7% | 9.5% | 13.9% |
| Fri 06/26 | 19.8% | 12.1% | 11.5% | 4.5% | 12.0% |
| Mon 06/29 | 21.5% | 13.7% | 12.0% | 2.6% | 12.5% |
| Tue 06/30 | 20.6% | 11.1% | 8.0% | 3.4% | 10.8% |
| Wed 07/01 | 20.0% | 17.7% | 7.2% | 4.6% | 12.4% |
| Thu 07/02 | 12.5% | 16.8% | 8.8% | 3.5% | 10.4% |
| Mon 07/06 | 16.0% | 15.2% | 7.6% | 8.4% | 11.8% |
| Tue 07/07 | 31.9% | 17.5% | 10.1% | 5.6% | 16.2% |
| Wed 07/08 | 18.3% | 14.7% | 10.6% | 5.2% | 12.2% |
| Thu 07/09 | 15.6% | 10.5% | 4.9% | 1.9% | 8.2% |
| Fri 07/10 | 19.6% | 14.0% | 9.9% | 1.8% | 11.3% |
| Mon 07/13 | 22.5% | 13.5% | 5.2% | 6.4% | 11.9% |
| Tue 07/14 | 25.4% | 11.8% | 7.6% | 9.8% | 13.7% |
| Wed 07/15 | 25.2% | 16.0% | 7.8% | 6.4% | 13.8% |
| Thu 07/16 | 24.1% | 15.1% | 11.2% | 3.7% | 13.5% |
| Fri 07/17 | 26.3% | 16.7% | 11.1% | 3.8% | 14.5% |
| Mon 07/20 | 24.8% | 14.9% | 8.1% | 4.9% | 13.2% |
| Tue 07/21 | 26.2% | 16.4% | 8.0% | 5.4% | 14.0% |
| Wed 07/22 | 23.0% | 13.2% | 10.0% | 6.0% | 13.1% |
| Thu 07/23 | 18.1% | 13.3% | 8.1% | 3.7% | 10.8% |
| Fri 07/24 | 25.4% | 15.7% | 9.2% | 4.6% | 13.7% |
| May baseline | 20.7% | 15.1% | 9.5% | 4.4% | 12.4% |
| June baseline | 20.6% | 14.5% | 9.3% | 4.6% | 12.2% |
| July baseline | 22.1% | 14.9% | 8.6% | 5.0% | 12.6% |
Rates are simple per-cell ratios; cohort tables use an average-of-days convention, so cohort totals can differ from pooled ratios.
| Channel | Leads | CPL | Contact | Qual | Enroll | Enrollments | Share | WoW |
|---|---|---|---|---|---|---|---|---|
| Paid Search | 3,133 | $38 | 61.4% | 45.4% | 20.5% | 179 | 36.5% | +2.3% |
| Paid Social | 2,441 | $24 | 48.7% | 33.1% | 17.3% | 68 | 13.8% | +11.5% |
| Organic | 1,211 | – | 56.2% | 50.4% | 20.1% | 69 | 14.1% | -2.8% |
| Affiliate | 1,752 | $31 | 45.5% | 35.1% | 18.9% | 53 | 10.8% | +3.9% |
| 786 | $2 | 66.9% | 41.8% | 20.5% | 45 | 9.2% | +7.1% | |
| Direct Mail | 978 | $46 | 58.0% | 51.9% | 23.1% | 68 | 13.8% | +3.0% |
| Broadcast | 607 | $52 | 39.0% | 35.4% | 10.7% | 9 | 1.8% | +12.5% |
Paid SearchPaid SocialOrganicAffiliateEmailDirect MailBroadcast
Projection method: workday-weighted seasonal naive (MTD run-rate scaled by remaining workday weights; Mondays run ~9% above and Fridays ~10% below a mid-week day). Stated range is an 80% band from trailing daily variance. It breaks when mix shifts sharply or a holiday lands mid-week.
Cumulative enrolled debt ($M)
Source extract freshness
2026-07-24 06:05 ET
2026-07-24 06:05 ET
Fact rows loaded
560 (expected 560)
560 (expected 560)
Report totals vs source extract
variance 0.00%
variance 0.00%
Workday calendar
80 business days; 3 holidays excluded
80 business days; 3 holidays excluded
Duplicate lead keys
0 found
0 found
No anomalies flagged this week.
Flagged when |WoW| > 15% AND |z| > 2 vs trailing weekly history, on segments with ≥ 50 of the metric. Dual threshold suppresses small-base noise.
Raw daily grain, 560 rows, paginated 100/page. This is the exact table serialized to data/report_data.json.
| Date | Channel | Leads | Contacted | Qualified | Enrolled |
|---|
Transparency tab: the shape of the reconciliation query. Schema and SQL are synthetic.
-- Synthetic illustrative SQL over a FICTIONAL warehouse schema.
-- The production analog reconciles a report extract against its source of
-- truth and refuses to render on non-zero variance.
with fact as (
select lead_date, channel,
count(*) as leads,
count_if(first_contact_at is not null) as contacted,
count_if(qualified_flag) as qualified,
count_if(enrolled_flag) as enrolled,
sum(iff(enrolled_flag, debt_amount, 0)) as enrolled_debt
from demo_dw.crm.fct_lead_funnel
where lead_date >= dateadd(day, -120, current_date)
group by 1, 2
),
extract_check as (
select sum(leads) as leads_fact from fact
),
source_check as (
select count(*) as leads_src
from demo_dw.raw.lead_events
where event_type = 'lead_created'
and event_date >= dateadd(day, -120, current_date)
)
select f.*,
(select leads_fact from extract_check) as recon_fact,
(select leads_src from source_check) as recon_source
from fact f
-- render gate: abs(recon_fact - recon_source) must be 0
order by lead_date desc, channel;| Date | Holiday |
|---|---|
| Mon May 25, 2026 | Memorial Day |
| Fri Jun 19, 2026 | Juneteenth |
| Fri Jul 03, 2026 | Independence Day (observed) |