Understanding Your NCOA Data

 

Part 2: Finding Bad Addresses in Your NCOA Results

Any addresses in your NCOA results with a record_type of “C” or “A” are mailable addresses according to USPS. You can find these addresses by filtering your file and selecting “A” (Active) and “C” (Current) on the record_type field. (See #1 Record Type)

In addition to identifying updated addresses on your file, you may also want to review the validity of an address and check if it is vacant. You can do this by filtering your file’s address_status field and vacant field.

Watch the video or our guide below for step by step instructions on finding invalid addresses.

How to Find Invalid Addresses

  1. Navigate to the field named address_status.
  2. Filter column and select only “N” to show invalid addresses.
    • Y = Valid
    • M = Multi Match (typically missing a prefix or suffix in the address)
    • N = Invalid
  3. You should not use addresses with address_status = “N”.

How to Find Vacant Addresses

  1. Navigate to the field named vacant.
  2. Filter column and select “Y”.
    • Y = Vacant
    • N = Occupied
  3. You should not use addresses with vacant = “Y”.

This information is covered in greater detail on our Output Guide, which you can see here. There are some helpful images in that document.


If you have any questions or need help, send us a quick note to support@truencoa.com.

Leave a Reply

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