play icon for videos
← Academy
Analyze · Other

How to Build a Relationship Record

Relationship intelligence should be a record, not a mailbox of interactions. Here is how to join every touch, document, and number onto one Contact ID, code it to a codebook, and read a whole relationship into a single cited brief.

<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <style> *{box-sizing:border-box} body{margin:0;font-family:'Hanken Grotesk',-apple-system,BlinkMacSystemFont,sans-serif;background:#F7F4EC;padding:24px;display:flex;justify-content:center} .card{width:600px;max-width:100%;background:#FFFFFF;border:1px solid #ECE4D4;border-radius:20px;box-shadow:0 24px 60px -34px rgba(60,40,20,.34),0 2px 4px rgba(60,40,20,.05);overflow:hidden} .hdr{display:flex;align-items:center;gap:11px;padding:16px 20px;border-bottom:1px solid #F0E9DB;background:#F7F4EC} .hdr .n{font-family:'Inter',Georgia,serif;font-weight:600;font-size:16px;color:#2A2118;letter-spacing:-.2px;line-height:1.25;min-width:0} .hdr .pill{margin-left:auto;display:inline-flex;align-items:center;gap:6px;font-size:11.5px;font-weight:700;color:#C05B3F;background:#F6E7E1;padding:5px 11px;border-radius:20px;white-space:nowrap;flex-shrink:0} .hdr .pill .d{width:6px;height:6px;border-radius:50%;background:#C05B3F} .tabs{display:flex;gap:0;padding:12px 14px 0;background:#F7F4EC;flex-wrap:wrap} .tab{flex:1;min-width:76px;display:flex;flex-direction:column;align-items:center;gap:5px;cursor:pointer;font-family:inherit;font-size:11px;font-weight:700;color:#8A7B66;background:transparent;border:none;border-bottom:2px solid transparent;padding:8px 4px 10px} .tab .lbl{line-height:1.2;text-align:center} .tab.on{font-weight:800;color:#C05B3F;border-bottom-color:#C05B3F} .tab .num{display:inline-flex;width:20px;height:20px;align-items:center;justify-content:center;border-radius:50%;font-size:11px;font-weight:800;color:#8A7B66;background:#F0E9DB} .tab.on .num{color:#fff;background:#C05B3F} .divider{height:1px;background:#F0E9DB} .body{padding:20px} .what{font-size:13.5px;line-height:1.55;color:#4A4030;margin:0 0 14px} .promptlbl{font-size:10px;font-weight:800;letter-spacing:1px;text-transform:uppercase;color:#B0A48D;margin-bottom:7px} .bubble{position:relative;font-family:ui-monospace,'SF Mono',Menlo,monospace;font-size:11.5px;line-height:1.55;color:#2A2118;background:#F7F4EC;border:1px solid #ECE4D4;border-left:3px solid #C05B3F;border-radius:12px;padding:13px 14px;white-space:pre-wrap;word-break:break-word} .actions{display:flex;align-items:center;gap:14px;margin-top:13px;flex-wrap:wrap} .copy{font-family:inherit;font-size:12px;font-weight:700;color:#C05B3F;background:#F6E7E1;border:1px solid #EFD5CC;border-radius:9px;padding:8px 14px;cursor:pointer} .copy.done{color:#15884F;background:#E4F1EA;border-color:#CBE6D6} .demo{font-size:12.5px;font-weight:700;color:#C05B3F;text-decoration:none} .demo:hover{text-decoration:underline} </style> </head> <body> <div class="card"> <div class="hdr"> <div class="n">How to build a relationship record</div> <span class="pill"><span class="d"></span>Sopact Sense</span> </div> <div class="tabs" id="tabs"></div> <div class="divider"></div> <div class="body"> <p class="what" id="what"></p> <div class="promptlbl">Copy-paste Sopact Assistant prompt</div> <div class="bubble" id="prompt"></div> <div class="actions"> <button type="button" class="copy" id="copyBtn">Copy prompt</button> <a class="demo" href="https://www.sopact.com/request-demo" target="_blank" rel="noopener">Request a demo &rarr;</a> </div> </div> </div> <script> (function(){ var D = {"title":"How to build a relationship record","pill":"Sopact Sense","steps":[{"n":1,"tab":"One record","what":"Bring every interaction — survey, document, meeting note, check-in — onto the same stakeholder Contact ID instead of scattered threads.","prompt":"Attach every interaction for this stakeholder — surveys, documents, meeting notes, check-ins — to their single persistent Contact ID [ID]. List anything currently living in a separate thread or spreadsheet that needs to be joined to the record."},{"n":2,"tab":"Code to codebook","what":"Map the qualitative signal to your codebook so a score and the sentence behind it live together on the record.","prompt":"Code the qualitative signal in this stakeholder's record [RECORD] against our codebook. For each theme, return the score and the exact source sentence behind it, so the number and its evidence stay together."},{"n":3,"tab":"One-page brief","what":"Synthesize the whole record into a single relationship brief — everything cited, nothing inferred.","prompt":"Synthesize this stakeholder's full record [RECORD] into a one-page relationship brief: current status, key needs or commitments with the source sentence, open flags, and what changed since the last touch — everything cited to the record, nothing inferred."},{"n":4,"tab":"Keep it safe","what":"Keep the record first-party and reproducible — exclude sensitive fields from AI and run on anonymized IDs where needed.","prompt":"Re-run this synthesis excluding the sensitive fields [FIELD LIST] and using anonymized IDs. Confirm the output is reproducible from the record and flag any line that could not be traced to a source sentence."}]}; var tabsEl = document.getElementById('tabs'); var whatEl = document.getElementById('what'); var promptEl = document.getElementById('prompt'); var copyEl = document.getElementById('copyBtn'); var cur = 0; function renderTabs(){ tabsEl.innerHTML=''; D.steps.forEach(function(st,i){ var b=document.createElement('button'); b.type='button'; b.className='tab'+(i===cur?' on':''); b.innerHTML='<span class="num">'+st.n+'</span><span class="lbl">'+st.tab+'</span>'; b.addEventListener('click',function(){cur=i;render();}); tabsEl.appendChild(b); }); } function render(){ renderTabs(); var st=D.steps[cur]; whatEl.textContent=st.what; promptEl.textContent=st.prompt; copyEl.textContent='Copy prompt'; copyEl.classList.remove('done'); } copyEl.addEventListener('click',function(){ var txt=D.steps[cur].prompt; function ok(){copyEl.textContent='Copied ✓';copyEl.classList.add('done');} if(navigator.clipboard&&navigator.clipboard.writeText){ navigator.clipboard.writeText(txt).then(ok,function(){fallback(txt,ok);}); }else{fallback(txt,ok);} }); function fallback(txt,ok){ var ta=document.createElement('textarea'); ta.value=txt;ta.style.position='fixed';ta.style.opacity='0'; document.body.appendChild(ta);ta.focus();ta.select(); try{document.execCommand('copy');ok();}catch(e){} document.body.removeChild(ta); } render(); })(); </script> </body> </html>
Sopact Academy · Course review

Practical Academy guide

How to Build a Relationship Record

A useful relationship record connects the relevant history of a person or organization without erasing who said what, when it happened or who may see it. Start with the relationship you need to manage, choose a stable identifier, and attach authorized interactions as dated records. Then prepare a short, source-linked brief of current commitments, questions and changes. A record is useful when the next colleague can understand the situation and follow through without rebuilding it from messages.

This lesson is for membership, partner and customer teams preparing a handoff or recurring review. You will produce a record plan and a one-page relationship brief. It does not require scoring people or collecting every interaction they have with your organization.

  1. Define the decision and whose relationship the record describes.
  2. Separate people, organizations and dated interactions.
  3. Choose a small shared core and preserve local detail.
  4. Review themes, commitments and changes against their sources.
  5. Prepare a dated brief with an owner and next action.
  6. Check access, corrections and the next refresh.

Whose record are you building?

An organization and its current representative are different entities. Give each a continuing identifier and record their relationship, including dates when a representative changes. Otherwise a new representative can appear to have made the previous representative’s commitments, or a change of contact can look like a change in the organization’s views.

In a fictional network, Organization Cedar has identifier O-14. Ana represents it until June; Lee takes over in July. Cedar’s annual return belongs to the organization and reporting period, with the submitting person recorded. Ana’s individual event feedback remains Ana’s response. A handoff note identifies which organizational commitments remain open and who has authority to confirm them.

Define the matching rule before importing data. A name or shared email address alone may be insufficient. Keep uncertain matches in a review queue rather than automatically combining records. Retain the source identifier so a correction can be traced.

What should the shared record contain?

Keep stable profile information separate from observations and interactions. Reuse appropriate registration information instead of asking for it on every survey. Confirm changing details at a useful interval and retain effective dates when those changes matter to analysis.

Record layerExampleWhy it stays separate
Organization or person profileIdentifier, current region, roleA changed role should not overwrite who contributed an earlier response.
RelationshipRepresentative of O-14 from JulyOne person may represent more than one organization over time.
InteractionSeptember survey, call note or uploaded returnEach has its own date, source, author and permitted audience.
CommitmentSend revised guidance by 12 SeptemberA promise needs an owner, due date and completion evidence.

Local teams can use different forms. Agree only the fields needed for the shared purpose, then map compatible fields in the data dictionary. A local “visit” and a local “meeting” are not automatically the same interaction type. Document the mapping and leave unmatched detail available in its original context.

How do you make qualitative history usable?

Use a small codebook to organize recurring subjects, such as access problems, support requests or upcoming priorities. Keep the original passage, source date and reviewer decision beside the code. A theme does not need a numerical score. If a rubric is useful, define its anchors and test it before using its ratings.

Distinguish a contributor’s statement from a staff interpretation. “We cannot attend on Tuesdays” is a stated scheduling constraint. “The member is disengaged” is an interpretation requiring further evidence. Do not let a summary turn the first into the second.

Older evidence also needs context. A complaint marked resolved in August should not appear as a current unresolved issue in September merely because its original wording is still in the history. Keep the earlier event and the later resolution; show the current status with its basis.

What belongs in the one-page brief?

Prepare the brief for a named purpose and date, using only the records authorized for that audience. Include the current relationship context, recent changes, open commitments, unresolved questions and the next action. Link each substantive statement to the relevant evidence. State uncertainty where sources disagree.

Brief itemFictional example
Purpose and scopePrepare Cedar’s September service review; records available through 5 September.
Current contextLee is the current representative; July registration update.
Open commitmentCentral team agreed to send guidance; August meeting note, not yet confirmed delivered.
Question to verifyDoes the new meeting time work? No response recorded.
Next actionAccount owner confirms delivery and asks about the proposed time.

Save the reviewed brief with its source cutoff and revision date. Source citations improve traceability but do not guarantee identical AI wording on a later run. Preserve approved outputs when they support a decision, along with the underlying evidence and review history.

How does this work in Sopact?

You can begin with linked tables and a manually written brief. Repeated exports become difficult when the same relationship receives surveys, documents and notes across several cycles. The Sopact approach is to connect those inputs to continuing records and supply the relevant definitions and context for analysis.

Test the configured workflow with one relationship: can a reviewer reach the source, distinguish a proposed action from a completed one, correct a mistaken match, and restrict the brief to its intended audience? People confirm commitments and decide what to share. Replacing names with identifiers does not by itself make detailed relationship history anonymous.

Practice: prepare a handoff another colleague can use

Choose a fictional or authorized relationship with three interactions. List the entity and source identifiers, dates and access scope. Write a five-line brief. Ask a colleague to trace every line, identify the next action and explain what remains unknown. Revise any line that depends on your memory rather than the record.

Frequently asked questions

Does every interaction belong in the record?

No. Include what serves the defined relationship purpose and is appropriate to retain and use. Private or unrelated material should not be added merely because it is available. Record the intended audience and retention approach before connecting sources.

Do we need a score for each theme?

No. Themes, requests and commitments can be useful without scores. Use a rating only when it supports a decision and has a defined rubric. Keep the evidence and reviewer interpretation separate so a reader can question the conclusion.

Can we combine everyone who uses one organizational email?

Not automatically. A shared inbox may represent several people or changing representatives. Use an organizational identifier and record the actual contributor when known. Review ambiguous matches before combining histories.

What happens when profile details change?

Update the current profile and preserve effective dates where the change affects interpretation. A later region or role should not silently replace the context of an earlier response. Decide which fields need history based on the questions you will answer.

Return to your course →

Put this guide into practice.

Start with a decision your team needs to make. Decide what information belongs together, how you will check it, and who is responsible for acting.

See context in action →
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
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? Start Here Before You Add AI
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.
For growing data collection, connected analysis and recurring reporting
Measurement & Reporting: Build Evidence into Your Work
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.
For growing data collection, connected analysis and recurring reporting
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 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.
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
Build Context: The 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 without reviewer bias: one rubric, read on arrival, people decide
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, 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
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
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
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 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