Column | Description | Dimensions / Metrics | Platform UI Name Mapping | Platform Mapping |
---|
id | The Internal Alli Id of the Record | N/A
| N/A
| N/A
|
source | The Source Table of Row | N/A
| N/A
| N/A
|
date | The Date of Performance Data | Dimensions |
CODE
{
'dv360': 'Date',
'google ads': 'Date',
'the trade desk': 'date',
'yahoo dsp': 'Date'
}
|
CODE
{
'dv360': 'filter_date',
'google ads': 'date',
'the trade desk': 'date',
'yahoo dsp': 'day',
'facebook ads': 'date'
}
|
platform | The Platform the Campaign belongs to. (Hard Coded) | Dimensions | N/A
|
CODE
{
'dv360': 'DV360',
'google ads': 'Google Ads',
'the trade desk': 'The Trade Desk',
'yahoo dsp': 'Yahoo DSP',
'facebook ads': 'Facebook Ads'
}
|
publisher_platform | The Publisher Platform on where the Campaign Delivered Ads
For Twitter Ads, there are Datasources that pull data from Ads on Twitter and the Twitter Audience Network which is hardcoded into this column.
| Dimensions |
CODE
{
'dv360': 'N/A',
'google ads': 'Networks',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'dv360': 'N/A',
'google ads': 'ad_network_type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A'
}
|
account_id | The Ad Account Identifier | Dimensions |
CODE
{
'dv360': 'Advertiser ID',
'google ads': 'Account ID',
'the trade desk': 'Advertiser ID',
'yahoo dsp': 'Advertiser ID'
}
|
CODE
{
'dv360': 'filter_advertiser',
'google ads': 'customer_id',
'the trade desk': 'advertiser_id',
'yahoo dsp': 'advertiser_id',
'facebook ads': 'account_id'
}
|
account_name | The Ad Account Name | Dimensions |
CODE
{
'dv360': 'Advertiser',
'google ads': 'Account',
'the trade desk': 'Advertiser',
'yahoo dsp': 'Advertiser Name'
}
|
CODE
{
'dv360': 'filter_advertiser_name',
'google ads': 'customer_name',
'the trade desk': 'advertiser_name',
'yahoo dsp': 'advertiser_name',
'facebook ads': 'account_name'
}
|
campaign_id | The Campaign Identifier | Dimensions |
CODE
{
'dv360': 'Insertion Order ID',
'google ads': 'Campaign ID',
'the trade desk': 'Campaign ID',
'yahoo dsp': 'Campaign ID'
}
|
CODE
{
'dv360': 'filter_insertion_order',
'google ads': 'campaign_id',
'the trade desk': 'campaign_id',
'yahoo dsp': 'campaign_id',
'facebook ads': 'campaign_id'
}
|
campaign_name | The Campaign Name | Dimensions |
CODE
{
'dv360': 'Insertion Order',
'google ads': 'Campaign',
'the trade desk': 'Campaign',
'yahoo dsp': 'Campaign Name'
}
|
CODE
{
'dv360': 'filter_insertion_name',
'google ads': 'campaign_name',,
'the trade desk': 'campaign',
'yahoo dsp': 'campaign_name',
'facebook ads': 'campaign_name'
}
|
campaign_status | The Current Campaign Status | Dimensions |
CODE
{
'dv360': 'N/A',
'google ads': 'Campaign status',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'dv360': 'N/A',
'google ads': 'campaign_status',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'campaign_status'
}
|
campaign_type | The Campaign Type | Dimensions |
CODE
{
'dv360': 'N/A',
'google ads': 'Campaign type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'dv360': 'N/A',
'google ads': 'campaign_advertising_channel_type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A'
}
|
campaign_objective | The Objective of the Campaign | Dimensions |
CODE
{
'dv360': 'N/A',
'google ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'dv360': 'N/A',
'google ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A'
}
|
campaign_daily_budget | The Daily Budget of the Campaign | Metrics |
CODE
{
'dv360': 'N/A',
'google ads': 'Budget',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'dv360': 'N/A',
'google ads': 'campaign_budget_amount',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A'
}
|
campaign_start_date | The Campaign Start Date | Dimensions |
CODE
{
'dv360': 'N/A',
'google ads': 'Campaign start date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'dv360': 'N/A',
'google ads': 'campaign_start_date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A'
}
|
campaign_end_date | The Campaign End Date | Dimensions |
CODE
{
'dv360': 'N/A',
'google ads': 'Campaign end date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'dv360': 'N/A',
'google ads': 'campaign_end_date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A'
}
|
country_name | The Country Name | Dimensions |
CODE
{
'dv360': 'Country',
'google ads': 'Location',
'the trade desk': 'Country',
'yahoo dsp': 'N/A'
}
|
CODE
{
'dv360': 'filter_country',
'google ads': 'geo_target_constant_name',
'the trade desk': 'country',
'yahoo dsp': 'country',
'facebook ads': 'country'
}
|
region_name | The Region Name | Dimensions |
CODE
{
'dv360': 'Region',
'google ads': 'Location',
'the trade desk': 'Region',
'yahoo dsp': 'N/A'
}
|
CODE
{
'dv360': 'filter_region_name',
'google ads': 'geo_target_constant_name',
'the trade desk': 'region',
'yahoo dsp': 'region',
'facebook ads': 'region'
}
|
city_name | The City Name | Dimensions |
CODE
{
'dv360': 'City',
'google ads': 'Location',
'the trade desk': 'City',
'yahoo dsp': 'N/A'
}
|
CODE
{
'dv360': 'filter_city_name',
'google ads': 'geo_target_constant_name',
'the trade desk': 'city',
'yahoo dsp': 'city',
'facebook ads': 'N/A'
}
|
channel | The Default Alli Data Library Channel (Hard Coded Value)
| Dimensions | N/A
|
CODE
{
'dv360': 'DISPLAY',
'google ads': 'SEARCH',
'the trade desk': 'DISPLAY',
'yahoo dsp': 'DISPLAY',
'facebook ads': 'SOCIAL'
}
|
cost | Costs (Ad Spend) | Metrics |
CODE
{
'dv360': 'Revenue (Advertiser Currency)',
'google ads': 'Cost',
'the trade desk': 'Advertiser Cost (USD)',
'yahoo dsp': 'Cost'
}
|
CODE
{
'dv360': 'metric_revenue_advertiser',
'google ads': 'cost',
'the trade desk': 'advertiser_cost_usd',
'yahoo dsp': 'cost',
'facebook ads': 'spend'
}
|
profit | Profit that the Inventory can Make | Metrics |
CODE
{
'dv360': 'Profit (Advertiser Currency)',
'google ads': 'N/A',
'the trade desk': 'Profit (USD)',
'yahoo dsp': 'N/A'
}
|
CODE
{
'dv360': 'metric_profit_advertiser',
'google ads': 'N/A',
'the trade desk': 'profit_usd',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A'
}
|
impressions | Impressions | Metrics |
CODE
{
'dv360': 'Impressions',
'google ads': 'Impr.',
'the trade desk': 'Impressions',
'yahoo dsp': 'impressions'
}
|
CODE
{
'dv360': 'metric_impressions',
'google ads': 'impressions',
'the trade desk': 'impressions',
'yahoo dsp': 'impressions',
'facebook ads': 'impressions'
}
|
clicks | Clicks | Metrics |
CODE
{
'dv360': 'Clicks',
'google ads': 'clicks',
'the trade desk': 'clicks',
'yahoo dsp': 'clicks'
}
|
CODE
{
'dv360': 'metric_clicks',
'google ads': 'clicks',
'the trade desk': 'clicks',
'yahoo dsp': 'clicks',
'facebook ads': 'clicks'
}
|
total_conversions | The Total Number of Conversions | Metrics |
CODE
{
'dv360': 'N/A',
'google ads': 'All conv.',
'the trade desk': 'Total Click + View Conversions 01',
'yahoo dsp': 'Conversions'
}
|
CODE
{
'dv360': 'metric_last_clicks + metric_last_impressions',
'google ads': 'all_conversions',
'the trade desk': 'total_click_view_conversions_01',
'yahoo dsp': 'conversions',
'facebook ads': 'actions'
}
|
total_conversions_value | The Value associated with the Total Number of Conversions | Metrics |
CODE
{
'dv360': 'N/A',
'google ads': 'All conv. value',
'the trade desk': 'Total Click + View Conversion Revenue 01',
'yahoo dsp': 'Conversions Value',
'facebook ads': 'N/A'
}
|
CODE
{
'dv360': 'metric_cm360_post_click_revenue + metric_cm360_post_view_revenue',
'google ads': 'all_conversions_value',
'the trade desk': 'total_click_view_conversion_revenue_01',
'yahoo dsp': 'conversions_value',
'facebook ads': 'N/A'
}
|
click_through_conversions | The Number of Click Through Conversions | Metrics |
CODE
{
'dv360': 'TBD',
'google ads': 'N/A',
'the trade desk': 'Click Conversion 01',
'yahoo dsp': 'Click Through Conversions'
}
|
CODE
{
'dv360': 'metric_last_clicks',
'google ads': 'N/A',
'the trade desk': 'click_conversion_01',
'yahoo dsp': 'click_through_conversions',
'facebook ads': 'N/A'
}
|
click_through_conversions_value | The Value associated with the Click Through Conversions | Metrics |
CODE
{
'dv360': 'TBD',
'google ads': 'N/A',
'the trade desk': 'Click Conversion Revenue 01',
'yahoo dsp': 'N/A'
}
|
CODE
{
'dv360': 'metric_cm_post_click_revenue',
'google ads': 'N/A',
'the trade desk': 'click_conversion_revenue_01',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A'
}
|
view_through_conversions | The Number of View Through Conversions | Metrics |
CODE
{
'dv360': 'TBD',
'google ads': 'View-through conv.',
'the trade desk': 'View Through Conversion 01',
'yahoo dsp': 'View Through Conversion'
}
|
CODE
{
'dv360': 'metric_last_impressions',
'google ads': 'view_through_conversions',
'the trade desk': 'view_through_conversion_01',
'yahoo dsp': 'view_through_conversions',
'facebook ads': 'N/A'
}
|
view_through_conversions_value | The Value associated with the View Through Conversions | Metrics |
CODE
{
'dv360': 'TBD',
'google ads': 'N/A',
'the trade desk': 'View Through Conversion Revenue 01',
'yahoo dsp': 'N/A'
}
|
CODE
{
'dv360': 'metric_cm_post_view_revenue',
'google ads': 'N/A',
'the trade desk': 'view_through_conversion_revenue_01',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A'
}
|