Creating A Dynamic Appeal List
Welcome to Week 32 of Annual Giving in One Hour a Week! If you’re like me and stuck living in the real world with somewhat imperfect data in your CRM or spreadsheets, then double-checking and workarounds are a part of life. Here are my low-tech, go-to techniques for creating a clean, effective data source to use for your fall campaign.
We want a spreadsheet with these separate fields:
- Unique Record ID (use this to tag and match dynamic printed items for assembly)
- Title, First Name, Middle Initial, Last Name, Suffix
- Salutation (what follows “Dear” at the start of a letter)
- Nickname (if you have it, use this as a double-check on Salutation)
- Organization (for people who receive their mail at their work address)
- Address Type (so you can tell if you’re looking at a home or work address)
- Address Line 1
- Address Line 2
- City, State, ZIP
- Email address
- Last gift amount and date
- Largest gift amount and date
- Assigned Solicitor (if there’s a person who is ideal to sign a solicitation, include that here — we’ll use it later in the fall)
If you have a database with suggested amounts to request, include those fields in your output. Most of us don’t, and for a list of a few hundred to a few thousand, I like to create those ask amounts organically at the start of a campaign, so when your list is pulled, add columns for:
- Ask Amount 1 (a modest increase, usually)
- Ask Amount 2 (a stretch amount, based on prior giving
- Appeal 1 (or whatever you’re calling your first ask effort that will go out next month)
Here are my favorite checks to ensure a clean list. As you correct errors in your spreadsheet, be sure to fix them in your main database. To make it easier to read columns against one another, you can hide other columns you aren’t checking at the time.
Sort by City and do two things:
- Read down the City column for misspellings (I’ve seen plenty of variations on “Philadelphia”). This method will group errors together.
- Read the ZIP column for incorrect codes, which could be typos or left over from an incomplete address update.
Sort by ZIP, then City, and look for fields that don’t match.
Sort by Last Name and do two things:
- Look for almost-duplicates with spelling errors that escaped your de-duping process.
- Read First Name and Last Name against Salutation and Nickname. Updating a surname doesn’t always make it to updating Salutation, so ensure that the names match. If most of your Salutations are informal and defaulted to First Name, check Nickname and use that to be as personal as you can.
Unhide everything and sort by Last Gift Amount. For people with no giving history, your Acquisition List, you’re going to enter the same Ask 1 and Ask 2 for everyone here. Change the amounts when you have more information.
What amounts should you request? It depends on your average first gift amount. If people become first-time donors by giving about $20, offer $15 and $25. Your objective is get people into the pool. You can approach them for increases down the road, but especially in 2020, you want to emphasize participation, not a high entry amount. Make it easy for people to say yes.
Move on to your past donors. Sort your list by Last Gift Date. For everyone whose last gift was 2016 or earlier, your objective is to get them back, so unless you have good information that you can be successful asking for more, use the same Ask1 and Ask2 as your Acquisition List. Override where you want.
Now the only people left with unassigned Ask Amounts are donors from the last three years. Look at the most recent donors – for those who have given in the last three to six months, you may want to strike them from solicitation, especially if they’ve made larger gifts that are likely their one annual gift. That’s your call. Place an x in the Appeal 1 column for anyone who has given too recently to be asked again. You’ll filter those out of the final data source.
Sort your document one more time by Ask1 (which is blank for all your recent donors, so they will be grouped together), then Last Gift Amount, Largest Gift Amount (often the same), and Last Name (to make it easier to find someone you’re thinking of while you’re in this process).
You’re going to enter your own Ask1 and Ask2 amounts here. Unless you are asking for odd amounts that are tied to a specific number like founding year or cost of services, suggest amounts ending in 0 or 5. You can ask for higher percentage increases on lower dollar gifts. My recommendation is not to reference the last gift amount, but suggest two numbers, one just a little higher and the other a stretch, plus an “Other” option on the reply device. Examples:
Last gift = $10, Ask1 = $15, Ask2 = $25
Last gift = $15, Ask1 = $20, Ask2 = $30
Last gift = $25, Ask1 = $30 Ask2 = $50
Last gift = $50, Ask1 = $60, Ask2 = $75
Make your own call when you see a Largest Gift that’s higher than the Last Gift – and check the date. If that big gift was more than three years ago, ignore it. If it arrived within the last couple of years, go with your gut and suggest gift amounts in between the Last and Largest. When you’re finished, filter your list so you see just the people who should receive your first appeal, sort in order by how you want your finished product (Last Name, then First Name is my go-to), and make a copy of your final list to use in production, whether that’s in-house or you’re sending it to your mail house.
The great thing about lists of a few hundred to a few thousand is that you can handle them personally. Dig into them and get to know your donors and prospects, both individually and as a group. The more you understand, the more effective you can make your appeals.
You’ve probably guessed that I love working with lists! I’d love to hear from you about any questions you have or data problems you’re trying to solve.