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 Dead-On Grouping Tricks to Treat you right

1.  Standard exclusions for print mailings

Whenever you create a Grouping intended for the sole purpose of sending out printed correspondence (letters, labels, envelopes), it's a good idea to use multiple lines of criteria in the Grouping, with the first line consisting of things you DON'T want, and subsequent lines for things you DO want.  It makes no sense, for instance, to include in a mailing Grouping anyone who doesn't have a complete mailing address, since they'll never receive it.  It makes less sense, perhaps, to include those records marked as "Deceased".  And you *may* want to exclude those who are marked as "Inactive", as well.  In this case, then, you could start the first line of criteria using the Common Patterns | Exclude section and mark "Inactive" and "Deceased", and then use the Finish Criteria button to save that line.  Then you would need to use the AND separator to start a new line of criteria and go to the Donor | Geo 2 section and select "Has An Incomplete Primary Address".  I know, we don't want incomplete addresses, so once you click the "Finish Criteria" button for this line, you'll use the NOT button (to the right of the criteria display), which will change it to say "does not have an incomplete address".  If you are okay with this method, then you'll just click the AND button again to start a third line, and use this line for any other criteria, such as donation information, or something else.  This will make certain that, no matter what other criteria you use to select people for the mailing, you'll have no "dead" mail (pun intended) costing you resources while doing no good.  Consider using this scheme for each mailing Grouping.

2.  Easily track mass mailings

An easy way to keep track of all the non-thank-you-letter mass mailing correspondence you do will also revolve around Groupings.  Normally you don't mail to everyone in your database at any one time, but, rather, target records for mailings by creating Groupings.  So, since you will normally have a Grouping in place, take an extra step or two and use the Groupings menu choice of "Assign Category Code to All" while you have the Grouping open.  Then, create a Category Code that reflects the mailing you are doing.  You don't need to create the Category Code first, but can do it "on the fly".  So, say I'm doing an Appeal Letter in October of 2013.  I might call the Category Code "October 2013 Appeal Letter", with a code of "AL1310" (no quotes for either, by the way).  When I assign this code to all the records in the Grouping I've created for this mailing, I remove any doubt as to who received the mailing, and I have an easy one-code identifier for them.  This means that, even though the Grouping may be lost, destroyed, or changed over time, I will always have a means of pulling together the records of those who received my October appeal letter.  It only takes a couple of extra steps to accomplish, and can be quite useful in the future.  One other suggestion:  once you've mass-assigned a code, consider marking the code as no longer active (Windows | Codes menu), so that no one will accidentally assign it to anyone else.

3.  Using Code "Formulae" to manage code usage

In FundRaiser there are a lot of codes, and that is a good thing, but can be a little unwieldy if they aren't managed well.  Of course, the menu choice of Windows | Codes will get you to the codes maintenance window where you can easily add, delete, and edit codes; you can even merge codes together if you have some codes that really mean the same thing as each other.  But Code Formulas (the way I prefer to say it, since Latin is a "dead" language) can help to ensure that codes are applied consistently.  Let's say, for instance, that you ALWAYS want name records to have and entry in the Donor Source code.  Well, you could go to the Options section and make it a "Required" entry when adding a new name record.  But, if you haven't yet done that, you may first want to see how many records don't have any source code.  To create a Grouping like that, the criteria you use will be in the Donors | Codes section, and you'll see an area to the right of the dropdown for code selection.  That's the Formula area.  And to find records with NO codes, type in "ISEMPTY" (without the quotes) and "Finish Criteria".  This can be used anywhere a Formula area exists next to a code dropdown, including Gift related codes.  So, if you want to make certain that a particular code type is NOT being used, you might go to it's formula section and type in "ISNOTEMPTY" (again without quotes) and then "Finish Criteria".  These two simple formula entries can go a long way in grouping together records for closer examination to see why they do or do not have a particular code.  Consistency in data entry is one of the hallmarks of a well-kept database, and will make the whole system easier to use, so take advantage of the tricks to maintain your data, and don't get "spooked" if you can't figure out exactly how to do something:  call us, or check out the training videos in the Customer Portal section of our website.

When I Forgot the Meaning of Philanthropy
3 Tips for Exporting Data to Spreadsheets

Related Posts

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

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