Keeping Your Mailing List Clean and Efficient

Your mailing list retains its value best if it is kept clean and efficient. This report will first talk about why you should maintain your list in this manner. Then, the procedures you can follow to update both the mailing and database information associated with the names on you list will be discussed.

THE IMPORTANCE OF MAINTAINING A CLEAN AND EFFICIENT LIST
What makes a list clean and efficient? Lists are clean and efficient when they are: * accurate. * current (up-to-date). * as free of duplicate names as possible. * maintained with complete data. Keeping lists clean and efficient requires a constant effort. The average mailing list begins to go out of date as soon as it is compiled. Industry studies have shown that the average consumer list changes approximately 20 percent a year. Business lists change a bit more slowly: about 18 percent a year. But individual names within a business can change much more frequently. The source of the list will often determine how frequently it is updated.

At best, lists compiled from Yellow or White Pages will only be as up-to-date as three to six months prior to the publication schedule of the directory. This is usually on an annual basis but may be once every two or even three years. Mail order buyer lists could have a higher degree of accuracy because part of normal business is maintaining correct information about customers.

Don't assume that a list is clean just because you bought it from a fellow business owner. Most of the best kept lists are made up of mail order buyers, those buyer lists which are poorly maintained represent some of the worst lists. Always try to see and test a portion of the list before you mail it in total.

Because mailing lists change so quickly, it is important to commit the necessary resources to keep your own lists current and correct. Lists that aren't properly maintained can be harmful and costly to your business or organization in several ways. For example:

1. You're wasting postage and printing dollars if the mailings are incorrectly addressed or if there are duplicate names on your file or if they have moved. 2. The database information is not kept current, you may not be mailing as efficiently as you could be. 3. You may be losing out on potential business if you cannot reliably get the mailing pieces to target audiences due to out-of-date or otherwise incorrect addresses. 4. You are damaging your image with your customers. Misspellings and out-of-date information reflect poorly on the organization - if the mailing reaches its destination. 5. Duplicate names can lead you to understate the response rate. The response you actually get may be much better than the numbers show. This can have an effect on future mailing plans since you believe that the response you are getting is much lower than it actually is.

The key to keeping a list clean and efficient is to establish procedures for making daily changes to your list. Develop a carefully planned, closely followed, regular updating program. In the next sections, we will discuss ideas for setting up a daily updating system, then give steps that should be included in any regular monitoring program.

KEEPING YOUR HOUSE LIST ACCURATE AND UP-TO-DATE ON A CONTINUING BASIS
Establishing an ongoing updating system is the most effective way to stay on top of changes to the customer mailing list. Customers are your easiest, most reliable source for keeping a customer list continuously current. Enlist their cooperation by including a request for updated information with each mailing sent. Here are some possible ways to make the request:

1. If you use an order form with a label affixed, request that customers change any incorrect information. 2. If you provide a return envelope which includes space for the recipient to write in a return address, below these lines provide a "key" that indicates that address information should be updated. The key could look like this: [ ] Check here if this is a new address. Record and maintain each transaction with a customer so that you can keep the important recency, frequency, and monetary value data current for each customer.

There are other database fields that may change frequently or with each transaction. These fields should be incorporated into any system you developed for continuous updating of the mailing list/database. If the audience is made up of individuals of businesses, here are some fields you will want to monitor and update on a regular basis:
*Credit Status Code: This code is based on the customer's payment history. Each time a customer orders, information about how long he takes to pay, and how he pays is generated. This data should be used to update his account. Credit status codes should also be evaluated and updated on a monthly basis. * Items Ordered: Keeping this information current will help uncover opportunities where you may be able to sell related products or supplies to that customer. This information can be updated on a monthly basis. *Date of Last Order: This information is used for recency and monetary value calculations. It can be updated on a monthly or quarterly basis. *Name and Address: This information should be verified and updated at the time a customer orders. *Title or Name of Contact: This information should be verified and updated at the time of order. *Date of Last Contact: This field should be updated at the time of contact - either the last date this name was mailed or the last date a sales call was made. If you are maintaining this information on a microcomputer, much of this information could be automatically updated.

