The legacy stack was tuned for the year-end report. The impact manager's real job is the Tuesday question — the program officer asking what happened with this cohort, the board chair asking what the case notes say, the funder asking which outcome moved. Five of those questions, shown three ways.
Tuesday question
Sopact
Legacy stack
"Did our cohort actually improve on the outcomes we promised, or did we only track who showed up?"
One query. Sense joins pre and post survey responses, the before-and-after scores your program already uses, case-note theme extraction, and attendance on the participant ID. Returns: 47 enrolled, 39 reached post (83% retention), pre→post confidence improved 2.3 points on average (n=37), 12 named themes in the case notes correlate with movement, 6 outliers worth a phone call. Citations to every figure.
Three systems, four weeks. Pull attendance from Apricot. Pull survey responses from SurveyMonkey. Export both to Excel. Hire an M&E consultant in Q4 to write the narrative. Hope the case notes can be summarized by hand. Repeat next funder cycle.
"What do the case notes tell us that the survey misses?"
Read the 95%. The reasoning layer reads the case notes as evidence, not as decoration. Returns: of the 39 participants who completed, 11 case-note records contain "anxiety in classroom setting" language coded against the baseline observation; 7 of those 11 show movement on the social-engagement instrument; 4 do not — and their case notes name a different blocker that the survey did not measure.
Read the 5%. The survey produced a Likert score. The case notes live in a free-text field in Apricot, unsearchable across cases, never reaching the funder report. The board hears one anecdote. The pattern across forty cases is invisible.
"Of the 47 who started, how many are still moving at 6 months — and what do the dropouts have in common?"
Longitudinal on one ID. Sense resolves the same participant at 6 months because the ID was minted at enrollment and never broke. Returns: 31 of 47 reachable at 6 months, 24 still moving on the primary outcome, 7 plateaued; the 16 lost-to-followup share two case-note themes (transportation, work-schedule conflict) the program design did not account for.
Rebuild the cohort from scratch. Survey IDs from the pre-program collection do not match the IDs in the case management system. Re-key the cohort. Email participants asking them to remember which study they were in. Twelve respond. Conclude that "longitudinal tracking proved difficult."
"Can we cut this funder report from six weeks to six hours, without rebuilding the data?"
Produced from one connected record. Funder-specific theory of change reads from the same participant data the board view uses. Whatever framework your funder asks for is referenced, not pasted in. Cost-per-outcome figures pull from QuickBooks. Citations to source records sit one click under every number. The report writer's job becomes interpretation, not data assembly.
Reassemble the report each cycle. Spreadsheet from the survey tool, export from the case management system, manual reconciliation by participant name (typos and all), separate accounting pull, copy-paste into a Word template. Six weeks of staff time. Funder asks one follow-up question that requires the cycle to repeat.
"What evidence-based story do we tell the board besides 'we served X people'?"
Outputs become outcomes become evidence. The board view answers: how many entered, how many moved, on which outcomes, with what cost-per-outcome, with citations to the case notes that explain the movement and the dropouts. The story is the data, not a slide layered on top of it.
A slide layered on top of a number. "We served 1,500 students." A photo. A pulled quote from one parent. A bar chart of attendance. The board has no way to ask the question behind the number, because the number was not built from one connected record per person.