play icon for videos
← Academy
Module 3 of 5 · Case intelligence

Keep a person’s history connected across programs and staff changes

Maintain a continuing person record while keeping program episodes, observations and contributor roles distinct. Use stable identifiers and dates, preserve the version and source of each observation, and show gaps instead of filling them with assumptions. A staff or reporting-year change should not erase the history an authorized colleague needs.

Sopact Academy · Case intelligence
Module 3 of 5 · Case intelligence

Keep a person’s history connected across programs and staff changes

Maintain a continuing person record while keeping program episodes, observations and contributor roles distinct. Use stable identifiers and dates, preserve the version and source of each observation, and show gaps instead of filling them with assumptions. A staff or reporting-year change should not erase the history an authorized colleague needs.

Read the lesson ↓

Separate the person from the program episode

P-24 attends a first program episode and later joins another. One person identifier can preserve continuity while separate episode records show which activities and observations belong together. Treating each enrollment as a new person loses history; merging every observation into one undated note loses context.

Record the relationship between the person, episode and observation. Include dates and respondent roles. A partner’s report may describe a different period from the practitioner’s recent note, so the latest file is not necessarily the latest evidence.

Plan a deliberate matching and duplicate-review process. Similar names or changed email addresses are reasons to check records, not sufficient grounds to merge them automatically.

Keep relationships and changes dated

A new practitioner takes over. Their access and assignment begin at a recorded time; older notes retain their original authors. Family or partner relationships can also change and should not silently transfer unrestricted access.

Preserve a corrected observation alongside the reason and reviewer. Identify which version is used for current analysis. If the original is retained under the agreed policy, a later reviewer can understand why the result changed.

Question and rubric versions matter too. A new definition may improve future collection but does not retroactively make old observations comparable. Keep the interpretation decision visible.

Show what is missing before describing change

If P-24 misses a follow-up check-in, there is no new participant observation. Do not copy the earlier score forward as though it was collected again. A practitioner’s observation may still be useful, but it is a different perspective.

Before reporting a change, inspect timing, source and coverage. A cohort view also needs to show who is absent from later waves. Otherwise, an apparent improvement may reflect who remained in the dataset.

Test a handoff question: what is known, what is unresolved and what should the next practitioner ask? A continuing record is useful when an authorized colleague can answer without repeating the matching and file-reading work from scratch.

Work through the Pathways example

This is a fictional teaching example. Adapt the fields and rules to the question your own program needs to answer.

RecordExamplePreserve
PersonP-24Stable identity and appropriate permissions
EpisodeProgram A, then Program BStart/end dates and participation context
ObservationParticipant check-in or practitioner noteAuthor, role, date, method and source
CorrectionReviewed revision to a noteOriginal context, reason and current review status
Read the complete practical guide

How do you track the same participant over time?

Use a stable, appropriately protected identifier to connect dated observations, while keeping question versions, sources and follow-up status visible. Plan how you will recognize returning participants, handle uncertain matches and preserve useful records when staff, contact details or systems change.

Use this reference when your collection plan follows a person through repeated observations or several service episodes. Design a participant record and test what happens when someone misses a wave, changes email address or returns through another service.

This chapter focuses on the collection and record design. For statistical comparisons, use the separate lesson on analyzing longitudinal survey data. A well-organized record makes analysis possible; it does not remove the need to choose an appropriate method.

Define what the continuing record needs to answer

Start with the decision and time horizon. Are you checking whether a training outcome remains present after six months, following a member's experience across renewals or understanding a person's changing support needs? Those purposes require different timing, measures and access.

Write down the unit you follow. One person may have several enrollments, service episodes or memberships. If they return for a second program, retain the person identifier and create a separate episode identifier. Otherwise, the new intake may overwrite the first, or the same person may be counted as two people.

Distinguish a panel that follows the same people from a repeated survey of whoever participates each year. Both can be useful, but they answer different questions. A stable annual average among different respondents is not evidence that each person's experience remained stable.

The UK Data Service's longitudinal-data guide provides a practical introduction to inspecting and managing repeated observations. Keep the identifier and the observation period explicit before comparing records.

Agree access, continuity and responsibilities early

Before committing to a collection arrangement, establish who can access the records, add a question, export the information and continue the follow-up if a supplier or staff member changes. Record responsibilities for security, corrections and retention. These are operational questions as well as contractual ones.

