RP Blog

Fundraising Success Webinar!

by Amanda Mallinger Reinartz on May 17, 2012 1:52 PM - 0 comments

Data Data Everywhere!

Metafile is co-hosting a webinar with Fundraising Success on using data to optimize your fundraising results. This free webinar will cover topics such as how to clean your data, how to use it to identify donor interest, how to communicate with specific segments, and so on. The session will be moderated by Margaret Battistelli Gardner, Editor-in-Chief of Fundraising Success.

If you would like to register for this webinar, please do so using the link below. The webinar will be held June 7th, 2012 from 2 PM - 3 PM Eastern Daylight Time (1 – 2 PM Central, 11 AM – 12 PM Pacific). Register now!

Staying in Touch

by Marcia D Grimm on May 10, 2012 9:45 AM - 0 comments

Mother’s Day always makes me feel a little guilty.

Sure, I go visit and take a card and perhaps some flowers, but I can never seem to escape that nagging feeling that I should spend more time with my mom – especially on days that Hallmark has not reminded me to. I should be letting her know that she is an important part of my life and that I’m thinking of her every day of the year.

I think the same can be said for your donors. They need to know that they are an important part of the life of your organization – even on days when they haven’t made a donation. Think about reaching out to them before they send their next donation:

  • Send a note of appreciation to donors on a day of importance to your organization – like during National Volunteer Week or on the day you your organization was founded
  • Send copies of press releases you issue when something newsworthy happens
  • Send personal cards to special donors on dates of importance to them (e.g. birthday, anniversary)
  • Have your board members make personal calls to donors for no reason other than to say ‘we appreciate you’

Whether it’s your donor or your mother, relationships need tending. Your software can help you keep track and communicate, so be sure to take full advantage of all the functionality available to you.

Oh – and PS – don’t forget to call your Mom.

Online Giving Forms

by Amanda Mallinger Reinartz on May 2, 2012 1:14 PM - 0 comments

Wow! The last few weeks have been a whirlwind of activity. We’ve had numerous customers asking us to provide an online giving form for them. And we’ve been happy to oblige. Working on these web forms in recent weeks made me wonder how many of our customers are aware that we can do this, so I thought I’d share what “this” is.

At Metafile, we can build, host, and provide integration for online giving forms.

In most cases, customers choose our “standard” form. With the standard form, you can choose which funds to allow donors to choose from (if any) and how you want the funds displayed (for example, “Unrestricted”). You can allow donors to make recurring monthly donations. You can choose from a number of fields to display (name and address information, for example). And, you can support gifts in tribute. With the standard form, part of the initial setup involves our “skinning” the form to match the branding on your website, providing your donors with a consistent website experience.

We also have a few cases where customers have highly customized needs. In those cases, we build a completely custom form.

Once the forms are built (from the standard or the custom options), we host the forms so that customers can provide their donors with a safe, secure giving experience. And we provide you, our customer, with a tool that allows you to securely transfer the donor data into your ResultsPlus database.

However, you don’t need to have us build and host your forms! As always, you can have anyone you wish “do” your online giving for you and still bring the information into ResultsPlus via our online gift retrieval as an option when creating batches in ResultsPlus. If you don’t know what this is, take a peek in the Help system to learn more!

If you are interested in learning more about any of the options, let us know with a call or email. Or, if you’ve built your own and have experience you’d like to share, please do so in the comments section!

Wish #3: The Value of CRM

by Marcia D. Grimm on April 27, 2012 12:51 PM - 1 comment

In my January 20th post  I committed to sharing items from a ‘Wish List’ - things I wished I would have known when I was an active ResultsPlus database user. Well it’s time for wish number three, and no one was more surprised than me that I never took advantage of some very basic functionality in ResultsPlus: the calendar.

I confess to being a compulsive planner and organizer. I carried a Franklin Planner when that was the fad, a PDA when they first came out, and now I am completely dependent on Microsoft Outlook which I synch with my phone so that my calendar is always current and at my fingertips. So how could I possibly have overlooked the calendar in ResultsPlus? I came up with quite a few reasons:

  • I didn’t recognize the value of having dates and times connected to all the other information I stored about my donors. I was faithfully keeping track of appointments and calls in my ‘planner du jour’ but had yet to see the value of adding that to everything else I knew about my donors.
  • I was looking too narrowly at the application and not recognizing its value at tracking the touch-points of our donor relationships. It was primarily a place to store names, addresses and gifts.
  • My experience was primarily in one-person offices where there was little need for coordinated and shared information across a large development office.

The value of tracking this type of information is now so prevalent that it has its own moniker - Constituent Relationship Management – and it’s one of the most commonly-asked questions of customers shopping for fundraising software. The good news is that ResultsPlus is a very effective CRM tool for that can help you manage a 360 degree view of your donor relationship. You can see forward and backward in time, and side to side views of their connections to other constituents.

Share your experience using the CRM functionality of ResultsPlus and how it’s helping you to grow your relationships with your donors and your organization.

From Silos to Synergy?

by Amanda Mallinger Reinartz on April 19, 2012 3:12 PM - 0 comments

Having recently returned from a conference, I’ve been thinking about some of the current themes in nonprofit technology. As in the past, integration (vs. silos) was a major topic. In recent years the concept of silos vs. integrated systems has come up time and again and I’ve often felt the discussion missed the mark. While in the extreme, data silos can definitely contribute to issues, the major barrier to effective, consistent communication and knowing your constituents is often a human one.

As a technology provider, I really wish software could work magic and address the “people” aspect of integration, but it cannot. This year the discussion finally began to move away from data silos and on to work and intellectual capital silos. As I sat listening to the presenters, I was almost giddy over the shift in the conversation. There was a brief discussion about the concept of a 360 degree view of your constituent and, interestingly enough, that perhaps it isn’t necessary, despite the marketing rage with software vendors lately. Perhaps the “sweet spot” of cost vs. benefit is really somewhere else…say 245 degrees, for example. This view, while still contingent upon some shared data, has less to do with how you store your data and what tools you use and more to do with cross-departmental communication. For example, your traditional development department may be communicating a different message than your online marketing folks (email, Facebook, Twitter, etc.) because the two groups aren’t aware of what the other group is doing. Perhaps your traditional development folks and online marketing folks have different goals and are unaware of how these goals can be synergistic. With some of this in mind, I thought I’d identify a few of the changes organizations can make to integrate fundraising strategies so that constituents receive better, more consistent communication and I’ll even mention a few about data!

  • Hold a meeting. I’m not a fan of meetings, but sometimes, they are necessary. This meeting should involve both traditional development and online marketing. Come prepared to identify your past few appeals and campaigns, bring notes on who received the messages and the timing of those messages. Compare notes to see where there were messages going to constituents from both groups. Were they in sync campaign-wise? Were they too close together? Were they too far apart?
  • Work on your next campaign or series of appeals together. (This means more meetings, sorry.) Plan your messaging.
  • Figure out what bits of data each group would like to know. Often times, this information can easily be made available in both traditional fundraising systems and online marketing systems. Or, perhaps you can grant your online marketing folks access to the constituent database.
  •  You can update your database to reflect that constituents were sent specific emails. In ResultsPlus you can run an import with the names (emails are frequently good links to records in ResultsPlus) and set an appeal, a message title and date. Another way is to run the mail merge wizard using a query and defaulting the same information; you don’t actually have to send a letter or email, you can choose a record-only option. Doing this enables users (both traditional development and online marketing) to see a more well-rounded view of communications constituents are receiving.
  • Gather email addresses from traditional mailings so that the online marketing folks can make use of them.
  • Upload lists to online resources like Constant Contact or Mail Chimp for your campaigns.
  • Update mailing codes in fundraising software to reflect opt-outs from email without losing the ability to communicate using other methods, like regular mail.If you find it valuable, you can even work through your Twitter follower and bring the data you wish into your fundraising software to use as you slice and dice your data. Here’s a link to a site with great free social media tools.

The above data components are easily done with traditional import/export features. Or, if you have high traffic offline and online communication plans, these updates can be automated.

  • If you have a donor who usually gives online, but they give at a rate that indicates they should perhaps be identified as a major gift prospect, let your major gifts officers know. Let he or she drive the communications for that donor. If you have someone who prefers to only receive online communications (and this person’s giving history reflects that), inform your online marketing folks of this donor and let them drive that.

Are there other things you are doing to promote collaboration between departments at your organization that result in more effective campaigns? Is there something you struggle with? Let us know below. We’d be happy to try and help!

Build on the Basics

by Marcia D Grimm on April 12, 2012 10:52 AM - 0 comments

I was thrilled to be an attendee at the AFP International Conference in Vancouver BC last week. It was exciting to be amidst this energized group of professionals in such a breathtaking location! Thanks to our Canadian neighbors for hosting the event and for sharing the beauty of their city and country.

Ironically, in the midst of all the sessions about social media (and believe me, there were a lot of sessions about social media!), I found myself drawn instead to the topics which focused on a broader view of development and fundraising. After all, without a strong mission, development plan and organizational strategy, what exactly do you have to ‘tweet’ about?

A good example of this idea was presented in a session by Gretchen Gordon, CFRE and Jill Pranger, ACFRE. Their message was pretty simple: regardless of what methods you use, focus on a successful annual fund program and the loyal, repeat donors who give to your organization faithfully every year. It is these donors who form the foundation of your development effort and serve as a barometer for your organization’s image and reputation in the community.

