Create Queries for Updated Canadian Addresses

Create a query for each code used to classify the results of the Canadian AddressFinder (NCOA) process.

• Move Identified, Address Updated

• Address Standardized

• Invalid Address

• Move Identified, Address Cannot Be Updated

You'll use the Address Updated and Address Standardized queries to identify constituent addresses that were updated by the process. If you use a user-defined field called "Mailing status" to track which constituents have bad addresses, you will also use these queries to run mass updates after each Canadian AddressFinder (NCOA) run.

We recommend you use the Invalid Address and Move Identified queries to locate personas whose addresses have become invalid. If you have other methods of reaching the constituents, contact them to request updated addresses.