Donor Data Hygiene: How to Keep Your Donor Database Clean

Your year-end appeal goes out to 3,100 households. Two weeks later, 140 letters come back undeliverable. A widow calls, upset that the letter was addressed to her late husband. A couple shows you three identical envelopes they received. And a donor who unsubscribed in August forwards your December email with one line: "I asked you to stop." None of these problems came from the appeal itself. They came from the data behind it.

Donor data hygiene is the set of standards and routines that keep donor records accurate, complete, free of duplicates and in line with each donor's wishes. It isn't a one-time cleanup before a big mailing. It's a habit: clear rules for how data enters your system, regular checks to catch errors, and a named person responsible for both.

This guide covers what bad data costs, how to set data standards, how to find and merge duplicates, how to keep addresses current with the USPS National Change of Address process, how to handle consent and opt-outs, how long to keep records, and a recurring audit checklist you can start this month.

What Bad Donor Data Costs You

Messy data rarely causes one dramatic failure. It causes dozens of small ones that add up to wasted money, lost gifts and damaged trust.

Run the numbers for the appeal above. If each piece costs $1.10 to print and mail, the 140 returned letters wasted $154 in direct costs. The larger loss is the gifts those donors would have made if they'd received the letter at their new address.

Unlinked gifts are especially painful in January, when donors expect a complete annual statement; our guide to donation receipts explains what those statements must include.

Bad data also distorts the metrics you use to make decisions. One donor split across two records looks like one lapsed donor and one new donor. That lowers your retention rate and makes donor lifetime value look worse than it is.

Set Data Standards Before You Clean

Cleaning without standards is like mopping with the faucet running. Before you touch a single record, write down how each important field should look. A one-page data dictionary is enough for most organizations.

The USPS publishes its addressing conventions, including standard street suffix and unit abbreviations, in Publication 28, Postal Addressing Standards. Following it makes later address updates much more reliable.

Two more rules prevent most new errors:

• Use dropdowns, not free text, for anything you'll filter or report on: sources, funds, membership types, preferences.
• Make the essential fields required at the point of entry, on online forms and in your database.

In campai, member profiles let you define custom fields with specific field types and required information, so a source code or preference can be picked from a list instead of typed differently each time.

Find and Merge Duplicates

Duplicates are the most common data problem in donor files. They usually come from ordinary situations: someone gives online and by check, registers for an event under a nickname, changes their email, or gives once personally and once through their business.

How to Find Them

Run matching checks from most to least certain:

Review medium- and low-confidence pairs by hand. A father and son with the same name at the same address are two people, not a duplicate.

How to Merge Without Losing History

• Pick a surviving record, usually the one with the longest giving history.
• Move all gifts, notes and activity to the surviving record. Never delete gift history.
• Keep the most recent address and email, with the date you confirmed them.
• Keep the stricter preference. If one record says "no mail" and the other doesn't, the opt-out wins.
• Log the merge: which records, when, and who did it.

Households Are Not Duplicates

Spouses and partners who give separately are two people in one household. Link them instead of merging them. You can then send one appeal per household while crediting each person's gifts correctly, and still send each a separate receipt for the gifts they made.

Stop Duplicates at the Source

• Search before creating a new record, every time.
• When importing an event list or online form export, match on email or ID first and update existing records instead of adding new ones.
• Review import previews before you confirm them.

In campai, CSV imports show a preview and field mapping before you confirm, and you can update existing members by membership number instead of creating new records. The import then reports which records were created, updated or failed.

Keep Addresses and Contact Details Current

Donors move, change email providers and switch phone numbers all the time. Build address maintenance into your calendar instead of waiting for returned mail.

Use NCOA Before Every Large Mailing

The USPS National Change of Address service, called NCOALink, lets mailers update lists with new addresses before mailing. According to USPS PostalPro, the data is provided through companies licensed by the Postal Service; depending on the license, providers work with 18 or 48 months of change-of-address records. Most nonprofits use a licensed provider or their mail house for this, and it belongs in every plan for direct mail fundraising.

If you mail at USPS Marketing Mail prices, which many nonprofits use, or at presorted First-Class Mail prices, address updates aren't optional. Under the USPS Move Update standard, those mailers must show they've updated their list within 95 days before the mailing date, using NCOALink, Address Change Service or approved ancillary service endorsements.

Process Returned Mail Every Week

• Update the address if the USPS provides a forwarding address.
• Mark the address as bad, with the date, if it doesn't.
• Try another channel, such as email or phone, before giving up on the donor.

Keep Email Clean

• Hard bounces: mark the address invalid immediately and stop sending to it.
• Repeated soft bounces: review after several consecutive failures.
• Role addresses like info@ or office@: keep them for organizations, but look for a named contact for individual donors.

A clean list also improves delivery for everyone else on it; our guide to nonprofit email marketing covers list growth and sending practices.

Handle Deceased Donors With Care

When a family member tells you a donor has died, update the record the same day: mark the person as deceased with the date and source, stop all solicitations, and update the household salutation for the surviving spouse. Keep the gift history; it's part of your organization's record and may matter for memorial or estate gifts. A personal note of condolence from your executive director is often appropriate.

Respect Consent, Preferences and Opt-Outs

A donor who says "please stop" should be heard once, everywhere. Store preferences by channel (mail, email, phone, text) and by purpose (solicitations, newsletters, event invitations, receipts), so you can honor "newsletters yes, appeals no" without losing the relationship.

