Using Data Creatively
By now most year-end appeals are drafted or close to it, the emails are lined up and someone on your team probably has a really good idea for this year. Maybe a handwritten note to every donor who has given five years in a row, or a thank you that tells each person exactly what their gift paid for. Those are the ideas people remember when their mailbox is full in December.
They are also the ones that tend to go sideways first. You pull the list and your board chair shows up in the first-time donor segment, or a donor who has given to your scholarship fund for ten years gets thanked for coming to the gala. Nobody did anything wrong and the idea was a great one. The data just was not ready to carry it yet.
The organizations that stand out in November are usually the ones whose data is clean enough to use.
Start with the people who matter most.
Nobody wants to clean data, and we understand why. It feels like it never ends and nobody throws you a party for fixing addresses. The good news is you do not have to clean the whole file before December.
We clean top-down and inside-out. We look at your board members, your top donors and prospects and the funds that matter most to you, and we make sure the names, salutations, households and gift coding on those records are right first. Whether an event code from seventeen years ago is exactly perfect can wait. For most organizations that first pass is a few hundred records, which is very doable before Thanksgiving.
If your file is messy, that usually means a lot of good people made a lot of reasonable choices over the years and nobody ever had time to go back and line them up.
Let the Data tell you Why People Give.
Once the top of the file is in good shape you can start asking it better questions, and that is where the creative ideas come from.
The question we keep coming back to is whether the letter is what brings a lapsed donor back or whether they just needed a reminder. A lot of time and money goes to the printer every year. If your data shows the phone call after the letter is doing most of the work, that changes how you plan. You can ask the same kind of thing about monthly donors and whether they ever upgrade, or about people who give to a specific program and how soon they give again compared to people who give to the general fund.
You only need one question to start. Pull two or three years of gifts and look at what happened. You will learn something about your donors that a lot of organizations never stop to ask about.
A small place to start this week.
Pull ten of your top donors and read their records as if you started on the team yesterday. Would you know how to greet them, what they care about and what they gave last year? If you would, you are ready to try something new this year. If you would not, you just found your first project.
And if you want someone to look at what you find with you, we would love that. Get unstuck in 20 minutes.
Erin Peshoff is the Founder of Vivid Operational Advisors. She has spent thirty years inside nonprofit operations, helped raise over $100 million for institutional missions, and built Vivid around the operating discipline most strategic engagements skip.

