play icon for videos
← Academy
SOPACT ACADEMY · CONNECTED DATA INTELLIGENCE · CONNECT

How to Collect Feedback Offline and Track the Same People Over Time

Collect offline, keep every visit on one ID, and count the hand-offs between sync and answer. Includes a field protocol and a KoboToolbox and SurveyCTO comparison.

Sopact Academy · Course review

Academy / Membership & networks / Deep dive

Practical Academy guide

How to Collect Feedback Offline and Track the Same People Over Time

Load the form and the people you will visit before you leave connectivity, give every person or household an ID at the first form, and confirm each sync before you clear the device. Then count the hand-offs between the sync and an answer. With KoboToolbox or SurveyCTO, the data usually leaves the tool for export, cleanup, label and language choices, reshaping and Power BI. With Sopact Sense, each offline response lands on the person’s record and is read as it arrives.

Additional course links
Collect feedback offline, KoboToolbox and SurveyCTO compared: collect offline, know now. Field tools capture well without a connection; the long part starts after sync. KoboToolbox and SurveyCTO: after the sync, the hand-offs begin, 5 hand-offs every round: 1 collect offline, the device queues responses; 2 export, generate, download or pull by API; 3 clean, test rows, duplicates and typed IDs; 4 labels and language, values or labels and one language per export; 5 transpose, repeat groups arrive as separate sheets; 6 Power BI, merge, model and refresh. Each new round starts the chain again. Sopact Sense: one record from the first form, the power of now, 0 hand-offs: 1 collect offline with the same form, syncing when back online; 2 lands on the ID issued at the first form, every visit after; 3 read on arrival, open answers and scores per person; 4 ask now, every line links to its record, for example which households were visited twice. Governed by your organization, managed by your team, no IT ticket. When offline collection outgrows export and rebuild: several sites, repeat visits, several devices, several languages, shared reporting.
At a glance: offline capture is not where these tools differ. The difference is what happens after the sync: five hand-offs before a dashboard with KoboToolbox or SurveyCTO, or none when every visit lands on the person’s ID in Sopact Sense. The field-tool steps come from each vendor’s public documentation, linked in the table below.

How do you collect feedback offline and keep it connected?

In short: Capture offline on a prepared device, give each person or household one ID at the first form, and sync every visit to that same record. How fast you learn is decided after the sync: either the response lands on a continuing record you can question today, or it lands in an export that has to be cleaned, relabeled, reshaped and loaded into a dashboard first.

This lesson is for program and evaluation teams who visit the same people more than once where connectivity is weak: household visits, clinic follow-ups, training sites and partner field teams. You leave with a field protocol, a reconciled test batch and a hand-off count for the workflow you use today.

  1. Define the unit you follow (person, household, site or partner) and issue its ID at the first form.
  2. Load the form version and the permitted roster on every device while it is still connected.
  3. Record each visit with its own visit date, the subject ID and the form version.
  4. Sync, then confirm receipt of every expected visit before anything is cleared from the device.
  5. Reconcile late uploads, retries and conflicting updates, and keep uncertain matches visible.
  6. Count the hand-offs between the sync and an answer your team can act on.
  7. Read the round while it is still open, and carry what you learn into the next visit.

Where does the time go after an offline round?

In short: Mostly after the sync. Field tools capture reliably without a connection. The delay comes from the steps between a synced response and an answer, and those steps repeat every round.

KoboToolbox and SurveyCTO are capable field-capture tools, and many teams run them well. Their own documentation shows what happens next when the analysis lives in another tool:

