S/
STEWARD
steward — data_hygiene_sprint.py — 80×32Python 3.12.0

INPUT — RAW

OUTPUT — RESOLVED

Your donor data has problems.
We read them like source code.

Steward diagnoses and repairs the data infrastructure of nonprofit development offices — so your CRM reflects reality before the next board meeting.

47%
AVG DUPLICATE RATE
in mature CRMs
3–6 wks
AUDIT DELAY
from reconciliation errors
12+
CRMs SUPPORTED
RE, NPSP, Bloomerang & more
// DIAGNOSTIC OUTPUT

The four failure modes
we find in every engagement.

ERR::DUPLICATE RECORDS01

47% average duplicate rate in mature CRMs

After five years of staff turnover and manual entry, most Raiser's Edge instances contain nearly half their donor records twice — sometimes three times. Every appeal, every ask, every report is built on a corrupted count.

47%AVG DUPLICATE RATE
ERR::GIFT RECONCILIATION02

Reconciliation errors delay audits by 3–6 weeks

When your finance system and your CRM disagree on gift totals, someone has to manually reconcile them before the auditors arrive. That someone is usually your most senior development staff, doing spreadsheet archaeology instead of fundraising.

6 wksAVG AUDIT DELAY
?
ERR::CAMPAIGN ATTRIBUTION03

Attribution gaps misreport ROI to your board

When gifts aren't tagged to the campaign that sourced them, your board sees a cost-per-dollar-raised that bears no relationship to reality. Capital campaigns look inefficient. Annual funds look miraculous. Neither is true.

68%GIFTS UNATTRIBUTED
ERR::SYSTEM SPRAWL04

Three systems, three versions of the truth

Salesforce NPSP for major gifts. Bloomerang for annual fund. A legacy Access database someone built in 2011 that "only Diane knows how to use." When Diane leaves, the institution's donor history goes with her.

AVG SYSTEMS PER ORG
// STEWARD.resolve() — METHODOLOGY

Four engagements.
Each one closes a specific loop.

FIX::DATA HYGIENE SPRINT01

resolves → ERR::DUPLICATE RECORDS

Canonical record merging in 2–4 weeks

We run probabilistic matching across all name variants, address histories, and email domains to identify duplicate clusters. Every merge decision is documented with confidence scores — your team retains full audit trail and can reverse any decision.

Duplicate rate < 3%Merge audit logOngoing dedup rules
=
FIX::RECONCILIATION MAPPING02

resolves → ERR::GIFT RECONCILIATION

Finance-to-CRM sync that closes cleanly

We map every gift record to its corresponding GL entry, identify the systematic mismatches, and build the integration rules that prevent them from recurring. Audit season becomes a one-day exercise instead of a six-week fire drill.

Zero-variance reconciliationAutomated sync rulesAuditor-ready exports
FIX::ATTRIBUTION MODEL DESIGN03

resolves → ERR::CAMPAIGN ATTRIBUTION

Board-ready attribution in 30 days

We design and implement a gift attribution model specific to your campaign structure — annual fund, major gifts, capital campaigns, planned giving. Every dollar gets a source. Every source gets a cost. The board sees real numbers.

100% gift attributionCampaign ROI dashboardBoard-ready exports
FIX::SYSTEM INTEGRATION04

resolves → ERR::SYSTEM SPRAWL

Single source of truth, documented

We inventory every system touching donor data, map the overlaps and gaps, and design the integration architecture that consolidates them. We don't just connect systems — we document the decisions so the next staff member can maintain them.

System inventory mapIntegration specStaff runbook
// COMPARATIVE ANALYSIS

In-house cleanup vs. Steward.
The numbers make the argument.

> Showing Steward engagement metrics — toggle to compare

METRIC
IN-HOUSE CLEANUP
STEWARD ENGAGEMENT
TIME_TO_CLEAN
4–9 months
3–6 weeks
STAFF_HOURS
200–400 hrs
12–20 hrs (client)
RESIDUAL_ERROR_RATE
18–34%
< 3%
AUDIT_READINESS
Manual prep required
Automated exports
DOCUMENTATION
Tribal knowledge
Full runbook delivered
RECURRENCE_RISK
High (no rules engine)
Low (automated rules)
REQUEST A DATA ASSESSMENT

// No commitment. We scope the engagement before you decide.

// CASE STUDIES — BEFORE / AFTER

What resolution looks like
in production environments.

HEALTH SYSTEM PHILANTHROPY84,000 records

Regional Medical Foundation

Raiser's Edge NXT

Duplicate donor records across 3 merged hospital foundations — 8 years of unreconciled imports.

BEFORE

52%

DUPLICATE RATE

AFTER

2.1%

DUPLICATE RATE

-96% DELTA4 weeks
HIGHER EDUCATION140,000 records

State University Advancement

Salesforce NPSP

Campaign attribution completely absent — $12M capital campaign had zero gift-to-campaign linkage in CRM.

BEFORE

0%

GIFTS ATTRIBUTED

AFTER

100%

GIFTS ATTRIBUTED

+100% DELTA6 weeks
GRANTMAKING FOUNDATION22,000 records

Community Foundation

Bloomerang

Finance and CRM gift totals diverged by $340K. Audit was delayed two months while staff reconciled manually.

BEFORE

$340K

RECONCILIATION VARIANCE

AFTER

$0

RECONCILIATION VARIANCE

−$340K DELTA3 weeks
// INITIATE ENGAGEMENT

Request a
Data Assessment.

We review your CRM, identify the top three data integrity issues, and scope a remediation engagement — at no cost. Most clients receive a written findings report within five business days.

WHAT HAPPENS NEXT

01

We review your intake form within 1 business day.

02

A 30-minute call to understand your CRM environment.

03

Written findings report — top issues, estimated effort, fixed-fee scope.

04

You decide whether to engage. No pressure, no follow-up cadence.

// assessment_intake_v2.form

Under5,00025,00075,000200,000+

5,000 – 25,000

// No spam. No sales pressure. Just findings.