Address Cleansing Results

After running an address cleansing job, several new columns are added to show the address cleansing result.

The following columns are added:

Column Name Data Type Description
addr_isLead Boolean true: This row is the result with the highest score.
addr_group Integer -1: No result is found.

0: Only one result row is found.

>0: Multiple results are found.

addr_rowInddex Integer The row index of the source data.
addr_longitude Integer The longitude of the source data.
addr_latitude Integer The latitude of the source data.
addr_city String The matched results returned from the address cleansing vendor.
Note: These columns only appear after you map the source columns and destination columns in the mapping area on the "Address cleansing" page.
addr_state
addr_zipcode
addr_country
addr_address
addr_score String The third-party vendor gives a percentage score for each address data based on the matching degree.