You’ll know your annual fund is successful if you raise more money this year than you did last year... right? According to Gordon and Pranger, there are other ways to measure success. They shared some other ideas to measure the growth and success of your annual fund program:

  1. The percentage of particular groups of constituents who gave (e.g. 100% board participation)
  2. The number of new volunteers recruited
  3. The number of new prospects qualified
  4. The amount of the average gift across all donor groups or across sub-groups
  5. Non-financial goals (staff growth, training hours, etc)
  6. Comparison of your organization to national and sector benchmarks

Celebrate all the ways your organization is succeeding and use your software to help you measure it. In ResultsPlus, check out the canned reports that can help you quickly evaluate your success - the Activity Reports in the General section, the Gift Performance Analysis report in the Gift section, or the Five Year Gift Reports in the Trend section. For even more control, use queries to find the constituents who participated in your individual efforts, then export to Excel for further analysis and measurement.

We’d love to hear about the ways you use ResultsPlus to measure and celebrate your success. Please share!

Blogging from the NTC

by Amanda Mallinger Reinartz on April 5, 2012 9:20 AM - 0 comments

For those of you who are wondering what the NTC is, it’s the nonprofit technology conference held by NTEN (Nonprofit Technology Network) each year. Historically, I’ve enjoyed the conference and always learned a lot when I’ve attended. This year is no different! I wanted to jot a few notes about what I’ve learned so far, and to invite any of you reading this who are also at the NTC to drop me a note.

The opening plenary session was given by Dan Roam on using pictures to define and communicate problems. It was a wonderful session, and I came away with the following nugget:

“Whoever best describes the problem is the one most likely to solve it.” The speaker also shared that the beginnings of the solution are always in the definition (picture) of the problem.

Of course, Mr. Roam had many other interesting tidbits during the session, but I found that one very empowering. Each of us is in a position to solve the problems we understand and can explain well to others.

I also attended a session given by Keith Heller on successfully implementing a CRM system. Along with other great information, a number of things stuck out for me as he was covering a project that spanned many, many months:

  1. Goals and Measurement: You need to know what your goals are and how you intend to measure where you are regarding meeting those goals. This impacts a number of other decisions.
  2. Plan to use the system the way it was designed to get the most out of it.
  3. Know, train and use data entry standards for your organization.
  4. Define who does what in the system. Know who fills what roles.
  5. Get Buy-In from people who will be using it. (To me this seems like one of the most important components.)
  6. Do a test conversion so users can work with data they know before the final conversion to identify where changes may need to be made both configuration-wise and adjustment to your procedures-wise.

This is not a comprehensive description of all the things discussed during the session, but just a few great things that I think are easy to read and digest in a quick post. And hey! If you’re at the conference let me know!

Can they see right through you?

by Marcia D Grimm on March 27, 2012 8:58 AM - 0 comments

Two side-by-side articles on the front page of the NonProfit Times March 1st issue were pretty eye-catching: “Pink Ribbon Gets Black Eye” and “Where’s Your 990?” I doubt it was by coincidence that these two articles were paired together, since both aim at the issues of accountability and transparency by charitable organizations.

Later in the article I saw a reference to the United Way of America (UWA) scandal of the early 90’s, when then-CEO William Arimony was caught using UWA funds for some less-than-charitable purposes. After I got over the shock that 20 years have passed since then, I got to thinking about how things have changed during that time.

It seems to me that charities have evolved in the way we talk to donors and in the way we evaluate ourselves. We think in more business-like ways and see donors as intelligent partners in our missions. Out of curiosity I logged onto a few of my favorite charities’ websites to see if my theory had any merit. One organization now sports a link to directly display a PDF of their IRS Form 990. Another site proudly displays their audit report (though still offers to provide the 990 only upon request).

From my perspective, accountability and transparency have become minimum requirements for any self-respecting nonprofit organization, and your fundraising software should support that. There are a few features built into ResultsPlus which, while originally designed for data protection purposes, can also help you with these goals:

  • A fund code is required to be entered for each gift. This is one small step to make sure that the purpose of a gift is addressed when it is entered into ResultsPlus. Additional fields are also available for describing donor intent in more detail.
  • If you use our recommended settings, gifts cannot be edited once they are posted. A credit memo must be entered to offset the original gift, and then a new gift entered with the correct information. This forces an audit trail to be created to document any changes made to gift records. It also protects the data enterer by eliminating any loopholes by which gifts could go missing. This should also make your auditor and accountant a bit happier as well!
  • Audit fields are stored in most tables in the database and any changes to gift records are logged. This allows administrators to see who was in the database when specific changes were made to data in the tables. It keeps database activity at a very transparent level and protects everyone – and it’s the primary reason we strongly recommend that you do not share usernames and passwords.
  • Transmittal Reports are generated as a required step for each batch to be posted. This is another form of documentation which can help clear up discrepancies in your data.
  • In addition to the system-required fields, other fields can be set as required to force consistency and prevent incomplete information from being added.

Use these features to help force some accountability steps into your processes and procedures. It can help you prepare for questions from the boss, the board, the auditor, and even a funder or donor – especially the smarter donors of today. With any luck, they aren’t going away anytime soon!

Happy Belated Pi Day!

by Amanda Mallinger Reinartz on March 19, 2012 9:05 AM - 0 comments

If you read the headline for this post, you likely already know what very special holiday occurred this week on March 14th. It was Pi Day, and I’m not talking about apple, pumpkin or the yummy chocolate silk varieties; I’m talking about that very special number: π 

When I think of Pi, I think of hours spent in Algebra II and how the teacher had Pi printed to I-don’t-know-how-many digits taped to all four walls, completely enclosing the room in this glorious number. I thought that I’d use the first few digits of that number today to identify some things you may or may not know about ResultsPlus. 

3               You can include up to 3 default sort levels in any query you write in ResultsPlus. And if you wish, you can change them after the results are returned

                  and sort any way you please. 

.                I’m making a point here (everyone groan at the pun), let’s move on to the next number. 

1               The No. 1 thing you should always do with your database is back it up. 

4               There are at least 4 ways you can create reports in ResultsPlus.
                      1.  You can write a query and format the results as a report for printing.
                      2.  You can export the results of that query to Excel and add pivot tables and charts, and whatever else you can imagine.
                      3.  You can run a standard report designed to accept queries as the data source.
                      4.  You can create your own report in Crystal Reports and add it to the ResultsPlus reports menu. 

1               You can see how your fundraising is going with 1 button – The Performance Overview button on the Performance tab. 

5               5 days a week the phone lines are open for support. Of course you can send an email any time!

9               There are way more than 9 “shortcuts” to various ResultsPlus features. My favorite ones are available by right-clicking on items in ResultsPlus to

                 access the most commonly used features in those areas.

2               There are 2 main methods of accessing the ResultsPlus Help system. Click the All topics button to open the Help system at the beginning, or hit F1 from

                 any screen in ResultsPlus to open the help to the topic specific to the screen you are viewing. (Hey, that’s another shortcut!) 

6               There are 6 ways to access mail merge (both regular letters and email) features. You can access mail merge from these locations:
                      1.  Individual screens (like a donor’s gift)
                      2.  Batch Processing
                      3.  Pledge Processing
                      4.  Membership Processing
                      5.  Home tab
                      6.  Context menus: right-click on any list of retrieved records 

5               There are 5 variations of the ‘Donor List’ report. Check them out to see which one’s right for you.

Write It Down

by Marcia D. Grimm on March 8, 2012 12:27 PM - 0 comments

A number of years ago I was working for a company that was engrossed in business strategies like ‘Total Quality Management’ and ‘Continuous Improvement.’ For a while it seemed that all we did was plan. We even had planning meetings to plan our plans. At the time, I don’t remember accomplishing all that much, which was pretty ironic. But in actuality, I can now see that I learned something very important which I use nearly every day of my current life. It’s a single piece of advice that stuck with me and here it is:

If you really want to accomplish something, write it down.

Seems too simple to be of any great value, doesn’t it? Consider some of the benefits:

  • The simple act of committing something to text helps me actually commit to do it. It turns an idea into a goal and when I see it right there in black and white (or in pixels), it’s pretty hard to pretend I didn’t.
  • Writing it down gives me permission to stop carrying it around in my head. There’s plenty of other ‘stuff’ I need to make room for up there, like my mother’s recipes and my anniversary (which incidentally are all getting written down now too…).
  • Documenting my tasks and goals helps me prioritize them. Especially when I put them on sticky notes and then continually rearrange them as new ones get added. When one task becomes more urgent than the others, I move it to the top of the list.

So what does this have to do with fundraising software? Everything. Any good fundraising software will let you document the important things in your development effort and help you commit to them and achieve them. If you’re not doing so already, consider using ResultsPlus to:

  • Commit to contacting that donor who is considering leaving a bequest to your organization in their will. Enter a contact record in the Edit Cultivation Data area to schedule a call to them next week. Schedule a reminder to pop up and prompt you the day before so you can prepare for your conversation.
  • Set yourself a target and commit to raising more from this years holiday appeal. You can associate your new goal amount with your Appeal Code in the performance code editor, then use the Expense Detail fields to help you determine your net amount raised.
  • Research potential major donors for funding your upcoming special project. Document what you learn and what you already know in note pad areas on the Executive Summary and in the Strategy/Cultivators area.

Let your software help you document the important things that you really want to achieve. Write them down, get them done.

