Clean Your Data!

Transform your data to keep one unified structure, no matter how many different names you have for the same insight across your different systems. Adnuntius Data’s mapping feature lets you connect all your data sources and ensure that all information is stored with a unified structure.

Why Mapping?

“Crap in, crap out” is very true when it comes to data, so keep yours clean. But let’s get specific and do an example: Let’s say you’re a media agency working with an company that has multiple systems collecting user data. This is not unusual, as many organizations have managed to grow quickly by letting business units make their own choices in technology they employ for different tasks (or, organizations are a result of acquisitions). But when time comes to create a centralized data strategy, project managers meet a chaos of data that is difficult to unify. How are you going to harness all this data in for instance targeted advertising if there is no structure? 

Let’s take one easy and simple data point; gender. Business unit 1 may use a software collecting “males” and “females” under the field “gender”. However, another business unit using another system might use a system using the field “sex”, and the values “M” and “F”. Now imagine 10 different systems with hundreds of fields and not just two possible values, but multiple. Sound like a fun project?

M for Male

The Adnuntius mapping feature lets you translate, transform and unify data on the way from sending it from your page to storing it in Adnuntius Data.

Back to our small example of gender: in the example above I am creating a mapping between “gender” and “sex” so that no matter the name it is stored under, all fields are stored as “gender”. If you have even more variations, then just create aliases.

Furthermore I want to ensure that if “M” or “F” are sent as values, I want them to be stored as “Male” and “Female”. No problem; I just create these transformations and then the system will translate everything to the right values on the way in. 

Now do this for any field and value sent to Adnuntius Data, and you will have ensured that every data point about every user follows a unified language, no matter how many systems are used. And if you charged with the task of creating a centralized data strategy, you may have recognized another benefit by now: you no longer have to force each business unit to conform to one unified language – you can allow them to continue as-is, as you will reach your goal either way.

Don’t Be a Stranger

Want to know more? Contact Stian at stian@adnuntius.com any time and we’ll give you a tour.