Project Music – Fundraising Growth Powered by Data Analysis & Strategic Consulting

The What

Project Music is a nonprofit music education program in Stamford, CT. At its 10-year mark, the organization needed to strengthen fundraising capacity by understanding its donor base, optimizing its CRM data, and uncovering strategic opportunities for donor growth. I joined a Columbia University consulting team to conduct a comprehensive CRM analysis, identify donor trends, and deliver actionable strategies to expand reach and improve retention across all funding sources.

‍

The How

Research Design & Data Collection

• Partnered with the Executive Director to define core strategic questions on donor base expansion, geographic reach, and funding diversification.
• Exported and merged constituent and transaction data from Bloomerang CRM, cleaning records to enable a unified, analyzable dataset.Developed a donor classification framework (individuals, foundations, corporates, board, etc.) to enable precise tracking of funding sources and behavior patterns.

Data Analysis & Insight Synthesis

• Applied statistical and data analysis to identify patterns across donor types, revenue streams, gift size distribution, geographic concentration, and retention rates.‍
• Analyzed geographic concentration and high-value donor locations, cross-referencing donor volume and average gift size by city.
• Explored donor motivations and attrition reasons, identifying high-impact opportunities in corporate giving, board engagement, and targeted market expansion.

Strategic Recommendations & Consulting Deliverables

• Created donor segmentation models highlighting retention improvement areas and market expansion targets.
• Recommended tiered donor programs, geographic targeting strategies (high-value vs. high-volume markets), and CRM data enhancements for better decision-making.
• Designed an action blueprint covering short-term revenue growth strategies (e.g., partnerships, event sponsorships) and long-term sustainability initiatives.

‍

The Impact

Fundraising Intelligence

• Delivered a 10-year donor behavior analysis, revealing a funding shift from government grants to a more diversified portfolio led by foundations and individual giving.
• Identified high-value donor cities (e.g., Colchester, Ft. Mitchell) and high-volume markets (e.g., Greenwich, New York) as priority targets for fundraising.
• Exposed donor retention drop-off points and first-year churn, enabling the design of targeted retention programs.

Data-Driven Decision Support

• Provided leadership with clear donor segmentation and geographic mapping, highlighting where to focus acquisition and retention efforts.
• Supplied actionable insights on donor motivations, gift size distribution, and retention patterns to guide fundraising strategy.

Strategic Growth Enablement

• Advised leadership on future core fundraising strategy to support long-term growth.
• Developed a diversified funding strategy to reduce reliance on single sources and strengthen financial resilience.
• Delivered a concrete action roadmap ensuring alignment between short-term fundraising goals and long-term sustainability objectives.