Address validation plays a number of roles in business – the foremost of which is accessing Australia Post’s bulk mail discounts.
Secondary to this, yet equally as important, is its role in effective data management.
Through the use of the Rapid Addressing Tool (RAT) – and in particular the API extension you can purchase as an add on – you can “batch” process your databases offline to ensure a more effective and comprehensive approach is given to your 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.
Benefits of address validation include:
- standardisation of data
- ensuring all possible address points have a DPID
- conformity to Australia Post’s AMAS standards
- a “leg up” to de-duplication methods
- allowing export of the data with multiple address elements
So what is the DataTools Rapid Addressing Tool (RAT)?
The DataTools RAT has two distinct uses:
- Front end data entry driven address validation and key stroke reduction interface/tool, referred to as “Rapid Address Capture”. Used either through calling on the RAT automatically when you click into the address area in your database, or through using the standalone RAT application to enter the address and then transfer to your database via a script – this quickly and easily ensures you capture the correct, validated address at first contact.
- The ability to become a fully integrated and automated “batch” type process for backend database management. The API can be utilised to create a process where the database as a whole is “batched” up and run through the RAT to validate and cleanse the data in one pass.
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.
Our focus today will be on the added benefits of fully integrating and automating the RAT into any existing database. This provides a scenario that has the potential to reduce labour components within the day-to-day management of data and databases which in turn means that this resource can be diverted to more intense processes that still require human interaction.
Address validation utilising the RAT allows a data owner/manager to perform a number of tasks outside the scope of those already being used to manage data being sent to Australia Post. A key component of the RAT is its highly effective ability to parse the different address elements.
The advanced nature of the DataTools RAT parsing technology comes into its own for a number of reasons, the most prevalent being;
- You are able to fix address records which may not have been possible otherwise.
- You can better manipulate and store your data.
- And by ensuring that all addresses are in a “standard” format, your de-duping algorithms will have one less issue to deal with.
Once you have your address data validated and standardised, 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 the RAT in 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.
For more information please contact our Sales team on (02) 9687 4666.