Care to share how you use ResultsPlus to keep you on goal?

How Do Enhancements Get Identified?

by Amanda Mallinger Reinartz on February 29, 2012 12:47 PM - 0 comments

As we’re getting ready to release ResultsPlus 11 (phase 1), I’ve been thinking about version 12…and 13…and… It comes up fairly often that a customer asks how to submit a suggestion for an enhancement, and it’s easier than you might think. Every enhancement suggestion submitted, either by email, phone, or pony express, gets entered into a central location and reviewed regularly as we are laying out plans for upcoming versions.

So, how do you make a suggestion?

You can share your idea with a support person on the phone. Or, better yet, submit it as an email to support so that your exact words are entered as part of the suggestion. Let us know what business problem this solves, or in what way it makes doing business easier for you. Let us know where you’d like to see it in the product. You never know, your suggestion may be in the next version! While we do not respond directly to each suggestion, know that they are received and that we appreciate every submission!

How do we evaluate which enhancements “make the grade”?

We look for how applicable the suggestion is to nonprofits as a group vs. solving an issue unique to one organization’s way of doing business. We also consider how many people/organizations have submitted similar suggestions, and the scope of impact on the application’s current functions, both positive and negative. Additionally, we research what capabilities the coding tools we use (and those we don’t) have, and whether or not these tools will enable us to implement the requested features. All these things combine to give us an idea of whether or not it’s “time” to implement a suggestion. Sometimes, we can implement them right away. Other times, it isn’t as easy to do.

For example, we reviewed the suggestion to allow splitting of donations between multiple campaigns and appeals over a period of years and versions. Because of the disruptive nature of the feature (impacted queries, reports, past reporting, etc.), it took a few versions before we could implement it. We needed to make sure it was wanted by a wide enough group of customers that the disruption didn’t outweigh the benefit. As you may already have experienced, that enhancement was in version 10.

Another example of an enhancement that has taken years of review and design is the implementation of row-level security-coming to ResultsPlus 11 Platinum edition. This is something that could be done technology-wise but was, before now, cost-prohibitive to implement for mid-sized nonprofits. With new features in 3rd party toolsets and platforms now available, we were able to design and implement these functions without adding cost to the product.

Even if your suggestion doesn’t get immediately implemented, know that all suggestions are reviewed, many times over years in some cases, so never hesitate to submit a suggestion!

Another Wish for You

by Marcia D. Grimm on February 21, 2012 10:51 AM - 0 comments

It’s time for another wish from my ‘if only I knew then…’ list. If this makes no sense to you, check out my post from two weeks ago where I promised to share some of the things I’ve learned about ResultsPlus I wished I’d known when I was sitting on your side of the desk. This post contains wish number two.

How many times have you been asked if you have a current backup of your database? Between the warning messages that pop up on your screen and the verbal requests from technicians on the Help Desk, it is a question which is impossible to avoid. The problem, I recall from my days in a hectic development office, is that the question surfaces at the exact moment when you don’t have time to deal with it. Inevitably, it occurs on the drop-date for the largest mailing of the year or when the board president is tapping their foot waiting for the information they have asked you to provide.

My wish is that you know how important the answer to the backup question is and how simple it can be. With a very small amount of work up front you can say “Yes, I have a backup and it was run last night” Consider doing the following three things right now:

  1. Make sure a backup process exists. Talk to your IT staff or consultant to determine what, if anything, is already in place. It’s very possible your database is included in a network backup strategy. If not, you may need to purchase backup software which specifically handles this task.
  2. Know what your backup schedule is. Once your backup process is established, know what the schedule is. If you don’t handle this process yourself, ask the person who does. Is it run nightly? Are copies of the backups stored elsewhere? And don’t accept any answer which begins with the words ‘I think …”. Make sure you know and maybe even ask for proof once in awhile (like requesting the date on the most recent backup file).
  3. Know the process for restoring a backup file. Should it ever become necessary, you should know what steps to take to retrieve a ‘good’ copy of your database. If this is handled by IT staff, this is a good time to get that proof you need that your data is safe and secure. It can also help you gauge how much time it will take to get your database back up and running again.

Invest the time up front to protect against the inevitable problems in the future and get your backup house in order. Your time is valuable, and so is your mission. Serve them well.

The Old is New Again (Segmentation), and For Good Reason!

by Amanda Mallinger Reinartz on February 9, 2012 12:46 PM - 0 comments

I’ve been seeing a lot written about segmentation lately. I even attended a Network for Good NonProfit 911 webinar on that very topic this week-and it was excellent. The concept of segmenting your prospect and donor data is nothing new, but the recent re-focus on the concept has me “all aflutter.” I love segmentation because it’s a beautiful example of how you can make all that data you’ve been so diligently gathering and entering into your fundraising CRM system work for you.

By segmenting your data you can:

  1. Send tailored communications to your constituents, ensuring the message they receive is geared toward them.
  2. Run reports to compare how various segments respond to your campaigns.
  3. Run queries to slice and dice your data based on any number of ways you wish to segment your data (constituency, gender, profession, highest level of education, marital status, campaigns, funds, gifts given in tribute, soft credits, and the list goes on).
  4. Create reports for your queries using the quick reporting tools in ResultsPlus. A go-to function of this tool is “sum”, but did you know you can also get averages, and perhaps even more importantly, medians? When working with donation amounts, for example, averages can be skewed high or low by your outlier donors, but the median will be the amount below which half of your donors gave and above which the other half gave. It is often a better indicator of the amount your “middle” donors give.
  5. Make data-driven decisions! Items two through four put you in the best position to make decisions and to improve how you work on your relationships with your donors, prospects, and volunteers. They can provide visibility into your past campaigns and appeals, identifying which ones worked well for which segments (and which ones didn’t work as well as you intended). This information is invaluable when working on new campaigns because it can help steer your efforts towards the actions and messages that are proven to work, and it can bring to light the areas you may want to adjust.

With all these great things you can do with segmentation, perhaps a slight distillation of the term is in order. There are, what some consider complex, forms of segmentation like RFM (also known as RFA analysis in some circles). This form of analysis generates what is called a segmentation code. The code is made up of 3 parts:

  • Recency: When the last donation was made (usually defined as a range, like 1-3 months, 3-6 months, 6 months – 1 year, etc.)
  • Frequency: How many times the constituent has made a gift (also a range like 1-3, 4-6, etc.)
  • Monetary (or Amount): This part of the code can be either the total amount of gifts ever given (the more common approach) or the single largest gift ever given.

These 3 items likely sound familiar to you, as most fundraising databases track this information. What’s unique about generating the code is that you:

  1. Don’t have to write a bunch of individual queries to put all the combinations for Recency, Frequency, and Amount values together to retrieve records.
  2. Don’t lose the historical information when the donor makes a new donation. Because a new donation changes the Recency and Frequency values (and usually the Amount, as well), so the segment changes. This is a good thing, but you may not want to lose the past segments a constituent has “passed through” as you’ve produced your appeals (because this information can be really useful when analyzing performance later).

However, there’s more to segmentation than RFM analysis. And for many organizations other ways of segmenting data are just as useful, and sometimes more useful, than RFM analysis. You may choose to review segments based on constituency, marital status, a special interest category, people you know are on twitter, Facebook, etc. Perhaps you even combine these things with one or more aspects of RFM analysis. The key is to know why you are looking at specific segments, and what you intend to do with your findings. Is it to learn how one behaves compared with another? Is it to analyze whether one segment is getting a more well-rounded view of your organization because of your approach to communications? Is it to help a specific segment to be more involved with your organization in some way? The questions are as endless as the ways you can segment your data. And this is a very beautiful thing.

Are there specific ways you segment your data that have served you well? Do you have a way you’d like to segment your data but are unsure how to go about it? Feel free to post them in the comments section.

Fundraising Effectiveness Project

by Marcia D. Grimm on February 3, 2012 9:57 AM - 0 comments

Now that another calendar year has passed, it’s a logical time to evaluate your fundraising efforts for 2011. Did you obtain new donors? Did you increase the size of the average gift over the previous year? Did any of your donors increase their giving? It’s no surprise if these questions seem familiar to you since they are likely asked every year by many of your colleagues in the nonprofit sector as they evaluate their development efforts.

These questions are likely the same ones that prompted the Association of Fundraising Professionals (AFP) and the Urban Institute to begin the collaboration called the Fundraising Effectiveness Project (FEP) back in 2006. The goal of FEP is to help you to evaluate your own effectiveness and ultimately to grow philanthropy overall. ResultsPlus is proud to be a charter member of the Fundraising Effectiveness Project. Learn more about FEP here.

The most tangible outcome of FEP so far is the Growth-in-Giving Report and, for you as a ResultsPlus user, it’s literally just a few keystrokes away. In ResultsPlus 10, click FEP Submission on the Administration Tab and then enter your information as directed. You can print or submit the report, or better yet, do both. Then, take a look at FEP’s sector-wide data here.

Seasoned analysts and data newbies alike will find this report immensely helpful. Please let us know what you think.

Nifty Reports You Didn't Know You Had

by Amanda Mallinger Reinartz on January 26, 2012 9:10 AM - 0 comments

If you read Marcia Grimm’s post last week mentioning she wished she would have recognized the value of reports (where she even shared a few), you may be wondering about what other reports are available. Here are a few common ones I like to highlight.

