Working across multiple regions, platforms, formats and fields, you want to comprehend your marketing performance across all these planes to enable smarter decisions.
But you realise that even if you try to coagulate the scattered data through straightforward API connections, you cannot enable the process of data integration. This is because all your data is stacked up in different pockets restricting disparate file formats, naming conventions and data fields to fit in to one cohesive data set. To add to your woes, marketing being a team sport, all the team members may or may not be using the same technology or the terminology.
Have you heard of Datorama’s useful series of features that help in data integration and data governance?
They facilitate data harmonization which is intrinsic in connecting all the marketing data into a seamless set ready for analysis and representation through marketing dashboards. Data is standardized further giving you the power to analyze with additional dimensions that didn’t exist in the initial data sets.
How does Datorama handle data harmonization?
Handling Campaign Management through different unrelated sources, requires data from these various sources to be standardized and be able to talk to each other. Datorama feeds in data from immense data sources through FTP, email scheduling or APIs and establishes harmony.
Below are the applicable data harmonization methods that your data can rely on within Datorama through marketing dashboards.
It is a relationship between two similar types of connected data streams and the connection is based on the main entity key common to both the streams
This method of data harmonization integrates measurements and dimensions from both streams, connecting them yet letting them be processed independently.
Two data streams get fused through one common entity attribute through Data Fusion. It is the link between two dimensions from either data sources where fusion once applied works for all respective fields of the connected streams.
Once set up, each of the two dimensions to which the fusion is applied can be viewed with measurements related to the other dimension.
VLOOKUP in Datorama is like VLOOKUP in excel where one dimension in a data stream is harmonized with the other dimension in another data stream within the workspace.
The dimension to search is not restricted only to one data stream but can pan all data streams within the workspace level.
It follows the syntax: VLookup
Cross Channel Entity (Custom Classification 1)
Another method of data harmonization where the only source of connection among two or more data streams is cross channel entities, (a universal attribute present in all data streams).
To connect these data streams, the dimension should be mapped to ‘Custom Classification 1’ within the data stream mapping thus creating this common entity as the bridge to fill in differences among them.
For E.g. Data Stream A has field A mapped to Custom Classification 1, similarly Data Stream B has field B mapped to Custom Classification 1.
So, field A is indirectly linked to field B without affecting the data streams and the mappings within.
Being stuck with disparate data is counterintuitive to modern marketing and data governance. Datorama empowers data harmonization with marketing-friendly data integrations (ETL), a centralized data model and machine learning-powered harmonization.
Find out more about our Datorama solutions here or feel free to contact us at anytime and we will be glad to assist.