Is your donor database working for you? If you put time in up front, the database can make your life easier. Set aside one week for a fundraising database tune up this April. You and your camp will thank you for the rest of the year!
MONDAY |
TUESDAY |
WEDNESDAY |
THURSDAY |
FRIDAY |
LYBUNT |
DEDUPE |
IMPORT |
BOARD GIVING |
STEWARDSHIP REPORTS |
Monday: LYBUNT report
LYBUNT stands for "Last Year But Unfortunately Not This year." A LYBUNT report is a list of all your donors who made gifts in the previous year but did not give during the current year. If you don't know how to easily run such a report from your donor database, email Kevin right now and set up an appointment to learn how to run this and other useful reports. Learning how to quickly run reports to tap the valuable information in your donor database is invaluable.
The exciting part about running a LYBUNT report is that it points to easy money you can raise right now. Research in philanthropy is finding that increasingly donors don't remember whether or not they have made their annual gifts. Stay positive and assume that your LYBUNT donors love camp but simply forgot to give in 2009, and would be willing to make a gift right now if asked.
Do it today: Run a LYBUNT report, look it over, and design a mini-campaign (maybe a simple mailing to these donors with some follow-up calls?) and set a dollar amount goal for LYBUNT gifts for this spring.
MONDAY |
TUESDAY |
WEDNESDAY |
THURSDAY |
FRIDAY |
LYBUNT |
DEDUPE |
IMPORT |
BOARD GIVING |
STEWARDSHIP REPORTS |
Tuesday: Deduping
Deduping is lingo for removing duplicate entries from the database, as in "de-duplicating." If you don't do this task, you can lose face with your donors: this winter I got three copies of a mailing from an organization with one addressed to me, one to my husband and the third to both of us. It was very wasteful and unprofessional. I recycled the appeals without reading them. Don't let that happen to you!
If you've never tried to dedupe your database before, or it has been a long time, email Kevin right now and set up an appointment to learn how to do this, and determine how long it might take. While you are working on this task, Kevin can help you to think about other ways to clean up your donor database while you are at it. If you dedupe once or twice a year, this task will not take longer than a day.
Do it today: Review your database, and estimate how much time you'll need for deduping. Most donor databases have a duplicate removal function. Use this function to find and merge known duplicate records.
MONDAY |
TUESDAY |
WEDNESDAY |
THURSDAY |
FRIDAY |
LYBUNT |
DEDUPE |
IMPORT |
BOARD GIVING |
STEWARDSHIP REPORTS |
Wednesday: Import Camper Records
Ideally, a camp's donor database would include all Alumni throughout time, current and past parents, current and past grandparents, current and past Board members, current and past staff, all current and past supporters, and camp business contacts. All these people are the camp's base for support. At some point information in the camp's registration/enrollment database needs to be moved into the donor database, especially as kids age-out of camp.
If you haven't yet set up decision criteria for when campers get transferred over from your camp database into your donor database, you should email Kevin right now and set up an appointment to discuss what is involved and how to get started. If you've set up your system for data imports and do this each year, then this task can get done in a day. Did you know that deduping (see above) is done again after a data import?
Do it today: Review your process for transferring contacts from the camper registration and enrollment software into your donor database, be sure you understand it, and make a plan to update this Spring. If you have a documented process that is used each year, data import will be relatively easy.
MONDAY |
TUESDAY |
WEDNESDAY |
THURSDAY |
FRIDAY |
LYBUNT |
DEDUPE |
IMPORT |
BOARD GIVING |
STEWARDSHIP REPORTS |
Thursday: Board Giving Update
Every camp should realize 100% participation in charitable donations by their Board members every year. Run a report right now to see if you have reached this goal this year. Do you know how to flag current Board members in your database? Do you know how to create payment reminders to Board members who make pledges but have not yet made their payment? If not, email Kevin right now and set up an appointment to learn how to flag constituents or create pledge reminders.
Once you have created your Board Giving Report, give your Board President a call (not an email) and share this information. As you share these results, use this time on the phone to create a Board member-to-Board member strategy to create 100% Board participation in the annual fund.
Do it today: Run a Board Gifts report, share it with your Camp Board President, and have a conversation. Provide assistance in setting up individual meetings with Board members who are not in compliance to remind them to give.
MONDAY |
TUESDAY |
WEDNESDAY |
THURSDAY |
FRIDAY |
LYBUNT |
DEDUPE |
IMPORT |
BOARD GIVING |
STEWARDSHIP REPORTS |
Friday: Stewardship Reports
Every major donor, past and present, deserves a thoughtful personal update on the impact of their gifts. For example, the lead donor to the dinning hall renovations in 2002 should have an opportunity to see pictures of Jewish campers in the dinning hall celebrating Shabbat and to realize that thanks to their gift 12,000 healthy Kosher meals have been served. Does your donor database help you to track contact with your generous donors and does it remind you to send updates on the impact of their gifts? If not, email Kevin right now and set up an appointment to learn how to set up reminders and keep stewardship notes.
You can use your donor database to track your stewardship of donors over time, stay in contact with your Legacy donors every year, and/or help you with scheduling donor visits to camp over the summer.
Do it today: Run a report to find out the latest stewardship activity with each of your largest donors. Don't have any Stewardship contacts tracked in your database? Start today! Have contacts, but none recently? Enter a future planned new contact with each major donor so that it reminds you to re-establish your relationship with them soon.
Later in the year, you can create custom reports for each donor to document the impact of their gifts. Writing a simple page of text together with color photos that focus on results and outcomes will be very powerful. Mail these reports to your donors with a personal note from the Camp Executive Director or Board President. Keep track of this reporting in your database, and set up a reminder for the next set of reports to be sent and to whom.
When you try all (or some) of the above, let us know how it goes. And contact Kevin if you need any assistance.