Five hand-offs between sync and answer, as each tool documents them
Hand-offKoboToolboxSurveyCTO
1. ExportGenerate an export, then download it as XLS, CSV or SPSS, or copy a synchronous export URL from the API (export guide).Export from the server console or SurveyCTO Desktop, or connect through the REST API (API guide).
2. CleanSomeone removes training tests, upload retries, duplicate registrations and mistyped IDs. The export cannot know which rows are the same person.
3. Labels and languageChoose question labels or data column names, choice labels or XML values, and the label language for each export.Choose choice values, or values and labels, and the label language; Desktop falls back to the default form language (export options).
4. TransposeRepeat groups export as separate sheets linked by _index and _parent_index. KoboToolbox notes that merging individual and roster data inside the system is not available and points to Excel Power Query (merging guide).Repeat groups export in wide format, or in long format with each repeat group in its own file or sheet (data format).
5. Power BIPaste the export URL into Power BI, transform the data in Power Query, set table relationships for repeat groups, then click Refresh for new data (Power BI guide).Connect the API URL, convert it to a table, expand the columns, which all arrive as text, set their types, then click Refresh (Power BI guide).

Each step is reasonable on its own. Together they mean the answer waits for whoever owns the export, and the chain starts again with the next round. A dashboard refresh brings in new rows; it does not decide which rows belong to the same person, and it does not read what people wrote in the open questions.

The hand-off count: a test for any field workflow

In short: Count the steps between a synced response and an answer your team can act on. Each hand-off adds delay, a chance of error and one more person the workflow depends on.

Run the count on one recent round. List every step from the sync to the report: what was done, in which tool, by whom, and how long the result waited. Then ask three questions:

  1. Does every visit land on the same person or household without a merge?
  2. Can someone ask a question of this round today and trace every answer to a record?
  3. If the person who builds the export leaves, does the workflow still run next round?

Zero is the target, not a rule. Some evaluations still need a statistical package for the final analysis. The test is whether routine questions wait for the chain: who was visited twice, who is missing a follow-up, and what people said about the service.

Start with the person, the visit and the submission

Consider a fictional fieldworker visiting one household in March, July and November. The household ID identifies the unit being followed. A visit ID distinguishes each encounter. The form version identifies the questions asked. The submission ID identifies the uploaded response. These identifiers serve different purposes and should not be substituted for one another.

A tablet’s upload order does not establish event order. Record when the visit occurred separately from when the response reached the server. If a different household member answers, keep the respondent’s role rather than assuming the same person supplied every answer.

Missing identifiers make reconstruction harder, but they do not prove that earlier evidence is lost. Authorized reconciliation may be possible from adequate source information. Keep uncertain matches visible and explain how unmatched records affect the analysis; do not force a match to complete a chart.

Choose what must work without a connection

Write down the actual offline tasks: open a form, select an existing household, add a new participant, save an attachment, validate a response and resume an interrupted visit. A tool supporting one task offline does not mean every lookup, file type or analysis feature works offline.

KoboToolbox’s web-form documentation requires opening and caching a form while connected before offline use. Responses queue locally and upload after reconnection, and clearing browser site data can delete queued work. KoboCollect’s Android documentation describes downloading deployed forms before collecting without a connection, with draft, finalized and sent as separate stages. Train fieldworkers to tell those states apart rather than treating “saved” as “received.”

Sopact Sense forms also collect offline and sync when the connection returns. Whichever tool you use, test the exact device, browser and form features your team will carry before the first real visit.

What an identifier has to survive

Four identity checks for a repeated field visit
ChangeWhat to test
A different deviceThe next fieldworker can select the correct authorized subject; an upload arriving late keeps its visit date.
A different fieldworkerThe protocol explains how to confirm the subject without relying on a colleague’s memory.
A long gapChanged contact details do not create a new person; household changes follow an explicit rule.
A lost card or forgotten codeA permitted recovery process exists; uncertain identity is flagged rather than guessed.

Design the ID for the unit you follow. A household splitting into two is not the same situation as a person changing phone number. Record a documented relationship or change event when the real-world unit changes; keeping the old label alone may misrepresent the history.

Self-generated codes can work in some study designs, but test their stability, uniqueness and disclosure risk: people interpret the instructions differently on later visits, and two people may produce the same code. System-issued codes need a retrieval process too. Do not rely on a phone number or a name alone; numbers are shared and reassigned, and names are transliterated differently.

