play icon for videos
← Academy
SOPACT ACADEMY · IMPACT MEASUREMENT · EMBED

How to Collect Clean Data Inside Your Workflow

Collect the right evidence at the right moment. Connect forms, files and follow-ups with clear definitions, practical checks and a person responsible for review.

Sopact Academy · Course review

Practical Academy guide

How to Collect Clean Data Inside Your Workflow

To collect clean evidence inside the workflow, assign every item in your Reporting-to-Evidence Map to the moment when it can be observed accurately and used. Define the minimum signal, the context needed to interpret it, the person responsible, the identity and timestamp that connect it to later records, the action it can trigger, and the follow-up that shows what changed. Clean evidence is not merely a validated form. It is evidence captured close enough to the work that the team can still respond.

This lesson is for program, MEL, grant, foundation, portfolio, and data leads who have completed the reporting-to-evidence map. You will turn that map into a Collection-Moment Plan that works across enrollment, attendance, service delivery, follow-up, interviews, case notes, partner documents, and emails.

What you will produce

  • A natural collection moment for every required evidence item.
  • A minimum operational signal plus a neutral context question where the signal cannot explain itself.
  • An owner, timestamp, identity rule, validation rule, and action trigger.
  • A follow-up event that shows what happened after the program response.

How do you turn an evidence map into a collection workflow?

  1. Start with a decision. Take one row from that map and state what someone could decide if the evidence arrived on time.
  2. Choose the natural moment. Place the evidence at enrollment, first service, completion, follow-up, interview, case action, partner submission, or document review.
  3. Capture the minimum signal. Record the smallest observable event or value that answers the operational question.
  4. Add context only where needed. Use one neutral open question, an interview, a note, or a source document when a number cannot explain why it changed.
  5. Connect and govern the record. Preserve person or entity, source, timestamp, stage, consent/access, validation, and review status.
  6. Define action and follow-up. Decide who sees the signal, what they can do, and which later record shows what happened after the response.

What does “clean evidence at the source” actually mean?

Collecting clean data at the source means checking its definition, identity, timing and origin when it arrives. These checks reduce avoidable errors; they do not guarantee that every submitted statement is true. Valid dates and allowed values matter, but they are only one part. A perfectly formatted attendance record is still weak evidence if it is attached to the wrong participant, entered weeks late, or cannot be linked to the staff response that followed.

From reporting requirements to collection
Reporting-to-Evidence Map
What must be known, which approved measure answers it, and what evidence could support it.
Collection-Moment Plan
When it appears → what is captured → who reviews it → what action follows.
Live evidence loop
Signal, context, program response, and follow-up remain connected over time.

This distinction changes the design question. Do not ask, “Which survey should we send?” Ask, “At which moment could we observe this evidence with the least burden and still do something useful with it?” Sometimes the answer is a form. It may also be an attendance event, an existing case note, an employer email, a partner PDF, a short interview, or an action already recorded by staff.

Use Moment → Signal → Context → Action → Follow-up

These are five fields to consider in a collection plan, not another course sequence. Use the fields needed to explain one observation and its follow-up. The moment says when evidence appears. The signal says what happened. Context explains what the signal cannot. Action records the program response. Follow-up shows whether the situation changed.

01 · Moment
When can this be observed naturally?
02 · Signal
What is the minimum event or value?
03 · Context
What do we need to understand why?
04 · Action
Who responds, how, and by when?
05 · Follow-up
What later evidence shows change?

These parts should not be collapsed. Attendance is a signal, not an explanation. A participant statement is context, not automatically a metric. A referral is a program action, not proof that the problem was resolved. A later attendance event may show re-engagement, but it does not by itself prove why the change occurred.

Worked example: youth enroll but do not attend the first session

Enrollment alone can hide the earliest point of disengagement. Record first-session attendance as a separate event, ask a neutral question when a young person does not attend, connect the answer to a staff response, and observe whether the person joins a later session.

Fictional teaching scenario: a youth program has enrollment records but does not consistently connect them to first-session attendance. Staff need to see missing or absent attendance promptly and ask what happened, rather than infer a cause from the enrollment total.

The mistake would be to begin with a long barrier survey or assume that the cause was fees. Transport, care responsibilities, safety, timing, family expectations, confidence, health, or something the team has not considered may matter. The first useful question is deliberately open:

One neutral context question
“What, if anything, made it difficult for you to attend the first session?”
It does not presume that a barrier existed or tell the young person which explanation the program expects.