ResultsPlus reports are divided into a number of categories. I’ll focus on one or two reports from the most popular categories.

Batch
Batch reports are printed by using the batch number associated with each donation. These reports tend to work really well for reconciling deposit slips, for comparing against accounting systems, and for use by auditors.

Folder
Reports in the Folder category are based on various types of constituents in your database. You can run lists by constituency, type (individual, corporation, foundation), etc. You can also run your Top N Donor lists. These lists are great tools to have in campaign planning meetings when you wish to identify lead donors for new campaigns.

General
The Activity reports are great reports to use for Board meetings. The Activity Report by Campaign is especially helpful at various checkpoints throughout your campaign lifecycle. It can be run by date range, so you can view the entire life of the campaign, or compare two different periods.

Gift
The Gift category contains Donor Recognition reports that are great for printing or submitting to printers for inclusion in newsletters or annual reports. Another set of informative reports is the set of Gift Constituency Analysis reports. The Gift Constituency Analysis by Campaign is an excellent report to use if you’d like to see how much a specific segment is contributing to a specific campaign effort. It will display the number of donations, the total given, the average gift amount, and the largest gift. What’s really nice is that it also displays the percentage of people in the segment (Constituency, in this case) who have contributed, helping you identify if your messaging to the segment is as effective as you intend. When run periodically, you can tweak your messaging to help you get to your goal. If you want to get really fancy, you can run the Gift Constituency Analysis by Appeal for the appeals that are a part of your campaign to evaluate each appeal for its effectiveness.

Trend
These reports provide summaries of various types over a period of time, showing you increases and decreases in giving so that you can identify trends you want to nurture, or perhaps trends you’d like to nip in the bud. A nice, easy-to-digest report is the 5 Year Trend Summaries report. It is a graphical report showing total giving, averages, medians, and acquisition over 5-year timeframes. You can select the start date to see various 5-year chunks of data.

Beyond the above categories and reports, the ResultsPlus help system can be very informative in your search for reports that provide meaningful metrics. Open the system by clicking the Question mark in the upper right corner of your ResultsPlus ribbon. From there, open the topic, “Running Reports.” The reports, descriptions, and parameters are identified by each report category. There is a screenshot of each report so that you can see what it looks like before running it. After you’ve narrowed the list to a few that appear interesting, print or schedule them to run for a “test drive.”

Are there reports I didn’t name here that you find extremely useful at your organization? In what ways are you able to use them to evaluate your performance, ability to meet your goals, and make decisions?

Sharing my Wish List

by Marcia D Grimm on January 20, 2012 11:29 AM - 0 comments

The past five years as a member of the Metafile support team has given me a fascinating perspective on my former life as a fundraiser. And while I’m busy looking forward and gaining new knowledge every day, I often catch myself looking back with that annoying cliché: “if only I knew then what I know now.”

So for what it’s worth I’m going to periodically share some of these insights with you (presumably a ResultsPlus user, development professional and blog reader) in hopes that they might prove to be helpful in your current life as a fundraiser. Let’s call it a wish list, and though it’s backward for me may it be frontward for you:

Wish #1: I wish I would have recognized the value of the reports which came built into the program. Sure I ran some of them regularly, but generally just those which showed lists of people or gifts. I missed the opportunity to take advantage of some of the more analytical reports in ResultsPlus - like the Fund Comparison Report, the Statistical History Report and the Gift Performance Analysis. All of them provide valuable information which could have helped me review my past activity and better plan for the future.

Which ResultsPlus reports do you find the most helpful? Please share, and watch for additions to my wish list for you in future blogs.

Plans for 2012

by Amanda Mallinger Reinartz on January 9, 2012 3:26 PM - 0 comments

As the new year kicks off, I wanted to take a few moments to share with you some of our plans for ResultsPlus in 2012.

ResultsPlus 11: We are busy testing ResultsPlus 11. It will be rolled out in 2 phases. The first phase will be a special edition that includes support for using Moneris as a credit card and ACH/EFT processor. We are excited about this new partnership with Moneris. There are a number of additional enhancements we’re testing for this first phase of version 11. Here are just a few:

  1. Quick Entry for Gift, Pledge, and Membership now supports an Excel-style entry format, making the process even quicker.
  2. Support for “Single Sign-On” has been added. This enables you to map your Windows user account to your ResultsPlus user account. When this is done, ResultsPlus will ask you to enter your Windows username and password when you log onto the database, enabling you to use the same username and password for ResultsPlus that you use for your other network activity. This also enables organizations to enforce their password policies, even in ResultsPlus, providing a more secure environment.
  3. You can now send your ResultsPlus contacts to other calendar programs using the iCalendar format. This enables you to share appointments with people who don’t use ResultsPlus, even if they don’t use Outlook. If you wish to send the appointment to a Board member, for example, but you do not know what calendaring program he or she uses, you can do so. Most major programs accept the iCalendar format.
  4. You can email scheduled contacts to the solicitor and other cultivators associated with a given contact record.
  5. Customers with the Platinum edition of ResultsPlus will be able to run an immediate backup whenever performing maintenance or import tasks. This will enable you to ensure you have a recent backup whenever you make large-scale changes to your data.

The first phase of version 11 will be made available the end of February. The second phase will include additional features like project management and document archival. We’ll have more to come on that in the coming months.

New Blogger: We’re adding a new regular blogger in 2012. Her first post was last week. Marcia Grimm will be a regular contributor to this blog. She has been a Development Director and Executive Director for multiple nonprofits in the past. She joined Metafile in Technical Support a few years ago. Recently she has taken a new position as Development Education Director here at Metafile. I look forward to reading her posts from the perspective of having worked in both industries!

New Courses: In addition to the ongoing changes in our tips and tricks section, we’ll be adding new courses to our online education site, www.resultsplus.tv. We’ll have more to share on that in the coming months as well. Look for changes during the first half of the year.

Happy New Year! We look forward to continuing to work with you in 2012.

Resolutions for the New Year

by Marcia D. Grimm on January 4, 2012 3:20 PM - 0 comments

There must be something about turning the calendar page which makes us think of turning over a new leaf. Aside from the obvious change in numeric year, maybe it marks the end of the excesses of the holiday season and a self-promise to be healthier.

In that light, this could be a good time to institute some healthy practices in your fundraising database. Start by looking backward and identifying some of the problems you had, then make your resolutions accordingly. Here are some suggestions based on some of the more common things we hear from our customers:

Resolution #1: I’ve got to get rid of all these duplicate records!
If your database is plagued with numerous duplicates you could be wasting precious resources, including time, financial and natural. If so, plan to run the Merge Constituents Wizard on a regular basis to make this task more manageable. After the first initial effort, it will be a much less daunting task.

Resolution #2: We need to get consistent about how we enter information into our database!
There is a good chance for data to be inconsistent if you work at an organization where more than one person enters or edits data into your database. Resolve to make this year the one where you create a set of policies to define how things are done. (eg. Always spell out ‘and’ when using ‘Mr. and Mrs.’ as a title). Documenting these rules and decisions can make data entry more efficient and accurate and save considerable time in the long run.

Resolution #3: There’s more we can be doing – we just need to know what the program is capable of!
Make this the year that you attend a class on using your database. Then, take things one step further and spin the experience into your own internal training process. Use the training manual provided to help create a procedures manual specifically for your organization. It will help to cement what you learned and pave the way for other users to get up to speed more quickly in the future.

Start the New Year out right by budgeting the resources you need—both human and financial—to make the most of your fundraising database. Care to share your resolutions here with us?

Article on Ways to Boost Responses Using Your Data

by Amanda Mallinger Reinartz on December 21, 2011 10:28 AM - 0 comments

Perusing the NonProfit Times website, I found an easy-to-read article on 5 ways to boost responses based on data in your donor database. This article seems like a perfect way to refresh and update development skills even though time is likely short for many people as the year draws to a close. Each of the 5 recommendations can be done using your ResultsPlus database and the donor data it contains.

  1. Analyze past giving behavior: From the Executive Summary, you can see each fund, campaign, and appeal to which a donor has responded. You can also access lots of additional data, based on how you wish to perform your analysis.
  2. Segment for sensitive issues: Because ResultsPlus enables you to store information regarding each donor, you can use this information to include or exclude people from your communications.
  3. Use behavior data: if you use ResultsPlus to track additional relationship information about your donors and their relationship with you and others, this can be leveraged as part of you strategy.
  4. Reference past gifts in the copy: Referencing annual giving, total giving, or a single past donation are all possible when qualifying and merging information from ResultsPlus into your copy.
  5. Use additional data in copy: Using additional data in copy is much the same as referencing past giving data when it comes to using ResultsPlus. For example, you could include the name of the family pet in your copy, if it is something you store in your ResultsPlus database. Or, you could include a note about running, if it fits with your communication, and you’ve stored the donor’s interest in running in their database record. Be as creative as you like!

If any of these 5 ideas appeal to you, go for it! Let us know if you have questions about how to find specific pieces of information in your ResultsPlus data.

Do you have additional recommendations for boosting responses? What has worked for you?

Year-End and Beyond

by Amanda Mallinger Reinartz on December 15, 2011 11:33 AM - 0 comments

This is the time of year when organizations start thinking about closing the year, if their fiscal year matches the calendar year. And even for organizations whose fiscal year doesn’t coincide with the calendar year, things like the distribution of donation summaries for donors are in many professionals’ thoughts.

