FundRaiser Blog

The FundRaiser Software Blog is an excellent resource for nonprofit organizations looking to learn more about fundraising, donor management, membership management, and much more.

10 Best Practices for Managing a Database

Note from Sasha: I have worked with Robert L. Weiner at the TechSoup forums where we have both been volunteer forum moderators in the database and software section for many years. Come visit us there sometime! Over the years, I've come to respect his depth of knowledge and skill at sharing about best practices for using donor databases. This article by him is one of my favorites. Robert is an independent technological consultant to non-profits and is not affiliated with FundRaiser Software. I'm sharing the article because I believe it is one of the most concisely helpful resources written on the subject of donor database best practices, and that FundRaiser users will benefit from reading it.

After people, data is your most important asset.-- John Kenyon

  1. Left unattended, databases will turn into piles of mush. Therefore, develop data entry policies and procedures, and train everyone who enters data.

  2. Excel is not a database, and is one of the leading causes of dirty data. It is difficult to enforce data entry standards in Excel. (like only allowing legal U.S. state codes). And anyone who can update your spreadsheet can see and change anything.

  3. Someone needs to be in charge of training, user support, and data quality (see #1). At a small organization, this might be a small part of someone's job. At a large organization, it might need to be a whole department.

  4. Run backups religiously. Be sure to test them periodically to make sure you can recover data.

  5. Keep a copy of your data off-site. This can be done by using an online backup service, a vendor that provides offsite storage and retrieval, or even by sending a backup home with a staff member. The latter is risky, however. Data taken off site is subject to theft, loss, copying, and malicious acts by disgruntled employees.

  6. Do all you can to prevent staff from downloading sensitive data (like social security numbers or credit card data) to laptops or memory sticks. Use encryption on your laptops and memory sticks. Tools like Identity Finder, Proventsure, SENF, and Spider will scan your computers for sensitive data.

  7. Require strong passwords. Do not share passwords. Change passwords regularly.

  8. Monitor your data entry. Run reports that look for common errors. Identify staff members who repeatedly make errors and provide additional training. If the errors continue, take away their data entry permissions.

  9. Run your database on a need-to-know basis. Give staff and volunteers access to only the data they need to see or change to do their jobs -- but make sure that they do have access to the data they need.

  10. Make sure your database has enough security options. You should be able to provide read-only access. You might want to have the ability to provide read-only access to just a portion of your data, like names and addresses but not gifts. You should be able to provide update access to only certain portions of your data, like updating addresses but not entering gifts. You should be able to restrict access to functions like posting a gift batch or importing online donations. And you should be able to restrict the ability to run mass updates or delete records.

See more at: http://www.rlweiner.com/best-practices-for-managing-a-database#sthash.KGNJCGZC.dpuf

To learn more about how FundRaiser can help with your donor management

Check out our 5 minute self-guided video tour

Case study: Ease of use for staff and donors of on...
Case study: moving from endowment-funding to broad...

Related Posts

Wait a minute, while we are rendering the calendar
small donations Company culture donor engagement gift notes field fundraising merge fields auction donation history donor attrition phoning donors correspondence Volunteer module online donations donor relations endowment campaign entering auction gifts welcome packet memorial giving Groupings features LYBUNTS operating systems on site training operational costs donor attrition rate Network for Good anonymous donors FundRaiser Hosted In-Kind gifts importing csv advanced tab membership programs donor slip mission driven tribute gifts spare fields data analysis overview upgrading donors planning data entry Snow Birds nonprofit fundraising Thank You upgrade spreadsheets repeat donors role of nonprofits FundRaiser Basic email new features Constant Contact corporate sponsors mode code alumni Facebook End of Year Letters flash sales foundations online donations gift acceptance policy gift entry capital campaign major gift prospects appeal fundraising letters donor prospects building donor relationships vacation budget announcements case study lapsed donor mailing Cloud custom page technical support donor retention rate change of address updating how-to videos Resiliency grassroots campaign ticket sales government grants donor profile direct mail PayPal segmenting donors charity golf tournaments pictures new leadership membersip benefits user spotlights office holiday letters Reminders training motivation code salutation ticketsales Importing Data look and feel user interface banquet how to handle auction gifts monthly giving transparency development director understanding giving trends donor contact information donor advised funds tech tip passwords follow up customer service password protection merge notes annual maintenance plan event management accounting software grants Facebook campaign Congratulations raffle community supported gardens happiness add ons tax summary letters Excel product news SYBUNTS Donor Portal legacy giving FundRaiser Spark planned giving in honor of donations communications updates backing up data recurring gifts donor loyalty arts Tickles the Ask holiday volunteering word processor security relationship tracking major donors Task List donor giving history social media Crowdfunding Campaign Personalizing adding personal notes to letters correspondance campaign reports board members data conversion letter increasing giving amounts appeal letters brick campaign support campaign management prospects texting donors GoFundMe project Alternative Addresses giving levels general targeted mailings premiums customer portal holiday giving volunteers Codes New Year Thanksgiving moves management personalizing letters new version large donations pledges animal rescue training tip donor recognition donor source Reporting to IRS community broadcasting ROI new nonprofit GivingTuesday donor targeting solicitors thank you letters new donors NCOA processing publicity materials letter templates National Change of Address membership benefits motivation annual campaign donor retention #GivingTuesday donor preferences disaster relief community arts nonprofits

Connect With Us

  800-880-3454 ext 3
  Email Us
  Request More Information
  Monday-Friday
      8:30AM-5:30PM CST

Customer Portal Login Form

   

The customer portal is unavailable. If you need support please reach out to support@fundraisersoftware.com Thank you.

 

  User Name:
  Password:

If you are not sure about your Customer User Name, please call 800-543-4131 and we will be able to help you.

Or you have lost your password, Request Password