The December appeal feels like a December project. It is not. By the time you are writing the letter and pulling the list, the quality of your results is already mostly decided by the state of your data. A clean, well-segmented database turns a good appeal into a great one. A messy database quietly costs you, through duplicate letters, wrong ask amounts, and lapsed donors who never get a reason to come back.
The fix is to start early and spread the work out. Here is a month-by-month timeline from August to December that keeps year-end data prep from becoming a crisis. None of it is hard. It just needs to happen before the season, not during it.
August: take an honest inventory
Right now, before the fall rush, look at your donor database with fresh eyes. How many total records do you have? How many have a valid mailing address? How many have an email? You are not fixing anything yet. You are measuring, so you know what you are working with and where the gaps are.
This is also the month to run a duplicate scan. Most nonprofit databases carry more duplicates than their staff expect, because every event upload, online gift, and hand-entered record is a chance to create a second version of someone who already exists. You do not have to merge them all in August. You just need to know the scale of the problem before it shows up as two appeal letters to the same household in November.
If you want a structured way to take that inventory, our free Data Health Checklist walks through the specific things to look at, section by section. It is built for exactly this kind of pre-season review.
September: clean up duplicates and fix addresses
Now do the merging you scoped in August. Work through your duplicates and combine them carefully, keeping the most complete and most recent information for each donor. Give special attention to your major donors and your board, because a duplicate record there can split someone's giving history in half and make a loyal supporter look like a first-time gift.
September is also address month. Pull your list of records with missing or clearly outdated addresses and start filling the gaps. Returned mail from a fall newsletter is a gift in disguise, because it tells you exactly which addresses to correct before the appeal goes out.
October: review your lapsed donors
A lapsed donor is someone who gave before but has not given recently, often defined as no gift in the last twelve to eighteen months. These people already believe in your mission. They are far more likely to give again than a stranger, and year-end is the natural moment to invite them back.
Pull a list of donors whose last gift falls outside your active window and read through it. You will recognize names. Some lapsed for a reason, and some simply never got asked again. Flag the ones worth a personal touch and set them aside for a segment of their own in the appeal.
November: build and check your segments
By November your data should be clean enough to slice. Build the segments your appeal will actually use. A simple and effective split is current donors, lapsed donors, and people who have never given but are on your list. If you can add a major-donor segment for personal asks, even better.
Before you hand any list to the mail house or load it into your email tool, do a final check. Pull one segment and read twenty rows by hand. Are the names formatted correctly? Are the ask amounts reasonable for each person's history? Is anyone in two segments who should only be in one? Twenty minutes of reading here prevents the errors donors actually notice.
December: pull the list and keep notes
When the appeal goes out, pull your final list from the clean, segmented data you have been building since August. The work is nearly done, because you did it in pieces over four months instead of all at once under deadline.
Keep one more habit through December: write down every problem you spot as gifts come in. A misspelled name, a wrong salutation, a duplicate that slipped through. Do not stop to fix each one during the busy season. Just log them, and you will have a ready-made cleanup list for January that makes next year's August inventory shorter.
Year-end giving rewards preparation more than intensity. The organizations that seem to run a smooth December are usually the ones that did quiet, unglamorous data work in August. Start now, and the season gets easier every year.