PERIODIC REVIEWS OF YOUR HOUSE LIST
In addition to making ongoing changes as necessary to individual records on your list, you should periodically review the entire list or portions of it and make all changes necessary to update and correct your list. Below is a variety of methods to consider including in your regular "list-cleaning" program: 1. Again, your customers are your best source for verifying changes to your list or database. For example: * You may want to send a mailing which has the sole purpose of updating and correcting the list. The mailing could consist of a business reply card with an address label affixed to it. Below the label, insert such check boxes as: [ ] Please update my account as noted on the label. [ ] Addressee no longer here. Please remove name from the list. *You may also want to conduct a mail or phone survey (depending on the size of the list), to update the demographic information about the audience. 2.The U.S. Postal Service provides several programs that your organization can use to periodically clean the list. Contact your local postmaster for full details.

ELIMINATING DUPLICATES
In addition to keeping the mailing list correct and up-to-date, make sure that it is as free of duplicate names as possible. This involved two steps: 1. Removing duplicate names from your customer list. 2. Eliminating duplicate names between and among the customer, prospect, or suspect lists you use. The techniques used to remove duplicate names from your house list depend largely on the size of the list and how it is maintained: *If the list is small enough, you can catch many duplicates by sorting the list in zip code or alphabetical order and "eyeballing" it *If the list is stored on a microcomputer, you can sort it by one variable and then use the eyeball approach to spot the duplicates. Possible variables for ordering the list include last name, company name, address or telephone number. *For large lists of more than 10,000 names, you may want to consider hiring a computer service bureau to "de-dupe" (eliminate duplicate from) the list using one of their specifically designed software programs. If you are renting lists, and your own list is automated, ask that the service bureau perform an "own customer" elimination as part of their service. Names of service bureaus in your area can be obtained from the Direct Marketing Association. In addition to removing duplicate names within your house list, match this list against any outside lists you use. The popular term for this is "merge/purge" which means matching two or more mailing lists (usually by electronic means) to remove duplication and make sure that each name receives only one mailing.

Basically, merge/purge is accomplished through use of a match code. Match codes can take the form of many different combinations. Some match codes eliminate all the vowels in the name and address, while others pick up certain characters from certain fields. The match code is made up of the same characters for each name on the lists, and fully and uniquely identifies that name. When lists are matched against each other, duplicate match codes indicate that the same name exists on more than one list.

When you hire a firm to run a merge/purge, try to find out how they identify duplicates, and if you can, set up a test with more than one service bureau to find out whose program best fits your needs.

Another concept to consider when trying to identify duplicates is "overkill" vs. "underkill." If the match code includes too many characters, possible duplicates will not be caught. This is called underkill. On the other hand, if the match code is too loose, names which are not duplicates will be recognized as duplicates (overkill).

Finding duplicates is really an art. How do you catch a match of an individual where one list says he lives at 505 7th St., and another has him living at 505 Seventh St.? Even worse, is Jean Smith, who lives at 510 Main St. the same person as the Jane Smith living at 501 Main St.? How you answer depends on whether you prefer overkill or underkill.

It's a bigger problem when running a merge/purge for businesses. Not only do you have to worry about name and address fields, but now you may need to find matches with business names and individual titles. The key here is to determine up front how many names per firm you want to mail to.

The key to successful merge/purge is close monitoring. Watch the process from beginning to end. Have thorough written instructions, and make sure they are carried out.

Copyright 2004 by DeAnna Spencer

Note to editors:
To show my appreciation to the editors that use my articles, I offer a free solo ad. Simply send an email to me by using the form on the contact me page on my website to tell me the url the article was used on or send me a copy of the ezine it was used in.

