Donor Database

2017-2018 - Writers in Baltimore Schools

Problem: A growing nonprofit needed to track donations, gain insight into their most effective fundraising channels, and stay in touch with donors. Donation data and donor info were scattered across Excel sheets.

Solution: Make a simple relational database (using the slick and intuitive Airtable!).

Process

  • Worked with WBS's executive director to pinpoint the group's needs.

  • Cleaned and standardized data.

  • Designed a simple database, complete with a few of the most urgently-needed reports built in.

  • Linked donation records with donor contact info, allowing for the creation of contact lists based on donation history.

Skills: Airtable, basic data architecture, working collaboratively to identify and respond to stakeholder needs.