play icon for videos
← Academy
SOPACT ACADEMY · CASE INTELLIGENCE · FOUNDATION

Theory of Change to Data Collection: A Four-Step Workflow

A one-page plan — one measure per outcome, a home and a moment for each measure, and a deliberate build order that starts with the workflow that shows value i

<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:23%"></span></div> <div class="ci-progress-label">You're here — Chapter 3 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-active" aria-current="step"> <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 class="ci-step-meta">You're here</span></span> </li> </ol> <div class="ci-group">Nonprofit Track</div> <ol class="ci-steps"> <li class="ci-step "> <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 "> <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 "> <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 "> <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 "> <a href="/academy/mentor-notes-early-warning" target="_blank" rel="noopener"> <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> </a> </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/review-applications-without-reviewer-bias" target="_blank" rel="noopener">Continue to Chapter 4 &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>

How do you turn a theory of change into a practical data-collection workflow?

Start with each outcome in your theory of change and ask four questions:

• What evidence would prove this outcome?
• What is the simplest measure that captures that evidence?
• Where and when should the measure be collected?
• Who owns the quality of that data?

Answer those four questions for every promised outcome and you have a working data-collection workflow.

Instead of collecting information because a form happens to ask for it, every field exists for a reason: to prove an outcome, test an assumption, support a program decision, or satisfy a reporting requirement.

In this guide you'll build that workflow in four steps:

1. Choose one defensible measure for each outcome.
2. Start with the workflow that creates visible value first.
3. Establish a baseline that makes change measurable.
4. Connect every measure to the right collection moment.

The result is a one-page collection plan that connects your theory of change to applications, intake forms, mentor notes, surveys, exit assessments, and follow-up data—creating evidence that can improve programs while they are still running, not just after they end.

As throughout this series, every step is tagged honestly. [DIY] steps can be completed in any AI chat window today. [SENSE] steps require a connected system that can receive data as it arrives, link this month’s answers to previous responses, and build a longitudinal record for each participant.

The one question that designs the workflow

A data-collection workflow may sound technical, but it begins with one question asked about every outcome:

What evidence would show that this outcome is occurring—and where would that evidence come from?

Your theory of change contains a series of claims: training increases confidence; confidence combined with a recognized credential improves employment prospects; placements remain stable six months later. Each claim needs a clearly defined measure, data source, and collection moment. Make those decisions for every outcome, and the structure of your workflow begins to emerge.

Important assumptions may also need evidence. If your theory assumes that employers continue to recognize a credential, for example, that assumption should become a monitoring question with its own source and collection schedule.

This reverses the way many organizations approach data collection. Most software starts with predefined forms—application, intake, case notes, discharge—and asks the organization to adapt its program to those forms. The resulting reports describe what the organization did but often cannot show what changed.

Here, the theory of change determines what gets collected. Every field must earn its place by supporting an outcome, testing an assumption, meeting a reporting requirement, or informing a decision.

Step 1 — Choose one measure per outcome [DIY]

For each outcome in your framework, ask:

What single number or answer would provide credible evidence that this outcome is occurring?

Start with one measure—not five. This is a minimum viable measurement approach: the simplest defensible evidence your team can collect consistently. More complex outcomes may eventually require multiple indicators, but beginning with one forces you to identify what matters most.

Then grade your current measurement honestly:

  • EVIDENCED — A relevant measure is already being collected, and its source can be traced.
  • UNPROVEN — The outcome is claimed, but the available data does not yet provide sufficient evidence.
  • MISSING — No defensible measure or data source has been identified.

These grades assess the current state of your evidence, not whether the program itself is succeeding. An UNPROVEN or MISSING label is not a failure; it identifies what your data-collection workflow needs to address.

Paste the following prompt into any AI tool, along with your theory of change, logic model, or a paragraph describing your program:

I run a [describe your program in one sentence]. Here are the outcomes we promise: [paste your theory of change, logic model, or a plain list].

For each outcome, suggest ONE simple way to measure it — a single question or number, with its scale (for example: confidence, self-rated 1–10). One measure per outcome, no more. Label each honestly: EVIDENCED if I told you data exists, UNPROVEN if we claim it but have no data, MISSING if nothing measures it. If no simple measure would truly prove an outcome, say MISSING — don’t invent one.
Example · measure map for a training nonprofit — at kickoff
Promised outcomeThe one measureScaleGrade today
Job-ready confidenceConfidence self-rating1–10, same wording at start, mid, and exitUNPROVEN claimed, no baseline yet
Skills credential earnedCredential Y/NY/N at exitEVIDENCED completion records exist
Living-wage employmentHourly wage + employed Y/N$/hr at six-month follow-upMISSING no follow-up wave exists
Ongoing support qualitySupport theme, classifiedfrom mentor notes, weeklyUNPROVEN notes exist, unread
Community-level change— no defensible measure yetMISSING honest, and stays out of the first workflow
Read it: the grades are supposed to look bad today — the UNPROVENs and MISSINGs are the map telling you what to build. And saying MISSING where nothing defensible exists keeps the rest of the map trustworthy.