If your organization sends letters to your donors with their annual giving information for tax purposes, I recommend reviewing a few options available in ResultsPlus to produce these letters.

If you only send the sum of all donations for the year, you can create a mail merge letter or email and place the following two fields in it:

Count of gifts for the year: Folder.YrToDateCnt
Sum of gifts for the year: Folder.YrToDateAmt

There is an additional option for those of you who intend to send the letters via “snail mail” and would like to send your donors an itemized list of their donations. I recommend reviewing the “Yearly Tax Receipt by Group” report in the Reports area of ResultsPlus. You can run this report for the year based on a query. You can use the same query to create labels in the Mailings area of ResultsPlus.

If the end of the calendar year is also the end of your fiscal year, take a peek at the LYBUNT and SYBUNT reports before closing your year. (After you close your year, everyone is a SYBUNT or LYBUNT until the first donation of the new year arrives!)

You can also use the “Donor Retention” area on the Performance tab to generate these lists for immediate action (email, letter, schedule a visit with the high-dollar donors, and so on).

Do you publish giving levels? If so, remember to run the giving levels for the year, as well. These can be printed from a query or a standard report. The Recognition Roster in the “ROSTER” category provides the option to run a list of donors and group them by giving level. This report may serve well as the source for your list.

Are there additional reports or processes you do at your organization to ensure a successful year-end experience?

Gift Entry Time-Saver

by Amanda Mallinger Reinartz on December 8, 2011 10:50 AM - 0 comments

Do you find yourself entering the same bits of data over and over when entering donations? If so, there are a couple things you can do to save yourself quite a bit of time.

If you are in the middle of an appeal where most of the donations are in response to the appeal, you can add default values (like the appeal and campaign codes) to your quick entry form for gifts. Even if you use the “standard” form, these values will default for you. And don’t worry; you can override them when entering donations if you wish.

Perhaps you want something a little less persistent. If you organize your donations according to similarity before entering them into your database, you can enter part of the first one and use CTRL+F2 to set temporary defaults. Then, when you enter your subsequent gifts, simply press F2 to apply the defaults. You can even change these defaults mid-entry when you move to a second stack of donations that have a different set of similarities.

Also, take a couple minutes and check out the shortcut keys. You can likely avoid the mouse altogether once you learn the keystroke combinations to get you from looking up a record (ALT+N) all the way through saving and closing the form (ALT+S).

Have you discovered other time-savers you think others may not know about? Please share them in the comments below!

Sign Up for Our Free Webinar + Best Practices for Handling Constituent Deletion

by Amanda Mallinger Reinartz on December 1, 2011 9:25 AM - 0 comments

Webinar

Our free webinar on using the charts available on the Performance Overview in ResultsPlus will be held December 8th at 1PM Central Time. If you would like to learn more about it please register today!

Best Practices for Handling Constituent Deletion

It happens from time to time. You have a constituent, or a group of constituents, that you think you may want to remove from your database. As you think about this, a common question may come to mind:  Do I really want to remove these records from my database, or should I just deactivate them? The answer to that question is the ever-popular, “It depends.”

And these are the things on which it depends: Is the constituent a donor? If yes, consider marking them deceased (if the person has passed away) and inactive rather than deleting them from your database. There are a couple reasons for this.

  • You do not want to lose this donor’s giving history, and it will be deleted along with the rest of this person’s information if you delete the record.
  • Other donors may wish to make donations in memory of this person. Do you know any family members of this person? Close friends? Perhaps a conversation with these folks will inform you regarding interest in memorials.

If the constituent is not a donor, is there other valuable information you do not wish to lose? Known relationships to other donors, long-time volunteer, potential donor, etc. Again, if the answer to this question is yes, you may be best served by marking the record inactive.

If the record is not that of a donor, tribute, viable prospect, or other “asset”, consider deleting the record. A good example of a candidate for deletion is a record that was added to your database because of a rented or purchased direct mail list. Often, there are time limits for using these lists. If the time has passed, identifying all the non-donors from the list can be done with a query. I like to use specific Source codes when I initially import the list. I can then use that code as part of my query to identify those I wish to delete. The query can be used to simply delete the entire group of records.

Not every candidate for deletion comes from an easily identifiable list. This is where the rubber meets the road (or where policy meets reality, if you prefer). Implementing a maintenance policy at your organization needn’t be too time-consuming and can help handle the ongoing need to ensure you do not have “excess baggage” in your database. I recommend creating a group in your database called “Potential Deletes.” This group can then be accessed by everyone who uses ResultsPlus. As people identify records they feel are candidates for deletion, they can add the records to the group. Then, at the end of the month (or quarter), have a quick meeting to review the candidates to decide which ones should be deleted and which ones shouldn’t. Remove any records from the group that got in there erroneously, based on the outcome of the meeting. Then, use the group to delete the remaining records. Afterward, you’re ready to move ahead with a group that will slowly gather candidates again over the coming months.

One note: Remember that you can merge records, too! Perhaps the record is a duplicate and should be merged into another record instead of deleted. That’s OK, too. The outcome is the same: happy data!

Are there other ongoing data concerns that crop up in your database? Feel free to share them by submitting a comment below, and I’ll try to address them in an upcoming post.

Happy Thanksgiving

by Amanda Mallinger Reinartz on November 21, 2011 11:01 AM - 0 comments

For this week's post, I wanted to highlight how thankful I am for our customers.  Aside from the obvious business reasons, I am grateful for each of you because of the fun and unique relationship we've built over the years.  I look forward to continuing those relationships and building new ones with new people and entirely new organizations.  Working with nonprofits is its own special joy.  It's such a privilege to work with people whose purpose is to help others, whether through community service organizations, spiritual organizations, health services, education, animal welfare - the list goes on.  Know that you and your work are appreciated!  Happy Thanksgiving.

Using Facebook

by Amanda Mallinger Reinartz on November 16, 2011 10:44 AM - 0 comments

Before the main topic, just a quick note about today, November 16...It's Give to the Max Day (www.givemn.org)!  Today is the day all of Minnesota focuses on charitable giving. (We don't ignore it the other 364 days, but today is really special.) To date, GiveMN has helped Minnesota nonprofits raise over $30,000,000.00. Let's raise that by another few million today!

And now to the topic of the week...

ResultsPlus doesn’t have a Facebook page. To date, Facebook doesn’t seem to bring much to the table from an engagement perspective. But that’s for ResultsPlus. I’ve seen a number of nonprofits with very active Facebook pages. And they’re often active because of people posting about their attendance at events. They may be indicating that they are attending, or that they did attend and had a great time. You’ll see great stories about their plans to attend or an interesting thing that happened at the event. I’ve sometimes found myself posting to these pages, commenting about some cool aspect of the event or another. When asked, I’ve even invited my Facebook friends who live in the area to attend these events!

Why am I sharing this? Because these are examples of effective use of Facebook by the organizing nonprofits. It seems to me that a number of incredible objectives are met, and none of those objectives is “Make a Donation.” That doesn’t mean I don’t believe you can raise money on Facebook; it means that, from my perspective, the donations are a side effect of other opportunities for engagement. In this post, I intend to share the objectives met, as I see them, and to ask you to share with me what you do on Facebook. What are your objectives, and how do you meet them? I’m not an expert on nonprofits’ use of social media, so I’m hoping you will help out and correct me where you feel I’m wrong, and to add your own 2 cents’-worth (or even a whole quarter’s-worth!) of experience with using social media effectively.

Here are the objectives, as I’ve experienced them:

Engage those who are aware (increase loyalty)

  • Invite people you know to attend
  • Provide space for people to post their own thoughts about the event
  • If you need help, ask people if they can provide help.

Induce those already aware to make others aware (increase awareness)

  • Ask fans of the page to invite their friends to attend

Share interesting content (increase awareness)

  • As you ramp up for the event, post progress updates. If applicable, post pictures of the “work in progress.”Induce people to attend your event (develop awareness and loyalty)
  • See above!

The interesting side effect is that these people are not only more engaged with the specific event, they talk about it with their friends, they purchase tickets, they learn more about the organization, they volunteer, and they may even donate!

As I mentioned above, I’m no expert. I invite you to post comments, success stories, lessons learned…whatever experience you have regarding social media, and specifically Facebook. We’re all in this crazy world of evolving technology together!

Seeking Input for Webinar: Please Help!

by Amanda Mallinger Reinartz on November 10, 2011 10:17 AM - 0 comments

We're putting together our next free webinar for ResultsPlus to be held on Thursday, December 6th from 1 PM Central Time - 2 PM Central Time.  The topic will be Performance Metrics, and specifically focused on the Performance Overview and how to read, interpret, and use it for decisions.  Please let us know if there are additional aspects of the Performance Overview you would like covered in the webinar.  Or, if there are other specific questions you have regarding gathering performance statistics, let us know that too.

We may not be able to cover everything in an hour, but we'll try to incorporate as much of your feedback as we can.  Please submit your requests in the comments section below this post.

Here's what we currently intend to cover:

  1. Providing charts to stakeholders
  2. Changing the view of the charts
  3. Comparing one chart to another
  4. Drilling into charts
  5. Using chart data for making decisions
  6. Using chart data for action

We'll be sending an email with registration information soon.  Sign up for email communications to make sure you're included on the list!

Please let us know what else you'd like to see in a webinar on the Performance Overview!  Thanks!

A Hauntingly Good Time

by Amanda Mallinger Reinartz on November 2, 2011 9:21 AM - 0 comments