“We own the data” is not enough detail. Ask whether an export includes stable IDs, dates, question definitions, attachments, relationships and review history. A spreadsheet of answers without those elements may be difficult to reuse. Conversely, working with an outside research provider does not automatically prevent a long study; the arrangement and permissions matter.

Define the purpose and the applicable arrangements for recontact, linkage and use of the information. A choice not to receive future invitations is not automatically the same as a request to erase all prior observations. Route changes to the responsible owner and apply the relevant policy and obligations.

Use the course lesson on access and sharing boundaries to separate operational contact details from analysis and report audiences. Do not publish a named list of people who missed a wave. Authorized follow-up staff may need that list; readers of an aggregate report usually do not.

Choose an identifier approach you can support

For a service relationship where the organization already knows the person and linkage is appropriate, an issued ID carried through a secure invitation can reduce the need to re-enter identifying details. Keep the mapping to contact information protected and separate where appropriate.

Issued IDs still need a recovery process. Invitations can be forwarded, links can be opened by someone else, contact details can change and duplicate records can be created. Test those cases instead of assuming a code guarantees correct identity.

Self-generated identification codes are another research approach. They can support matching where direct identifiers are not collected, but code consistency and collisions need evaluation. They should not be dismissed as always unusable or presented as automatically anonymous.

A 2025 cohort study of self-generated identification codes matched approximately 72.65% of its school-based sample using perfect and partial matching. That result demonstrates both potential and loss: it is evidence from one study, not a benchmark for your population or a recommendation to copy its code design.

Choose according to the purpose, participants' needs and the collection promise. Do not quietly convert an anonymous survey into an identifiable record to make analysis easier. If linkage is not intended or justified, analyze the data at an appropriate aggregate level.

Separate the person, the episode and the observation

Think in three linked parts. The person record identifies the continuing relationship. An episode describes a particular program, membership or service period. An observation records what was collected, when, from which source and under which version.

RecordUseful fieldsWhat it prevents
PersonStable person ID, approved contact reference, linkage statusCreating a new identity for every response
EpisodeEpisode ID, person ID, program or service, start and end datesOverwriting an earlier enrollment when someone returns
ObservationObservation ID, person/episode ID, event date, collection date, instrument version, sourceLosing the timing and meaning of an answer
Follow-up statusExpected wave, eligibility, contact status, response status, review dateTreating every missing value as the same problem

You may implement these parts in linked tables, an approved database or another suitable system. A wide spreadsheet can be workable for a small fixed study; a long-format table often helps with repeated observations and changing schedules. The essential requirement is a documented relationship, not a universal prohibition on files or columns.

Keep attachments and transcripts attached to the right observation or episode, not just somewhere under a person's name. A document's upload date can differ from the date of the event it describes. Record both when the distinction matters.

Worked example: one person, two program episodes

The following record is fictional. P-024 joins a training program in January, misses a July follow-up and returns for a different course the next year. The first program history remains available.

Person / episodeDateRecordInterpretation
P-024 / E-01January 2025Baseline confidence 2 of 5, version AStarting observation for E-01
P-024 / E-01April 2025Endline confidence 4 of 5, version AObserved change of +2 under the same measure
P-024 / E-01July 2025No follow-up responseOutcome unknown at this wave; not a score of zero
P-024 / E-01October 2025Confidence 3 of 5, version A; note about new roleObserved score and contextual account, not proof of causation
P-024 / E-02January 2026New enrollment; different skill measure, version BNew episode and measure; do not append to the old confidence trend

The record supports a +2 change from January to April on the stated measure and a score of 3 in October. It does not show what happened in July or prove continuous improvement between checks. The new skill measure belongs in its own series unless a defensible comparison is established.

A team reviewing this record can ask a focused question: what was reported after the first program, and what information is missing? It should not infer a successful July outcome simply because the person returned later.

Make timing part of the definition

Record actual dates as well as labels such as “six-month follow-up.” A response collected at month eight is not identical to one collected at month six. Establish an acceptable collection window and say how late responses are handled.

Decide whether analysis uses calendar time, time since intake, time since exit or another meaningful clock. Programs with rolling enrollment often need elapsed time. A common reporting quarter can still be useful, but it should not conceal different lengths of participation.

Keep scheduled waves distinct from unscheduled notes or service events. A note written during an urgent call is useful evidence, but it is not necessarily a completed follow-up survey. Avoid counting it as one merely to fill a gap.

Changes to cadence are possible. Record when they occurred and why, and adapt the comparison accordingly. Planning early reduces avoidable problems, but it is too strong to say that every decision becomes impossible to repair after the first wave.