This article may be redistributed freely on the Internet as long as the resource box remains intact.
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
DeAnna is the publisher of the ezine, Prospecting and Presents.
Subscribers get one free ad per week.
Subscribe today by visiting http://www.pnewsletter.com
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

---

Google News Updated : Sun, 07 Sep 2008 08:08:09 GMT Yes, the mosquitoes were nasty this summer - Yakima Herald-Republic Yes, the mosquitoes were nasty this summer Yakima Herald-Republic - 1 hour ago by Ross Courtney PROSSER - Cody Jansen sloshes through a pasture, his rubber boots squishing in muddy puddles as he goes. He dips a ladle into a tiny pool and looks closely. Rockland resisted West Nile virus query Lower Hudson Journal news Aerial survey being conducted to find mosquito breeding grounds San Jose Mercury News San Francisco Chronicle - Shelbyville News - Atlanta Journal Constitution - dBTechno all 362 news articles Publ.Date : Sun, 07 Sep 2008 06:47:33 GMT Tim Tebow leads Florida past Miami - Los Angeles Times OnlineSportsHandicapping.com Tim Tebow leads Florida past Miami Los Angeles Times - 1 hour ago * at No. 5 Florida 26, Miami 3: Tim Tebow threw two touchdown passes for the Gators (2-0), who ended a six-game losing streak against the Hurricanes with their first win in the on-again, off-again series since 1985. Tebow's maturity key to Gators' win over Canes - College Football ESPN Marve's debut gives Miami (Fla.) reason for hope SportingNews.com Orlando Sentinel - Seattle Post Intelligencer - CNN International - Independent Florida Alligator all 590 news articles Publ.Date : Sun, 07 Sep 2008 06:58:47 GMT 'Home: A Novel' by Marilynne Robinson - Los Angeles Times Washington Post 'Home: A Novel' by Marilynne Robinson Los Angeles Times - 1 hour ago Drawing on the characters of prize-winning novel 'Gilead,' Marilynne Robinson revisits an Iowa town. By Emily Barton UNLIKE novels that delight in plot twists and structural play, Marilynne Robinson's Pulitzer Prize-winning "Gilead" is seemingly ... Back at home, troubled siblings look for refuge Boston Globe Their Father's House Washington Post The Oregonian - OregonLive.com - Austin American-Statesman - News & Observer all 7 news articles Publ.Date : Sun, 07 Sep 2008 07:04:58 GMT Gates outacts Seinfeld in Back To The Future - CNET News Seattle Times Gates outacts Seinfeld in Back To The Future CNET News - 8 hours ago Which is why Crispin Porter Bogusky, the agency responsible for the otherworldly new Microsoft TV spot featuring the clowning Bill Gates and Jerry Seinfeld, is already happy. Microsoft's Renewed Vista Strategy PC World Journals week in review: news from One Microsoft Way Ars Technica InformationWeek - New York Times - MacMod - CRN all 522 news articles Publ.Date : Sun, 07 Sep 2008 00:01:52 GMT Sarah Palin may have women flocking - to Barack Obama - New York Daily News Times Online Sarah Palin may have women flocking - to Barack Obama New York Daily News - 13 hours ago BY KENNETH R. BAZINET and MICHAEL McAULIFF WASHINGTON - If John McCain wanted to poach the women's vote from Barack Obama, he shouldn't have tapped a running mate who dubbed herself a "pit bull with lipstick. Sarah Palin's appeal to working-class women may be limited Los Angeles Times A feminist's argument for McCain's VP San Francisco Chronicle Boston Globe - Newsweek - The Associated Press - Richmond Times Dispatch all 1,109 news articles Publ.Date : Sat, 06 Sep 2008 18:10:33 GMT Health Buzz: Immunosuppressive Drug Warning and Other Health News - U.S. News & World Report eFluxMedia Health Buzz: Immunosuppressive Drug Warning and Other Health News U.S. News & World Report - Sep 5, 2008 The Food and Drug Administration has asked the manufacturers of Humira, Cimzia, Enbrel, and Remicade—which belong to a class of medications known as tumor necrosis factor alpha blockers (TNF-alpha blockers)—to strengthen the warning for risk of fungal ... FDA urges more caution over TNF blocker infections Reuters Arthritis Drugs Linked to Risks From Infection New York Times WebMD - eFluxMedia - Scientific American all 622 news articles Publ.Date : Fri, 05 Sep 2008 15:23:08 GMT 'Wrestler' wins Golden Lion - Hollywood Reporter Hollywood Reporter 'Wrestler' wins Golden Lion Hollywood Reporter - 2 hours ago By Eric J. Lyman ROME - Darren Aronofsky's "The Wrestler," which set the Venice Lido abuzz after its world premiere Friday, won the festival's top prize Saturday. Video: Mickey Rourke Pinned in 'The Wrestler' AssociatedPress Will victory at the Venice Film Festival help 'The Wrestler' in ... Los Angeles Times Variety - Reuters - Monsters and Critics.com - Washington Post all 445 news articles Publ.Date : Sun, 07 Sep 2008 05:36:04 GMT RSS Software Increase Web Traffic