How do KoboToolbox and SurveyCTO follow the same person?

In short: Both can link visits, but the link is something you design and maintain alongside the forms. In Sopact Sense, the ID issued at the first form is the record, and every later form is added to it.

KoboToolbox offers dynamic data attachments: a follow-up form looks up values from a parent project through a matching identifying question. Its documentation lists the limits: parent data must be submitted and downloaded to the device first, values cannot be pulled from repeat groups, and choice names appear instead of labels. SurveyCTO offers case management: cases sit in a cases dataset with an id and a label column, forms are linked through a formids column, and published form data can update existing cases or create new ones.

Teams that set these up carefully get reliable follow-up visits. The analysis still happens after export. In Sopact Sense, the first form issues the ID, and the next visit, the follow-up survey, an interview note or public data loaded as a survey are added to that same record, so the history is already together when someone asks a question.

Prepare a field protocol before the first visit

  1. Define the unit and ID. State whether you follow a person, household, facility or partner. Decide how repeat visits connect and how a genuinely new unit is registered.
  2. Prepare permitted reference data. Give fieldworkers only the roster information they need. Test whether it stays available offline and how updates reach the device.
  3. Prevent ID collisions. If codes are issued offline, use an agreed unique-ID method or allocated ranges across devices and sites. Test the same new-registration scenario on two devices.
  4. Load and test the right form version. Check language, branching, required fields, ranges and attachments without a connection. Keep the version with each response.
  5. Explain local storage. Fieldworkers should know how to save, resume, finalize and confirm an upload, and which actions could remove unsent records.
  6. Plan exceptions. Define what happens after a lost device, an interrupted visit, a duplicate registration, a changed permission or a failed upload.
  7. Reconcile the batch. Compare expected visits, the local queue and accepted server records. Resolve discrepancies before removing local data under the agreed retention procedure.

If a mapping links codes to identifiable people, control access to it and keep the analytical view separate. Avoid printing sensitive program information on a card that could expose a participant if someone else found it.

What changes when two devices are offline?

Device A may record a new address while device B holds an older roster. When both reconnect, the server needs a policy for updates and conflicts. “Last uploaded” is not necessarily “most recent event,” and a silent overwrite can hide a valid observation.

ODK documents Entities for longitudinal and case workflows, including information shared between forms and conflict handling. Use your own tool’s documentation to design the test, and verify the exact relationships, permissions and conflict handling rather than relying on a feature name.

Test a late submission, a repeated upload and two different updates to one subject. Keep distinct visit records. If a current attribute changes, keep enough history to show which source supplied it and how a conflict was resolved. Do not count an upload retry as another visit.

Practice: reconcile a partner’s field batch

Use fictional Partner P-024 for this exercise. A partner’s field team makes three authorized visits. Two devices synchronize in a different order from the visits, and one upload is retried.

Fictional batch: visits and uploads are different counts
RecordSubject and eventExpected result
V-101H-014 · September 2 · device AOne visit, even if uploaded after V-102
V-102H-014 · September 9 · device BA second visit linked to the same household
V-103H-015 · September 9 · device AA separate household and visit
Retry of V-102Same submission attempted againRecognized as a retry; not a fourth visit

The expected result is three visits across two households, once the IDs and the retry have been checked. There are four transmission attempts. A transmission count is not a participant, household or visit count.

Add one conflicting address update and one record with an unrecognized subject ID. Do not invent the answer that makes the total reconcile. Record the conflict, keep the source and ask the authorized reviewer to resolve it. Your batch note should state what was accepted, what remains unresolved and whether any record is left out of a report.

Now count the hand-offs for this batch. In an export workflow, the visits reach the team as rows: someone removes the retry, checks the IDs, merges any roster sheet and refreshes the dashboard before anyone can say that household H-014 was visited twice. In Sopact Sense, both H-014 visits sit on one household record once they sync, and the team can ask which households had a second visit and open each record behind the answer. The conflict and the unrecognized ID still go to a person; no tool should guess them.

