Skip to main content

Navigating the complexities of managing global address data

The U.S. Postal Service (USPS) delivers mail to almost 167 million addresses in the United States, and anyone who has tried to order something online has likely had the experience of not getting a package delivered on time (or at all) because the address was entered incorrectly or in a weird format, causing shipping delays.

The USPS has a standard format it accepts, but it’s not standard around the world. Internationally there are over 200 different address formats used and more than 20 language scripts used to write those addresses. 

Given the complexity of considering all of these different global formats, using a verification service like Melissa’s Global Address service can help ensure that all addresses are properly formatted based on where they need to go, which improves deliverability.

John DeMatteo, solutions engineer I at Melissa, explained in a recent SD Times microwebinar that “fewer errors and returns equals more time to be working on other things, as well as less money spent on returned packages,” he said. 

Melissa’s Global Address service takes in addresses and returns them as validated, enriched, and standardized addresses for more than 250 countries and territories. According to DeMatteo, validated means an address was confirmed through official sources as being accurate and deliverable; enriched means the address was appended with additional data not present in the original request; and standardized means an address is output in the preferred format.

During the microwebinar, DeMatteo gave a demo of Melissa’s Global Address service with the following input address:

FF: 10 Dziadoszaska, Pozna, 61-248, PL

Global Address identifies this as being an address in Poland and reformats it in that country’s preferred address format, and also adds diacritics, which are the symbols that appear over certain letters in the Polish alphabet (ex. ć, Å„, ó, Å›, ź).

AddressLine1: ul. Dziadoszańska 10
AddressLine2: 61-248 Poznań

The addresses can also be transliterated to Native, Latin, or the Input script. According to DeMatteo, the difference between transliteration and translation is that transliteration converts character by character whereas translation converts whole words.  

To show transliteration in action, another example he shared during the microwebinar is an input written in Kanji — a set of characters used in Japanese writing — that was requested to be output into Latin script. “This is a lot more readable for me if I’m a data steward or someone working with the data,” he said. 

When it comes to making the most out of Global Address, like with any data verification process, “the better the data we have for the input, the better data we have for the output,” DeMatteo said. Therefore, there are a couple of best practices that he recommends following when working with Global Address.

While Global Address is good at detecting the country from the input, he says that when possible, the country code and name should be included with every record. He also recommends sending in multiple addresses at once for batch processing, which can improve speed and efficiency. And finally, customers should avoid including extraneous information not related to the address. 

Global Address can be used on its own, or better yet, in combination with Melissa’s other verification services including Global Name, Global Email, and Global Phone

“The Global Suite works together to provide a comprehensive Validation, Enrichment, and Standardization solution for the big four data types,” he said. “Used together, customers can ensure their data is of the highest quality possible.”

The post Navigating the complexities of managing global address data appeared first on SD Times.



from SD Times https://ift.tt/RKJbe8o

Comments

Popular posts from this blog

A guide to data integration tools

CData Software is a leader in data access and connectivity solutions. It specializes in the development of data drivers and data access technologies for real-time access to online or on-premise applications, databases and web APIs. The company is focused on bringing data connectivity capabilities natively into tools organizations already use. It also features ETL/ELT solutions, enterprise connectors, and data visualization. Matillion ’s data transformation software empowers customers to extract data from a wide number of sources, load it into their chosen cloud data warehouse (CDW) and transform that data from its siloed source state, into analytics-ready insights – prepared for advanced analytics, machine learning, and artificial intelligence use cases. Only Matillion is purpose-built for Snowflake, Amazon Redshift, Google BigQuery, and Microsoft Azure, enabling businesses to achieve new levels of simplicity, speed, scale, and savings. Trusted by companies of all sizes to meet...

2022: The year of hybrid work

Remote work was once considered a luxury to many, but in 2020, it became a necessity for a large portion of the workforce, as the scary and unknown COVID-19 virus sickened and even took the lives of so many people around the world.  Some workers were able to thrive in a remote setting, while others felt isolated and struggled to keep up a balance between their work and home lives. Last year saw the availability of life-saving vaccines, so companies were able to start having the conversation about what to do next. Should they keep everyone remote? Should they go back to working in the office full time? Or should they do something in between? Enter hybrid work, which offers a mix of the two. A Fall 2021 study conducted by Google revealed that over 75% of survey respondents expect hybrid work to become a standard practice within their organization within the next three years.  Thus, two years after the world abruptly shifted to widespread adoption of remote work, we are dec...

10 Simple Image Slider HTML CSS JavaScript Examples Neeraj Mishra The Crazy Programmer

Slider is a very important part of any website or web project. Here are some simple image slider examples that I handpicked from various sites. These are built by different developers using basic HTML, CSS, and JavaScript. Some are manual while others have auto-slide functionality. You can find the source code for each by clicking on the code button or on the image. 1. Very Simple Slider Demo + Code 2. Popout Slider Demo + Code 3. Really Simple Slider Demo + Code 4. Jquery Simple Slider Demo + Code 5. Manual Slideshow Demo + Code 6. Slideshow Indicators Demo + Code 7. Simple Responsive Fullscreen Slider Demo + Code 8. Responsive Image Slider Demo + Code 9. Simple Image Slider Demo + Code 10. Slicebox – 3D Image Slider Demo + Code I hope these simple image sliders are helpful for you. For any queries, you can ask in the comment section below. The post 10 Simple Image Slider HTML CSS JavaScript Examples appeared first on The Crazy Prog...