What are donor data analytics and how exactly can it help me increase revenue? It’s a common question we get from nonprofits all over the country. Analytics is the process of studying, examining and modeling your donor data to help you understand exactly how donors are financially engaging with your organization.
Today we share with you part one of a new Vlog series to help you do your own donor data analytics with your database. This 5-part series will focus on:
Annual Giving
Major Giving
Acquisition
Retention and Recapturing Donors
Departmental Structure and Strategy
Today’s video will provide an overview of ways too look at how new donors are coming to your organization, what they’re giving and what channel they’ve chosen that led them to your organization.
To walk side-by-side Mary in this tutorial, we recommend you query your donor database first and extract the data into an excel spreadsheet. First run a query against the “first gift = last fiscal year” and make sure your data has these four components:
Constituent ID
First gift date
First gift amount
First gift appeal
Once you have this information, Mary will walk you through analyzing your data with easy-to-follow instructions using pivot tables.
If you have any questions, feel free to ask them in the comments below or contact Ravela Insights today.