Version questions without discarding the history

Maintain core measures where comparability is important, and document additions and revisions. New questions should appear as “not asked” in earlier waves. A blank caused by a skipped response is a different status.

Exact wording is useful but not the whole measurement context. Language, response options, collection mode and interpretation can also change. Conversely, a carefully evaluated revision may retain useful comparability. Record the decision rather than treating any edit as either harmless or fatal.

Use the question-versioning lesson to create a change log. Keep the original answers and definitions available. Do not overwrite historical values to make an updated form look consistent.

Review uncertain matches instead of forcing them

Define what counts as an exact match and what requires review. A returning record with the same authorized ID may be straightforward; a conflicting ID, duplicated invitation or ambiguous name requires more attention.

Keep the unmatched record with a status and source. Do not invent an ID or choose the nearest-looking person simply to raise the match rate. A false match can create a convincing but incorrect history.

When an approved review resolves a duplicate, retain the decision, reviewer and original references. Consider whether a mistaken merge can be reversed. Email addresses and names can help an authorized reconciliation process, but neither should be assumed permanent or unique.

Track match quality separately from response coverage. Receiving twenty surveys does not mean that twenty people have usable paired observations. Some may be duplicates, new entrants, incomplete responses or unresolved matches.

Report missing waves without guessing the outcome

Distinguish not eligible, not yet due, not asked, invited but no response, incomplete and unresolved linkage. Apply categories consistently and avoid collecting sensitive explanations merely to fill an administrative field.

Compare available baseline characteristics of respondents and nonrespondents where appropriate. Differences can reveal a concern, but they do not tell you the missing outcomes. People may stop responding for many reasons; the direction of resulting bias cannot be assumed.

For each comparison, state the usable base and why records were excluded. Follow the survey-attrition lesson for a fuller missingness review. Keep individual outreach lists restricted while reporting suitable aggregate coverage.

Test the workflow before expanding it

Use a fictional twenty-person cohort for a two-wave rehearsal. Create three nonresponses, one duplicate return, one changed contact address and one unresolved identifier. Add a question in the second wave and change a measure's response scale.

  1. Check identity: valid returning IDs connect to their history; the ambiguous return remains flagged until review.
  2. Check episodes: a new enrollment creates a new episode without deleting the first.
  3. Check dates and versions: collection timing and changed measures remain visible.
  4. Check missingness: nonresponse, not asked and unresolved linkage remain distinct.
  5. Check access: each role sees the information appropriate to its task, including exported records.
  6. Check continuity: another authorized colleague can interpret the record and retrieve the source without relying on the original designer.

Document expected and actual results. A vendor demonstration should use these cases in the proposed configuration, including export and correction. In a Sopact evaluation, ask how collection, documents and analysis stay associated with the person and episode. Verify the actual setup rather than assuming a feature label proves the workflow.

Your handover pack should contain the data dictionary, identifier rules, version log, follow-up schedule, access responsibilities and known unresolved records. Review it after meaningful changes. That small amount of documentation helps the record survive beyond one person's memory.

Watch: connect a participant journey from application onward

Watch the video · 4 minutes 13 seconds. This training-workflow demonstration uses illustrative data. It shows the connected-record idea; it is not evidence of a multi-year customer outcome. Browse more videos in the video library.

Frequently asked questions

What is longitudinal participant tracking?

It links dated observations about the same person over time, with the measures, sources and relevant context preserved. This differs from comparing surveys of different respondents each year.

Should participants create their own code?

That depends on the study and privacy design. Self-generated codes can work but may have substantial matching loss. Issued identifiers also need secure delivery, recovery and duplicate checks.

Does a stable ID make the data anonymous?

No. If the ID can be linked back to a person, the record remains linkable. Apply the appropriate access and use arrangements rather than calling it anonymous because the name is hidden.

Can we add new questions later?

Yes. Preserve the historical instrument, label new questions as not asked in earlier waves and assess whether revised measures remain comparable. Do not silently overwrite definitions.

What does a missing wave mean?

It means the expected observation is unavailable under the recorded status. It does not automatically mean the person lost the outcome, left the program or scored zero.

What if a participant returns to another program?

Where linkage is appropriate, keep the person identifier and create a distinct episode. Preserve the earlier history and avoid combining different measures into one trend without justification.

What should survive a system change?

Stable references, dates, instrument definitions, source links, relationships, relevant permissions and unresolved-record notes. Test a usable export and an authorized handover before relying on continuity.

When several people contribute observations

