Harmonize data
The data in Mix Modeler is of different nature depending on the source of data. The data can be:
- aggregate or summary data, for example collected from walled garden data sources or offline advertising data gathered (like spend) from running a billboard campaign, an event, or a physical ad campaign,
- event data, for example from first party data sources. This event data can be data collected through the Adobe Analytics source connector from Adobe Analytics, or through the Experience Platform Web or Mobile SDK or Edge Network API, or data ingested using source connectors.
The harmonization service of Mix Modeler assimilates the aggregate and event data into a consistent data view. This data view, combined with internal and external factors data, is the source for the models in Mix Modeler.
An example of harmonized data
Imagine you have the following datasets available for Mix Modeler.
Dataset 1
Contains marketing effort dataset from YouTube, with a granularity of the aggregate data set to daily.
Dataset 2
Contains marketing effort dataset from Facebook, with a granularity of the aggregate data set to weekly.
Dataset 3
A conversion dataset, with a granularity of the aggregate data set to daily.
Dataset 4
A sample experience event dataset (Web SDK events) from the customer.
You want to build a harmonized dataset, with a granularity set to weekly. The event data is aggregated to week granularity and added to the harmonized dataset. The result is:
Harmonized dataset
Setup harmonized data
To build a harmonized dataset, like in the simplified example, you must follow these steps:
- Define additional harmonized fields that you want to use beyond the global harmonized fields already available.
- Set up dataset rules to map fields from your aggregate or experience event datasets to harmonized fields.
- Define marketing touchpoints using the standard and additional harmonized fields that you defined.
- Define conversions using the standard and additional harmonized fields that you defined.
View harmonized data
To see your harmonized data, in the Mix Modeler interface:
-
Select Harmonized datasets from the left rail.
-
Select Harmonized Data from the top bar. You see a recap of your harmonized data based on the fields, dataset rules, marketing touchpoints and conversions you have defined.
-
To redefine the period on which the recap of harmonized data is based, enter a date range for Date range or use to select a data range.
-
To modify the harmonized field columns displayed for the Harmonized data table, use to open the Column settings dialog.
-
Select one or more columns from AVAILABLE COLUMNS and use to add these columns to SELECTED COLUMNS.
-
Select one or more columns from SELECTED COLUMNS and use to remove the selected columns and return these columns back to AVAILABLE COLUMNS.
-
Select a column from DEFAULT SORT and toggle between Ascending or Descending.
-
To change the order of columns displayed, you can move a column in SELECTED COLUMNS up and down through drag and drop .
-
-
Select Submit to submit your column setting changes. Select Close to cancel any changes you made.
-
-
If more pages are available, use or at Page x of x to move between pages.