play icon for videos
← Academy
SOPACT ACADEMY · CASE INTELLIGENCE · CHAPTER 8

How to Catch At-Risk Participants Early with Mentor Notes

Every note structured on arrival — topics, progress, blockers, next actions, each pinned to a quoted sentence — plus a caseload view that flags aging blockers while the fix is still a bus pass.

<aside class="ci-wizard" aria-label="Case Intelligence series navigator"> <div class="ci-wiz-eyebrow">The Case Intelligence Series</div> <div class="ci-wiz-sub">13 chapters · foundation + two tracks</div> <div class="ci-progress"><span style="width:62%"></span></div> <div class="ci-progress-label">You're here — Chapter 8 of 13</div> <div class="ci-group">Foundation</div> <ol class="ci-steps"> <li class="ci-step is-done"> <a href="/academy/what-is-case-intelligence" target="_blank" rel="noopener"> <span class="ci-num">1</span> <span class="ci-step-body"><span class="ci-step-title">What Is Case Intelligence?</span></span> </a> </li> <li class="ci-step is-done"> <a href="/academy/how-to-build-a-theory-of-change" target="_blank" rel="noopener"> <span class="ci-num">2</span> <span class="ci-step-body"><span class="ci-step-title">How to Build a Theory of Change That Survives Funder Questions</span></span> </a> </li> <li class="ci-step is-done"> <a href="/academy/theory-of-change-to-data-collection-workflow" target="_blank" rel="noopener"> <span class="ci-num">3</span> <span class="ci-step-body"><span class="ci-step-title">How to Turn a Theory of Change into a Data-Collection Workflow</span></span> </a> </li> </ol> <div class="ci-group">Nonprofit Track</div> <ol class="ci-steps"> <li class="ci-step is-done"> <a href="/academy/review-applications-without-reviewer-bias" target="_blank" rel="noopener"> <span class="ci-num">4</span> <span class="ci-step-body"><span class="ci-step-title">How to Review Applications Without Reviewer Bias</span></span> </a> </li> <li class="ci-step is-done"> <a href="/academy/intake-form-usable-baseline" target="_blank" rel="noopener"> <span class="ci-num">5</span> <span class="ci-step-body"><span class="ci-step-title">How to Design an Intake Form That Captures a Usable Baseline</span></span> </a> </li> <li class="ci-step is-done"> <a href="/academy/spot-at-risk-participants-mid-program" target="_blank" rel="noopener"> <span class="ci-num">6</span> <span class="ci-step-body"><span class="ci-step-title">How to Spot At-Risk Participants Mid-Program</span></span> </a> </li> <li class="ci-step is-done"> <a href="/academy/measure-change-at-exit" target="_blank" rel="noopener"> <span class="ci-num">7</span> <span class="ci-step-body"><span class="ci-step-title">How to Measure Change at Exit (Not Just Completion)</span></span> </a> </li> <li class="ci-step is-active" aria-current="step"> <span class="ci-num">8</span> <span class="ci-step-body"><span class="ci-step-title">How to Catch At-Risk Participants Early with Mentor Notes</span><span class="ci-step-meta">You're here</span></span> </li> <li class="ci-step "> <a href="/academy/calculate-sroi-live" target="_blank" rel="noopener"> <span class="ci-num">9</span> <span class="ci-step-body"><span class="ci-step-title">How to Calculate SROI — Live, Sourced, and Honest</span></span> </a> </li> <li class="ci-step "> <a href="/academy/cohort-to-funder-impact-report" target="_blank" rel="noopener"> <span class="ci-num ci-num-range">12a</span> <span class="ci-step-body"><span class="ci-step-title">How to Turn a Cohort into a Funder Impact Report</span></span> </a> </li> </ol> <div class="ci-group">Social Enterprise Track</div> <ol class="ci-steps"> <li class="ci-step "> <a href="/academy/job-description-requirements-checklist" target="_blank" rel="noopener"> <span class="ci-num ci-num-range">10</span> <span class="ci-step-body"><span class="ci-step-title">How to Turn a Job Description into a Requirements Checklist</span></span> </a> </li> <li class="ci-step "> <a href="/academy/score-candidate-role-matches-without-bias" target="_blank" rel="noopener"> <span class="ci-num ci-num-range">11</span> <span class="ci-step-body"><span class="ci-step-title">How to Score Candidate–Role Matches Without Bias</span></span> </a> </li> <li class="ci-step "> <a href="/academy/cohort-to-investor-impact-report" target="_blank" rel="noopener"> <span class="ci-num ci-num-range">12b</span> <span class="ci-step-body"><span class="ci-step-title">How to Turn a Cohort into a Social-Enterprise Investor Report</span></span> </a> </li> </ol> <a class="ci-next" href="/academy/calculate-sroi-live" target="_blank" rel="noopener">Continue to Chapter 9 &nbsp;→</a> </aside> <style> .ci-wizard{--ink:#48416A;--body:#3D3A33;--muted:#76716A;--surface:#F7F6FD;--surface2:#EFEAFB;--line:#E4DFF2;--line2:#DCCEF4;--accent:#8D8AE8; position:sticky;top:24px;box-sizing:border-box;font-family:'Inter',system-ui,sans-serif;color:var(--body); background:var(--surface);border:1px solid var(--line);border-radius:14px;padding:22px 20px;} .ci-wizard *{box-sizing:border-box;} .ci-wiz-eyebrow{font-family:'Inter',Georgia,serif;font-size:18px;font-weight:600;color:var(--ink);line-height:1.25;} .ci-wiz-sub{font-size:12.5px;color:var(--muted);margin-top:3px;} .ci-progress{height:5px;border-radius:999px;background:var(--surface2);margin:14px 0 7px;overflow:hidden;} .ci-progress span{display:block;height:100%;background:var(--accent);border-radius:999px;} .ci-progress-label{font-size:12px;color:var(--muted);} .ci-group{font-size:11px;font-weight:700;letter-spacing:.12em;text-transform:uppercase;color:var(--muted);margin:18px 0 8px;padding-top:14px;border-top:1px solid var(--line);} .ci-group:first-of-type{border-top:0;} .ci-steps{list-style:none;margin:0;padding:0;display:flex;flex-direction:column;gap:2px;} .ci-step a,.ci-step{display:flex;gap:12px;align-items:flex-start;text-decoration:none;color:inherit;} .ci-step a{padding:8px;margin:-8px;border-radius:10px;transition:background .15s;width:100%;} .ci-step a:hover{background:var(--surface2);} .ci-step{padding:8px 0;} .ci-num{flex:0 0 auto;width:26px;height:26px;border-radius:50%;display:grid;place-items:center;font-size:12.5px;font-weight:600;color:var(--muted);background:var(--surface2);border:1px solid var(--line2);} .ci-num-range{width:auto;min-width:26px;padding:0 9px;border-radius:999px;font-size:11.5px;height:26px;} .ci-step-title{display:block;font-size:14px;font-weight:500;color:var(--ink);line-height:1.35;} .ci-step-meta{display:block;font-size:11.5px;color:var(--muted);margin-top:2px;} .ci-step.is-active .ci-num{background:var(--accent);border-color:var(--accent);color:#fff;box-shadow:0 0 0 4px rgba(201,100,66,.15);} .ci-step.is-active .ci-step-title{font-weight:600;} .ci-step.is-active .ci-step-meta{color:var(--accent);font-weight:600;} .ci-step.is-done .ci-num{background:var(--ink);border-color:var(--ink);color:#fff;} .ci-next{display:flex;align-items:center;justify-content:center;margin-top:20px;background:var(--ink);color:#fff;text-decoration:none;font-size:14px;font-weight:600;padding:12px 16px;border-radius:11px;transition:transform .15s,background .15s;} .ci-next:hover{background:var(--accent);transform:translateY(-1px);} </style>

For: anyone whose program runs on recurring notes — mentor sessions, coaching check-ins, case visits, advisor calls — that nobody reads across the caseload until someone drops out and the warning turns up in week four's note.

Why: those notes are the richest early-warning data a program collects, and in most systems they're free text filed per person: visible one file at a time, invisible at scale, read only in the post-mortem.

Outcome: every note structured the moment it arrives — topics, progress, blockers, next actions, each pinned to the exact sentence it came from and never a guessed feeling — plus a caseload view that surfaces aging blockers while the fix is still a bus pass, not an exit interview.

What every note becomes the moment it's filed:

  • Intelligent Cell structures each note on arrival — topics, progress, blockers, next actions, every one pinned to the quoted sentence it came from and never an invented emotion.
  • Intelligent Row assembles the caseload view — one row per participant accumulating every session, so a blocker that's aged three weeks is visible at a glance instead of buried in file twelve.
  • Ask the caseload anything, in plain English — the Sopact assistant cuts across notes, surveys, and attendance together: "Which active blockers are older than two weeks, and who owns the next action?" — from Sense, or from Claude or ChatGPT via MCP.
  • Aging blockers escalate themselves — Intelligent Cell notifies the right person automatically when a risk signal appears or a blocker goes stale, while the fix is still a bus pass, not a dropout.

This is Chapter 8 of the Case Intelligence series. In Chapter 7 you measured change for the people who finished. But exit is where you count the people you kept — the weekly notes are where you keep them. The eighteen people a typical cohort loses don't vanish at exit; they slip weeks earlier, one missed session and one unresolved blocker at a time, while the evidence sits unread in the notes.

As always, the first two steps are [DIY]. The last two are [SENSE] — because trajectory is a many-record fact, and a chat window can't order weeks it never saw.

One rule governs this whole chapter: evidence only — never infer emotion. "Missed two sessions; said the bus route changed" is a fact a skeptic can check against the note. "Seems discouraged" is a fabrication — and invented sentiment is the fastest way to make staff stop trusting the analysis.

The best early-warning data is the notes nobody reads

Run the inventory on your own program: every weekly note already says what the person worked on, whether they moved, what's in the way, and what happens next. Multiply by the caseload and you're holding hundreds of small status reports on exactly the people most likely to slip.

And in a traditional system, that data is functionally invisible. Notes file per participant in chronological piles; a mentor sees their own mentee's last note; a coordinator opens a file only when there's already a problem. Nobody reads three hundred notes across a caseload week over week — so nobody sees that the same blocker, "still no reliable transport," has appeared in three different people's notes for three weeks running. The pattern that predicts the drop-off is present in the text and absent from every screen.

Two framing points. This wave is recurring, not pre/post: its value is trajectory — a blocker mentioned once is noise, the same blocker three weeks running is signal. And it complements the Chapter 6 midpoint flag rather than replacing it: the midpoint catches who is slipping at the halfway line; the note stream catches the slide forming, weeks before.

Step 1 — Design a note a busy mentor will fill [DIY]

Exactly four free-text headings, and resist every urge to add a fifth: topics discussed, progress, blockers, next actions. Too long and mentors skip it after busy sessions — exactly the sessions you need recorded. And no mood box: a mood field invites speculation, and speculation poisons the store.

Paste this into any AI:

My mentoring (or coaching / case management) program in one sentence: [describe who meets whom, how often].

Design a weekly note template with exactly four free-text headings — topics discussed; progress (moved forward, held, or slipped, on what); blockers (specific and concrete: a named module, a bus route, a childcare gap); next actions (what happens before next session, and who owns it). One line of writing guidance under each, phrased to pull concrete facts. No mood or "how are they feeling" field — if the person said something that matters, it belongs under blockers or progress as what was said. The whole note must take under five minutes.

The template is the contract between the humans who write and the machine that reads: four predictable headings mean the extraction lands cleanly on every note, and concrete blocker language means the flag that eventually fires carries a checkable fact.

Step 2 — Write the extraction rule: evidence only [DIY]

Before any AI touches a note, write down what it may pull out — and what it is forbidden to invent. This is the most important artifact in the chapter.

Here are my four note fields: [paste them — and one or two anonymized sample notes if you have them].

Write the extraction instruction that will govern how any AI reads these notes: extract only the four fields; attach the exact sentence from the note as evidence to every extracted item — no quote, no extraction; never infer, guess, or describe emotion, mood, or feeling ("missed two sessions; said the bus route changed" is allowed, "seems discouraged" is forbidden, even when it might be true); return "not stated" for anything missing rather than filling the gap; and carry recurrence counts only as the mentor stated them ("third week this has come up").

Why the hard line: the entire value of the system is that a human can trust a flag without re-reading the note. A flag that traces to a quoted sentence survives scrutiny. A flag built on "the model sensed frustration" collapses the first time a mentor says "I never wrote that" — and takes the whole system's credibility down with it. Emotion-guessing is also unfair to the participant: it converts a bad bus route into a personality assessment.

Step 3 — The note, structured on arrival [SENSE]

From here on, this is what the product does — not a prompt you run. A good week-six note reads: covered blueprint reading and test prep; picked up the fillet weld symbols without help; missed Tuesday's session again — said the bus route changed, third week transport has come up; next: confirm transport support with staff. Nothing about how anyone feels; everything about what happened. The moment it lands, it becomes structure on the participant's timeline:

One weekly note · structured the moment it lands
FieldExtractedEvidence — the exact sentence
TopicsBlueprint reading · certification test prep"Covered blueprint reading and joint prep for the practice test"
ProgressAdvancing on technical skills"Got through the fillet weld symbols without help this week"
BlockerTransport — RECURRING · 3rd week"Missed Tuesday's session again; said the bus route changed… third week transport has come up"
Next actionConfirm transport support — owner: staff, before next session"Told him I'd flag it for a bus pass or a schedule shift"
EmotionNot extracted — by rule
Read it: every cell is checkable against the sentence beside it. The blocker carries its own age because the mentor stated it — nothing inferred, no feeling guessed.

Every cell is checkable against the sentence beside it, and the blocker carries its own age because the mentor stated it. A chat window could produce this table for one pasted note — but it couldn't stamp it onto a timeline, couldn't know this is the third week without the earlier notes, and couldn't do it for three hundred notes as they arrive. The structure is only useful because it accumulates.

Step 4 — Trajectory, aging blockers, and the Monday list [SENSE]

One structured note is a data point; the value is the line through all of them. In Sense you ask the store in plain language:

  • "Show this person's trajectory" — momentum read from the extracted progress and blocker fields, week by week, never from inferred mood.
  • "List every blocker that has repeated two or more weeks for the same person" — ranked by age, each with its quotes.
  • "Which blockers appear across multiple people?" — one person's transport problem is a support ticket; the same quote in three people's notes is a program-design finding.
  • "Who has no note stream at all?" — an unwatched participant is a silent one; the coverage gap is the store auditing itself.
Monday morning · what the note store surfaces across the caseload
SignalEvidence across the storeRoute to
Aging blockerTransport, 3 weeks running for one mentee — while technical progress trends upBus pass or schedule shift this week
Repeating blocker"Still no reliable transport to the shop" — 3 different mentees, three weeks runningProgram-level fix, not three separate chats
Stalling momentumProgress "held" three weeks straight, no blocker named — quotes attachedMentor check-in: something unstated is in the way
Coverage gapTwo participants with no note stream at all — both later surfaced on the at-risk listAssign mentors now — an unwatched participant is a silent one
Read it: no emotion anywhere in the table. Every flag traces to a quoted sentence or a countable absence.

Notice the shape of the first flag: technical progress up and risk up at the same time — the profile a single score would flatten. That three-week transport blocker gets fixed with a bus pass this week; caught at exit, it's the reason a completer became a non-completer. And no emotion appears anywhere in the table — every flag traces to a quoted sentence or a countable absence.

Common mistakes

Adding a mood field to the template. It feels caring and it corrupts the store — mentors start recording guesses, and every downstream flag inherits the speculation.

Letting the AI infer emotion "for richness." "Seems disengaged" reads like insight and is unverifiable by design. The first disputed feeling kills trust in every other output.

Reading notes per file instead of across the caseload. Per-file reading is how three people report the same blocker for three weeks and nobody notices. The unit of analysis is the store, not the file.

Treating one mention as a crisis — or three as noise. Write the threshold down (two or more weeks, same person) so the flag fires by rule, not by whoever happened to read the note.

Ignoring the people with no notes at all. An empty note stream is not good news; it's a blind spot — and the unwatched people are usually the ones who surface on the at-risk list. Audit coverage monthly.

What you have now

A four-field note that busy mentors actually complete. A written extraction rule with the hard line in it — evidence quotes, never inferred emotion, "not stated" over assumption. Every note structured on arrival and filed onto a timeline by persistent ID. Per-person trajectories that read momentum from what was said. And a Monday-morning list — aging blockers ranked by persistence, repeated blockers promoted to program findings, coverage gaps named — every flag traceable to a sentence a human can check.

The one thing to do this week

Restructure your note template into the four headings — topics, progress, blockers, next actions — and delete the mood field if you have one. That single change makes every future note extractable, and it costs your mentors nothing but a cleaner form.

Who this is for

Coordinators with hundreds of notes and no way to read them at caseload scale. Program leads who learned about a three-week-old blocker in an exit interview. Anyone burned by an analytics tool that reported feelings nobody wrote down. If your program's richest data is filed per participant and read post-mortem, the fix starts here.

Put your notes to work in Sopact Sense — sopact.com/academy.

Next in the series: How to Calculate SROI — Live, Sourced, and Honest — the outcomes this chapter helped protect become a ratio a funder can check, with every number traced to its store.

Ready to try it for yourself?

ChatGPT, Claude, and Gemini are fine for a quick test — but not for an answer you'll put in front of a funder or board. When it has to hold up, run it in Sopact Sense.

Try it in Case Intelligence →
The Loop
The Loop — the method in one read
the-loop
Loop
The method
0
One continuous method for reliable, traceable AI reporting across case, application, grant, and program workflows: collect clean, analyze on arrival, and improve in time.
Teams running cases, applications, grants, or programs that need AI-assisted reporting they can reproduce, trace to source evidence, and act on before the cycle ends.
What Is Case Intelligence?
What Is Case Intelligence?
what-is-case-intelligence
Case
Foundation
1
One current, traceable record for each person—connecting intake, services, notes, surveys, documents, outcomes, decisions, and follow-up.
Workforce and training · Youth and mentoring · Case management · Scholarships · Accelerators · Education · Nonprofit programs
What Is Grant Intelligence?
What Is Grant Intelligence?
what-is-grant-intelligence
Grant
Foundation
1
One connected evidence record from application and committee review through the awarded grant, grantee reporting, renewal, and board accountability.
Foundations and grantmakers · Public grant programs · Scholarships and fellowships · Accelerators
What Is Portfolio Intelligence?
What Is Portfolio Intelligence?
what-is-portfolio-intelligence
Portfolio
Strategy
1
A source-linked portfolio view that connects each investee or grantee's agreed plan, reporting cadence, evidence, risks, and results.
Impact funds and investors · Foundations with grant portfolios · Family offices · Blended-finance vehicles
What Is Connected Data Intelligence?
What Is Connected Data Intelligence?
connected-data-intelligence
Feedback
Foundation
1
Keep evidence from surveys, files, notes, documents, systems, sites, and reporting periods connected to one continuing record.
Multi-program nonprofits · Member and chapter networks · Research associations · Training and coaching teams · Organizations with scattered evidence
What Is Impact Measurement and Reporting?
What Is Impact Measurement and Reporting?
embedded-impact-measurement
Reporting
Align
1
Define intended change, align organization and funder context, govern measures, interpret evidence, and produce traceable reports for decisions.
Program and impact teams · MEL leads · Funders and donors · Foundations · Impact funds · Organizations building rigorous impact reports
The Loop Methodology
Methodology — continuous, not annual
loop-methodology
Loop
The method
1
The continuous collect–analyze–improve cycle, adopted as an experiment: start with the step that already pays and add one data-collection step at a time.
Teams tired of rebuilding spreadsheets and forms who want a measurement system that compounds instead of resetting.
How to Build a Theory of Change with AI: Prompts, Workflow & Examples
Build a Theory of Change You Can Test
how-to-build-a-theory-of-change
Reporting
Align
2
How Do You Onboard a Portfolio and Track Results?
Onboard a Portfolio & Lock the Impact Agreement
onboard-portfolio-lock-impact-agreement-track-results
Portfolio
Data Dictionary
2
The Loop: Reliability
Reliability — the same answer twice
loop-reliability
Loop
The method
2
Determinism as a feature: the same question over the same data returns the same answer every run — the opposite of a generic AI chat that drifts.
Anyone who has watched a general AI tool give two different numbers for the same question and needs results they can stand behind.
How to Design a Fair Application and Selection Process
Design an Application Process
how-to-design-an-application-process
Grant
Foundation
2
Which Shape Is Your Data?
Which shape is your data?
which-shape-is-your-data
Feedback
Foundation
2
How Do You Build a Logic Model?
Build a Logic Model You Can Use
how-to-build-a-logic-model
Reporting
Align
3
How Do You Onboard a Grant or RFP Program?
Onboard a Grant or RFP Program
how-to-onboard-a-grant-rfp-program
Grant
Foundation
3
Theory of Change to Data Collection: A Four-Step Workflow
Turn a Theory of Change into a Data-Collection Workflow
theory-of-change-to-data-collection-workflow
Case
Foundation
3
How Do You Map Portfolio Data to IRIS+, GRI, and ESRS?
One Data Dictionary & Standards Mapping (IRIS+ / GRI / ESRS / CSRD)
portfolio-data-dictionary-standards-mapping
Portfolio
Chapters
3
The Loop: Traceability & Transparency
Traceability & Transparency
loop-traceability
Loop
The method
3
Every figure links back to the exact response, note, or document it came from — a full audit trail from headline result to raw evidence.
Teams whose numbers get scrutinized — by funders, boards, auditors, or standards — and who need to answer where did this come from on the spot.
How Do You Change a Question Without Breaking the Record?
Change questions without breaking the record
change-questions-without-breaking-the-record
Feedback
Control
3
Versioning questions and rules so a programme team can improve the instrument mid-cycle without silently breaking the trend line.
Programme & MEL leads · Teams whose questionnaire has ossified · Anyone evaluating a platform where configuration is a purchased service
What Are the IMP Five Dimensions of Impact?
Use the Five Dimensions to Test the Evidence
five-dimensions-of-impact
Reporting
Align
4
How Do You Design a Grant Rubric and Eligibility Rules?
Design Your Rubric & Eligibility Rules
grant-rubric-eligibility-rules
Grant
Foundation
4
How Do You Frame Portfolio Outcomes Over Outputs?
Frame Outcomes Over Outputs at Portfolio Level
frame-outcomes-portfolio-level
Portfolio
Chapters
4
The Loop: Flexibility
Flexibility — one method, four workflows
loop-flexibility
Loop
The method
4
The same collect–analyze–improve cycle, shaped to four kinds of impact work — case, grant, portfolio, and feedback — each shown end to end.
Anyone deciding where the Loop fits their work, who wants to see the full path from messy input to a report they can defend.
How Do You Collect Feedback Offline and in the Field?
Collect Feedback Offline & in the Field
collect-feedback-offline
Feedback
Connect
4
Capturing stakeholder feedback where there's no connectivity and syncing each answer to one continuing record — so field and multi-site programs keep a single identity from intake to endline.
Field & multi-site programs · Low-connectivity contexts · Nonprofits collecting in person
How Do You Design an Intake Form for a Baseline?
Design an Intake Form That Captures a Usable Baseline
intake-form-usable-baseline
Case
Nonprofit Track
5
What's the Difference Between Outcomes and Outputs?
Outcomes vs Outputs
frame-outcomes-over-outputs
Grant
Foundation
5
How Do You Do Pre-Investment Due Diligence?
Pre-Investment Due Diligence & Screening
pre-investment-due-diligence-screening
Portfolio
Chapters
5
The Loop Guarantee
The Guarantee — first workflow in 2 months
loop-guarantee
Loop
The method
5
How Do You Build an Organization Evidence Model?
Build the Organization Evidence Model
build-organization-evidence-model
Reporting
Align
5
How Do You Use Documents as Evidence?
Read documents as evidence
read-documents-as-evidence
Feedback
Connect
5
How to Clean Open-Ended Survey Responses
Clean Open-Ended Responses at the Source
clean-open-ended-survey-responses
Feedback
Clean
6
How Do You Spot At-Risk Participants Mid-Program?
Spot At-Risk Participants Mid-Program
spot-at-risk-participants-mid-program
Case
Nonprofit Track
6
How to Write a Nonprofit Grant Application: Template and Example
Grant Application for Nonprofits
grant-application-for-nonprofit-organizations
Grant
Foundation
6
How Do You Collect Investee Reporting Without Burden?
Collect Standardized Reporting from Every Investee, Without Burden
collect-investee-reporting-without-burden
Portfolio
Chapters
6
How Do You Build a Funder Context Profile?
Build a Sourced Funder Context Profile
build-funder-context-profile
Reporting
Align
6
How Do You Measure Change at Exit?
Measure Change at Exit (Not Just Completion)
measure-change-at-exit
Case
Nonprofit Track
7
How Do You Collect Applications Clean at the Source?
Collect Applications Clean at the Source
collect-applications-clean-at-source
Grant
Collect
7
How Do You Chase Missing Investee Data?
Chase Missing Investee Data — Automatically
chase-missing-investee-data
Portfolio
Chapters
7
How Do You Analyze Multilingual Feedback?
Analyze Multilingual Feedback
analyze-multilingual-feedback
Feedback
Clean
7
Cleaning and theming multilingual open-ended feedback across languages on one continuing record — every theme cited to the person's own words, with no manual translate-then-code step.
Multi-country programs · Multilingual survey data · Global networks & chapters
How Do You Define Measures the Organization and Funder Can Both Use?
Define Measures the Organization and Funder Can Both Use
define-impact-metrics-funders-want
Reporting
Align
7
How Do You Find Who Is Missing Survey Waves?
Survey attrition — who is missing waves
survey-attrition-longitudinal-studies
Feedback
Read
8
How to Catch At-Risk Participants Early with Mentor Notes
Catch At-Risk Participants Early with Mentor Notes
mentor-notes-early-warning
Case
Nonprofit Track
8
How Do You Reduce Applicant Burden?
Reduce Applicant Burden
reduce-applicant-burden-auto-clarification
Grant
Collect
8
How Do You Analyze Investee Reports?
Read Investee Reports Across Qual + Quant + Financial + Social
read-investee-reports-multi-signal
Portfolio
Chapters
8
How Do You Define an Impact Metric So Everyone Counts It the Same Way?
Give Every Number One Definition
one-definition-for-every-number
Reporting
Define
8
How Do You Connect Quantitative and Qualitative Data?
Connect Quantitative & Qualitative Data
connect-quantitative-qualitative-survey-data
Feedback
Read
9
How Do You Calculate SROI Live?
Calculate SROI — Live, Sourced, and Honest
calculate-sroi-live
Case
Nonprofit Track
9
How Do You Collect Grantee Reports Without Burden?
Collect Grantee Reports Without Burden
collect-grantee-reporting-without-burden
Grant
Collect
9
How Do You Track Investees Against the Impact Agreement?
Track Investees Against the Impact Agreement (Variance)
track-investees-impact-agreement-variance
Portfolio
Chapters
9
How Do You Turn Reporting Requirements Into Evidence You Can Collect?
Turn Requirements Into Collectable Evidence
turn-reporting-requirements-into-evidence
Reporting
Define
9
How to Analyze Pre and Post Survey Data
Analyze Pre / Mid / Post Data
analyze-pre-mid-post-survey-data
Feedback
Read
10
How to Report a Job-Training Program to Grant Funders
Turn a Cohort into a Funder Impact Report
job-training-grant-impact-report
Case
Nonprofit Track
10
How Do You Chase Missing Grantee Data?
Chase Missing Grantee Data
chase-missing-grantee-data
Grant
Collect
10
How Do You Monitor Portfolio Risk in Real Time?
Portfolio Risk Monitoring & Early-Warning Alerts
portfolio-risk-monitoring-alerts
Portfolio
Chapters
10
How Do You Collect Clean Evidence Inside the Workflow?
Collect Clean Evidence Inside the Workflow
collect-clean-data-at-the-source
Reporting
Embed
10
How Do You Analyze Longitudinal Survey Data?
Track One Person’s Change Across Years
analyze-longitudinal-survey-data
Feedback
Read
11
How Do You Turn a Job Description Into a Checklist?
Turn a Job Description into a Requirements Checklist
job-description-requirements-checklist
Case
Social Enterprise Track
11
How Do You Review Applications Without Reviewer Bias?
Review Without Reviewer Bias
review-applications-without-reviewer-bias
Grant
Analyze
11
Ask Your Whole Portfolio Anything (Claude + MCP)
Ask Your Whole Portfolio Anything (Claude + MCP)
ask-your-portfolio-anything
Portfolio
Chapters
11
How Do You Get Stable Results From Governed Data?
Get Stable Results From Governed Data
same-numbers-every-time
Reporting
Read
11
How Do You Analyze a Batch of Grant Applications?
Analyze a Whole Round
how-to-analyze-a-batch-of-grant-applications
Grant
Analyze
12
How Long Do Program Outcomes Last?
Measure how long outcomes last
measure-outcome-duration-drop-off
Feedback
Read
12
How Do You Score Candidate-Role Matches Without Bias?
Score Candidate–Role Matches Without Bias
score-candidate-role-matches-without-bias
Case
Social Enterprise Track
12
How Do You Trace Every Result Back to Its Evidence?
Trace Every Result Back to Its Evidence
where-every-number-came-from
Reporting
Read
12
How Do You Roll Up a Grant Portfolio?
Aggregate Outcomes Across the Portfolio
how-to-roll-up-a-grant-portfolio
Portfolio
Communicate
13
How to Report Job Placements to Impact Investors
Turn a Cohort into a Social-Enterprise Investor Report
job-placement-investor-impact-report
Case
Social Enterprise Track
13
How Do You Track Reviewer Conflicts of Interest?
Track Reviewer Conflicts of Interest
track-conflicts-of-interest-audit
Grant
Analyze
13
How Do You Write a Donor Report?
Design a Report for a Real Funding Decision
donor-report-funders-trust
Reporting
Decide
13
A practical, step-by-step track for building a donor or grant report funders trust — from the funder's decision back through metrics, clean data, and traceable numbers.
Program & grant managers who report to funders
What Should AI Be Allowed to See in Your Stakeholder Data?
What the assistant may see
what-the-assistant-may-see
Feedback
Prove
13
How Do You Write an Impact Narrative for a Funder?
Write a Cited Impact Narrative
impact-narrative-funder-report-cited
Feedback
Prove
14
How Do You Read a Grantee Report?
Read a Grantee Report
read-grantee-report-multi-signal
Grant
Analyze
14
How Do You Monetize Impact with SROI?
Monetize Impact with SROI Across Levels
monetize-impact-sroi-across-levels
Portfolio
Chapters
14
How Do You Get AI to Write a Funder Report?
Generate the Audience-Specific Report From Evidence
assistant-writes-the-funder-report
Reporting
Decide
14
How Do You Compute Grantee Variance?
Compute Grantee Variance
how-to-compute-grantee-variance
Grant
Analyze
15
How Do You Put a Dollar Value on Impact?
Add a Credible Dollar Value With SROI
credible-dollar-value-on-impact
Reporting
Optional method
15
How Do You Set Up a Study That Follows People for Years?
One person, followed for years
one-person-followed-for-years
Feedback
Shapes
15
How Do You Build an SROI Value Map?
Build an SROI Value Map
how-to-build-an-sroi-value-map
Reporting
Optional method
16
How Do You Track Budget and Actual Spend?
Track Budget vs Actual Spend
how-to-track-budget-invoices-actual-spend
Grant
Analyze
16
How Do You Collect Feedback From Several People About One Person?
Several people describing one person
several-people-describing-one-person
Feedback
Shapes
16
How Do You Pick a Financial Proxy for SROI?
Pick a Defensible Financial Proxy
how-to-pick-a-financial-proxy-for-sroi
Reporting
Optional method
17
How Do You Analyze Grantee Reporting Longitudinally?
Analyze Grantee Reporting Over Time
analyze-grantee-reporting-longitudinal
Grant
Analyze
17
How Do You Compare and Benchmark Investees?
Compare & Benchmark Investees
compare-benchmark-investees
Portfolio
Chapters
17
How Do You Report Across Programs That Were Designed Separately?
Many programs, one picture
many-programs-one-picture
Feedback
Shapes
17
How Do You Calculate the SROI Ratio?
Calculate the SROI Ratio With a Range
how-to-calculate-the-sroi-ratio
Reporting
Optional method
18
How Do You Read a 990 for Compliance?
Read a 990 for Compliance
how-to-read-a-990-for-compliance
Grant
Analyze
18
How Do You Build Dashboards and Compliance Reports?
Portfolio Dashboards & Geographic Mapping
dashboards-sroi-compliance-reports
Portfolio
Communicate
18
How Do You Run a Survey Across a Member Network?
A network where each member sees their own part
member-network-survey
Feedback
Shapes
18
Ask Your Whole Grant Round Anything (Assistant + MCP)
Ask Your Whole Grant Round Anything
ask-your-grant-round-anything
Grant
Analyze
19
How Do You Produce an LP and Board Impact Report?
Produce the LP / Board Impact Report — Live, Not Annual
portfolio-lp-board-impact-report
Portfolio
Chapters
19
How Do You Build a Grant Audit Trail?
Build a Grant Audit Trail
grant-audit-compliance-trail
Grant
Communicate
20
How Do You Connect Your Stack Without Lock-In?
Connect Your Stack Without Lock-In (Microsoft Dynamics, Power BI, Affinity, MCP)
portfolio-connect-your-stack
Portfolio
Chapters
20
How Do You Produce Grant Compliance Reports?
Produce Compliance Reports
grant-compliance-regulatory-reports
Grant
Communicate
21
How Do You Roll Grantees Into a Board Report?
Roll Grantees Into a Board Report
roll-grantees-funder-board-report
Grant
Communicate
22
How Do You Build Grant Dashboards and Maps?
Grant Dashboards & Maps
grant-dashboards-geographic-mapping
Grant
Communicate
23