so_logo.png

Address Detective – Why it is so cool!

Service Objects has been providing USPS CASS-Certified Address Validation services for over 17 years. Over this time, we have developed one of the best systems for validating, correcting and appending useful data points to US addresses. Our address validation service specializes in fuzzy matching for address corrections and, more importantly, making sure that each and every address provided is NOT changed to something unexpected or incorrect.

While our address validation service is top notch, the focus on both USPS and accuracy introduces necessary limits on how we treat addresses that might be messy or missing key elements.  Which brings us to one of Service Objects more under appreciated offerings, our DOTS Address Detective service.

Address Detective and its operations

Address Detective was born from a need to help our customers fill in the gaps and make sense of their very messy and/or incomplete addresses. This service is an ever-evolving collection of address utilities designed to help with various problems that can arise from these messy or incomplete addresses.  Currently, there are three operations available that each solve uniquely different problems.  It is helpful to understand what each operations does and how it can be best used to correct an address before you even start your implementation.

Operation NameDescription
FindAddressUses name and phone number to assist with the processing of very messy or incomplete addresses.
FindAddressLineTakes inputs that might be jumbled into the wrong columns and parses them into a usable result.
FindOutlyingAddressesDigs into alternative data sets from USPS to identify addresses that while not deliverable may still be good addresses.

Address Detective’s operations explained: FindAddress

The flagship operation of Address Detective is FindAddress. This service was designed to help clients with addresses that may be so messy or incomplete that they may not be obviously fixable, even to the human eye. FindAddress is given free reign to be more aggressive in its basic operation but also makes use of other data points like name, business name or phone number to assist with the validation.

Behind the scenes the service will dig into public and proprietary data sources to connect the dots between given data points to return an accurate result. The service is not designed to return an address if one is not given, its designed to analyze data given with cross referenced values in order improve or validate a normally unvalidatable address.

For example, perhaps the desired address is:

Taco Bell
821 N Milpas St
Santa Barbara, CA 93103

But what if the input address is something like:

Milpas Street
Santa Barbara, CA 93103

Clearly, not enough information is given for this address to pass validation. A house number is always required. DOTS Address Detective is able to use either the name “Taco Bell” or the phone number, (805) 962-1114, to properly identify and standardize the right location. The partial input values given are still important to compare back and make sure the most accurate result is returned.

What about addresses that are even messier with misspelled or incorrect data:

Milpaaaas Str
Santa Bar, CF 93103

Given either “Taco Bell” or (805) 962-1114, there is still enough information to go on to compare, cleanse and return the correct standardized result.

Address Detective’s operations explained: FindAddressLines

The second operation, FindAddressLines, solves a very different problem. We would often run lists of addresses for clients where they would give us a .csv file of addresses with data points that were in unexpected locations. Perhaps they tracked multiple address lines in which the third or fourth address line contained the normal “main” address line.  For example; what if they had something like this:

[dropshadowbox align=”none” effect=”raised” width=”auto” height=”” background_color=”#FFFFFF” border_width=”1″ border_color=”#ddddd” ]Four Address Lines:

Address 1: Johson Paper Bag Company
Address 2: C/O John Smith
Address 3: Floor 4
Address 4: 123 Main Street
City: Santa Barbara
State: California
ZIP: 93101
[/dropshadowbox]

If the user does not know that the needed address in this case is Address4 (123 Main Street) its possible they may be sending the address: Johnson Paper Bag Company, C/O John Smith, Santa Barbara, CA, 93101 which obviously would not be a valid address. Perhaps they have an even bigger problem and there was an error in how the address was stored or a corrupted database leading to something like this:

[dropshadowbox align=”none” effect=”raised” width=”auto” height=”” background_color=”#FFFFFF” border_width=”1″ border_color=”#ddddd” ]Corrupted Database Example:

Address 1: 123 Main St
City: Apt 5
State: Santa Barbara
ZIP: CA
[/dropshadowbox]

Both of these cases are solved by using the FindAddressLines. FindAddressLines takes in a generic list of Address inputs and analyzes them to figure out how to properly assign the inputs to the correct fields.  The result is then validated, corrected and standardized as a normal address. While there is some synergy with the FindAddress operation here, in order to properly parse out an address, the address would have to at least look like an address.  FindAddressLines would not be able to do anything with an address of “Milpas Street” as opposed to “821 Milpas Street”.

Address Detective’s operations explained: FindOutlyingAddresses

The final operation is FindOutlyingAddresses. This operation cross references several massive non-USPS datasets to find likely good addresses when USPS cannot. While our Address Validation service is designed to accurately identify deliverable addresses and contains the vast majority of US based addresses it does not cover everything. Pockets of addresses either in very rural areas or some well known areas like Mammoth Lakes (California) do not have deliverable houses, all mail is delivered to a local post office for pickup by residents.

FindOutlyingAddresses aims to fill in the blanks of these hard to find addresses. They may not be important for mail delivery but still play a vital role in identifying lead quality. While the data returns for this operation are not as complete as our Address Validation service, we will attempt to identify the data points at the lowest level we can. Do we know the house number exists? Maybe the house number does not exist but we know the street does? This operation will return as much useful information as it can about these locations.

Address Validation + Address Detective = Powerful one-two punch

One of the best ways to ensure you have accurate and up-to-date address information is by combining our Address Validation service with Address Detective. This combination allows many of our customers to identify and repair addresses that they would have normally discarded.  We are always happy to help our clients set up this powerful one-two punch.

In its most basic form, we use Address Validation to correct and verify all addresses. Addresses that could not be validated or corrected by the initial, stricter validation process, would be sent to our Address Detective service where supplemental information helps ‘solve’ the address and returns a viable address.

What is next for Address Detective?

DOTS Address Detective is an ever-evolving collection of operations that were created to meet the needs of our clients. We are always looking for new algorithms, data sets and features we can add to meet these needs and help clients recover and update even more addresses.

One of the more recent requests we are working on is helping identify GDPR exposure.  Our clients need to know if a contact record resides in any of the European Countries that are covered by the far-reaching privacy protection regulations of the GDPR. It is always a little more fun to solve real-world problems that our clients are facing and we are excited to be launching a new international address detective service in the coming week to help.  (By the way, if you think it is simple to identify a country by an address, try taking this Country Quiz.)

We encourage clients and prospects alike to reach out and let us know if they have a need that does not seem to be covered by one of our current products.  Share your needs or try it today to see what DOTS Address Detective can do to help!