> Skip to content
FEATURED:
  • America's Favorite Charities
  • Nonprofits and the Trump Agenda
  • Impact Stories Hub
Sign In
  • Latest
  • Commons
  • Advice
  • Opinion
  • Webinars
  • Online Events
  • Data
  • Grants
  • Magazine
  • Store
    • Featured Products
    • Data
    • Reports
    • Collections
    • Back Issues
    • Webinars
    • Featured Products
    • Data
    • Reports
    • Collections
    • Back Issues
    • Webinars
  • Jobs
    • Find a Job
    • Post a Job
    • Career Advice
    • Find a Job
    • Post a Job
    • Career Advice
Sign In
  • Latest
  • Commons
  • Advice
  • Opinion
  • Webinars
  • Online Events
  • Data
  • Grants
  • Magazine
  • Store
    • Featured Products
    • Data
    • Reports
    • Collections
    • Back Issues
    • Webinars
    • Featured Products
    • Data
    • Reports
    • Collections
    • Back Issues
    • Webinars
  • Jobs
    • Find a Job
    • Post a Job
    • Career Advice
    • Find a Job
    • Post a Job
    • Career Advice
  • Latest
  • Commons
  • Advice
  • Opinion
  • Webinars
  • Online Events
  • Data
  • Grants
  • Magazine
  • Store
    • Featured Products
    • Data
    • Reports
    • Collections
    • Back Issues
    • Webinars
    • Featured Products
    • Data
    • Reports
    • Collections
    • Back Issues
    • Webinars
  • Jobs
    • Find a Job
    • Post a Job
    • Career Advice
    • Find a Job
    • Post a Job
    • Career Advice
Sign In
ADVERTISEMENT
Advice
  • Twitter
  • LinkedIn
  • Show more sharing options
Share
  • Twitter
  • LinkedIn
  • Email
  • Facebook
  • Copy Link URLCopied!
  • Print

Start With a Spreadsheet and a Survey: Advice From Experts

By  Nicole Wallace
May 5, 2014

Start small

A lot of nonprofits don’t understand basic information about their fundraising, such as mean gift size or the percentage of donors who contribute annually, says Darrow Zeidenstein, vice president for resource development at Rice University.

Organizations that want to jump into analytics can start by using a simple spreadsheet to get to know their numbers and move on from there, he says: “You don’t need whiz-bang statistical packages to do some really powerful things.”

Look for differences

We're sorry. Something went wrong.

We are unable to fully display the content of this page.

The most likely cause of this is a content blocker on your computer or network.

Please allow access to our site, and then refresh this page. You may then be asked to log in, create an account if you don't already have one, or subscribe.

If you continue to experience issues, please contact us at 571-540-8070 or cophelp@philanthropy.com

Start small

A lot of nonprofits don’t understand basic information about their fundraising, such as mean gift size or the percentage of donors who contribute annually, says Darrow Zeidenstein, vice president for resource development at Rice University.

Organizations that want to jump into analytics can start by using a simple spreadsheet to get to know their numbers and move on from there, he says: “You don’t need whiz-bang statistical packages to do some really powerful things.”

Look for differences

Organizations should record more than just donations in their fundraising databases, says Josh Birkholz, author of Fundraising Analytics: Using Data to Guide Strategy. He recommends that nonprofits track which events their supporters attend, whether they volunteer or serve on committees, and maybe even whether they give to other charities.

“In modeling, you want to find what’s different about a select group so that you can find more of them,” he says.

Mr. Birkholz’s suggestion for nonprofits just starting with analytics: Conduct a survey of the group’s top 100 donors and a random sample of 100 other supporters, and then line up the responses in a spreadsheet to look for what sets the best donors apart.

ADVERTISEMENT

Identify loyal donors

The traits and behaviors that predict who is most likely to give a large gift varies from organization to organization, with one notable exception, says Sarah Williams, lead analyst and consultant at Marts & Lundy, a fundraising consulting company.

“One of the characteristics that basically is a huge, flashing light is that they have consistently been giving,” she says. “It could be $25 a year, but if they’ve been doing that for 10 years, then that’s a flashing light that this person is attached and more likely to give.”

Presentation matters

Great number-crunching isn’t enough, says Lisa Howley, director of relationship management at the Johns Hopkins Institutions. Analysts, she says, need to figure out the best way to convey their findings so other employees in the organization can understand and act on them.

When Ms. Howley’s office first offered a service to help departments analyze their gift officers’ portfolios, the approach entailed using simple tables to organize donor prospects based on what size gifts the research suggested they were able to make and their inclination to give.

When the service was slow to take off, Ms. Howley revised the format so that various colors were added to the tables to indicate different levels of priority in the donor portfolios. “All of a sudden,” she says, “it started to get a ton of attention.”

ADVERTISEMENT

Read other items in this How to Use Data to Advance Fundraising package.
We welcome your thoughts and questions about this article. Please email the editors or submit a letter for publication.
Fundraising from IndividualsInnovation
Nicole Wallace
Nicole Wallace is features editor of the Chronicle of Philanthropy.
ADVERTISEMENT
ADVERTISEMENT
SPONSORED, GEORGE MASON UNIVERSITY
  • Explore
    • Latest Articles
    • Get Newsletters
    • Advice
    • Webinars
    • Data & Research
    • Podcasts
    • Magazine
    • Chronicle Store
    • Find a Job
    • Impact Stories
    Explore
    • Latest Articles
    • Get Newsletters
    • Advice
    • Webinars
    • Data & Research
    • Podcasts
    • Magazine
    • Chronicle Store
    • Find a Job
    • Impact Stories
  • The Chronicle
    • About Us
    • Our Mission and Values
    • Work at the Chronicle
    • User Agreement
    • Privacy Policy
    • California Privacy Policy
    • Gift-Acceptance Policy
    • Gifts and Grants Received
    • Site Map
    • DEI Commitment Statement
    • Chronicle Fellowships
    • Pressroom
    The Chronicle
    • About Us
    • Our Mission and Values
    • Work at the Chronicle
    • User Agreement
    • Privacy Policy
    • California Privacy Policy
    • Gift-Acceptance Policy
    • Gifts and Grants Received
    • Site Map
    • DEI Commitment Statement
    • Chronicle Fellowships
    • Pressroom
  • Customer Assistance
    • Contact Us
    • Advertise With Us
    • Post a Job
    • Reprints & Permissions
    • Do Not Sell My Personal Information
    • Advertising Terms and Conditions
    Customer Assistance
    • Contact Us
    • Advertise With Us
    • Post a Job
    • Reprints & Permissions
    • Do Not Sell My Personal Information
    • Advertising Terms and Conditions
  • Subscribe
    • Individual Subscriptions
    • Site License Subscriptions
    • Subscription & Account FAQ
    • Manage Newsletters
    • Manage Your Account
    Subscribe
    • Individual Subscriptions
    • Site License Subscriptions
    • Subscription & Account FAQ
    • Manage Newsletters
    • Manage Your Account
1255 23rd Street, N.W. Washington, D.C. 20037
© 2026 The Chronicle of Philanthropy
  • twitter
  • instagram
  • youtube
  • facebook
  • linkedin