This past week, I spent quite a bit of time helping with a 4-day event here in Rochester. It was a fundraiser for a local nonprofit. The event required about 500 volunteers and had between 5,000 and 6,000 participants. I came away from this event with several thoughts that I’d like to share with you.

  • Events that involve so many people take a ton of effort, and they are very tiring. However, they also garner huge community support and awareness for your organization. Throughout the event, we heard amazingly supportive comments from local businesses and community members.
  • Every event is an opportunity to learn. Each day of the event, we came away with new lessons. While things may have appeared to be running smoothly on the outside, those of us working behind the scenes had a different perspective. We made adjustments each day of the event based on the past days’ experiences. This not only provided us with the opportunity to evaluate the changes, we also got to experience the issues that bubbled to the top once larger ones had been addressed.
  • Businesses want to be involved. I think that, sometimes, there is an assumption that businesses and nonprofits have different goals. And this is true. However, the goals are not mutually exclusive. The businesses involved with our event had a great time helping during the event, and many of them commented about what great community exposure they were getting as a business.
  • As a product manager for software, my day involves lots of problem-solving. I primarily see the side of things that aren’t working and focus on what can be done to “fix” them. While this skill-set was invaluable during our event, mingling with the participants also provided the opportunity for me to see things from the perspective of those experiencing success and fun. This perspective is invigorating, and it reminds me why problem-solvers do what we do…we want everyone to experience success and fun, whether it is attending an event or working with software.

After all the planning, setup, and then 4 days of nonstop craziness while the event was open to the public, I came away with a renewed sense of vigor and positivity about the organization, supporting businesses, volunteers, and our whole community. I hope that each of our nonprofit customers experience this sort of outcome as you hold your fundraisers!

Things That Go Bump in the Night

by Amanda Mallinger Reinartz on October 19, 2011 2:07 PM - 0 comments

Halloween is right around the corner, and it has me thinking of things that go bump in the night. I thought I’d share the 3 scariest things I hear from people when it comes to technology and fundraising software. The good news is, these 3 scary things are all easily remedied or avoided, so you don’t need to stay awake at night in fear.

What backup?
Every once in a while, we get a frantic call from someone who has accidentally purged 1000 records, only to discover that they selected the wrong query to use for purging the records. This is a very scary situation. It’s one of those times when, if you’re the person who just watched all those records disappear, you want to scream “Eek!” If you have a backup strategy that includes periodic testing of the backups, then this “Eek!” moment can be downsized to a minor “Aw, nutz!” moment.

Before you delete records from your database, take a moment and ask your IT department to back up your database. Or, if you know your backups run every night, perform your deletion operations first thing in the morning. Then, if something goes wrong, you just need to ask IT to restore a backup. (It helps if you bring candy when you ask.)

In addition to implementing a regularly scheduled backup of your database, have your IT department restore one of the backups at least once a month. That way you’ll know that your backups are working.

If you or your IT folks do not know how to perform backups using SQL Server Express, contact our Support department. We have a document you can give to your IT department that may be of help.

Who has time for training?
Everyone is super busy these days, and training is one of those things that it may seem like there isn’t time to do. When tempted to throw some poor soul into a task for which they haven’t been trained, think of this: It will likely take hours to identify, undo, then re-do a task that was performed incorrectly in your database. And that’s assuming the “badness” didn’t accidentally get “out the door” and into the hands of your donors.

Speaking of assumptions, that’s another scary thing.

No, the software can’t do that. (Typically heard from the same person who asks “Who has time for training?”)
If you are unsure if your software can do something, first check out the online help. It’s faster than calling support. If you don’t find it there, call Technical Support; it’s possible that it is available, but that it has a name that is different from what you expect. (Some day, when I’m really hurting for topic ideas, perhaps I’ll regale you with all the time I spend searching Microsoft’s web site for things I know are there, but I can’t find because I’m searching for them using different terms.) It’s very likely your software or vendor has the feature or service you seek.

Are there things you hear that have you shaking in your boots? Do you have ways to handle these things that make them less frightening?

Donor Retention Rates/Growth in Giving

by Amanda Mallinger Reinartz on October 12, 2011 12:23 PM - 0 comments

The results for the 2010 Fundraising Effectiveness Survey  are now available. This annual survey is conducted as part of the Fundraising Effectiveness Project, of which Metafile is a charter member (Donor Software Workgroup). The project was started by AFP and the Center for Nonprofits and Philanthropy at the Urban Institute. With this new data, the project now has data from 2004-05 through 2010. It’s growing into an essential statistical resource.

Why are the survey and its results interesting? For me, they are interesting because they provide the nonprofit sector with a way to benchmark giving performance, regardless of software used. It enables organizations to compare themselves to other organizations operating in their budget level, regional area, sub-sector, etc. It also enables organizations to focus on their own year-over-year performance and use this information to fine-tune their fundraising programs. And, as evidenced in recent years, it can be reflective of the economic conditions of the timeframe. This most recent report is another example, I suspect.

Giving hasn’t returned to pre-recession levels, in fact, it dropped again last year for small budget organizations. What’s interesting is that in some of the budget levels, giving, dollar-wise in addition to numbers of donors, was up over 2009. The report also highlights a turnaround in gaining new or reactivating lapsed donors. The increase in number of donors was up 1.7% in 2010 vs. a 3.2% loss in 2009. Because the breakdown of each organization is different, please read the survey and use its data to compare and contrast your own organization where appropriate. If you like the ability to compare this kind of data, please consider joining the survey next year. You can do it from directly within ResultsPlus, so there’s no need to manually gather and submit the data!

Do you have other benchmarking resources you like to use at your organization? If so, what are they, and what makes them beneficial tools for your needs?

What's all the talk about the Benevon Model lately?

by Amanda Mallinger Reinartz on October 6, 2011 9:30 AM - 0 comments

Do you ever feel like phone calls tend to run along specific themes from time-to-time? I know I do. When I was in Support, I remember thinking that fairly often. It turns out that it happens with our account managers, as well. One gal recently mentioned that she has spoken with a few customers who were asking the Benevon Model for donor cultivation and sustainable fundraising, and she asked if I would blog a little bit about the model and how it applies to fundraising software. Always grateful for topic suggestions, I agreed without a moment’s hesitation, and here we are.

The Benevon Model used to be known as “Raising More Money” for those of you who have been working in the nonprofit sector for a while. I am no expert on this specific model, but the idea of models for mapping fundraising processes is ubiquitous among fundraisers. Generally speaking, the Benevon Model is an approach to fundraising that, while very intentionally focusing on the donor, encompasses a series of cultivation stages beginning with meeting the prospective donor, then getting to know them while they get to know you organizationally, moving to making the ask, then showing appreciation and getting the word out to additional prospective donors, and finally starting the process again, identifying new prospects. Any potential donor, once in the cycle, can and should remain in your cultivation cycle/pipeline through any number of iterations as your organization and its needs change over time.

As with all effective fundraising models, the vast majority of the work that results in successful implementation is “head work.” That’s not to say that your fundraising software isn’t invaluable, but the choice of fundraising software is almost irrelevant in the context of the model (though I’d prefer you use ResultsPlus, of course). So why am I, a software developer, blogging about this? Because I’d like to identify the key components of software that support your efforts with the model and highlight how these components are standard features of most every major fundraising application available.

I will summarize the stages per my understanding below. This is not intended to be a course on the model, because I am not qualified to teach such a thing. It’s simply a broad strokes summary of the stages for cultivating long-term relationships. The innovative details of each stage are legion and unique to each organization. To learn more about the Benevon Model, I recommend visiting http://www.benevon.com. The folks there provide training and consulting to design and successfully implement their model according to each organization’s needs.

The first stage is generally based on the concept of acquisition. There are many aspects to acquisition, but here I’m looking at those with a high level of human interaction. Acquisition, when framed right, can also communicate gratitude, which is also an aspect of how you complete the cycle and restart it effectively. This doesn’t mean everything you do for acquisition has an aspect of gratitude, but you may be able to find ways of weaving it in.

Events: You may be planning an event to kick off a new project, or an event to celebrate successful completion of a project. Invite people who provided funding, volunteer hours, or emotional support when you and your colleagues were stressed out about meeting some deadline; you get the picture. Here’s where it’s fun. Don’t just invite those people, invite them to bring along a family member or friend who may also enjoy the festivities.

Software: Your software can help you identify and retrieve constituents in your system that have shown an interest in supporting similar past projects, attending similar events, and in many cases, even help you expand that list to other people in your database who have known relationships with those constituents. Perhaps your list is “hand-picked.” Your software should support your desire to add those people to a temporary working list or “group” as you identify the people you wish to invite.

Elevator Pitch: We know we need one, but do we have one? If not, it’s time to come up with one. We want to be able to let people know what we do, why we feel they may be interested, and how to get more information. And we need to have a way to do this that can be used anywhere, any time. This is an example of “head work.” Your software cannot help you craft a concise, eloquent, interesting message. It would likely come out looking something like the statements generated by Catbert’s Automatic Mission Statement Generator (yes, that Catbert, of the Dilbert cartoons). But wouldn’t it be great if it could?

Storytelling: Every organization has a story to tell. Tell yours; tell it well and tell it often. Make sure you start with something that entices your reader or partner in conversation to want to know more. What’s compelling about it? Margaret Battistelli Gardner’s recent editorial, Arm(adillo) Yourself, in Fundraising Success highlights a wonderful example of this. Again, here’s where the work can only be done by clever humans.

