Practical Advice for Modern Fundraisers

THOUGHT·FUL

adjective\ˈtht-fəl\

: serious and quiet because you are thinking: done or made after careful thinking   : done or made after careful thinking: showing concern for the needs or : showing concern for the needs of feelings of other people

What makes up your CRM?

What data do you collect?  Well, I collect all kinds of data on my prospects, donors and the gifts we receive.  However, if I were starting a CRM from scratch what would a collect? First, I would decide what the primary data is I need for every entry.  The minimum I would collect on every person I was adding to the database is the following:

Title

First Name

Last Name

Suffix

Street Address

City

State

Zip

Phone

Email

Salutation

Addressee (Formal Name)

Connection to Charity (donor, prospect, volunteer, board member, etc.)

Besides the basic data fields, you might consider adding these fields. They will help with reporting, prospecting, and cultivation. The additional fields, I recommend, include:

Mailings Sent

Spouse information

Gender

Work Information

Giving Interest

Social Media Handles

Solicitor

Notes

Those are the fields I would collect whether the individual is a donor or a prospect. If the data comes from a donation, I would add the following gift fields. Gift fields should include the data that you need to thank donors and do basic financial reporting.

Amount

Date

Receipt Amount (helpful with events)

Purpose

Giving Vehicle (what was the gift in response to)

Gift fields have a few basics that you have to have simply to thank and to do the most basic reporting. To do more advanced reporting and to assist you in reconciling with your finance department you should add the following fields.

Financial codes (GL Accounts, or fund)

Acknowledgment coding (if thanked, date thanked)

Gift Type (Cash, Check, Credit Card)

With these fields, you can track donor interactions and gifts. You can also create reports for "Years Given, Cumulative Giving, Donor Locations, Response Rate, Attrition Rate, Giving by Date, LYBNTY, SYBNTY and Never Given and Giving by Connection to Charity - to name a few. You may not need all of these reports now, but it is better to have the data available than to try and go back and add it to your data.

Since most of us are not building CRM's from scratch how does this affect us? Well, it gives you an idea of what your CRM needs no matter whether it is custom built or out of the box. It is also a reminder that just because a CRM includes a field you do not have to use it.  Be thoughtful in your approach, and you will be gathering the data you need.

You can’t report on what you don’t collect.

 

Short Thoughtful Post

It Occurs To Me

Please leave a comment, thoughtfully.

 

 

 

 

Thoughtful Tweets

Thoughtful Facebook Post

You'd like to say...

Email:
Subject:
Message:
How many eyes does a typical person have?

Thoughtful Stewardship

* indicates required

 

 

I recommend...

I have used MailChimp for years and not just for sending E-Correspondence. It is great for website sign up forms and event registration. The best part is it integrates with lots of other apps and is FREE up to a point. To register and learn more click on FREDDIE!

I recommend...

siteground

I have used Suteground or a ny=umer of years for hosting bith full websites and domains usrd for emails.  They support all of the major CCM and CRM system. The also have a number of free extensions and apps. Most importantlh they have put a great deal of time and resources into customer support. Click here to receive a discount. and to learn more about their services.

Books of Note

Go to top