Preserve the exact response. AI or a human may later code recurring themes, but the theme must remain connected to the source words. Do not infer a sensitive circumstance that the participant did not state. In this fictional example, staff can follow up through an approved contact channel to understand whether financial hardship—or another barrier the young person identifies—made attendance difficult. This account does not establish that financial support was offered or promised.

Part Proposed evidence What it can tell the team What it cannot prove
MomentFirst scheduled sessionThe earliest planned participation pointWhether enrollment reflected commitment or access
SignalAttended / did not attend / attendance not recordedWho may need timely follow-upWhy someone was absent
ContextExact response to the neutral questionThe participant’s stated experienceA diagnosis or complete causal explanation
ActionStaff outreach to understand the barrier, including possible financial hardship; owner and date recordedHow the program followed upThat financial support was offered or that the outreach resolved the barrier
Follow-upAttended a later session, remained unreachable, declined, or exitedWhat happened after the responseThat the program alone caused the later outcome

Example boundary: these are proposed collection fields for a fictional program, not a customer’s instruments or demonstrated outcomes.

Why do you need quantitative, qualitative, and longitudinal evidence together?

Quantitative evidence identifies the pattern, qualitative evidence helps explain the participant’s experience, program records show the response, and longitudinal evidence shows what happened next. None should impersonate the others.

Pattern
Quantitative: enrollment, attendance, completion, follow-up status.
Experience
Qualitative: participant words, interview, observation, case note.
Response
Operational: contact, referral, schedule change, owner, date.
Change over time
Longitudinal: first session → response → later participation.

This also reduces survey burden. Do not ask participants to repeat information that already exists in attendance, case, partner, or document records. Ask only for evidence that the workflow cannot observe—especially the person’s experience, priorities, and interpretation. A short, well-timed question can be more useful than a long end-of-program survey that arrives after the opportunity to help has passed.

Can clean evidence reveal a problem you did not plan to measure?

Yes. A useful evidence workflow must preserve unexpected observations, not only answers to predetermined metrics. The observation needs a source, place, timestamp, owner, response, and resolution status so that it becomes actionable rather than disappearing inside a message or someone’s memory.

In a separate fictional example, a staff member reports a water leak during program delivery. A water leak is not an outcome indicator, yet it can affect safety, program delivery, cost, and attendance. If the system accepts only the metrics selected at the start, this kind of operational evidence can remain buried until it becomes a larger problem.

Unexpected evidence
A water leak is observed or reported at a program site.
Make it traceable
Retain the description, source, location, time, and any supporting image or note.
Close the loop
Assign an owner, record the response, and verify whether the issue was resolved.

The point is not to add “number of water leaks” to the theory of change. It is to connect field intelligence to action. Metrics describe expected signals; open text, observations, interviews, messages, and documents preserve what the team did not know to ask. Both belong in the same governed evidence workflow.

What belongs in a Collection-Moment Plan?

For each evidence requirement, document the natural moment, minimum signal, context source, identity and timestamp, owner, validation, action threshold, access rule, and follow-up. If nobody will review or act on the evidence, question whether it should be collected.

Evidence requirement Moment Signal / context Identity + time Owner + validation Action + follow-up
First-session participationFirst scheduled sessionAttendance status; neutral question if absentParticipant ID; session ID; event timeFacilitator; separate “not recorded” from “absent”Staff follow-up; observe next attendance
Participant barriersWhen risk appears—not only at exitExact words; confirm whether financial hardship or another barrier appliesParticipant ID; Contact source; response timeAssigned staff; source text retainedDocument outreach and later status; do not imply unconfirmed assistance
Unexpected site conditionWhen observed during program deliveryExact observation; supporting note or image if availableSite; source; observation timeAssigned owner; validate location and current statusRecord response and verify resolution
Partner delivery evidencePartner’s normal reporting or service eventStructured values plus source documentPartner; site; period; upload datePartner owner; completeness and definition checkMissing-evidence alert; next partner review

How do you collect and clean data without another spreadsheet pass?

Put predictable checks into collection, then send uncertain cases to a named reviewer. Keep the original submission and a correction history. Cleaning should resolve an error with evidence, not replace an inconvenient value with an assumption.

The Government Data Quality Framework distinguishes completeness, uniqueness, consistency, timeliness, validity and accuracy. It recommends attention to quality at source. A complete record can still be inaccurate, and a valid date can still be the wrong date. The examples below apply those distinctions to this course’s collection plan.

