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.

3 Tips for Donor Database Code Usage

1. People codes vs. Gift codes

The most important code usage tip (in my opinion) is to make certain that the assignment or attribute fits.  In FundRaiser there are codes that attach to name records (what I call "people" codes), and codes that attach to gift records (hence "gift" codes).  For the most effective assignment of codes, think of codes as "unique identifiers" that attach to either a person or a gift.  In other words, does the code have to do with the person, defining that person in some way?  Or does it have to do more with a gift, defining the gift in some way?  An example of people codes are the Category codes in FundRaiser.  Category codes, unlimited in the number that can be created and/or assigned, give us information about people such as life situations (parents, grandparents, students, seniors, occupation, hobbies, interests, relationship to our organization or another, etc.).  Gift codes, on the other hand, tell us about the gift, such as why the gift was given (Motivation code), or how that money is to be spent (Purpose code, for describing restricted/designated use gifts).  Make a list of all the things you need to know about a gift.  Make a separate list of all the things you need/want to know about your people.  Keep the lists handy, and, when in doubt, refer to them when wanting to assign a code.

2. Avoid double work

Think of Category codes as "non-giving" aspects of peoples' lives.  There is no need to code someone as a "major donor", or as a "frequent giver", since their individual giving history will tell that story, and their status could change over time.  If you code them, then you may, at some point in the future, need to remember to change their coding as their status changes.  If, instead, you rely on your gift records to gather together major or frequent donors, you eliminate that double work.  Coding is supposed to make your job easier, not harder, so don't code fi it creates duplicity.  By the same token, make certain that everyone entering data is playing by the same rules, so that you have consistency in your coding plan.

3. Using Groupings and/or Advanced Report options

Most reports can be used with Groupings (gatherings of name records that have one or more things in common), which will limit the report to just those folks in the grouping, and most reports have an "Advanced" tab that allows you to further define who and what will appear on a report.  Codes, of course, can be used as criteria in both Groupings and the Advanced section.  Whether to use one or the other or both in concert can be a bit confusing, but it's a good idea to explore these options when trying to "segment" your donor base, such as suggested in Sasha's blog this week.  Let's say you've coded people as parents, grandparents, students, seniors, etc.  It may be that you want to see which of those groups donates the most.  You'll need to be a bit careful, since some of these codings may overlap.  Grandparents are also parents, and could be seniors and/or students.  So it may not be appropriate to segregate them quite that way.  In order to include certain codes, but exclude others, it may be necessary to use a grouping in addition to advanced report options.  The point is:  think carefully about the results you want, and whether or not the dividing lines between groups of donors are distinct or blurry, and proceed accordingly.

3 Actions Schools Take with Their Donor Database ...
Database Support Team Motivated by Desire to Creat...

Related Posts

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

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