New 42-day free trial
Smarty

Common problems when working with address data

Andrew Townsend
Andrew Townsend
 | 
November 29, 2022
Tags
Common problems when working with address data

There are many problems you may run into if you're working with address data. In our recent webinar, our own Adam Charlton went over some of the challenges he's encountered the most, and how to deal with them.

Here’s some of what he talked about. You can view the full recording at the link below.

Standardization

Standardizing addresses helps solve many of the problems inherent in data blending (combining two or more address databases together). To properly blend different address databases together, you need to either have an external ID correlate the two sources or have identically formatted address fields.

It’s worth noting that the USPS DPV barcode isn’t sufficient for data blending. It can be very difficult to properly correlate addresses going off ove the DPV barcode only. See “Semi-valid Addresses” below for more information on that.

Human error

Human error is a natural occurrence that can wreak havoc on an address database. If you decide that you’re going to self-standardize your database and change every “street”, “avenue”, or “boulevard” to a standard abbreviation, there’s plenty of opportunity to make mistakes.

Imagine what would happen if you have a correct address, but it isn’t standardized, and when trying to manually standardize it, you accidentally change a number. The issues just pop up from there.

The solution is using an automated system to standardize your address database. This could be through a bulk standardizing tool, an API, or other means.

An additional benefit to using an external standardizing tool is that it will likely also validate the addresses. Standardizing means to make an address appear correctly, but validating means that it is an actual mailable address. So what should be considered when validating an address database?

Common address validation issues

Not every address validation tool is created equal. Many will merely tell you if it’s mailable or not, but even those who’t tell you why they're not mailable.

Adam went over three main problems that most people run into when trying to validate addresses.

Unique ZIP Codes

There are some places in the United States that receive such a high volume of mail that the USPS has given them their own ZIP Code. For example, the Empire State Building, some university campuses, or other large corporate offices.

This means that when you use a validation service that uses the USPS database, you won’t get a whole lot of information about those addresses because as long as it has those ZIP Codes, it’s mailable, but still might not get where it needs to go.

There’s more information about this in one of Adam’s previous webinars, Address data masterclass.

Smarty counteracts this challenge by ensuring that we inform the user of unique ZIP Codes, and we have three unique places to make sure you’re informed.

Semi-valid addresses

Addresses that are missing secondary addresses may still be valid, but may not get your mail delivered to them. This means if you mail something to da large apartment building, but you put an apartment number that isn’t in the building, it would still be identified as mailable. However, Smarty’s validation tools will ensure that you are aware that your address may have trouble delivering to that address.

R7 addresses fall into this category. These are mailable, but they’re not street-deliverable. This sort of mail is typically picked up from the post office and doesn’t have a DPV barcode.

Non-postals

Not every address is USPS-serviceable. This doesn’t mean that these addresses are not real, though. Depending on your use case, these addresses may still be valid. For example, if you’re trying to mass-mail something to addresses that are non-postal, they are probably not valid. But if you’re a real-estate developer they may be valid for your purposes.

Typically, to validate non-postal addresses, you’ll need a special validation service. Smarty has an Enhanced match validation tool that handles these like a dream.

Watch the full recording

If you’d like to view the full 36 minute webinar, feel free!

Subscribe to our blog!
Learn more about RSS feeds here.
rss feed icon
Subscribe Now
Read our recent posts
Improving user/customer experience in every industry with clean address data
Arrow Icon
You finally track down an essential addition to your collector’s set of [insert item of your choice], and you're hyped to buy it until the chaos begins. The cart is hidden in a fly-out on the side, cluttered with blocky, overwhelming text. You spend way too long just trying to find the "Proceed to Checkout" button. 👎 That’s bad UI (user interface): messy, confusing design that makes navigation a chore. You make it to the checkout and start entering your info, but the site keeps rejecting your address.
Dashboard essentials for Smarty users
Arrow Icon
The Smarty dashboard is your central hub for managing address verification, geocoding, and property data services. Whether you're just starting or looking to optimize your current setup, understanding the dashboard's full capabilities can significantly streamline your address data operations. We recently held a webinar in which we reviewed all of the Smarty dashboard's items and features. Missed it? That's OK; we've got all the information right here. You can expect to read about:Accessing your dashboardSetting up your account for successUnderstanding your active subscriptionsManaging API keys effectivelyStreamlining billing and financial managementStaying informed with smart notificationsTeam management and access controlsWeb toolsMaking the most of free trialsKey takeawaysLet’s get going!Accessing your dashboardGetting to your dashboard is straightforward.
Take charge of your API usage with Smarty’s key management features
Arrow Icon
Ever wondered, “Where did all my lookups go?!” Without proper API management, you may burn through your lookups quicker, experience runaway code, and encounter unexpected usage. That’s why Smarty created usage by key (included in all annual plans) and limit by key (included in some plans; you can add them by contacting sales) for its APIs. Why key management mattersCommon API usage challenges (problems to solve):Unexpected spikes in lookupsDifficulty tracking specific key usageWhich keys are calling which Smarty licenseNeed for better control over API consumptionDifficulty allocating Smarty lookups across an organizationWith Smarty's key management features, you gain more control by having better visibility of your usage, eliminating the element of surprise (you know, the bad kind, like when you’re suddenly out of lookups).

Ready to get started?