Out-of-the-box transformation and enrichments
Data transformation and enrichment is the process that helps transform your disparate data with inconsistent formatting into a restructured, consistent database from which you can draw valuable insights.
With market-leading data transformation capabilities and advanced ‘out-of-the-box’ data enrichments, you can achieve data consistency, such as currency conversion, language translation, and location unification.
Smart Naming Conventions
Smart Naming Conventions help with data consistency by enforcing consistent naming conventions in your data.
It’s possibly best to illustrate the power of this functionality with an example - so let’s assume that, as part of your data governance strategy, you’ve agreed that the naming conventions of all your marketing campaigns should adhere to the following format:
- Country Code | Year | Product Name | Category| Manufacturer
So a list of campaign names might look like:
- UK | 2022 | Wicker table and chair set | Outdoor furniture | Garden Delights
- UK | 2022 | Marble dining table and chairs | Dining furniture | Dining Solutions
- FR | 2022 | Wicker table and chair set | Outdoor furniture | Succès du Jardin
- US | 2023 | Nature's Serenity Table and Chair Set| Outdoor furniture | ABC Gardens
Smart Naming Conventions will split the data by the agreed delimiter (in this example the pipe) and ensure that each variable in the campaign name matches the criteria that have been set in your agreed format.
Imagine there’s a new marketing team member who sets up a campaign in the following format:
- 2023 | UK | Outdoor Furniture | Rattan garden set | ABC Gardens
When breaking this campaign name into separate values by the pipe delimiter, Smart Naming Conventions would identify that the first value is not a country code and the second value is not a year - and either alert you to the inconsistency or withhold the upload until the error is fixed.
Match and Map
Another feature that can help you save time and help improve the consistency of both your data and your analysis is "Match and Map".
Explained simply, this enables you to find specific values in the data you extract and create new values based on criteria that you set.
Let’s illustrate with the same campaign names we used earlier:
- UK | 2022 | Wicker table and chair set | Outdoor furniture | Garden Delights
- UK | 2022 | Marble dining table and chairs | Dining furniture | Dining Solutions
- FR | 2022 | Wicker table and chair set | Outdoor furniture | Succès du Jardin
- US | 2023 | Nature's Serenity Table and Chair Set| Outdoor furniture | ABC Gardens
Marketing teams might want to be able to compare the performance metrics of European and North American campaigns.
This could be done manually by users at the analysis stage, by adding a filter by a selection of country codes.
But inconsistencies can creep in this way. For example, does the business define the UK as within Europe or not for purposes of reporting? What if one country code is missed in the filtering process?
With Match and Map, the business can set rules so that if the country codes match UK, FR, DE, or ES, the value of "Europe" is mapped to a new field. If the country codes match US and CA the value mapped is "North America".
This means there is no confusion or inconsistencies in the way that data is analyzed when it comes to campaign optimizations.
Activity Monitor
Although not specifically focused on data consistency, an Activity Monitor helps with the ongoing quality control of your data.
This feature provides an overview of all your data collection and data transfer tasks, helping you identify any errors and delays, so you can proactively fix any issues that may impact data quality.
Ready to improve the quality and consistency of your data?
High-quality and consistent data is essential if you’re going to make accurate and effective business decisions.
If you’re still operating with manual data integration or ineffective ETL solutions, or don’t have the technology to help you proactively address data quality issues - it’s all too easy for inconsistencies to affect your data, which can undermine confidence in your database and lead to incorrect decision making.
Adverity can help ensure the quality, accuracy, and consistency of your data through a full suite of data transformation and data governance features.