Two notes on reading your own version of this table. First, the grades are supposed to look bad today — the UNPROVENs and MISSINGs are the map telling you what to build, and pretending otherwise only defers the problem to reporting season. Second, one measure beats five. A confidence question asked the same way at the start, middle, and end of a program reads as one line — 4.2 → 7.1 → 7.4 — three points, one story. Three different confidence instruments produce more data and less proof.

Step 2 — Choose your first workflow: lead with proof of value [DIY]

Here is where most initiatives go wrong, and where this chapter departs from the standard advice. The instinct is to build in journey order — intake first, then everything else. The better rule:

Build first the workflow where intelligence shows its value fastest — to your own team.

A first workflow earns its keep when three things are true: the work is already happening, it is drowning in qualitative input, and it is painful because of coordination. You aren’t asking anyone to collect new data or change behavior — you’re taking a pile everyone dreads and returning it read, scored, and cited in minutes. That early, visible win is what buys patience for the baselines and follow-ups whose payoff comes months later.

For most cohort-based programs, that workflow is the application:

  • The nonprofit’s training cohort opens with applications: personal statements, goal and barrier questions, sometimes an uploaded proposal. Reviewing them normally means recruiting a committee, aligning calendars for weeks, and accepting that reviewer #1 and reviewer #5 score by different private standards.
  • The accelerator’s or fellowship’s version is identical — proposals in, weeks of inconsistent review, decisions that arrive late.

Run that same pool through scoring-on-arrival and the contrast is immediate: every application scored against one rubric the moment it is submitted, each score backed by the applicant’s own words, the whole pool ranked and comparable — with no reviewer coordination at all. The time saved is measured in weeks; the consistency is something a committee cannot produce even in principle. That is the demonstration that turns skeptics into sponsors.

Ask your AI to pressure-test the choice:

Here is my measure map from Step 1: [paste it]. And here are the workflows my program already runs (for example: applications, intake, mid-program survey, mentor check-ins, exit survey, follow-up).

Which ONE workflow should I make intelligent first? Prefer a workflow that already exists, receives lots of open-ended text, and currently costs heavy coordination (like application review). Explain the trade-off of your top pick versus starting in journey order.

If your program truly has no application moment, the same logic points to whichever workflow holds the most unread words today — a backlog of session notes, a stack of open-ended survey answers. Start where the pile is.

Step 3 — Baseline next: the “before” that makes change provable [DIY]

The natural second workflow is the baseline — the pre-program or needs snapshot. Two reasons it comes right after applications, and not later.

The application often already is the baseline. The nonprofit’s application asked for confidence (1–10), current wage, goals, and barriers — because the admission decision needed them. Those same fields are the “before” half of every change claim the program will ever make. Stamp the application as your baseline wave and “pre” costs zero extra effort; no applicant fills a second, duplicate form.

Needs analysis pays off on day one, not at reporting time. Baseline answers, read on arrival, tell you who needs what before the program starts — the applicant whose barrier text says “no car, and the site is 40 minutes away” gets transport support in week zero, not a dropout flag in week six. A baseline is not just a future comparison point; it is the program’s first act of service.

The discipline that makes a baseline usable later: every measure you capture “before” must be re-asked at a named later moment, on the same scale, worded the same way. A 7.4 at exit proves nothing without the 4.2 it started from — and it proves nothing either if the intake asked the question differently.

Here is my application/intake form and my measure map: [paste both].
  1. Which application fields already serve as baseline measures — and for which outcome? (2) Which promised outcomes still have no “before” measure — and what one question would capture each? (3) Flag any measure whose later re-ask would use a different scale or wording — those pairs won’t be comparable. Group the result into: REUSE from application · ADD at intake · re-ask later at [moment].

Step 4 — Now design for change: pick your collection moments [SENSE]

With applications scored and a baseline locked, the remaining question is: where else does the journey speak? This is where the plan becomes a workflow map — and where it stops being generic, because the right moments depend on what your funders require and what your team needs to decide.

The common menu, from which each program picks:

  • Mid-program check-in — the same baseline questions re-asked, plus “what’s getting in your way right now?” Catches people drifting while intervention is still cheap.
  • Mentor, coach, or staff notes — recurring, unstructured, and the richest early-warning source a program has, if they are read on arrival instead of filed.
  • LMS or attendance signals — engagement data that already exists; connected to the record, it turns “quietly disengaging” into a visible pattern.
  • Exit — closes the before/after pair the baseline opened; completion alone is not change.
  • Follow-up (3, 6, or 12 months) — where the outcomes that matter actually live: employment, wages, persistence, placement durability.
  • The demand side — for the social enterprise: employer requirements, openings, and placements, so candidate supply and employer demand reconcile instead of living as two unrelated counts.