Federal rules depend on the channel:

• Email. The FTC's CAN-SPAM guide says the law covers messages whose primary purpose is commercial. For those, you must honor opt-out requests within 10 business days, keep your opt-out mechanism working for at least 30 days after sending, and never sell or transfer the addresses of people who opted out. Whether a fundraising email counts as commercial depends on its primary purpose, so the simplest policy is to treat every unsubscribe the same way.
• Phone. According to the FTC's Telemarketing Sales Rule guidance, nonprofits calling on their own behalf aren't covered, but a professional fundraising firm calling for you must honor entity-specific do-not-call requests. Keep a "do not call" flag either way.
• Text messages have their own consent rules under federal law. Check them before you launch a texting program.

State privacy laws are also expanding. Some apply to nonprofits that meet their thresholds; for example, the Oregon Department of Justice explains that Oregon's consumer privacy law has applied to qualifying nonprofits since July 1, 2025. Check the rules in the states where your donors live, and see our guide to association data security for protecting the data you hold.

Two practices go beyond the legal minimum and build trust:

• Don't share or exchange donor lists without clear permission.
• Honor "anonymous" requests in every published list, donor wall and annual report.

In campai, the communication tools show delivery status, errors and unsubscribes where the mailing's delivery method supports it, so you can update preferences from actual results.

Decide How Long to Keep Records

Clean data also means not keeping what you no longer need. Records you hold longer than necessary still have to be protected, and outdated prospect data clutters every search.

For federal tax purposes, IRS Publication 4221-PC says public charities should keep records that support items on a return until the statute of limitations for that return runs out, generally three years after the return is due or filed, whichever is later. It lists some records to keep permanently, including your exemption application and determination letter, organizing documents and bylaws, and board minutes, and says employment tax records should be kept at least four years. Grantors, insurers, creditors or state agencies may require longer periods. Form 990 also asks whether you have a written document retention and destruction policy.

A practical schedule, to confirm with your accountant:

Write the schedule into a board-approved document retention policy so deletions follow a rule, not a hunch.

Run a Regular Data Audit

Hygiene works when it's routine. Split the work into small, recurring tasks with an owner for each.

Data Audit Checklist

Use this list for your quarterly review:

• Duplicate check run and merges logged
• Records without a valid mailing address or email counted and reviewed
• Returned mail and bounces from the quarter processed
• Deceased and do-not-contact flags confirmed on suppression lists
• Opt-outs from every channel applied to every list
• New gifts checked for source code, fund code and linked donor
• Salutations and addressees filled in for new donors
• Household links checked for recent marriages, moves and deaths
• User accounts reviewed; former staff and volunteers removed
• Data quality numbers recorded for comparison

Track a Few Quality Numbers

Pick four or five measures and record them every quarter:

• Duplicate rate: suspected duplicates ÷ total records
• Deliverable address rate: records with a valid mailing address ÷ active donors
• Email bounce rate from your last three newsletters
• Coded gift rate: gifts with a source code ÷ all gifts
• Complete salutation rate: active donors with a salutation ÷ active donors

If a number gets worse, look at the process that feeds it: a new online form, a volunteer doing data entry without training, or an event import that skipped the matching step.

Give Data Quality an Owner

Every organization has someone who knows the database best. Make it official. A data steward, even a part-time volunteer, should own the data dictionary, approve new fields and codes, run the audit calendar, and train anyone who enters data.

Limit editing rights to people who need them, keep a change history so you can see who changed what, and put recurring audit tasks on a shared calendar with due dates. For a broader look at structuring your records, see our guide to building a member database.

Frequently Asked Questions

How often should we clean our donor database?

Handle bounces, returned mail and opt-outs every week, check new records monthly, and run a full duplicate and quality review every quarter. Run NCOA before every large mailing, and at least within 95 days of mailing if you use Marketing Mail or presorted First-Class prices.

What is NCOA?

NCOA stands for National Change of Address. It's a USPS database of permanent change-of-address records. Licensed providers match your mailing list against it and return updated addresses for people who've moved and filed a change of address.

Should we delete lapsed donors?

Not just because they've lapsed. Former donors are often your best reactivation prospects; see our guide to lapsed donors. Keep their gift history, mark them inactive, and follow your retention policy for records with no activity for many years.

Should spouses be one record or two?

Two records, linked as a household. That way each person's gifts and preferences stay correct, you can send one appeal per household, and you can still issue accurate receipts to each donor.

What should we do when we learn a donor has died?

Mark the record as deceased with the date and source the same day, remove the person from all solicitation lists, update the household salutation, and keep the gift history. Send a personal note if appropriate.

Does CAN-SPAM apply to nonprofits?

It applies to email whose primary purpose is commercial, and the FTC's guide doesn't exempt nonprofits as senders. Whether a particular appeal or newsletter is commercial depends on its content, so honoring unsubscribes quickly is the safest and most respectful policy for every message you send.

Next Steps

1. Write a one-page data dictionary for your 10 most important fields.
2. Run a duplicate check this month, and merge using the rules above.
3. Schedule NCOA processing before your next large mailing, ideally your year-end appeal.
4. Audit your opt-outs across email, mail and phone, and make sure every list respects them.
5. Name a data steward and put the weekly, monthly and quarterly tasks on a shared calendar.