Get the most out of DonorSnap

  1. Data Cleanup Tools -- Are you getting the most out of DonorSnap?
  2. Thank you for sharing DonorSnap!
  3. Free DonorSnap Training
  4. Not Using DonorSnap Yet?

Data Cleanup Tools -- Are you getting the most out of DonorSnap?

One of the most important steps in managing a donor management database is to keep it clean! The benefits are fairly obvious, but let me remind you quickly:

  • Increase funding through well-targeted communication
  • Reduce mailing costs by removing duplicates
  • Avoid embarrassing mail merge letters and emails with proper name capitalization and spacing
  • Save time and eliminate frustration in data entry
  • Great decision making starts with accurate data

Now that you are on board with the benefits of keeping your database clean, let's take a look at some of the tools built into DonorSnap that make it easy.

Merge Lookup/Dropdown Values

Let's start with the low hanging fruit. Your lookup or dropdown fields have pre-determined values that you can choose from. If there's any duplicates or typos within one field such as Campaign or Appeal Code, DonorSnap makes it easy to merge them. This will correct all existing records using these values in one swoop.

Merge lookup values

  1. Go to Maintenance > Site Setup
    • Click on the DonorSnap Site Lookups tab to find all of the system fields like Accounting Code, Contact Type, etc.
    • Click the User Defined Setup tab and then the "Lookups for User Defined Controls" right beneath it to see the fields you created.
  2. Click the expand arrow next to a field to see the values
  3. In the upper right corner of the expanded window you'll see the "Change all records from one description to another" button.

Duplicates Report

Now to get to the heart of your database cleanup, you'll need to find all of the duplicate contacts within your database. The Duplicates Report is found under Reports > Administrative Reports and provides five different methods for determining duplicates.

Duplicates report

Once you run your report, you can view it as a PDF or export it directly to Excel. If you're cleaning up many duplicates, take advantage of editing the data right in Excel. You can then use the Excel Import tool to upload any changes you make back into your database. The Merge Duplicates tool will also come in handy as I'll explain next.

Merge Duplicates Tool

Now that you've found your duplicates, you'll need to move all of the activity records (donations, interactions, notes, etc.) from the old contact record to the new one and inactivate the old contact. This tool is very simple to use. (It does not change any contact information; you'll want to use Excel Import for those changes.) Just select the two contacts and click the button.

Merge duplicates

Excel Import - Update Contact Information

This tool is a huge time saver when you are making a large amount of changes to the contact information for multiple contacts. Don't fret with looking up each contact individually, make your changes in Excel and then upload the spreadsheet.

Not only is this tool helpful for combining duplicate contact records, it's great for making mass changes to your database. For example, let's say that you haven't been using the ContactType field in the past, but your organization now has a lot a of businesses in your database. Using Excel, it's easy to add the value of "Individual" to all of your records for people and "Business" for all of your business records. The same is true for other changes such as mass inactivating contacts or updating membership expiration dates.

Active/inactive contacts

Sometimes your database isn't as black and white with which contacts you need to keep track of. You've certainly got your active contacts, but let's say you want to remove some of your contacts from your active list and still need to keep the information you have for them. That's where inactivating a record comes in handy. When you mark a contact as inactive, you can run your reports or set up your mailing lists without including those contacts.


Looking for more help? Watch the Cleaning Up Your Database Training Webinar.

Thank you for sharing DonorSnap

We know that you share your experience using DonorSnap with other organizations. Those referrals have helped make DonorSnap what it is today. For one more month, we would like to give back to you for doing what you are already doing.

For any new referrals you make and report using this form by May 31, 2015 that sign up and use DonorSnap for 31 days, we will reward you with $200. As long as the organization has never contacted DonorSnap and they sign up by July 31, 2015, you are eligible for the referral reward.

Get started today and let us know who you are referring to receive your reward.

Free DonorSnap Training

DonorSnap is now offering a free training almost every week. The free trainings take place on Wednesday afternoons and the topics range from Getting Started with DonorSnap to advanced features like DataMiner Platinum and Online Forms. The next 4 trainings can be viewed at any time.

Find the link to the training schedule under the Help menu from within DonorSnap:

Upcoming Trainings:

  • May 6th: DataMiner Batch Letters
  • May 13th: Standard Reports
  • May 20th: DataMiner Platinum Beginner
  • May 27th: DataMiner Platinum Intermediate

Space is limited so Register Now.

Want to Watch a Past Training?

Each of our weekly trainings are recorded and placed on the DonorSnap Help Site. These trainings are generally available a few hours after the training ends.

See all of the other past trainings on the help site under Training Webinars.

Not Using DonorSnap Yet?

Sign up for one of our free webinar demonstrations to see the software in action.
Ready to be set up with your own database? Get started today!