T70 Source check and data gap notice
Source check and data gap notice
Finance export failed the pre-release check: the cancellation section is held
The finance export for the October pack arrived with 30 percent fewer rows than the previous period, while the membership data looked normal. The export may be a partial load, so the cancellation figures cannot be verified yet. Northfold has held the cancellation section in draft. The rest of the pack goes out on time on Mon, Oct 5, 2026, and the held section says why it is missing. No unverified figure will be released.
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.
Sample template: the firm, people, clients and figures are fictional.
Source check results
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 | |
| Membership system | Row count against the previous period | Within 5 percent | 1.9 percent higher | |
| Club check-ins | Arrival from all 14 clubs | By 06:00 on Oct 1 | 14 of 14 arrived by 05:40 | |
| Club check-ins | Row count against the previous period | Within 5 percent | 2.7 percent lower | |
| Finance export | Arrival | By 06:00 on Oct 1 | Arrived 22:10 on Sep 30 | |
| 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 | |
| Finance export | Cancellations reconcile to membership status changes | Within 1 percent | Cannot run until a full export arrives |
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.
Live example from the Dashboards app, shown with Kestrel Fitness' demo data. Block dates move forward each week, so they can differ from the sample dates on this page.
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.
How the check decides
flowchart TD
A["Source files arrive"] --> B{"Arrived by 06:00?"}
B -- "No" --> H["Hold the affected section and tell the client"]
B -- "Yes" --> C{"Row count within 5 percent of the last period?"}
C -- "Yes" --> R["Release the section"]
C -- "5 to 10 percent" --> V["Release with a caveat on the page"]
C -- "Above 10 percent" --> H
H --> Q["Ask the Kestrel data team for a full export"]
Q --> W{"Full export confirmed?"}
W -- "Yes" --> R
W -- "No" --> K["Keep the section in draft and report status"]
Working thresholds for this retainer (sample figures)
Within 5 percent of the previous period passes. Between 5 and 10 percent is released with a caveat printed on the page. Above 10 percent holds the section. Arjun Mehta and Grace Whitfield can change these numbers, and a change is recorded here before it is used. The finance export is 30 percent lower, so it falls in the hold band.
Live example from the Dashboards app, shown with Kestrel Fitness' demo data.
Release plan
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.
What this notice does not cover
This is Northfold's pre-release review of the three sources named above. It does not replace Kestrel's own monitoring of its data pipelines, and it cannot say why the export is short. Finding the cause is for the Kestrel data team.
How to use this template
Issue one notice per pack, on the day a source fails its check and before the pack is released. Fill the variables below from the check log and send the notice to the client data owner first.
| Variable | Meaning | Required |
|---|---|---|
{{client.name}} | Client organization receiving the notice | Required |
{{pack.name}} | Pack the notice applies to, with its release date | Required |
{{source.name}} | Source that failed the check | Required |
{{check.result}} | Check that failed, the threshold and the measured result | Required |
{{section.held_list}} | Sections held in draft because of the failure | Required |
{{release.held_date}} | Date the held sections will be released if the check passes | Required |
{{contact.owner_name}} | Person who owns the fix on the consultancy side | Optional |
If a required value is missing, show Needs review in its place and hold the notice; never fill it with a guess. If the check log is unavailable, show Unavailable instead of the results table.
The live Dashboards blocks on this page show the Kestrel Fitness demo profile. Point each block at your own client's profile, or remove it, before you share the page.