PARLOT::Ebooks, Scripts, Websites, and more...

Adsense websites

Whats Your Marketing Weak Link?

Your marketing weak link could be undermining the rest of... Read More

Distinguish Your Business From The Competition

You followed time-honored online marketing techniques to the letter: you... Read More

The 30 Incredible Ways To Sell Your Products Now and Sell More

How to sell more and sell quickly online for your... Read More

Has the Internet Killed Off the Direct Mail Baron?

Over the past 30 years, direct mail has been responsible... Read More

Whats In a Business Card?

Over the years as I have attended trade shows, networking... Read More

Take My Commitment (to Your Biz) Quiz!

Starting and managing a successful small business takes time, energy,... Read More

Using Flyers In Your Business

If you are not using flyers in your business you... Read More

What The Heck Is An Eponym, And What Does It Mean For Your Brand?

Today I've decided to share with you a new word... Read More

Practical Advice to Generate Successful Campaigns Using Merged Lists

You could end up with poor results when designing a... Read More

After The Mailing Is Done, What Happens Next?

If you're doing any sort of marketing effort, whether it's... Read More

How To Market Effectively Even If No One Understands What You Do

So how do you effectively market your product or service... Read More

Consistent Marketing Provides Big Rewards

Being inconsistent when it comes to marketing your business can... Read More

For Market Breakthroughs, Put Timing on Your Side

In today' s marketplace, the pressure for immediate bottom-line results... Read More

Marketing Strategy 101: 10 Marketing Strategies I Learnt From My Oral Surgeon

This is how the conversation went on my follow-up visit... Read More

Competitive Research and Google

It all started out with an email message: "I am... Read More

Creating Your Future with a Marketing Plan

Almost everyone who dreams of starting their own business is... Read More

Break Even On Your Next Direct Mail Campaign...And Still Generate Huge Profits

With direct mail, you can break even and still claim... Read More

Take The Test: Does Your Marketing Copy Sell?

Your marketing materials must grab your prospect's attention long enough... Read More

How To Choose a Qualitative Research Market

Qualitative research, whether individual interviews, in-homes, focus groups, ethnographies and... Read More

Make Your E-Mail Signature File WORK for You!

You're probably familiar with e-mail signature (or "sig") files -... Read More

Build Lifelong Networks With Your Own Barter Group

I don't know if you have ever seriously considered bartering.... Read More

Fern Reisss PublishingGame.com: Achieve Media Attention for Your Business

Do you want to be quoted by the national press... Read More

Marketing Success Defined

How do you personally define success? High income? Substantial net... Read More

Connecting With Your Clients

Many service professionals tell me that they are uncomfortable with... Read More

How to Convey Trustworthiness in Direct Mail Marketing Sales Letter

A person or business that might buy from you is... Read More