Coming Clean the Old-Fashioned Way

While myriad high-tech tools and techniques exist to help you scrub your data, you shouldn’t overlook the importance of manually cleaning out the file, says Don Buck, president of Milwaukee-based consultancy Buck Marketing.

“It may sound arduous,” Buck says, “but I once worked with a business-to-business cataloger that took its entire 500,000-record customer file, printed it out, and handed out portions to every employee, from the president on down.” The employees reviewed the file in search of misspellings, slightly different street addresses, and near- duplications, such as “Michael Smith” and “Michael P. Smith.”

“Each set of computer printouts was handed out with instructions and time sheets,” Buck continues. “The list department controlled this process by tracking who had which set of computer printouts, spot-checking staff’s work, tabulating hours, and coordinating with the keying department. Because all 150 employees were involved, it took about two weeks. This was done annually for three years in a row. The company’s annual catalog mailing costs, including postage, printing, and all other associated costs, was $32 per customer. The savings, after cleaning for three consecutive years, was in the six figures each year.”

In general, Buck says, “updating your addresses and merging your duplicate records are absolutely essential in cleaning your customer file. If you have a clean file, your match rates from processing merge/purge will be more accurate.” This saves you from mailing prospects who are already customers on your file, for instance.

Partner Content

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.
Strategies for Maximizing Mobile Point-of-Sale Technology - NetSuite
Learn the top five innovative ways to utilize your mobile POS technology to drive customer engagement, increase sales and elevate your brand.