Choose against two lists: what your funder or board must see (their report defines mandatory moments), and what your team must decide (an early-warning list needs mid-program data; a staffing decision needs LMS signals). A moment that serves neither list is a survey nobody needed.

Why this step is [SENSE]. A plan on paper can name these moments; only a connected system makes them worth collecting. Two behaviors do the work. First, each stakeholder carries one ID across every form, so a mid-program dip lands next to that person’s baseline automatically — for example, confidence 4.2 → 7.1 → 7.4 across three waves, same people, same scale; or completers employed at follow-up at nearly double the rate of non-completers. Second, every arriving record is read on arrival, so each new moment you add starts producing signal its first week — not after an analyst clears the backlog. That is also what de-risks the phased build: add one moment, watch it work, add the next.

Example · workflow map — collection moments and what each one proves
MomentWhat's collectedWho provides itWhat it proves or enables
Application (build first)Goals, barriers, confidence baseline, qualitative answersApplicantFair admission on one rubric — and the baseline, at zero extra cost
Mid-program check-inSame confidence question + "what's in your way right now?"ParticipantEarly warning while intervention is still cheap
Mentor / staff notesTopics, progress, blockers — weekly, unstructuredMentorThe richest early-warning source, if read on arrival
LMS / attendance signalsEngagement data that already existsSystemMakes quiet disengagement visible
ExitSame measures as baseline + "would this have happened anyway?"ParticipantCloses the before/after pair — completion is not change
Follow-up (3–12 months)Employment, wage, persistenceParticipantThe outcomes that actually matter
Employer demand (social enterprise)Requirements, openings, placementsEmployerSupply and demand reconcile into one diagnosis
Choose against two lists: what your funder or board must see, and what your team must decide. A moment that serves neither is a survey nobody needed.

Common mistakes

Building in journey order instead of value order. Intake-first feels logical and dies quietly: months of collection before anyone sees a benefit. Lead with the workflow that returns a visible win in days — usually applications — and let it fund the patience for the rest.

Measuring the end without the beginning. Every “after” needs a “before” on the same scale. Baselines are the cheapest thing to collect and the most expensive to reconstruct.

Adding collection moments no one asked for. Every moment must serve the funder’s report or a real decision your team makes. Anything else lowers response rates and goodwill.

Merging instead of connecting. Don’t flatten everything into one giant spreadsheet; keep each moment’s data where it lands and connect through one ID. It’s the missing ID, not the missing field, that silently breaks the story.

How does a theory of change guide data collection?

A theory of change guides data collection by identifying the outcomes and assumptions that require evidence. Each outcome should be mapped to an indicator, data source, collection method, responsible person, and collection moment. This prevents organizations from collecting information that is easy to count but cannot show whether stakeholders experienced the intended change.

How do you turn a theory-of-change outcome into an indicator?

Start by rewriting the outcome as an observable change in a defined population. Then ask, “What would we expect to see if this change occurred?” Select one practical measure that captures that evidence, define its scale, and identify when and from whom it should be collected. Use the same wording and scale at baseline and follow-up whenever change over time must be measured.

What should a theory-of-change data-collection plan include?

A practical plan should include the outcome, indicator, data source, collection method, responsible person, collection frequency, baseline moment, follow-up moment, and participant identifier. It should also include monitoring questions for important assumptions. Every data field should support an outcome claim, test an assumption, satisfy a reporting requirement, or inform a program decision.

Can an application form be used as a baseline?

Yes, when the application is completed before services begin and captures the same outcome measures that will be repeated later. For example, an application can establish initial employment status, wage, confidence, goals, or barriers. It should not be treated as a baseline when questions, scales, or participant identities cannot be matched reliably with later responses.

What is the difference between a data-collection plan and an M&E plan?

A data-collection plan specifies what information will be collected, from whom, when, how, and where it will be stored. An M&E plan is broader: it also defines indicators, targets, responsibilities, analysis methods, learning questions, reporting schedules, and how findings will influence decisions. The workflow in this article forms the data-collection foundation of the broader M&E plan.

How often should outcome data be collected?

Collect outcome data when meaningful change could reasonably occur and when the result can inform a decision. Common moments include baseline, mid-program, exit, and three-, six-, or twelve-month follow-up. More frequent collection is not automatically better. Every collection moment should support a comparison, reporting requirement, early intervention, or program decision.

Should every theory-of-change outcome have an indicator?

Every outcome the organization intends to manage or report should have at least one defensible indicator. Some long-term or system-level outcomes may be beyond the organization’s practical measurement capacity. Those should be marked clearly as unmeasured or contribution-level outcomes rather than supported with weak proxy measures.

See an application pool scored on arrival in Sopact Sense — sopact.com/academy.

Next in the series: How to Review Applications Without Reviewer Bias — the workflow you just chose first, built end to end: one rubric, every application scored the moment it arrives, every score backed by the applicant’s own words.

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