Leona Group Schools · Marketing ↔ Data Team

Enrollment Report Logic

How the report suite in the ALL SCHOOLS workbook counts students — which clock each report runs on and why, the counting rules, and the data it all depends on.

updated 10/28/2026 (v7 — In-Session Days now count true school days; two-clock methodology adopted 9/30 with the data team) reports: New Students · Monthly YoY · Attrition · Attrition YoY · Summer vs In-Year · Event Planner · Marketing Retention · Cohort Retention · Insights ×5 · Marketing ROI

Why different reports use different dates

Adopted with the data team on 9/30/2026. The principle: what date makes sense depends on what the data is for.

Every student in Synergy carries two meaningful dates, and they answer different questions:

Pulled in  the marketing clockWhen the enrollment record was created (Add Date Time Stamp) — the moment the family converted. A family's engagement with us peaks here, not on the first day of school. This is the clock for marketing attribution: leads, ads, tours, conversion windows.
Started  the enrollment clockThe first day of actual membership (Enter Date) — when the student is in a seat and the state starts funding them. This is the clock for counting new students, pacing, cohorts, and anything that should reconcile with enrollment reality.

Why it matters: families often pre-register months before school starts. Colegio Petite's kindergarten families register in January–June for an August 1 start; the alt high schools pre-register all winter and spring. Counting those students at their registration date filed them into the previous school year — 34 of Colegio's fall-2024 kindergartners were invisible in the fall-2024 column before this change, and Alta Vista alone had 111 hidden fall starters. Synergy's own Original Enter Date field agrees: the student's entry is the day they start, not the day the paperwork was created.

Which report runs on which clock

ReportClockWhy
New Students Report · Enrollment Pacing · Monthly YoY · Dashboard new-student countsStarted"New by this date" means students in seats. A student counts in the school year they actually start — so spring pre-registrations land in the fall they attend, and a record created with no enrollment yet counts in no year until the student starts.
Marketing Retention · Marketing ROI · Lead Insights · tour reportingPulled inMarketing attribution — credit belongs to the moment the family was won. Lead windows, conversion rates, and spend joins all key on lead/record creation dates.
Monthly YoY (planned toggle)EitherA March registration for an August start is a March recruiting win and an August enrollment. A control cell will show either view; until the script update installs, the live tab still counts on the pulled-in clock.
Cohort Retention · Retention Insights · attrition reportsStartedRetention clocks run from when a student actually attends. Departure rules are unchanged; cohort entry follows the start clock.
Marketing Retention's In-Session Days · 90-day blocksBothThe lead side uses the marketing clock; the day count deliberately borrows the funding clock (Enter Date + each school's calendar) so blocks track what the state pays for.

Preschool never counts as new — and that's a funding statement. PS isn't government funded, so a preschooler isn't a funded enrollment yet. The student becomes New to Leona in the year they start KG (or their first non-PS grade) — the first time the state funds them. PS rows are excluded from every new-student count; they don't create newness and a PS year doesn't block it later.

Students who enroll and later withdraw still count as new. The enrollment happened; the retention and attrition reports carry the drop. New-student counts never look at leave codes — codes only matter for attrition.

Rollovers and returners never re-count. A student counts once, at their first-ever funded enrollment across every year of data. A record created this year for a student with any prior-year enrollment is a returning student, whatever the code says.

What changed on 9/30/2026: new-student counts moved from the pulled-in clock to the started clock, and PS was excluded. Every "new by date" level rose (the pre-registered students surfaced in the right years, consistently, so year-over-year comparisons stay apples-to-apples), and the SY26-27 pacing read moved from slightly behind to slightly ahead. Documents dated before 9/30 use the old rule.

After the 9/30 install — what to rerun and what moves

The script installed 9/30/2026. Each report picks up the new rules on its next RUN. One cause behind every shift: students count when they start, and PS never counts.

ReportWhat you'll see changeWhy
Monthly YoYFall months roughly double historically; spring months shrink; KG entry columns rise at elementaries; a new Count by dropdown appears in B5.Spring registrations move into the fall they attended; PS→KG kids now count as new KG. The B5 toggle keeps the old registration view one click away.
Enrollment PacingEvery year's level rises ~450–500 district-wide; SY26-27 reads ahead of last year instead of behind.The pre-registered fall starters surface in the year they attend.
New Students ReportFall date-ranges gain students; spring ranges lose them; PS disappears.Same clock change, applied to whatever date range is set.
Cohort RetentionCohorts re-form around start months; early checkpoints read slightly higher.The retention clock no longer burns days between registration and the first day of school.
Retention Insights · Attrition Patterns · Lead Insights · Event PlannerTenure and survival figures tighten slightly.All clocks now start at the first day in a seat.
Attrition · Attrition YoY · Summer vs In-YearNo change.The LOST rules were never touched.
Marketing Retention · Marketing ROINo change.They run on the pulled-in clock on purpose — attribution belongs to when the family was won.

Reference restatement — Monthly YoY, August New-to-Leona, all schools (the numbers to expect after the first rerun):

Count byAug 2023Aug 2024Aug 2025Aug 2026
Started (default)1,8661,7601,2531,558
Pulled in (B5 toggle)861790571572

Why the change makes the analysis better:

• Pacing is an early-warning system now. Roughly 500 real fall starters per year were invisible in the current-year column because they'd been counted at spring registration — budget decisions were steering against a number that couldn't move when families actually showed up.

• Seasonality is true. The old curve's "spring enrollment" was paperwork. The restated curve shows when families arrive — and it immediately surfaced real intel: August intake dipped to 1,253 in 2025 and recovered to 1,558 in 2026.

• "Registered but never started" is now a countable group — the warmest re-engagement audience there is.

• PS→KG is a measurable funnel: preschool families converting to funded KG now appear as new-student wins in the KG year.

• Retention clocks are honest, so cohort checkpoints and event timing reflect real at-risk windows, not registration artifacts.

• One language with the data team: new-student counts now reconcile with the ADM view by construction, while the Monthly YoY toggle still answers "when did we win them?" whenever the marketing view is the right one.