Where Sopact Sense fits: the power of now

In short: Sopact Sense keeps offline collection, the continuing record and the analysis in one place, so a round can be read while it is still in the field.

You can run this method with any field tool and a spreadsheet: issue IDs carefully, reconcile each batch and rebuild the report every round. That holds up for one site and one round. It slows down as sites, devices, languages and rounds multiply, because every round repeats the export chain and depends on the person who knows it.

In Sopact Sense, the ID is issued at the first form and every later form is another workflow on the same record. Forms collect offline and sync when the connection returns. As responses arrive, the Intelligence Cell reads each open-ended answer and the Intelligence Row summarizes each person across visits. The AI Assistant answers questions about the round, such as which households are missing a follow-up, with every line linked to the record behind it, and it works only on the surveys you pick. You choose which fields reach the AI, so names and phone numbers can stay out of the model, and each team’s folder limits what its assistant can see. Your team sets this up and runs it, with no IT ticket.

People still decide. A conflicting update, an unrecognized ID or a household split needs a named reviewer. The AI reads and summarizes; it does not settle identity or replace the field protocol.

Privacy: a linked record is not necessarily anonymous

Replacing a name with a code may protect some uses of the data, but a retained mapping can still identify the person. The UK Information Commissioner’s guidance distinguishes pseudonymisation from anonymisation and stresses protecting the additional identifying information. Do not describe a follow-up system as anonymous because the report hides names.

Agree what participants are told about collection, follow-up, access and retention. A request not to be contacted again is different from a request about data already collected; follow the applicable protocol for each. Offline devices may not hold the latest permission status, so define how fieldworkers get current instructions. Before giving data to an assistant, continue with the lesson on AI access to stakeholder data.

What should you verify when choosing a tool?

  • Which forms, reference lists and attachments work offline on your supported devices?
  • Can staff tell a draft, a queued response and a confirmed server receipt apart?
  • Does the ID issued at the first form carry every later visit without a merge?
  • How are new IDs issued across sites, and how are duplicates or uncertain matches reviewed?
  • How are late updates, retries and conflicting edits handled?
  • How many hand-offs sit between a synced response and an answer, and who owns each one?
  • Are open-ended answers read as they arrive, or coded after export?
  • What happens to unsent work after a restart, low storage, logout or a lost device?

Do not assume an XLSForm import preserves every feature in another product. Test a representative form with its real calculations, repeat groups, translations, media and validation before promising a migration route.

Run the test before field deployment

Use a safe test environment with representative history. Put two devices offline, complete the fictional batch, restart one device, reconnect in reverse order and inspect the received records. Test the real form features and the permissions each role needs.

Pass when every expected visit can be accounted for, duplicates are handled by the documented rule, uncertainty is visible, the source context survives and your team can answer a routine question about the batch the same day. Human review of an ambiguous case is not failure. An unnoticed merge or a missing submission is.

After the test passes, release the field protocol and check the first real batch closely. Keep a named owner for synchronization problems and unresolved identity questions. Connectivity, battery, storage and training remain operational concerns whichever software you choose.

Watch: why collected evidence needs its record context

Watch the video · 2 minutes 34 seconds. This is a companion explanation of connected evidence, not a demonstration of offline device support. Use the field test above to verify offline behavior in your chosen configuration. Explore more explainers in the video library.

Frequently asked questions

Can a survey work with no internet connection?

Yes, if the form and the reference data it needs are on the device first. KoboToolbox, SurveyCTO and Sopact Sense all collect offline and sync later. An ordinary online survey link does not work offline. Test the supported device, browser and form features before deployment.

Is Sopact Sense an alternative to KoboToolbox or SurveyCTO?

Yes, for teams that follow the same people over time and need answers during the round. All three collect offline. The difference is after the sync: Sopact Sense issues the ID at the first form, adds every later visit to that record and reads responses as they arrive, instead of handing data to an export, cleanup, reshaping and a dashboard.

