Skip to content

Posts tagged ‘de-dupe’


Data Cleaning Tools

Since a lot of direct mail includes your house mailing lists, we thought we would discuss the “data toolbox”.  Most of your contacts are developed over the years from prospecting, prior customers, donors, etc.  And once the contact is added to your database, it’s rarely updated.  That’s where we come in.Data Cleaning Tools from FNBR

The most valuable tool in the data cleaning toolbox is NCOA.  Short for National Change of Address, if your contact has moved and completed a change-of-address with the USPS in the last 4 years, we’ll mail to their new address.

If you are mailing at first class rates, the post office will forward your mail to the updated address on file for 12-months. This is time consuming since the mail must be re-routed, and if you have a time sensitive offer, your postage may end up being wasted. If you are using Standard Mail, the mail piece will not be forwarded at all.

NCOA is a quick, efficient and inexpensive way of keeping mailing lists up to date. If you are purchasing a list through FNBR, you can be assured that the mailing list has already been NCOA’d and we will provide you with the date that the NCOA certificate* is good through. If you are supplying your own mailing list for FNBR to use, we can NCOA update the list for you.

NCOA is one of the many software tools that FNBR uses to keep your mailing costs streamlined and your mail delivered as quickly as possible.

Other Tools Include:

  • CASS – Address correction, including DPV, LACSLink and SuiteLink processing which adds missing postal data like ZIP+4, carrier route, eLOT and more.
  • ECOA (Extended Change-of-Address) – Updates addresses using sources other than the USPS NCOALink file, including magazine subscriptions, catalogs, insurance and credit companies. Identify up to 20% more moves up to 5 years old.
  • Apartment Number – Appends residential unit numbers based on the submitted name and address. Complements SuiteLink processing, which appends unit numbers for business addresses, to further reduce undeliverable and misdirected mail.
  • Suppression Suite – Flags records that match entries in do-not-mail, deceased person and correctional facility lists. Improve mailing ROI by removing people that are unwilling or unable to respond.

For more information on applying these data tools to your database, or other postage saving techniques, please email us at or call toll free 888-988-8148.

*NCOA Certified mailing lists qualify for Automation postage discounts for 95 days from the date of certification.


Database Hygiene

There are many tasks in the work environment that require your attention. We routinely prioritize our daily tasks and tackle the most important ones first. Often times, database maintenance gets placed at the bottom of the “To Do” list – if it makes it to the list at all. This is unfortunate, because a well-maintained mailing list ultimately saves your business money and keeps you in touch with your clients and prospects.

FNBR can perform the following database management services to clean up your mailing lists: 

  • Remove Duplicates: Our de-duping software can remove duplicate records from your database.
  • CASS: Standardize and correct address elements including city, state, zip, zip+4 and more.
  • SuiteLINK: When available, adds the missing suite number to business records.
  • NCOA: Our USPS Certified National Change of Address software will replace the previous mailing address with the current mailing address of anyone that has filed a change of address in the prior four years. This process can also flag records that have moved but left no forwarding address.
  • Case Conversion: Convert your data to upper/lower case format.
  • Name Parsing, Address Parsing, Add Gender, and Much More.

Click here to learn more about our database services.

Continue the Conversation
If you’d like to discuss ways to “clean up” your databases, call FNBR Inc. at 888-988-8148 or send us an email at

%d bloggers like this: