See Results of National Change of Address Updates

NCOA Update Results

See the results of an NCOA update.

1. Click the Update Schedule tab.

2. Find the update in the In Progress and Past Updates section. Jobs can be in one of these states:

   • In progress jobs are indicated by an In Progress Ring icon.

   • Successfully completed jobs have a white checkmark inside a green circle.

   • Partially successful jobs are signified by a white checkmark inside an orange circle.

3. Click the National Change of Address (NCOA) update you want to see.

4. Click a tab to see the results:

   • Overview: See the number of changed addresses found, the total number of addresses reviewed, and the number of errors.

   • All Updates: See the status for each address that was reviewed. You can also search by address or status.

   • Details: See details about the update, including the start and finish date and time.

   • Errors: See a list of errors that were found during the update. Run the job again if you get any errors.

5. Optionally, from the All Updates tab, click the Download button to obtain a CSV file with all addresses in the update, including the current address, prior address, and status.

After an NCOA update, you'll also see these changes on Address records:

• The Verified checkbox will be selected for addresses that were updated with a new address.

• The Verified Date will be updated for addresses that were updated with a new address.

• NCOA Evaluation Date will be updated to show the most recent date and time the address was evaluated for NCOA updates, regardless of if a new address was found.

• NCOA Result Code will show the NCOA result code from Melissa Data.

Error Handling

Data Integrity has a robust system for logging transient Melissa Data and core API errors, as well as automatically attempting retries on failure.

This system:

• Breaks large requests for Addresses from the CRM into a number of batches, enabling job processing to continue regardless of failure for a subset of these batches. The average batch contains about 30,000 records.

• Displays error count for partially successful address standardization jobs on the Overview tab of the results interface.

Furthermore, after receiving an error:

• Failed API calls to Melissa Data for address standardization and NCOA updates are automatically retried in case of network errors. Each batch sent to Melissa Data contains up to 100 records. Data Integrity attempts 3 retries per batch.

• Data Integrity automatically attempts retries following errors fetching access tokens from the CRM Core API. The application attempts up to 4 retries over 5 seconds.

Data Integrity does not attempt a retry and the job fails in these scenarios:

• Melissa Data SmartMover license key has expired or is invalid.
• Melissa Data service is down.