SMEs: Address matching and cleansing

Address matching and cleansing

Poor, sub-standard address data costs – whether it’s due to delayed or undelivered goods, or wasted staff time caused by inefficient processes and manual verification.

Cleansing your data and keeping it clean minimises these inefficiencies while reaping significant time and revenue benefits.

The first step towards optimising your address data is to match and cleanse it against a data source that uses the British Standard BS7666, ie one of Ordnance Survey’s AddressBase products. The most suitable for most SMEs is AddressBase Core. This offers the same BS7666 standard addresses as the more complex AddressBase Premium, providing you with the Unique Property Reference Numbers (UPRNs) and geo coordinates. However, because it only provides current addresses, it is far simpler and therefore comes at a lower cost.

Tagging with UPRN & geo coordinates

Our address matching and cleansing solution, iMatch, matches against AddressBase Core, using the Unique Property Reference Numbers (UPRNs) to match and cleanse the data, and allocating the UPRNs to the addresses on your source dataset. The allocated geo coordinates also verify the addresses with pinpoint precision, unlike the ambiguity of postcodes, in addition to allowing any department’s data to be viewed spatially.

Its simple interface is easy to configure and effortless to use, showing the matching status of each record that’s processed.

Automated and interactive address matching

Our solution can facilitate both automated address matching, and interactive matching when a more manual approach is needed. You can tailor the automated address matching by choosing:

  • which fields from the source system to use against the relevant part of the AddressBase Core dataset
  • which phrases within an address to ignore, eg ‘Ltd’
  • which addresses to ignore during the matching process

This maximises achieving an automatic match and results in less time and effort spent in manual address matching. As it is rare that one set of matching criteria will cater for every address in your dataset, you can implement multiple matching runs against the data, each with its own set of matching requirements.

Manually matching residual data

With the remaining unmatched records, iMatch will show in-depth detail on potential matches so you can make an informed choice. This could include:

  • any parent or child properties (especially useful for blocks of flats)
  • its status, ie whether it’s in use
  • other properties in close proximity
  • a map showing the location (tailored to your preference, ie Google Maps, Open Street Maps or OS Maps).

You just choose the potential match and then accept, ignore, reject or log any issues found.  This enables complete control over the quality of data on an address by address basis.

Post-matching export

Once a match is complete, simply export the results of the match back to the source system for address cleansing. The match results will contain the UPRN from the match, the matched BS7666 address and the original address from the source system.

Integrated or stand alone

Our address matching and cleansing solution can be implemented as a standalone solution or can be integrated with our AddressBase Core customer address data management solution for ongoing data maintenance. As an integrated solution, the automation between solutions will provide greater efficiency, but either way, after matching and cleansing, you’ll be confident your address data is of the highest quality data.

On site or in the cloud

You can either subscribe to our matching and cleansing solution to manage on-site or we can host it in the cloud for you.

Address matching and cleansing infogram

Depending on your needs, you can either subscribe to the core product alone, the full suite for address cleansing and management, or anything in between.

Integration modules for address matching and cleansing:

now to find out how this can work for you.