Program Intelligence

What this eBook is about

From Fragmented Data to Program Intelligence is the series capstone — it runs the whole spine for an organization with many programs and many funders. Right now your theory of change lives in a Google Doc, survey data in Airtable, financials as PDFs, and field notes in Excel, with two teams translating the same data. This guide shows how one connected record per person replaces that — design the framework, collect across every program and chapter, aggregate onto one record, and report to each funder in the framework they asked for. Traditional impact measurement returned about 5% of the context (the survey); the other 95% — case notes, transcripts, documents, financials, stories — finally connects on one persistent participant ID.

Who should read it

The organization that runs four to twelve programs — or a federation of chapters and members — each with its own logic model, funder, and reporting cadence: mid-tier nonprofits, foundations tracking grantee outcomes, associations and networks standardizing across sites, and the M&E leads who answer to all of them.

What’s inside

• The reframe — outputs were never outcomes, the 5/95 gap, and the Cell → Row → Column → Grid roll-up
• Design — build the framework and data dictionary from your own interviews, and standardize across chapters and members
• Collect — surveys, documents, interviews, and offline data in 40+ languages, unified at the source
• Aggregate & report — one ID with zero reconciliation, multi-program roll-up, and a report to each funder generated (not assembled), every figure cited

Why it matters

Standardize collection once and the national roll-up is a query, not a reconciliation project per member; each funder’s framework is a different narrative over the same connected record. Most teams have their first cohort report in under a month. Download the guide — it also ties the whole seven-book library together on one spine.