Do we still need Power BI?

For routine questions about a round, often not, because the AI Assistant in Sopact Sense answers them on the record with each line linked to its source. Teams with an established dashboard or a statistical analysis plan can keep those tools for the final analysis. The change is that they stop being the only route to an answer.

Is saving a response the same as uploading it?

No. A draft or locally queued response may not have reached the server. Confirm receipt and reconcile the expected batch before removing local copies under the retention procedure.

Can a system-generated ID make the survey anonymous?

Not by itself. If a mapping or other information can identify the person, hiding the name does not make the data anonymous. Describe the actual confidentiality and follow-up arrangements accurately.

What if a household is not on the roster?

Use the approved new-registration process and unique-ID method. Flag any doubt about whether the household already exists; do not create or merge records only to finish the form.

How do we handle a household that moves or splits?

A move may keep the same household record under your definition. A split may need new linked units. Define the rule, keep the event dates and do not assume an unchanged ID always means an unchanged household.

Can we bring forms or past rounds from KoboToolbox or SurveyCTO?

Test the exact form in the receiving tool; calculations, repeat groups and offline behavior may not transfer unchanged. Past rounds usually arrive as exports, so plan how earlier IDs map to the new records and check a sample before the first new visit.

Is a manual matching review a failure?

No. A controlled review of uncertainty protects data quality. The problem is an unsupported match presented as certain, or an unresolved record silently left out of the report.

If your field collection includes attachments

Bring the reconciled batch and its source files to the document-evidence lesson. You will examine how attachments and transcripts retain their source, period and permissions when their contents are analyzed.

Lesson reviewed October 1, 2026. Partner P-024, H-014, H-015 and the visit records are fictional training examples. KoboToolbox and SurveyCTO steps are taken from their public documentation as of October 2026; check the linked pages for changes.

Return to your course →

Put this guide into practice.

