Import Data: Unclean data from your systems is imported into our cleansing system. Typically provided by yourselves in an Excel, CSV, or Tab-Separated Text file format.
Merge Data Sets: Data from multiple differently formatted sources (eg excel, csv, sql, sap, salesforce etc) is converted and merged into a common database.
Rebuild Missing Data: Wherever possible, missing information is recreated (e.g. Post codes, states, country, phone area codes, gender, web address from email addresses etc.).
Standardise Data: Data is combined, separated or modified to ensure that the same type of data exists in each column. This step ensures that your contact’s first name, last name, email address, mobile phone number etc. are all in their respective columns.
Normalise Data: Similar data is normalised (e.g. mister, Mr., mr are all converted to Mr. Or street, st., strt. are all converted to St.). Telephone numbers are converted to their standard Telstra format, or otherwise as advised by yourselves. Email and web addresses formats are also checked, where provided, and reformatted as necessary.
De-Duplicate data: We use a custom-built fuzzy-matching algorithm to identify potential duplicates. Our methodology provides high accuracy matches with a tolerance for misspelling, missing values or different address orders. For mission critical data, these results are manually reviewed (by either ourselves or our client) and the database updated accordingly.
Verify & Enrich Data: Data is validated by voice to voice communication with the lead themselves. We call every lead on the database and verify the details which you need to ensure that your data is up to date.
Export Data: Data can be exported in numerous formats for example, excel, csv, SQL database, XML, tiff, PDF, or as required. Typically, we return it in the same layout and format that we receive it.