Address validation, not just for Australia Posts benefit!

Hi , and welcome to an ongoing series of articles relating to Data Management tips, tricks, discussions, and best practices. We’ll make sure that the articles are of a size that you can easily digest, within 2 minutes or less, yet still provide you enough fulfilment so you don’t walk away feeling empty. These articles are written by Benjamin Jones, who is a dynamic and leading edge thinker, within the Data Management industry.

Address validation plays a number of roles in the business, foremost ensuring AMAS compliance. Secondary to this, yet equally as important, is its role in effective data management. Through the use of 3rd Party address tools, we can “batch” process our databases offline and ensure a more effective and comprehensive approach is given to our data management, without any need for human interaction. These fully automated processes are easily integrated into existing database systems, and provide a wealth of additional information and surety.
Address validation;

  • allows us to standardise our data.
  • ensures all possible address points have a DPID.
  • provides conformity to AMAS standards.
  • provides a “leg up” to our de-duplication methods.
  • allows us to export the data with multiple address elements.

When we think of address validation, we usually think of an activity that will save money, when sending out direct mail, or a process that keeps the address data in our systems “clean”. We do this, to ensure that we can append a DPID to as many records as possible, which in turn allows us to apply a barcode to the data, and ultimately save money on Direct Mail.
Once you have your address data validated and normalised, the job of actually managing your data becomes a great deal easier. For a number of cases, you’ll be able to de-dupe directly on this data using basic SQL statements. You’ll be able to match this data to existing data sets, or new data sets as they come into the environment. And when it comes to any type of Migration work, then the old adage of “Rubbish in, Rubbish out”, really hits home.
So as you’ve seen, all this highlights the opportunities of becoming a fully integrated and automated component of your day-to-day data management practices. It’s something that every business should explore, as the benefits to ensuring compliance within your databases are easily measurable.