Bring one recent offline round: the form, the ID list and the export behind your last report. Count the hand-offs, then see the same round kept on one record per person in Sopact Sense.

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.
How to Turn Findings into Action and Check What Changes
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.
For growing data collection, connected analysis and recurring reporting
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
Connected Data Intelligence
Understand the approach
connected-data-intelligence
Feedback
Foundation
1
Connect recurring collection, relevant history, AI analysis, and governance in a workflow your team can maintain.
Growing organizations managing recurring data collection without a dedicated data team.
Measurement and Reporting: From Agreement to Evidence-Based Report
Measurement and reporting: from agreement to report
embedded-impact-measurement
Reporting
Start here
1
Turn the onboarding call into a reporting agreement, share one data dictionary, and write reports funders can compare and check.
For funders and the organizations they fund
Connect company context before collecting another return
Connect context
track-investees-impact-agreement-variance
Portfolio
Portfolio intelligence tools
1
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.
Agree the theory of change and core metrics on the onboarding call
Agree measures
onboard-portfolio-lock-impact-agreement-track-results
Portfolio
Portfolio intelligence tools
2
Test whether an AI-assisted result is repeatable and correct
Reliability — test repeatability and accuracy
loop-reliability
Loop
The method
2
Test repeatability and accuracy using versioned data, defined calculations, known-answer checks and human review of qualitative interpretation.
Teams that need to check recurring AI-assisted analysis before using it in decisions or reports.
Design an application process around the decision, not the form
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.
Turn the onboarding call into a reporting agreement
Turn the onboarding call into a reporting agreement
onboarding-call-to-reporting-agreement
Reporting
Agree together
2
How to build a theory of change, then show it as a logic model, logframe or results framework
How to build a theory of change, then show it as a logic model, logframe or results framework
how-to-build-a-theory-of-change
Reporting
Agree together
3
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
Run quarterly collection around each company's dictionary
Collect quarterly
collect-investee-reporting-without-burden
Portfolio
Portfolio intelligence tools
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.
Build Context: What Your AI Needs to Know
Build context
build-organization-evidence-model
Feedback
Foundation
3
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
Review impact and financial evidence before it reaches the dashboard
Review and approve
read-investee-reports-multi-signal
Portfolio
Portfolio intelligence tools
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 Track the Same People Over Time
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 · Teams 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
Plan and review your first workflow pilot
Plan and review your first workflow pilot
loop-guarantee
Loop
The method
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.
Check each partner report against the agreement
Check each partner report against the agreement
check-partner-reports-against-agreement
Reporting
Funder road
5
Combine compatible metrics and explain every portfolio total
Build rollups
portfolio-impact-rollups
Portfolio
Portfolio intelligence tools
5
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
Personalize quarterly donor and annual LP reports
Report with evidence
portfolio-lp-board-impact-report
Portfolio
Portfolio intelligence tools
6
How to Build a Funder Context Profile: Research to Reporting
Build a Sourced Funder Context Profile
build-funder-context-profile
Reporting
Align
6
Roll up and benchmark portfolio results
Roll up and benchmark portfolio results
roll-up-and-benchmark-portfolio-results
Reporting
Funder road
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
Turn portfolio findings into action and test the next cycle
Act and improve
portfolio-risk-monitoring-alerts
Portfolio
Portfolio intelligence tools
7
How to Analyze Multilingual Feedback Without Losing Meaning
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
Write the portfolio report for your board or donors
Write the portfolio report for your board or donors
write-the-portfolio-report
Reporting
Funder road
7
Survey Attrition: How to Track Missing Waves in Longitudinal Studies
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
Impact Metric Definitions: A Practical Worksheet and Example
Give Every Number One Definition
one-definition-for-every-number
Reporting
Define
8
Map every funder's ask to one evidence base
Map every funder's ask to one evidence base
turn-reporting-requirements-into-evidence
Reporting
Funded partner road
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
Capture each funder's taste, and your own
Capture each funder's taste, and your own
capture-funder-taste
Reporting
Funded partner road
9
How to Analyze Pre, Mid and Post Survey Data
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 Collect Clean Data Inside Your Workflow
Collect Clean Evidence Inside the Workflow
collect-clean-data-at-the-source
Reporting
Embed
10
Write each funder's report with AI, then check it
Write each funder's report with AI, then check it
assistant-writes-the-funder-report
Reporting
Funded partner road
10
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 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 without reviewer bias: one rubric, read on arrival, people decide
Review Without Reviewer Bias
review-applications-without-reviewer-bias
Grant
Analyze
11
How to Keep Impact Reporting Numbers Consistent
Get Stable Results From Governed Data
same-numbers-every-time
Reporting
Read
11
Compare your results with outside data: live queries and public datasets
Compare your results with outside data: live queries and public datasets
compare-with-outside-data
Reporting
Toolkit
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
Make every number in your report match its source
Make every number in your report match its source
where-every-number-came-from
Reporting
Toolkit
12
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
How to put a credible dollar value on your results
How to put a credible dollar value on your results
credible-dollar-value-on-impact
Reporting
Toolkit
13
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
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 calculate the SROI ratio, step by step: value map, financial proxies and adjustments
How to calculate the SROI ratio, step by step: value map, financial proxies and adjustments
how-to-calculate-the-sroi-ratio
Reporting
Toolkit
14
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 Write an Evidence-Based Impact Narrative for a Funder Report
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 Do You Compute Grantee Variance?
Compute Grantee Variance
how-to-compute-grantee-variance
Grant
Analyze
15
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, invoices and actual spend for a grant?
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
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 to read Form 990 for a grant review
Read a 990 for Compliance
how-to-read-a-990-for-compliance
Grant
Analyze
18
Pick One Question. Keep Every System You Have.
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
How do you build a grant audit trail?
Build a Grant Audit Trail
grant-audit-compliance-trail
Grant
Communicate
20
How do you produce grant compliance and regulatory 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