Loading Case Study...
Impact Data & Gala Reporting
Unifying fragmented donor and program data into a compelling, defensible impact narrative for the 2025 Gala.
21:1
Donor Leverage
Value per $1 donated
$151,000
Community Impact
Services delivered
315
Survivors
Directly supported
4,000
Vol. Hours
Capacity created
60+
Gala Guests
Supporters reached
The Challenge
- Fragmented data across Givebutter (5+ CSV exports) and manual sign-in logs.
- Need for defensible, benchmarked valuations for donor-facing reports.
- Tight timeline ahead of the November 2025 Gala.
- Strict safety and privacy requirements for survivor-centered data.
The Solution
FLA built a custom ETL pipeline to unify Givebutter transactions with internal program records. We applied conservative local market benchmarks to quantify the 'Service Value' of every donor dollar ($151k total impact).
Outcomes
- Delivered pivotal slide assets for the 2025 Gala program.
- Proved a 21:1 ROI narrative for major donors.
- Validated methodology for 'unique individuals' vs 'attendances'.
- Created a master doc for board reuse in future events.
Deep Dive
Context & Goals
Beacon of Hope needed to move beyond 'simple totals' to tell a complex impact story. They required a partner who could reconcile dollars, label free vs. paid registrations, and quantify the massive invisible value of their volunteer and survivor support network.
The Old Way
- Data fragmentation
- Valuation gaps
- Safety compliance
- Manual reconciliation
The New Way
- Givebutter CSV Normalization (Transactions, Contacts, Payouts)
- Donor Deduplication & Ticket-Attendee Joining
- Market-Benchmarked Service Valuations ($33/hr staff, $20/hr vol)
- Anonymized Survivor Reporting (No PII)
- Unique vs. Attendance counting rules
- Vital Statistics framing (WI vs. National context)
Built With
Node.js (ETL)
Data Modeling
Impact Design
Project Gallery