Continue to several people describing one person. That reference adds another distinction: the person being described and the person supplying the observation are not always the same.

Reviewed September 12, 2026. P-024 and the twenty-person rehearsal are fictional teaching examples.

Build this part of your plan in more detail

These lessons address the next practical questions in this module. Choose the detail your workflow needs, then return to complete the exercise.

More practical questions in this module (4)

Add this part to your plan

On workbook page 4, draw P-24 across two episodes and a practitioner handoff. Add a missing check-in and one corrected observation.

Download workbook (fillable PDF)
Compare with a suggested answer

Keep one person record, distinct episodes and dated assignments. The missing check-in remains missing; it is not replaced by staff opinion. Preserve the corrected observation’s source, reason and review status so a new practitioner can follow the history.

Self-check: Can the next practitioner distinguish the person’s history from a particular episode and its reporting period?

Questions you may have

Should a new fiscal year create a new person record?

A reporting boundary should not erase continuity. Keep the person record and identify reporting periods or episodes separately.

Can staff observations replace missing self-reports?

They can provide additional evidence, but should remain labeled as staff observations rather than substitutes for a missing participant response.

Apply the method to your work

Use the five-part plan to assess the sources, analysis and permissions your team needs. The solution page shows where a connected platform can support that workflow.

Explore the case intelligence solution →

Put this guide into practice.

Start with data your teams struggle to bring together. Agree shared definitions, keep each source identifiable, and decide who can see what before asking AI for an answer.

