Care and Feeding of Your Database – Fundraising Solicitations
As I mentioned in an earlier post, the care and feeding of one's fundraising database is important. It helps to keep your NPO running like a well-oiled machine.
Just as important as keeping your contacts straight is keeping your funding solicitations well-organized. One way to do this is through the use of the "Proposal" system. Keeping track of the proposals or funding requests you send to people or organizations will help you to track where your time is spent, not to mention the "life cycle" of the proposal in question.
Again, consistency is key when it comes to keeping your proposals in order. If you know you will have a lot of proposals, develop some guidelines as to how these should be entered into the system. Should you indicate the calendar or fiscal year in the proposal's name? What kind of giving this proposal falls under?
An example of codes you might develop for the database:
FY10: Operating = A Fiscal Year 2010 proposal for operating support.
FY10C: Astronomy Building = A Fiscal Year 2010 Capital support proposal for the astronomy building.
Your "naming" system should be as simple as possible while still allowing other employees to see, at a glance, what the donor or potential donor's solicitation history looks like.
The rest of the proposal record should be filled in as appropriate. Make sure you have the "Sent" or "Asked" date filled out when you actually ask the donor for a gift. Add in the amount of the ask - did you solicit Jane R. for $500, or for $5,000? Do you expect to receive the amount you asked for, or a smaller gift?
Similar to the "relationship" post, here too I counsel anyone designing a database entry system to keep it as simple as possible. Drop down fields should have as many options as necessary to get the job done - without being overwhelming. Avoid redundancy as much as possible; an employee shouldn't have to edit three parts of a proposal when one will suffice. This is especially important if you want anyone to actually follow your guidelines!