Source check results
October pack, due Oct 5 1 source failed 1 section held
A notice to the Kestrel data owner before release: which source failed the check, which sections are held, and when the held figures will be released. Prepared by Arjun Mehta, analytics lead at Northfold Analytics, for Grace Whitfield, head of membership data at Kestrel Fitness. Notice issued October 1, 2026.
Northfold checks each source against the thresholds below before a section is assembled. Two of the three sources passed every check that could be run.
| Source | Check | Threshold | Result | Status |
|---|---|---|---|---|
| Membership system | Arrival | By 06:00 on Oct 1 | Arrived 05:12 | Pass |
| Membership system | Row count against the previous period | Within 5 percent | 1.9 percent higher | Pass |
| Club check-ins | Arrival from all 14 clubs | By 06:00 on Oct 1 | 14 of 14 arrived by 05:40 | Pass |
| Club check-ins | Row count against the previous period | Within 5 percent | 2.7 percent lower | Pass |
| Finance export | Arrival | By 06:00 on Oct 1 | Arrived 22:10 on Sep 30 | Pass |
| Finance export | Row count against the previous period | Within 5 percent; hold above 10 percent | 28,840 rows against 41,200, which is 30 percent lower | Fail, hold |
| Finance export | Cancellations reconcile to membership status changes | Within 1 percent | Cannot run until a full export arrives | Not run |
Row counts and arrival times are sample figures. The export arrived on time, which is why the arrival check passed even though the file was incomplete.
What is held and what is released
The held section appears in the pack as a page that states the reason and the planned release date, so Grace reads about the gap in the pack itself.
Cancellation section, held in draft
- Cancellation rate by club, the first figures under the definition effective Oct 5open
- Cancellations by club against the previous periodopen
- Cancellation commentary, and any recommendation that cites itopen
Released on schedule
- Active members, New joiners and Reactivated members from the membership systemdone
- Average weekly visits and Peak hour check-ins from club check-insdone
- Pack commentary, rewritten so that it does not cite cancellationsdone
How the check decides
| Check | Result | What happens |
|---|---|---|
| Did the source arrive by 06:00? | No | Hold the section it feeds and tell the client |
| Row count within 5 percent of the last period | Yes | Release the section |
| Row count 5 to 10 percent away | Caveat | Release with a caveat printed on the page |
| Row count more than 10 percent away | Hold | Ask the Kestrel data team for a full export |
| Full export confirmed | Yes or no | Release the section, or keep it in draft and report status |
Release plan
- Oct 1: finance export fails the row count check, Grace Whitfield is told
- Oct 2: full export requested from the Kestrel data team
- Oct 5: October pack released with the cancellation section held
- Oct 6: full export due, Sofia Reyes reruns the check
- Oct 8: held section released if the check passes
The date that matters is the full export, and it sits with the Kestrel data team. If a full export is not confirmed by Oct 8, the section stays in draft, Arjun Mehta reports the status to Grace Whitfield at the weekly check-in, and the pack keeps stating the reason. The cancellation figures reach Kestrel only after Sofia Reyes has reconciled them to membership status changes.
Contacts
- Arjun MehtaAnalytics lead, Northfold Analytics, decides release or hold
- Sofia ReyesSenior analyst, Northfold Analytics, reruns the check on the full export
- Grace WhitfieldHead of membership data, Kestrel Fitness, confirms the full export with her team