Improving your merge/purge

A quick way to sabotage any mailing is to take the merge/purge process for granted, says Joe Balaban, vice president of business development at Farmingdale, NY-based service bureau Anchor Computer. Here, Balaban offers specific tips on how to work with your supplier to ensure a successful merge/purge project:

1) Make certain your service bureau knows what to expect. If you plan on following your mailing with a telephone campaign, for instance, make sure your service bureau knows to check for telephone numbers. Or if you need a minimum number of names for a mailing, tell the service bureau so that it can notify you if your list falls short after the merge/purge.

2) If you’re a business-to-business cataloger, make sure your service bureau is familiar with b-to-b issues. Business addresses generally have more fields than consumer addresses, which can make the merge/purge process more challenging.

3) Always run your list against the Postal Service’s Delivery Sequence File (DSF). This file can identify undeliverable addresses and sort businesses from residential addresses.

4) When possible, mail only to zip+4 addresses. But be wary of software programs that assign zip+4 codes based on address location. Such programs will assign a code even to nonexistent addresses by estimating what the code would be if the address existed.

5) On b-to-b lists, consider eliminating addresses of establishments with histories of bad debt. Balaban has found that unprofitable business locations often remain unsuccessful regardless of who operates them.

6) Read-and be sure you understand-the entire merge/purge report. Beyond checking the percentage of dupes, look for specific records and duplicates you knew of beforehand. Only the complete list will show you these. If you notice missing records or systematic problems, the bureau can correct them and run the merge/purge again.

Partner Content

Hincapie Sportswear Finds Omnichannel Success in the Cloud - Netsuite
For more and more companies, a cloud-based unified data solution is the way to make this happen. Custom cycling apparel maker Hincapie Sportswear has leveraged this capability to gain greater visibility into revenue streams, turning opportunities into sales more quickly while gaining overall operating efficiency. Download this ecommerce special report from Multichannel Merchant to more.
The Gift of Wow: Preparing your store for the holiday season - Netsuite
Being prepared for the holiday rush used to mean stocking shelves and making sure your associates were ready for the long hours. But the digital revolution has changed everything, most importantly, customer expectations. Retailers with a physical store presence should be asking themselves—what am I doing to wow the customer?
3 Critical Components to Achieving the Perfect Order - NetSuite
Explore the 3 critical components to delivering the perfect order.
Streamlining Unified Commerce Complexity - NetSuite
Explore how consolidating multiple systems through a cloud-based commerce platform provides a seamless experience for both you, and your customer.