CheckWhat can happen at collectionWhat still needs review
CompletenessIdentify a required reporting period or missing supporting documentDistinguish not collected, declined, not applicable and unknown; do not fill missing outcomes with zero
UniquenessFlag a repeated submission ID or possible duplicate contactCheck whether this is a correction, another event or a different person; preserve legitimate repeat observations
ConsistencyCompare the form’s period, currency and total with the attached partner reportAsk the owner to resolve differences; retain both source values until resolved
TimelinessKeep event time separately from submission time and flag overdue updatesDecide whether late evidence belongs in the current report or a documented revision
ValidityCheck allowed statuses, formats and agreed rangesInvestigate unusual but possible values rather than automatically rejecting them
AccuracyRequest a source or confirmation appropriate to the measureCompare with that evidence; a format check alone cannot establish truth

Practice: receive a quarterly partner update

Fictional exercise. Partner P-024 sends a quarterly form, a financial report and a social audit document. The form says Q3 but the attached financial report covers Q2. Do not silently relabel the file or accept it because an upload exists.

  1. Keep the submission attached to P-024, with its submitted period and received timestamp.
  2. Flag the period mismatch and route it to the partner reporting owner.
  3. Request the correct document, or record a justified exception with its limitations.
  4. Retain the original and the replacement with version and review status.
  5. Allow only approved values into the Q3 report; show any unresolved gap.

For a social audit finding, keep the finding reference, action owner and closure evidence together. A checked box stating “resolved” is a claim to review, not sufficient evidence by itself.

When should a check warn rather than block?

Block a submission only when the field is necessary and the person can reasonably correct it. For an uncertain outcome, provide an appropriate unknown or declined option. A hard-required outcome can encourage a guess. Keep warnings understandable: explain which field conflicts, which period is expected and how to contact the owner. Pilot the form with actual users before rollout.

How do you keep collection useful without overloading staff and participants?

Reuse evidence already created by the work, collect only what can change a decision or satisfy a justified requirement, and place each question with the person and moment best able to answer it. More fields do not create more insight.

  • Do not duplicate operational evidence. If attendance already exists, link it; do not ask the participant to report it again.
  • Do not collect context from the wrong person. Staff can record an action; participants should describe their own experience.
  • Do not ask too early or too late. Baseline belongs before the service can affect the measure; a barrier question belongs when the barrier becomes visible.
  • Do not force narrative into a number. Keep exact text, approved codes, and AI interpretation separate.
  • Do not confuse missing with negative. “Attendance not recorded,” “did not attend,” “declined to answer,” and “unreachable” are different states.
  • Do not create an alert without an owner. A risk signal needs a responsible person, response window, and documented resolution.

Prompt: turn the evidence map into a Collection-Moment Plan

Prompt
You are preparing a DRAFT Collection-Moment Plan for human approval. INPUTS 1. Approved Reporting-to-Evidence Map 2. Approved Metric Definition Sheets 3. Actual workflow stages and staff roles 4. Existing forms, attendance records, case notes, emails, interviews, partner reports, and documents 5. Consent, privacy, access, retention, and safeguarding rules FOR EACH EVIDENCE REQUIREMENT RETURN - Decision the evidence supports - Natural collection moment - Minimum quantitative or documentary signal - Neutral context question or source, only where needed - Person/entity ID, source ID, program stage, and timestamp - Owner and collection channel - Validation and missing-state rules - Access and consent rule - Action trigger, reviewer, and response window - Follow-up evidence and review cadence RULES - Reuse existing evidence before creating a new question. - Never assume the cause of a signal; use neutral wording. - Keep participant words, approved codes, staff actions, and AI interpretations separate. - Do not infer sensitive attributes or convert narrative into an unsupported number. - Distinguish absent, not recorded, declined, not applicable, and unreachable. - Flag any evidence with no decision, owner, or justified reporting requirement as REMOVE OR JUSTIFY. - Mark uncertain items NEEDS HUMAN REVIEW. OUTPUT 1. Collection-Moment Plan 2. Questions or fields to remove 3. New collection or integration work required 4. Alerts and actions requiring an owner 5. Privacy, consent, or safeguarding decisions

Where can AI help—and where must people decide?

Configured validation rules can check formats and required fields. AI can propose themes, summarize evidence and flag possible contradictions; record matching and all important interpretations need appropriate checks. People decide what to ask, whether a theme is valid, what action is appropriate, and how participant rights are protected.

AI can assist
  • Use configured rules for types, required values and missing states; review possible duplicates
  • Connect evidence using approved identity rules
  • Propose themes while preserving exact source text
  • Flag a no-show, missing partner file, or contradictory record
  • Draft a cited summary from approved evidence
