The Coffey Blog

Separate the duplicates: How to clean up your hospital newsletter mailing list

Posted on: Monday, January 8, 2018

Alanna Jacob, Director of Mailing & Fulfillment Services, HIPAA Compliance Officer

Even if your hospital newsletter is filled to the brim with the information your fans have been clamoring for, those fans probably don't want to see multiple copies of your publication when they open up their mailboxes.

And if you're hoping to maximize your marketing budget, you'll want to ensure that you send just one copy to each home in your target market.

That's why we recommend taking your hospital newsletter mailing lists through a merge/purge process. Here, we combine all of your disparate lists (which we talked about in a previous blog post) into one master list—and we look for and eliminate duplications.

Merge/purge is a delicate process, and the right steps must be performed in the right order for the best results. Here's what we recommend.

4 key merge/purge steps to take

Step 1: Analyze your list and perform cleanup.

A typical mailing list contains predictable fields, including address, city, state and ZIP codes. But some lists utilize an unusual format, which means merging that list into a larger list can cause big problems.

Looking over your lists for these issues, and fixing what you can fix before you merge, can help you ensure that the data in your different lists will combine into one cohesive whole you can use.

Step 2: Scrutinize addresses.

List processing software will scan your list to make sure all addresses appear in a standardized format. (That can help catch issues such as "St." for "Street.") The software can also move through ZIP code correction processing (CASS) to ensure that the right code is connected to the right address. And finally, the software can remove addresses that just can't be standardized or corrected.

Step 3: Remove duplicates.

Once each list is as clean and standardized as possible, the final merge/purge step can be performed to combine all the lists and remove duplicates.

There are several ways to run this process. If your goal is to remove as many duplicates as possible, you can search for duplicates by address, city, state and ZIP.

Sometimes, a last name plus address, city, state and ZIP must be used for matching (for example, in a list that contains a lot of different people at the same business address). But sometimes a full name and address must be used for matching.

Unfortunately, the more fields you add to the matching criteria (such as name fields, which can't be standardized or corrected by the software), the more likely it is that duplicates will remain in your final list. That's because the software is unable to detect duplicates due to all the variations involved.

For example, while you could infer that Jackie Smith and Jacquelyn Smith at 1234 Any Street might be the same person, the computer software will not be able to make this logic leap.

Step 4: Track your results.

At the end of this process, you should have a list you can use for your mailing project. But you'll want to take note of the number of duplicates you found. When you complete the next project, you can compare numbers. If you see a significant rise or drop in duplicates, this could mean you need to do a little digging into what changed with your lists.

Work with an expert

Who you send your publication to is just as important as what you put in that publication. Don't leave your list work to chance. At Coffey, we have decades of experience in helping healthcare organizations reach their communities with print publications that work. We'd love to help you. Contact us to find out more.

Related reading

3 must-haves for a great healthcare publication
How to create compelling hospital magazine covers
7 creative ways to package your healthcare content in print