Data updater
Address cleansing
Administrators and data managers can now choose to enable address cleansing when they run a data updater job to update addresses. Address cleansing verifies addresses and parses the data into Network fields. Because cleansing can change the address data in your uploaded file, you might not want cleansing to occur; for example, if you are correcting postal codes on existing addresses. However, it is helpful to use Network's address cleansing to correct entire addresses. Now, you have the option to enable address cleansing depending on the address data in your file.
This enhancement is available by default in your Network instance.
Address cleansing options
Disable cleansing
When you create a data updater job, the option for address cleansing displays after you choose the address object. The option is disabled by default.
When address cleansing is disabled, only the vid__v column is required in the file that you upload. When the job runs, the updates in your file are applied to existing address records.
Enable cleansing
If you enable the Verify and clean addresses option, address cleansing occurs during the job. Network's third party cleansing service verifies and parses addresses into Network's address fields. This is helpful if you are using the data updater job to correct entire addresses.
When address cleansing is enabled, several column headers (fields) are required in your file:
vid__vaddress_line_1__vlocality__vadministrative_area__vcountry__vpostal_code__v
Click See Example to view an example file with the required fields. These fields ensure that address cleansing can occur. If the fields are not in your file as column headers, the upload will fail.
On the File Summary tab, the Status column confirms that address cleansing will apply to the field.
If address cleansing is not enabled for a country, but the Verify and Clean Addresses option is set, the data updater job simply skips the address verification and cleansing for any records for that country.
Network remembers your choice for the next time you log in and create a data updater job for addresses.
Job Details
The Verify and Clean Addresses heading on the Job Details page indicates whether address cleansing occurred for jobs for address objects. The heading does not display for jobs for other objects.