The second stage involves growing your relationships. This means following up with the people you’ve met, engaging them in additional ways, seeking to know more about the constituent’s uniqueness and interests, and sharing more about the unique and meaningful aspects of your organization. In short,

Get to know your donor: If this person is brand new to your organization, respect that as part of the development process. If you have volunteers, know and respect that relationship and grow it from that base. Long-time donors have different needs and expectations, and so on. The key is that each donor is unique and deserves an approach respectful of that. Think back to how you met your various friends. Each of those relationships developed in their own unique ways and on their own timetables. Perhaps you were introduced to some of them by other friends, you worked together, you volunteered at the same event, etc. Your relationships with your donors may evolve much the same way, meaning not necessarily in the same way at all! Engaging your board and other stakeholders in this series of steps is also incredibly important. These are not things your software can do. However, there are things your software can and should be able to do to help you manage knowledge and use it effectively in the context of engagement and relationship development.

Software: Your software cannot tell you the approach to take with your donors. However, it can help you keep track of your strategy, which contacts have been made, when, by whom, when additional contacts are scheduled. It can help you track changes to your strategy, identify where you feel you are in your relationship with the donor, whether or not it is appropriate to make “an ask” at this time, what events a person has been invited to, which ones they’ve attended, who else was at those events, in what ways the person has already been involved with your organization, whether or not you know of a connection between them and a board member, staff member, volunteer, or another constituent. Now that you’ve reached the end of my seemingly-never-ending sentence, you get the idea: Intellectual capital can be documented and stored for later retrieval, analysis, scheduling, and so on.

At some point during the development of your relationships with your donors, it will be appropriate to ask them for monetary support. And so we enter the third stage.

Ask For Money: Asking is an aspect of the model that is taught so that the “asks” can occur naturally and without pressure. Making “the ask” is, of course, something best done in person by a human! But having various giving programs and ideas for making a donation “do more” by promoting additional donations from others are things your software can support. One specific example used to aid in asking for money identified on the Benevon website involves the creation of a multiple-year giving society.

Software: The Giving Society is a great example of something that your software can support. Most every application supports the creation of giving levels that can span a lifetime, a year, or a custom set of criteria.

If you are asking a donor for a leadership gift, some software applications today support the storage and access of your actual proposal documents, names of persons who met at the time of the proposal, and so on.

Challenge gifts are also accommodated in software, and have been for many years via the concept of “matching gifts.”

After you’ve been the beneficiary of your constituents’ generosity, it is only right to thank them well and often. And perhaps that thank-you can be an invitation to a lovely, free event, and the donors can be encouraged to bring a friend, thus introducing new prospects to you and your organization. This brings us to the final stage of the Benevon Model, designing and integrating ways to introduce new people, who have a desire to know more about your organization, to your organization. At events like these, the word of the day is “capture.” Capture names, addresses, emails, what brought the people to your event…whatever you can. When you get back to the office, document all this in your fundraising system so that you can embark on a new iteration of your effective cycle.

Monthly Giving Programs

by Amanda Mallinger Reinartz on September 28, 2011 4:03 PM - 0 comments

This post was has been delayed a bit due to a blogging software update. We’ve applied updates to our blogging software that should address an issue that was discovered with posting comments.

Now, on to the actual topic of the week! 

The September 2011 edition of Fundraising Success has a wonderful article on Monthly Giving by Pamela Grow. If you are a small organization, and you are interested in growing your monthly giving program, I recommend the article; it’s an easy, informative read. If your organization has a web site through which people can give, that’s great, but this article even has a low tech example!  

The key to growing your program, as with many things, is how you communicate your message. And this article provides examples from organizations with compelling messages, describing in concrete terms the impact of monthly giving.  The article also identifies where you might get your prospects-from your existing donors. Ms. Grow suggests donors with a history of loyal giving or those who’ve given more than one gift in the last fiscal year. Her suggestions are also easy to implement with fundraising management systems. Fundraising systems are designed to hold this information, so you can pull donors and prospects back out based on these types of markers and then send an email, letter, make a call, invite them to an event, etc.

And finally, I think the last paragraph of Ms. Grow’s article may be the most important one. She identifies the need to re-evaluate your program each year.

Do you have a monthly giving program? What messages have worked for you when communicating the value of monthly giving programs to your donors?

Thank You Letter Ideas

by Amanda Mallinger Reinartz on September 16, 2011 2:02 PM - 0 comments

I read a post on the Chronicle of Philanthropy's website the other day titled, "Making Sure No Donor Gets the Same Thank-You Letter Twice" (http://philanthropy.com/blogs/prospecting/making-sure-no-donor-gets-the-same-thank-you-letter-twice/31153). It was an interesting and short read about one organization's approach to ensuring that its acknowledgment letters are continually updated and refreshed so that donors do not get the same letter more than once. I don't think that the idea of updating letters periodically is a new one, but what is interesting to me is that there is a source for finding new letter content. And that's my reason for this post.

There are examples of fresh wording to use in your letters as you highlight your organization's success, your needs, your donors' successes, and so on. In case you missed it on the Chronicle's web site, The Great Acknowledgment Swap is a great resource for this type of content. The letters have been submitted by other professionals working in the NPO/NGO arena. If you would like to check them out, here's the link: http://www.donorrelationsguru.com/home/tgas

Do you have other "go-to" places for sharing and seeking ways to keep your letter content fresh?

Volunteer Coordination

by Amanda Mallinger Reinartz on September 13, 2011 1:43 PM - 0 comments

As a volunteer, I've coordinated other volunteers for a few different organizations, and I hope that sharing some of what I've learned, and soliciting feedback from other non-profit professionals out there, can provide help for anybody stepping into the role of volunteer coordinator at their organization. The steps seem minimal, but they can be intense. My hat is off to all the volunteer coordinators who've done this time and again as part of their full-time job! Also, please feel free to share what you've done that's been successful!

Step 1 is determining our needs for volunteers. The needs continue to be revealed as the organization moves forward with the planning, especially when coordinating volunteers for an event. The number of factors is incredible when working on an event. What is the capacity of the space? How many volunteer shifts do we need? Do we require volunteers to be of a certain age (for example, no minors)? How many youth do we allow per chaperone? Do we need volunteers to help people navigate the event space? And so the list goes.

Step 2 is figuring out how to manage the correspondence. By correspondence I mean, sending, emailing, and calling - All the ways to ask people to volunteer. Also, documenting the yea and nay responses, communicating requirements for each shift as the date gets closer, sending reminders, and handling last minute cancellations must be managed. There are a number of great ways to do this. Some folks are handy with email and Excel. Others prefer paper. Some, like me, are looking for technology to help. There is a really neat site called www.VolunteerSpot.com that works well. And it's free if your needs are simple. And did I mention that you can export the names, numbers, and emails of your volunteers to bring into your donor management system for future contact?

Step 3 is the identification of potential sources for volunteers. In the case of schools, for example, the sources may be student governments, Key clubs, Parent-Teacher Associations, school sports teams, etc. (I imagine this step and Step 2 may be in reverse and work perfectly well.)

Step 4 is to thank our volunteers. I thank them when they agree to volunteer. I thank them at the end of each communication (and sometimes in the middle). And I will thank them all at the end, because I know there is NO WAY we could have a successful event without them!

Have you done something that really works you can share? Or tried something that didn't work? Do you have other wisdom in regard to working with volunteers?

What is Give to the Max Day, and How Can You Participate?

by Amanda Mallinger Reinartz on September 2, 2011 9:30 AM - 0 comments