Explore Connected Data Intelligence →
Prepare data governance before using AI
Prepare your data governance
nonprofit-data-governance-before-ai
Feedback
Foundation
Prepare an evidence register and a tested governance baseline before applying AI to program data.
Make learning part of the work you already do
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
Build an impact report from evidence you can explain
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
Build a repeatable collect, review and improve cycle
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 and 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?
Agree the Portfolio Reporting Plan
onboard-portfolio-lock-impact-agreement-track-results
Portfolio
Data Dictionary
2
Test whether an AI-assisted result is repeatable and correct
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.
Design application intake around a defensible decision
Design an Application Process
how-to-design-an-application-process
Grant
Foundation
2
How to Structure Stakeholder Data: Four Common Patterns
Choose your record structure
which-shape-is-your-data
Feedback
Foundation
2
Map the people, observations and relationships your workflow needs before collecting data.
How to Build a Logic Model: Steps, Example and AI Prompt
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
Turn your theory of change into a data-collection plan
Turn a Theory of Change into a Data-Collection Workflow
theory-of-change-to-data-collection-workflow
Case
Foundation
3
Build a portfolio data dictionary without forcing false comparisons
Map Portfolio Data to Reporting Standards
portfolio-data-dictionary-standards-mapping
Portfolio
Chapters
3
Keep a clear trail from a finding to its evidence
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 to Change Survey Questions Without Losing Comparability
Change questions with a clear history
change-questions-without-breaking-the-record
Feedback
Control
3
Create a question-change log and decide how old and new versions should appear in reports.
Programme & MEL leads · Teams whose questionnaire has ossified · Anyone evaluating a platform where configuration is a purchased service
Five Dimensions of Impact: How to Review Your Evidence
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 to Measure Outcomes Across an Investment or Grant Portfolio
Frame Outcomes Over Outputs at Portfolio Level
frame-outcomes-portfolio-level
Portfolio
Chapters
4
Adapt the learning cycle to your workflow
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 to Collect Feedback Offline and Keep Records Connected
Collect offline and reconcile the batch
collect-feedback-offline
Feedback
Connect
4
Build a field protocol and reconcile a test batch across devices, visits and delayed uploads.
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
Turn a proposed outcome into a reporting definition
Outcomes vs Outputs
frame-outcomes-over-outputs
Grant
Foundation
5
Impact Due Diligence: Review Evidence Before Investment
Pre-Investment Due Diligence & Screening
pre-investment-due-diligence-screening
Portfolio
Chapters
5
Plan and review your first workflow pilot
The Guarantee — first workflow in 2 months
loop-guarantee
Loop
The method
5
How to Build an Organization Evidence Model
Build the Organization Evidence Model
build-organization-evidence-model
Reporting
Align
5
How to Analyze Documents as Evidence: Sources, Context and Review
Read documents as traceable evidence
read-documents-as-evidence
Feedback
Connect
5
Create a document register and reviewed findings with source locations, context and explicit exceptions.
How to Clean Open-Ended Survey Responses Without Losing Meaning
Clean responses and define the denominator
clean-open-ended-survey-responses
Feedback
Clean
6
Create a cleaning log, response-status table and reproducible report statement.
How to Review Participant Support Needs 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
Design quarterly portfolio reporting that investees can complete
Collect Investee Reporting Without Repeated Rework
collect-investee-reporting-without-burden
Portfolio
Chapters
6
How to Build a Funder Context Profile: Research to Reporting
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 to Follow Up on Missing Investee Data
How to Follow Up on Missing Investee Data
chase-missing-investee-data
Portfolio
Chapters
7
How to Analyze Multilingual Feedback and Evaluate Software
Analyze and review multilingual feedback
analyze-multilingual-feedback
Feedback
Clean
7
Build a language review sheet and test software on original responses, translations, codes and reporting bases.
Multi-country programs · Multilingual survey data · Global networks & chapters
How to Define Impact Metrics Your Team and Funder Can Use
Define Measures the Organization and Funder Can Both Use
define-impact-metrics-funders-want
Reporting
Align
7
Survey Attrition in Longitudinal Studies: Track Missing Waves
Track missing waves and matched outcomes
survey-attrition-longitudinal-studies
Feedback
Read
8
Build a wave-status register, compare response groups and report paired change with coverage and limitations.
How to Use Mentor Notes to Review Participant Support
Use mentor notes for support review
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
Find inconsistencies in portfolio returns before reporting
Analyze Investee Reports Across Sources
read-investee-reports-multi-signal
Portfolio
Chapters
8
Impact Metric Definitions: A Practical Worksheet and Example
Give Every Number One Definition
one-definition-for-every-number
Reporting
Define
8
How to Connect Quantitative and Qualitative Survey Data
Connect scores and comments
connect-quantitative-qualitative-survey-data
Feedback
Read
9
Build a linked analysis view and joint display, with clear groups, reporting bases and evidence limits.
How to Calculate SROI as New Evidence Arrives
Calculate SROI — Live, Sourced, and Honest
calculate-sroi-live
Case
Nonprofit Track
9
How to Collect Grantee Reports with Less Burden
Collect Grantee Reports Without Burden
collect-grantee-reporting-without-burden
Grant
Collect
9
Keep company, investment and reporting history connected
Track Results Against the Impact Agreement
track-investees-impact-agreement-variance
Portfolio
Chapters
9
Turn Reporting Requirements into Evidence: A Practical Mapping Guide
Turn Requirements Into Collectable Evidence
turn-reporting-requirements-into-evidence
Reporting
Define
9
Connect baseline, follow-up and different rater perspectives
Analyze pre, mid and post surveys
analyze-pre-mid-post-survey-data
Feedback
Read
10
Build a matched pre/mid/post analysis, interpret score movement and retain clear rules for missing waves.
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 to Follow Up on Missing Grantee Data
Chase Missing Grantee Data
chase-missing-grantee-data
Grant
Collect
10
How to Build Useful Portfolio Impact Monitoring Alerts
Build Useful Portfolio Impact Alerts
portfolio-risk-monitoring-alerts
Portfolio
Chapters
10
How to Collect Clean Data Inside Your Workflow
Collect Clean Evidence Inside the Workflow
collect-clean-data-at-the-source
Reporting
Embed
10
How to Analyze Longitudinal Survey Data
Analyze longitudinal survey data
analyze-longitudinal-survey-data
Feedback
Read
11
Build a continuing analysis record with clear time scales, observed trajectories and limits.
How to Turn a Job Description into a Requirements Checklist
Clarify employer requirements
job-description-requirements-checklist
Case
Social Enterprise Track
11
Review applications with evidence, clear criteria and human judgment
Review Without Reviewer Bias
review-applications-without-reviewer-bias
Grant
Analyze
11
How to Ask AI Questions About Your Portfolio Data
Ask AI Questions About Portfolio Data
ask-your-portfolio-anything
Portfolio
Chapters
11
How to Keep Impact Reporting Numbers Consistent
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 to Measure Outcome Duration and Drop-Off
Measure outcome duration and drop-off
measure-outcome-duration-drop-off
Feedback
Read
12
Build a dated outcome claim, distinguish missingness from outcome loss and test forecast assumptions.
How to Score Candidate–Role Matches with a Clear Rubric
Review candidate–role evidence
score-candidate-role-matches-without-bias
Case
Social Enterprise Track
12
Evidence Traceability: Link Every Report Claim to Its Source
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 a Grant Portfolio
how-to-roll-up-a-grant-portfolio
Portfolio
Chapters
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 to Write a Donor Report: Format, Evidence and Example
Design a Report for a Real Funding Decision
donor-report-funders-trust
Reporting
Decide
13
Build a report brief and claim-and-evidence table before drafting. Explain delivery, outcomes, spending, limitations and next actions.
Program managers, grant leads and reporting teams
AI Data Access Controls: What Your Assistant May See
Control what the assistant can access
what-the-assistant-may-see
Feedback
Prove
13
Define task-specific access, test synthetic records and verify report-sharing boundaries.
How to Write an Evidence-Based Impact Narrative
Write a cited impact narrative
impact-narrative-funder-report-cited
Feedback
Prove
14
Build and check a report paragraph using a claim-and-source table, appropriate quotations and clear limitations.
How Do You Read a Grantee Report?
Read a Grantee Report
read-grantee-report-multi-signal
Grant
Analyze
14
How to Use SROI Across a Portfolio Without Double Counting
Use SROI Across a Portfolio
monetize-impact-sroi-across-levels
Portfolio
Chapters
14
How to Write a Funder Report with AI—and Check It
Generate the Audience-Specific Report From Evidence
assistant-writes-the-funder-report
Reporting
Decide
14
Draft from approved sources, check the claims, and save an accountable report version. Bring the brief from the previous lesson.
Program managers, grant leads and reporting teams
How Do You Compute Grantee Variance?
Compute Grantee Variance
how-to-compute-grantee-variance
Grant
Analyze
15
When Is a Monetary Value on Social Impact Credible?
Add a Credible Dollar Value With SROI
credible-dollar-value-on-impact
Reporting
Optional method
15
Prepare a valuation brief. Decide what the evidence supports, what needs more work, and when an outcome account is enough.
Program, evaluation and investment teams considering social-value estimates
Keep a person’s history connected across programs and staff changes
Follow one person over time
one-person-followed-for-years
Feedback
Shapes
15
Build a participant record that preserves episodes, dates, versions and missingness across repeated collection.
How Do You Build an SROI Value Map?
Build an SROI Value Map
how-to-build-an-sroi-value-map
Reporting
Optional method
16
Build a first value map, keep missing evidence visible, and give each unresolved outcome a next action.
Evaluation, program and investment teams preparing an SROI analysis
How Do You Track Budget and Actual Spend?
Track Budget vs Actual Spend
how-to-track-budget-invoices-actual-spend
Grant
Analyze
16
Multi-Rater Feedback: Connect Perspectives and Protect Context
Connect several perspectives on one person
several-people-describing-one-person
Feedback
Shapes
16
Design subject-rater relationships, reporting rules and a tested multi-perspective feedback record.
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
Compare candidate valuation sources and document why one fits your outcome, stakeholder and reporting period.
Evaluation and reporting teams selecting financial proxies
How Do You Analyze Grantee Reporting Longitudinally?
Analyze Grantee Reporting Over Time
analyze-grantee-reporting-longitudinal
Grant
Analyze
17
How Do You Compare Investees When Each One Defines Its Metrics Differently?
Compare & Benchmark Investees
compare-benchmark-investees
Portfolio
Chapters
17
Cross-Program Reporting: Combine Results Without Losing Meaning
Combine evidence across programs
many-programs-one-picture
Feedback
Shapes
17
Build a defensible cross-program result with comparable measures, correct denominators and documented exclusions.
How Do You Calculate the SROI Ratio?
Calculate the SROI Ratio With a Range
how-to-calculate-the-sroi-ratio
Reporting
Optional method
18
Build a reproducible SROI calculation, test its assumptions and explain the result in a reviewed report.
Evaluation and reporting teams reviewing an SROI calculation
How to Read Form 990 for a Grant Review
Read a 990 for Compliance
how-to-read-a-990-for-compliance
Grant
Analyze
18
How Do You Build Dashboards and Compliance Reports?
Build Dashboards and Reviewed Reports
dashboards-sroi-compliance-reports
Portfolio
Chapters
18
Plan evidence collection across your network
Run a member-network survey
member-network-survey
Feedback
Shapes
18
Design and test a member reporting cycle with continuing records, coverage checks and authorized results.
Ask Your Whole Grant Round Anything (Assistant + MCP)
Ask Your Whole Grant Round Anything
ask-your-grant-round-anything
Grant
Analyze
19
Produce portfolio reports that trace back to approved evidence
Produce the LP and Board Impact Report
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 Systems and Test Data Portability
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