Raising funds for good causes.

Raising funds for good causes is a noble thing to do. I mean being a fundraiser and actually asking for monies is a noble thing to do. There are many nonprofit leaders who task others to raise funds and would rather not do the ask themselves. As a fundraiser, I see myself as a facilitator between a cause (need/want) and people with the means and perhaps interest to support the cause.

When I attended the Development Director Certificate Program at the University of San Francisco in the early  ’90, I was taught that there are several “types” of fundraisers. Some people would see fundraising as a professional job and do it regardless of the cause. Others would care deeply about the cause and try to raise funds because of the pressing issue. Obviously, nobody is just one or the other, but the point can be made that there are “professionals” dedicated to their industry and  “laymen” dedicated to their cause.

Would it not be great for you to find and hire a professional dedicated to this industry and your cause?

I am recently being reminded by books like  M. Sandel’s on Justice, that America is a country affording people choices in terms of what “goods” to pursue. The country does not impose on its citizens a fixed set of virtues to live up to. I thank America for that because I grew up in a country (Germany) that once tried to do that and with rather severe consequences.

Causes and virtues are inextricably intertwined with each other. Causes – in some respect – promote, uphold and honor  certain virtues. Thus, philanthropy may be a vital venue for a renewed discussion of virtues, if not only to balance the amorality of the ever-dominant  market place and the slightly coercive nature of the government in our lives.

Thumbs up for philanthropy!

Completed Database Conversion

It took almost two years, from the first moment of serious consideration to the final days of implementation: we let go of Sage’s Millennium and now work in Blackbaud’s Raiser’s Edge fundraising software.  I did not think that it would take that long and that it would be that complex.

Having worked as an independent consultat many years ago and having completed several fundraising database conversions for nonprofits and schools, I thought that I could perhaps do this conversion myself as well. But, hey, we are a state university and things get done differently.

There is a good reason for that. State universities are complex beasts of organizations, very different from small nonprofits. At a state university, there are many more stakeholders and whatever you do, you do not want to endanger the reputation of the university or cause grief otherwise to executive management.

A few month after we hired a consultant, Rob Weiner, to help us with the initial evaluation of software packages, the university’s information technology division stepped into the process, took some ownership of it, and gave me a project manager to oversee the entire undertaking. Talking about risk management. Well, it was for the better I think. It afforded me the time to keep doing my regular job directing advancement services, instead of primarily managing timelines, resources and conflict.

I also hired Sabre Leek, a consultant experience with Sage’s Millennium fundraising software, to re-align and “clean up” data in the system we wanted to retire. I thought it would be better to do the “scrubbing” in the system we were most familiar with, prior to the conversion. A smart move, as we encounted a gazillion of issues in the data.

Data in Millennium was not only inaccurate (Berkeley spelled as Bersekely, etc.), data also sat in the wrong places (employment data in the address fields, membership dues on non-existing memberships, etc.). This was not Millennium’s fault, but just plain, unintelligent data entry of the past. It took us about 9 month to massage the data to a point were it possibly could be considered safe for conversion.

We haggled with Blackbaud over the licensing costs for the Raiser’s Edge and got us some discounts. While I had a generous budget to work with, the Enterprise version of RE with a license for 20 concurrent users did not come cheap. One could buy a nice house in the Central Valley for the money.

I hired Heller consultants for the conversion and implementation itself. We got a deal there as well since they are local and did not incur a lot of travel costs. Their conversion programmer operates out of Chicago or so, and we managed with a few video conference calls. We had some issues with the conversion programming in regard to installment schedules for pledges. Heller consultants say that it is difficult to convert extensive pledge information into RE. Luckily we are in between fundraising campaigns and do not have a lot of pledges with outstanding balances.

So, after nearly four month of conversion and implementation, we are now tinkering around in our fundraining data within the Raiser’s Edge. Executives and staff are generally happy and inspired about the database. We had Heller consultants train our staff for a week on our premises and also provide individual hands-on assistance in terms of work flow and processes. Some of my core staff took Blackbaud’s online classes for the more intricate chores of data entry, etc.

I am almost done setting up the constituent codes, fund codes and the chart of accounts so that they lend themselves to a one-click VSE report. Sure do not want to spend countless hours running countless and disjointed queries and reports trying to get a coherent financial picture of our fundraising activites.

Successful fundraising is a complex undertaking. The more money you want to raise, the more effort you have to expend on systems like fundraising software and the maintenance of its data. While the Raiser’s Edge is rather full-featured and yet intuitive to use, it does accomodate the inticacies of  comprehensive fundraising methodologies and processes.

This poses a challenge to users, both fundraisers and advancement services staff, because many operational choices have to be made by them regardless of the systems intuitiveness and ease-of-use. In a report, do we want to summarize annual giving based on donations that walked through the door of the organization (gifts, pledge payments, etc.), or do we want to summarize based on committments made (gifts, pledges, etc.)? Do we need the report to be based on the calendar year or the fiscal year? Do we want to mail to home addresses as well as business addresses (if no home address exists)? Do we need your report in .pdf format or as a comma-delimited file? Why are there duplicates in the list?

In this age of a data-driven economy, endusers, including major gifts officers, will need to deal with some details of a fundraising system (processes, methodologies, data, hardware, criteria, formats, etc.) that may be too technical for many of the older generation.

Transposing Data

Have you ever had to export relational data from your fundraising database application to a vendor whereas the vendor asks for one row per constituent?

Let me give you and example. For the purpose of analytical modeling of fundraising data, a vendor might want to have a file that contains the name of the donor, along with the last five gifts, etc. The layout of the file would look as follows:
ID, Name, GiftDate1, GiftAmount1, GiftDate2, GiftAmount2, GiftDate3, GiftAmount3,….
005, Bill Jones, 3/5/05, $50.00, 8/11/06, $240.00, 23/1/07, $75.00, …
012, Mary Thompson, 4/7/05, $150.00, 12/4/06, $40.00, 2/11/07, $175.00, …

However, a typical export file, sorted by gift date, might looks like this:
ID, Name, GiftDate, GiftAmount
005, Bill Jones, 3/5/05, $50.00
012, Mary Thompson, 4/7/05, $150.00
005, Bill Jones, 8/11/06, $240.00
012, Mary Thompson, 12/4/06, $40.00
005, Bill Jones, 23/1/07, $75.00
012, Mary Thompson, 2/11/07, $175.00

Yes, you can sort the export file by ID in order to better group the gifts by donor, but the Excel past/transpose function will not care for that.

Microsoft’s Access suggestion, http://support.microsoft.com/kb/202176, is not doing it much better.

It has always nagged me not knowing how to easily transpose grouped data. Luckily, I found some VB code in the cloud last year that became the basis for a little Access database app of mine which transposes table data per group. Its not very polished right now, but workable. If you need a convenient solution for transposing a larger set of data for analytical modeling (Marts & Lundy, Blackbaud Analytics, etc.), please contact me. Perhaps we can work out a deal.