Being based in Minnesota, I am well-aware of the "great Minnesota give together" known as Give to the Max Day. (Yes, I lifted that pithy phrase off the http://givemn.razoo.com/p/gtmd-postgame website.) For people who are unaware of what this is, or who wonder how they, as a Minnesota nonprofit, can prepare for participation, please continue reading.

Give to the Max Day is a single day, November 16th 2011 (this year), where there is significant buzz around giving. Nonprofits can sign up with GiveMN to participate in this 24 hour online fundraising event. And you don't even need to have your own online giving site; all donations to your organization are made through GiveMN. To learn more about GiveMN, Give to the Max Day, and the "fine print", visit the http://www.GiveMN.org web site.

Why am I mentioning this special November day so far in advance? I want to let folks know about the day so that there is plenty of time to get registered, set up your systems to handle donations via this appeal, and get the word out to your constituents that you are a participant.

To prepare for Give to the Max Day:

  • Decide whether or not to register your organization.
  • I'd recommend making changes to you donor management system to support importing donations from the site. How do you do this? Set up a specific campaign and/or appeal, as well as a "GiveMN" source code so that when you add these donations (and new constituents) to your system, you can accurately report on the success of the day (and you may wish to be on the site year-round, so I recommend an additional appeal that is for GiveMN "general" donations in addition to a "Give to the Max Day" appeal).
  • Register your organization. (Do this after you've decided your codes. That way, your system will be "ready for action" when you register.
  • Communicate! Let your constituents know about Give to the Max Day, and let them know you are a participant.
  • Import your donations from the GiveMN web site into your donor management system. Use the codes you've defined for this.
  • Thank donors!
  • Report your success using the codes you've applied to your Give to the Max Day donations.

Perhaps I've missed some steps you would add to the list for your organization. Feel free to share them below. If you've participated in past years, and have an experience you'd like to share, feel free to do that, as well! And a last thought...Are there days like this in your state? If so, please let me know. I'd love to be able to share the fundraising opportunity with others!

 

QR Codes: What Are They? Why Are They Interesting?

by Amanda Mallinger Reinartz on August 26, 2011 12:14 PM - 1 comment

There's a lot of buzz around QR codes lately in the nonprofit community, if the nonprofit tech sites are an accurate reflection of interest. I thought I'd jump on the bandwagon.

To answer the question, "what is a QR code", it is, quite simply, a Quick Response code. There is more to this, of course. They are 2 dimensional codes that are readable by electronic means. For a better definition, visit the ever-popular Wikipedia for a definition (http://en.wikipedia.org/wiki/QR_code).

Picture

Now let's answer the second question, "Why are they interesting?" There are many answers to this question. The primary reason I find them interesting is that they offer a very specific value normal barcodes don't: They're appealing. They appeal to a wide range of technically savvy, current and potential donors. They are almost "toy-like" in the joy they bring the people who focus their smart phones on them. Assuming that this novelty doesn't wear off in the next few months, are there effective ways nonprofits can use (or continue to use) these codes? I decided to try out a few tests of my own. These are only tests, and I have no data on whether or not they'd be effective. If you've implemented QR codes in campaigns at your organization, please share where you've had success and where you've learned what not to do. Both experiences are really valuable!

If you'd like to take QR codes for a spin, here are the primary tools I used for my tests:

  1. I used an existing version of our product (you can use any donor management software) as the data source for test data.
  2. Microsoft Word.
  3. An Add-In for Word to generate QR Codes (I downloaded a demo of it here: Tec-IT web site ).
  4. Our public web site (The above image is the QR Code I used for my test. You can put your smart phone up to the screen and test it in 30 seconds.)
  5. An internal test web-site (I embedded test data like constituent IDs, campaigns, appeals, etc. and observed that the data was embedded in the web page. The tests for this are likely too tricky for a 5 minute test drive.)
  6. I don't have a smart phone. So, I walked down the hall and borrowed one from a friend in our technical support department.

And I made up a new rating system, the niftiness scale (1-5). This scale is completely biased, but it was fun. Here are my 4 test cases.

  1. I created a QR Code that opened a specific page on our web site. It's the QR Code above in this post. On my niftiness scale, this ranks a 2. Here's the code, in case you have a smart phone and are curious where I sent myself. (Hint: I read the newsletter.)
  2. I created a QR Code that took me to a specific page and populated a campaign and appeal value that got submitted along with the test donation I added from the page. On my niftiness scale, this ranks a 3. (Sorry, I'm not displaying the code for you, because it goes to an externally inaccessible test system.)
  3. I created a QR code that took me to a specific web page that pre-populated constituent information (the unique ID in a fundraising database for a given constituent), the campaign and appeal. The constituent ID was not displayed onscreen, but the form had it as a hidden value. Then, upon submission of a donation, all 3 values came along for the ride. This is a 4 on my niftiness scale.
  4. I created a code that did everything in test 3, but also said "Hi" and then used the constituent's name. It also had the last donation amount and date in it, so the constituent could see that for reference. My ranking on the niftiness scale for this is 5, but it made me think that I need a second scale, creepiness. And this gets a 4 on that scale.

There are many uses that have nothing to do with displaying web sites, as well, but I used these tests because they were easy to identify. The point of all this is that QR codes, if you can entice people to use them, may provide your constituents with a wonderfully personalized experience, while helping you maintain and gather pristine data in your donor management system.

What are your thoughts on QR codes? Are they a fad to be ignored? Are they worth some effort? Do you have hopes and dreams for what you could do with them? Please share your thoughts in the comments section.

Overwhelming Response + RMHC Conference!

by Amanda Mallinger Reinartz on August 19, 2011 2:34 PM - 0 comments

Wow. Last week our marketing folks sent out an email to our customers announcing our new blog. Within a few minutes, we had an unexpectedly high number of subscribers. That leads me to two things:

First: Thank you! I look forward to our discussions on various aspects of fundraising and donor management as we journey forward together.

Second: I must admit that I'm a bit intimidated. It's easy to write something if you think nobody is paying attention, but it's quite a different story when you have a group of people reading with you. Please always feel free to submit topic ideas. I really want to make sure that this blog is interesting and informative. Bring up a topic, and I'll do the legwork (at least some of it)!

I'd like to share some words from Marcia Grimm, our Development Advisor, about the RMHC conference.

How exciting it was to be a part of the 2011 Ronald McDonald House Charities International Conference in Chicago last week! There was an amazing energy in the conference hall, as an estimated 1000 attendees from all over the world stopped by vendor and supplier booths in the ‘Resource Connection Center.' We visited with people representing RMHC charities and Ronald McDonald Houses in Brazil, Korea, Australia, Canada, Tazmania, and numerous states throughout the US - all looking for information on products and services to help them in their heartwarming missions. We hope to soon welcome some of these very special organizations into the ResultsPlus family and are very proud to support our own local Ronald McDonald House as well.

Have you attended a stimulating conference lately? If yes, what made the experience such a positive one? Anything you would like to share?

Renewing Donors and Segmenting Communications

by Amanda Mallinger Reinartz on August 10, 2011 9:40 AM - 0 comments

I've recently been getting communications from an organization of which I've been a member for a number of years. And I've been getting communications regarding my lack of renewal, which prompted me to go online and renew. The reason I'm mentioning this is because it reminded me of a number of things that I like when it comes to communications from my favorite organizations-especially in regard to lapsed donor/renewal communications. Each of these things can be managed/made easier with CRM software. If you're a ResultsPlus user and don't know how, please give us a call!

Here are my personal "Likes":

  • Timely. I received an email before my membership renewal was due indicating I was entering a renewal period. I'm certain this was no accident!

    Help: Define a query in your CRM to pull a list of members whose next renewal date is, say, in the next 2 months.
  •  

  • Follow-up. I didn't respond to the email by renewing my membership. I received a follow-up letter in the mail about 6-8 weeks later. This letter had different wording, highlighting that the organization recognized that I was already at the end of my membership (in a very polite way, of course) and that they hoped I would renew and continue my support of the organization and the services it provides.

    Help: Query your CRM by Renewal Date in the next 0-15 days to generate a list from your donor management/CRM system.
  •  

  • Highlights of What My Membership Supports. This is a wonderful reminder of what my membership donations accomplish each year. This message was in each reminder I received.

    Help: N/A. These words are likely not found in your donor management system, at least not in a way that is palatable to your donors, but I'm sure each person who works for a nonprofit can highlight exactly what you do each year to meet your mission.
  •  

  • Thank-You. I received a Thank-you after renewing my membership specifically acknowledging that it was a renewal. This may seem like a small thing, but it definitely made an impact on me. I felt that even though I'm not a major donor, the organization is aware enough of me to know that I've been around for some time, making donations as I am able.

    Help: Donor management systems enable you to choose different thank-you's when entering or reviewing donations, so you can pick one for your first-timers and a different one for your long-standing donors, if you choose. Doing so can have quite an impact on the recipient (at least it did on me).
  •  

  • Web Site. The communications I received all provided a link to a web site where I could renew my membership. The site was very forgiving. If I knew my membership number, I could enter it. If I didn't, it wasn't required.

    Help: Nonprofits have a number of options for handling donations made online. You can use sites like www.networkforgood.org and then import the data into your donor managements system; you can custom build your own forms into your web site using APIs from your vendors to bring the data into your donor management system; you can contract with vendors to build and host the these forms for you, etc. The key is to identify the pros and cons of each way, and the work from there, knowing that each way will have its own set of challenges (but they are worth it!). 

Are there other key components to your communications you know your donors love? If so, please share in the comments area!

Inaugural Post - Welcome to the RP Blog!

by Amanda Mallinger Reinartz on July 21, 2011 10:46 AM - 1 comment

Greetings! This is my first post for the RP Blog. My hope for this blog is that it can serve as a place to find fundraising information and ideas. While ResultsPlus is a donor management/CRM product, so many aspects of fundraising are sourced from, entered into, and reported from products like ours that this blog seems a good place to make broader fundraising topics available for discussion. Readers, please feel free to become contributors by posting comments, making suggestions, and generally sharing your expertise on the topics!

So, let's get started...

I recently read a great blog post by Holly Hall on the Chronicle of Philanthropy's web site. (http://philanthropy.com/blogs/prospecting/breaking-the-rules-taking-the-long-view-in-fund-raising/30498) She wrote about Bill Littlejohn and his "long view" approach to fundraising. His approach is to focus on multi-year sources of revenue to better enable his organization to prosper during lean economic times. The post is a short, interesting read. I recommend taking a peek if you have a few minutes.

I think part of the reason I appreciate Littlejohn's approach is not only because of its long view, but also because it is attainable by even the smallest non-profit organizations, and it doesn't require specialized knowledge, technology, or expensive resources. It's an approach that, at first blush, doesn't seem to take a lot of valuable planning time away from other fundraising activities and campaigns. Promoting multi-year pledges, recurring gift programs, and payroll deduction programs are three ways to provide a stream of donations that spans multiple budgets. They are all ways with which organizations are already familiar, and these are also ways to give that can be added to most any campaign or appeal.

If you are a member of an organization that approaches fundraising with this "long view", please post any tips for success you have to share with others!