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.

Keeping Data Clean

Clean data is good data, that's for sure, but how can we insure that we're getting clean data, or that we're keeping data clean, and what, exactly, IS "clean" data.  

First of all, from a data entry viewpoint, clean data is information that is entered in a consistent way, with every data entry person adding things in the same way, using codes in the same way, and so forth.  For instance, if we use mailing labels, we want to insure that all of our mailing labels are consistent in style, both with names of donors and street addresses. 

City, State, and Zip (Postal Code) fields usually take care of themselves in FundRaiser, using the US Postal Code Lookup feature: i.e., entering the 5- or 9-digit US postal code will automatically (and consistently) fill in the corresponding City and State.  So far as the style used for the names on a mailing label, the Name Defaults section of the Options menu can help with that.  

 You've probably noticed, while entering a new name record, that FundRaiser automatically builds several forms of the name on the Name Details page, including Report Name, Public Name, and both Formal and Informal Salutations.  It does that by taking the information you type into the Donor and Spouse fields and applying the rules that you set up in the Name Defaults Options.  By the way, you can view these rules by opening the Options menu, then click on Name Defaults, OR, if you're on the Name Details tab, you'll see a "Settings" button to the right of the name fields which will also take you there.

When you explore the options, you'll find different possibilites for all the variations you might encounter.  There are just a few possible scenarios for any one record.  First, it could be either an organizational entry or individual entry.  This is determined by the Account Type setting on a name record.  Next, if it's an organization, it may or may not have a contact name on the record.  If it's an individual account, it may or may not have an organization name on the name record.  For individual accounts, it may have a spouse or not, and if it does, the spouse may have the same or a different last name.  With all these possible scenarios, it's good that you can tell FundRaiser how you want the names formed for any one scenario, for each and every way the names are used (Report, Public, Formal, Informal, and Mailing Label).  In some instances there may be subtle differences of which you need to be aware.  For instance, if you have traditional marriages (male/female) but the woman is the donor, you may need to make sure you have the Public Name options set to " " in order to come out with the traditional "Mr. & Mrs. John Doe", instead of "Mr. & Mrs. Jane Doe".

If, after using FundRaiser a while, you discover that you want to change the way the program forms these names, then you can re-set the options the way you want them, and have it apply those changes to all records by going to the Miscellaneous section of the Utilities menu, and choosing to Reform All Names.  HINT:  if you do this, and you know you have some Informal Salutations that use nicknames (Larry instead of Lawrence, for instance), then reform all EXCEPT the Informal Salutation, allowing FundRaiser to overwrite the existing entries, and then go back through the process choosing ONLY the Informal Salutation, checking the box that will NOT overwrite existing names, but simply fill in any blanks.

When it comes to other consistencies, like how and when to code people and gifts, you'll need to coordinate between data entry people and management in order to come up with the best and most understandable ways to code, and then write down those guidelines, maybe as a Staff Tickler that can be referenced easily while in the program.  For more on Coding, you'll want to view the Coding and Spare Fields training video by logging into the Customer section of our website.

Clean data is everyone's business, so work together to understand how data entry can be accomplished to satisfy everyone's use of the database.  It will be worth the effort, and having written down some guidelines will give everyone a reference to help stay on track.  You can always change the guidelines later, within reason, of course, but just having the guidelines will help.  You can reform names at any time, you can modify codes (within their code type) at any time, and you can merge codes together if you find you've created multiple codes that mean the same thing, but it's still much better to avoid all that by having a solid grasp of how you want the data entered from the beginning.

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

Connect With Us

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

Customer Portal Login Form

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