Your appeal is ready. Is your database?

A step-by-step guide to preparing your Bloomerang CRM for your next appeal
You've spent weeks writing the perfect appeal letter, crafting your messaging, and scheduling communications. You have got your mailing list pulled, your email template loaded, and you are ready to hit send.
But here is the question nobody is asking: is your database ready?
I don't want you to launch a carefully crafted appeal into a database that wasn't prepared to receive the results: gifts come in and don't get coded to the right appeal, acknowledgment letters don't go out, duplicate records mean part of your list got an email twice and many didn't get it at all. And then when it's all over, nobody can tell you which oureach of the appeal actually worked, so next year you won't know what to repeat and what to change.
A little prep work before you launch can make the difference between an appeal that generates clean data and useful insights, and an appeal that creates a month of cleanup work for your team.
Your Pre-Appeal Process, Step-by-step
Step 1: Clean and Update Your Addresses
Many nonprofits skip this step entirely but it's the one that will save you the most money in returned mail and wasted postage.
48 million Americans move every year - that's 17% of the adult population! If you have a database of 15,000 constituents and you haven't run an address update in the past year, up to 2,500 of those addresses could be outdated. Every piece of mail you send to an old address is money thrown away.
Here's the good news: on BloomerangCRM, NCOA processing is already built into your subscription through their TrueGivers integration.
To turn it on, go to your My Organization settings and click the "Activate NCOA Processing" button. Once it's active, Bloomerang will scan your database nightly against the USPS National Change of Address database, which covers all change-of-address requests filed in the past 48 months, and update addresses for people who have moved, standardize your address formatting (adding St, Ave, Rd where missing, correcting directionals, adding the +4 to ZIP codes), and even flag deceased constituents so you can keep them off your mailing list.
And here's another workflow tip that will make your life easier in the long run - do a manual cleanup scan at this same stage! After your address cleanup, pull your final mailing list including the Account Number column, and export it from Bloomerang to Excel. Clean up your data in Excel (standardize name formats to remove ALL CAPS NAMES, etc, fill in missing fields, fix typos, whatever needs attention), and then re-import the file back into Bloomerang using the Account Number to match and update existing records. Bloomerang will update the profile fields on the matching constituents without creating duplicates, and you will have a bulk data refresh before an appeal without touching gift data or giving history.
Step 2: Dedupe Your Mailing List
This one's obvious but it's important. Run Bloomerang's native duplicate tool and commit some time to merging your duplicates before pulling your appeal list. The benefit of cleaning up addresses first is that it increases the likelihood of Bloomerang finding a fuzzy address match.
Nothing undermines a polished appeal faster than a donor receiving it twice!
If you aren't sure whether someone is a true duplicate or an intentional individual record, don't merge it. It's better to leave a potential duplicate in place than to merge two records that should stay separate (untangling an accidentally-merged record is a nightmare!), so just flag it and ask someone who knows the donor's history.
Step 3: Verify Your Segmentation
Pull your target segmentations and take some time to think about it critically. Does the record count make sense for what you're trying to do? If you're mailing 2,000 people and you have 15,000 constituents in your database, there is some bloat in your database.
Make sure your filters are flagged correctly so you're not mailing people who asked to be removed from your list or are deceased. Sort your list by address to find household duplicates so you're not sending two copies of a direct mail piece to the same kitchen table.
Ensure your email platform is updated, even if you have an integration set up; export your mialing list out of Bloomerang CRM with emails included, then upload it into your email platform to make sure you're catching every email you have.
Step 4: Set Up Your Appeal and Campaign Codes
This is the step that separates organizations that can measure their results from organizations that cannot.
Gift coding is the most important data point for improving your appeals year over year!
Before a single gift comes in, create your appeal codes in Bloomerang. Follow whatever naming convention you use (and if you do not have a naming convention, that is a whole other blog post), and make sure the code is active and visible to whoever will be entering gifts.
How many components do you have in your appeal? I recommend having as many appeal codes as you can reasonably track under a large campaign (such as end-of-year or an annual fundraising event). Differentiating gifts based on your email, eg. received via direct mail vs email vs social media vs board outreach, is the most effective way to plan for future appeals.
And the final critical step: check that your online donation forms are tied to the correct appeal code.
Step 5: Confirm Your Acknowledgment Workflows
Your acknowledgment letter is part of your appeal, and many organizations make the mistake of treating it as an afterthought. A donor's first interaction after giving is your thank-you, and if it's late, generic, or missing entirely, you've just made it harder to get that donor to give again.
Before you launch, check that your acknowledgment template is branded and customized to the appeal, and confirm that the workflow is set to auto-generate acknowledgments when gifts come in with your new appeal code.
Step 6: Final Pre-Send Checks
You're almost there! Before you schedule those emails and send your direct mail appeal to br printed, do a final pass:
Send a test email or proof your direct mail piece
Confirm all links work and donation forms load correctly
Double-check that reply-to email addresses and phone numbers are current
Verify your mailing address and organization name are correct on all materials
If you gift processing and reporting fall on your development team, make sure your team knows who is responsible for gift entry and acknowledgment once gifts start coming in
That last one's more important than it sounds - if three people on your team are entering gifts and they're inconsistent on the new appeal codes, you're going to end up with uncoded transactions and incomplete reports. A two-minute conversation before the appeal launches can save you a week of cleanup afterward.
After the Appeal: Report on Your Campaign!
Once your appeal ends, you can easily pull a transaction report filtered by the campaign and sorted by appeal code. Because you set up multiple appeal codes, you can instantly see which outreach performed best, which ones brought in the most revenue, and which ones aren't worth repeating next year.
That's the real power of doing the prep work: when your appeal codes are set up correctly and your data is clean going in, your post-appeal reporting practically writes itself.
No manual combination of spreadsheets, no guessing which codes map to which efforts, no scramble to figure out what actually worked.
Want help preparing your Bloomerang CRM for your next appeal? Contact Alberto Ashby Consulting at andrea@albertoashbyconsulting.com.


Comments