Herbert Smith Freehills

Herbert Smith Freehills logo

DCA provided a major database cleanse, by way of creating tailored data cleansing
algorithims that not only optimised the data files but also generated a report outlining the percentage of valid data and percentage of data requiring the cleanse process. This report allowed us to internally communicate the quality of the data precleanse to validate the work continually undertaken across the firm on maintaining contact details, but also provided us with statistics to demonstrate the value the external process added to our data integrity strategy.

We see this process as an ongoing partnership where annually DCA will provide a data cleanse to complement internal initiatives.

Client Relationship Database Manager, Herbert Smith Freehills

Client Industry

Herbert Smith Freehills is an Australia-based international law firm providing innovative, commercial legal advice to clients around the world. It has the resources and expertise of around 1000 lawyers, including more than 200 partners across offices in Australia and South-East Asia.

Client Requirement

Herbert Smith Freehills uses InterAction, an internal Customer Relationship Management (CRM) database, to house and manage approximately 140,000 company personal contact records linked to approximately 30,000 company records. This database was implemented well over 10 years ago and, despite extensive internal maintenance of the data, a more comprehensive data cleanse was required.

DCA’s Solution

DCA and Herbert Smith Freehills had extensive consultations to determine what was required, deciding that DCA’s data cleansing services were needed to enhance data quality and identify relationships within the database. DCA tailored data-cleansing algorithms to accommodate the specific legal nature of the data and its structures (exported from InterAction software). The cleansing algorithms were an amalgamation of DCA’s current standard cleansing routines and were set up in DCA’s internal software, allowing them to be used again for repeat jobs at a lower price

On completion of the data cleanse, de-dupe, consolidation and enhancement, DCA supplied cleansed and enhanced output files, as well as detailed data reports, to Herbert Smith Freehills.

Customer Benefits

‘Keeping clients’ contact data up-to-date is a time-consuming daily task. However, it is vital in order to maintain a single view of the customer and ensure this valued data source is appropriately utilised.

At Herbert Smith Freehills, we have extensive in-house data maintenance strategies and processes, but certain data corruption issues are difficult to identify, particularly on systems of this size. For example, DCA were able to identify potentially duplicated records based on criteria we supplied. To do the same work internally would have required days of trawling through rows of data.

The benefits gained by reducing the number of errors in contact data on a database cannot be underestimated – accurate mailing and event lists, greater respect for database content, clearer knowledge of where contacts have moved – all of which contribute to increasing the value of the database for supporting your client initiatives.

DCA were also able to compare company locations listed on our database against the addresses recognised by Australia Post to verify and clean up incorrect mailing details: invaluable for targeted distributions.

The major data cleanse DCA provided produced cleaned data files as well as a report outlining the percentage of valid data and of data requiring cleaning. This report allowed us to communicate internally the quality of the data pre-cleanse to validate the work continually undertaken across the firm on maintaining contact details, as well as providing statistics to demonstrate the value the external process added to our data integrity strategy.

DCA were also able to compare company locations listed on our database against Australia Post recognised addresses to verify and clean up incorrect mailing details, invaluable to targeted distributions.

The major data cleanse provided by DCA produced cleaned data files but also a report outlining the percentage of valid data and percentage of data requiring their cleanse process. This report allowed us to internally communicate the quality of the data pre-cleanse to validate the work continually undertaken across the firm on maintaining contact details, but also provided us with statistics to demonstrate the value the external process added to our data integrity strategy.

Download Case Study

Services:
Consolidation, Data Cleanse, De-dupe
Industry:
Prof. Services
Back to Client Stories
Call Now Enquiry

Start your data-driven journey today

  • This field is for validation purposes and should be left unchanged.