Data Tips: Deduping and Suppressing

Cleaning a database of dedupes is one of the simplest ways to maximize its efficiency for your data marketing needs. This includes many small steps, but two are imperative when mailing to your customers.

The first is deduping. Deduping is simply the process of removing duplicate records. There are several different options you can choose to go by when deduping, this allows your marketing campaign to be as efficient and direct as you would like. For example, here is a list of deduping options that CSG offers.

One Per Individual Deduping

Individual Exact – This matches the address, first and last name, and zip code. So, if there is a Bob Smith at 123 Liberty Lane in your list twice one will be exported out of your list.

Individual Tight – Compares the same as above, but those that sound alike, such as: Christopher Ryan at 123 Liberty Lane, Chris Ryan at Liberty Lane or Jonathan Smith or John Smith. These are considered the same person and therefor a dedupe.

Individual Exact and Tight deduping comes in handy when your mailer has individual offers like the example below.

John Smith at 150 Freedom Dr. gets 100 bonus points
Sally Smith at 150 Freedom Dr. gets 120 bonus points

Although both live at the same address, they both have different first names therefor are not deduped out by using Individual Exact and Tight. This allows you to market to multiple people within a single household. Furthermore, you can market variable offers to every unique individual inside your data list.

One Per Household Deduping

Resident Exact – Dedupes the list by address and zip code only. So regardless of name if two or more records have the same exact address all but one record will be exported out of the main list.

Family Tight – Compares the last name, address, and zip code. This catches and slight variation of spelling that may occur between dedupes.

For example:
John Smith, 123 Liberty Lane, Apt B302
John Smith, 123 Liberty Lane

The above is a dedupe, although one of the above addresses contains an apartment number, the bottom record must be deleted in order to prevent the targeted clientele receiving multiple mailers for the same marketing campaign.

Resident Exact and Family Tight are handy for generic mailers that don’t have variable offers. There is really no need to send a mailer to everyone in a household for the same event, not only is it over marketing and annoying to those receiving the offer, but it is a waste of print and postage expenditures.

One Per Company Deduping

Company Exact – Much like Individual Exact with the exception that it compares the Company Name instead of the First and last along with the address/zip code.

Company Tight – Matches Company names that sound alike and have the same address/zip code.

For example:
Flag Makers Incorporation, 123 Freedom Way Suite 202
Flag Makers Inc. 123 Freedom Way Suite 202

This is obviously a dedupe, but wasn’t picked out by Company Exact because “Incorporation” was abbreviated in one and not the other.

Company Exact and Tight is only used when a list contains a company field.

There are instances where you will have First and last name fields along with a company field. This opens the possibility that several individuals at the same company and address will be in your list. Whether you want each of those instances to be mailed to will be entirely up to you.

Suppression

Suppression is when two different data lists are deduped against each other; whether it be Individual Exact, Resident Exact, etc.

This is typically utilized when you don’t want to mail to customers that were previously mailed to in recent marketing campaign.

So you can see that there is a lot that can be done to with these two data processes that can save you some big bucks, prevent your mailers from annoying your targeted audience, and ultimately insuring that you are getting the best out of your data.

3 thoughts on “Data Tips: Deduping and Suppressing

  1. Any recommendations on list scrubbing software? I’ve been an excel guy for a while but have to believe that their is something better out there for deduping and suppressing lists.

  2. Unfortunately good dedpuping software isn’t cheap. Most Mailing Presort programs have deduping as a function as well. I love Postalsoft Desktop Products (now SAP) for the many levels of deduping and “percentage of matching” options.

    Most standard database sofware requires exact match only.

    Also, since you are deduping with fields other than names, like address and zip; mailing software is better since it cleans the list based on the US Postal Service address database so matches are found easier. (CASS)

Leave a Reply to Staygreen12 Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>