Part 1: Finding NCOA Updated Addresses
With each NCOA file, you will receive a plethora of information. Using Excel sorting and filtering techniques, you can find identified addresses for 18-month moves, identified flags for 48-month moves, residential delivery indicators, delivery point verification, identified move types, identified address types, identified vacancies, and more!
Review Record Type For Move Insights
Finding updated addresses is easy. With TrueNCOA’s default layout, your download will mark updated addresses as Current in the record_type field (the field will contain a “C” for Current). TrueNCOA returns updated addresses as an additional row in your output. This allows us to give you full information on your input address AND full information on your updated address.
Sample of how an updated address is returned. Note: We did not include all export fields in our example.
Watch the video or see our guide below for step by step instructions on filtering record type.
Filter By Record Type
The quickest way to find updated addresses is to filter record_type. Record Type returns one of three results: A, C, H.
|A||Active||When an address is marked “Active”, it means that the change of address process did not find a move record. This address may not be current if the contact moved and did not file a change of address with the United States Postal Service.|
|C||Current||When an address is marked “Current”, it means that the change of address process found a move record.|
|H||Historical||TrueNCOA updates a record_type to “Historic” when an address you included on your upload is identified as
a previous address by the change of address process. The Postal Service has a record of your contact at this
address, and may also have a new address on file.
Filtering the field to show “C” – Current, will show all updated addresses that were returned in your file. These addresses will have an input_id that matches its historical record’s input_id. Using this input_id will allow you to update the addresses easily. If you filter the field to show both “H” – Historical and “C” – Current, you will receive all updated addresses and the corresponding, previous address. The top row displays historical address, and the following row displays current address. Filtering by both Historical and Current record types gives a clearer understanding of what has changed between the two addresses. For example: The constituent may have moved from a single-family home to a high rise.
Flagged 48-Month Moves
To find flagged 48-month moves, filter the record_type field to “H” for Historical and then filter the ANK field to only show the number “77”. The USPS identifies these records as persons that moved within the last 19-48 months. You should not mail to these addresses. To obtain updated addresses for these 48-Month NCOA moves, please contact firstname.lastname@example.org for pricing and more details.
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 email@example.com.