MCDM schema objects
MCDM schema consists of different objects that help you structure provided data.
MCDM object |
Description |
Database representation |
Example |
MCDM Category |
A collection of MCDM tables for a particular business use case. Tables may belong to various categories if their fields apply to multiple use cases. |
Group of tables |
Paid ads - Wide range of Advertising platforms, all providing information about daily campaign performance down to adset, ad level, creative, or placement level. |
MCDM Table |
A data table that offers data for a business use case on a particular granularity level. Different MCDM tables will offer a higher or lower granularity. |
Single table |
Basic Performance - contains Campaign, Adset and Ad data for different data connectors. |
MCDM Field |
The different fields that build MCDM table. The fields are a result of combining and standardizing fields from several individual data connectors. |
Table column |
Impressions - the total impressions from several data connectors. |
MCDM Mapping dictionary
The mapping is the core logic of data unification provided within MCDM. It defines how a field from each data source is "translated" into a common model. MCDM Mapping Dictionary is a live documentation that explains how each field of each data source is being converted into MCDM value.
Field name |
Description |
Example 1 |
Example 2 |
Data source |
name of the data source used for mapping |
MediaMath |
TikTok Ads |
report_type |
name of the report type used for mapping |
strategies_device |
ads_region |
original_field |
name of the “raw data” field used for mapping |
total_spend |
cost |
mcdm_table |
name of the unified MCDM table |
paid_ads__geo_performance |
paid_ads__geo_performance |
mcdm_field |
name of the unified MCDM field |
spend |
spend |
mcdm_field_type |
type of the unified MCDM field |
float |
float |