People remain responsible
  • Approve the question and collection moment
  • Confirm the meaning of a qualitative theme
  • Choose an appropriate program response
  • Review sensitive or high-stakes interpretations
  • Set consent, access, retention, and safeguarding rules

Where does Sopact Sense help?

A small team can maintain a Collection-Moment Plan in a spreadsheet and use its existing forms and folders. Friction grows when evidence arrives through many channels, the same participant or partner appears across records, open text accumulates unread, partners use different definitions, and nobody sees a gap until reporting begins.

A configured Sopact Sense workflow can collect forms and uploaded documents against the relevant contact or partner, with agreed imports for other sources. Set the definitions, permissions and review rules before applying AI analysis to incoming evidence. Teams can review proposed themes, inspect sources and ask questions across the linked record over time. Validate any record matching and alerts with sample submissions; a proposed match is not permission to merge two people. Staff validate themes, approve actions, and retain final authority.

For decisions affecting people, test collection and analysis across languages and access needs, document overrides, restrict sensitive records, establish retention rules, and monitor whether alerts or classifications affect groups differently. Faster evidence is useful only when it remains responsible and reviewable.

Watch: connect collection moments across a program

Watch the 4-minute 13-second Sopact demonstration using synthetic participant data. Follow how application, baseline and follow-up records connect; then identify the equivalent collection moments in your own workflow.

Browse the video library.

Frequently asked questions

How do you collect clean evidence inside a program workflow?

Start with a justified evidence requirement, place it at the moment it naturally appears, capture the minimum signal, add neutral context only when needed, and preserve identity, source, stage, timestamp, consent, and validation. Assign an owner and action trigger, then identify the later evidence that shows what happened after the response.

Is clean data at the source just form validation?

No. Form validation prevents invalid types and values, but clean evidence also requires the correct definition, participant or entity, source, collection moment, timestamp, missing-state rule, and provenance. Evidence can be technically valid yet operationally useless if it arrives too late or cannot be connected to an action and follow-up.

What is a collection moment?

A collection moment is the point in real work when evidence can be observed with the least distortion and burden—for example application, enrollment, first session, service delivery, completion, follow-up, interview, case action, partner submission, or document review. It is more specific than choosing a survey frequency.

How do you ask why someone did not attend without leading them?

Begin with neutral wording such as, “What, if anything, made it difficult for you to attend?” Do not assume the barrier was fees, transport, safety, motivation, or another expected category. Preserve the exact answer; confirm a structured category only when required for action or analysis.

Should every metric have an open-ended question?

No. Add qualitative context when the signal cannot answer a decision-relevant “why,” when participant experience is itself required evidence, or when the team needs to design an appropriate response. Routine operational events may need no extra question. Repeated unnecessary questions create burden and weaker answers.

How do you connect the same person across enrollment and follow-up?

Use one governed participant identifier across events and keep event-specific identifiers and timestamps for each collection moment. Define duplicate resolution, consent, access, and identity-correction rules. Do not rely on approximate name matching as the normal method, especially when records affect services or reporting.

Can emails, case notes, and partner PDFs be collected as evidence?

Yes. Preserve the source, author or organization, date, reporting period, relevant entity, access rule, and citation. Extracted values or themes should link back to the document passage. A file’s existence does not make every statement accurate, comparable, or sufficient; validation and human review still apply.

What happens after the Collection-Moment Plan is operating?

Test whether the same governed evidence produces stable results across repeated analyses. Review missingness, duplicates, definition drift, coding changes, late entries, and contradictory sources. The consistency reference shows how to control those conditions so a result does not change merely because a different person prepared the report.

Sources and example boundaries

  • Open Play Foundation — public organization and program context.
  • The existing published lesson attributes the first-session, WhatsApp, possible-financial-hardship and water-leak observations to a field account shared by Marco Botha through Sopact. These details are not a published outcome evaluation; the public source establishes the organization and program context. The table fields are a reusable design derived from that account, and the article makes no claim that financial assistance was offered.

Related practice: Your evidence is now captured with a governed definition, source, identity, timestamp, and collection moment. The consistency reference shows how to keep the analysis stable in How Do You Get the Same Numbers Every Time? →

For the final reporting stage, use How to Write an Impact Report and report examples.

By Sopact Academy · Revised September 12, 2026. The proposed collection plan is a practical worksheet; field-account boundaries are stated above.

Return to your course →

Put this guide into practice.

Bring one recurring collection workflow. Identify where evidence gets lost and which checks your team needs.

Explore Impact Measurement →
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