Column | Description | Dimensions / Metrics / Categorization | 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
{
'amazon dsp': 'Date',
'dv360': 'Date',
'google ads': 'Date',
'the trade desk': 'Date',
'yahoo dsp': 'Date'
}
|
CODE
{
'amazon dsp': 'date',
'dv360': 'filter_date',
'google ads': 'date',
'the trade desk': 'date',
'yahoo dsp': 'day'
}
|
core_media_channel | The channel that the platform is a part of | Categorization | N/A
| N/A
|
platform | The Platform the Campaign belongs to. (Hard Coded) | Dimensions | N/A
|
CODE
{
'amazon dsp': 'Amazon DSP',
'dv360': 'DV360',
'google ads': 'Google Ads',
'the trade desk': 'The Trade Desk',
'yahoo dsp': 'Yahoo DSP'
}
|
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
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'Networks',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'ad_network_type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
account_id | The Ad Account Identifier | Dimensions |
CODE
{
'amazon dsp': 'Advertiser Id',
'dv360': 'Advertiser ID',
'google ads': 'Account ID',
'the trade desk': 'Advertiser ID',
'yahoo dsp': 'Advertiser ID'
}
|
CODE
{
'amazon dsp': 'advertiserid',
'dv360': 'filter_advertiser',
'google ads': 'customer_id',
'the trade desk': 'advertiser_id',
'yahoo dsp': 'advertiser_id'
}
|
account_name | The Ad Account Name | Dimensions |
CODE
{
'amazon dsp': 'Advertiser Name',
'dv360': 'Advertiser',
'google ads': 'Account',
'the trade desk': 'Advertiser',
'yahoo dsp': 'Advertiser Name'
}
|
CODE
{
'amazon dsp': 'advertisername',
'dv360': 'filter_advertiser_name',
'google ads': 'customer_name',
'the trade desk': 'advertiser_name',
'yahoo dsp': 'advertiser_name'
}
|
campaign_id | The Campaign Identifier | Dimensions |
CODE
{
'amazon dsp': 'Order ID',
'dv360': 'Insertion Order ID',
'google ads': 'Campaign ID',
'the trade desk': 'Campaign ID',
'yahoo dsp': 'Campaign ID'
}
|
CODE
{
'amazon dsp': 'orderid',
'dv360': 'filter_insertion_order',
'google ads': 'campaign_id',
'the trade desk': 'campaign_id',
'yahoo dsp': 'campaign_id'
}
|
campaign_name | The Campaign Name | Dimensions |
CODE
{
'amazon dsp': 'Order Name',
'dv360': 'Insertion Order',
'google ads': 'Campaign',
'the trade desk': 'Campaign',
'yahoo dsp': 'Campaign Name'
}
|
CODE
{
'amazon dsp': 'ordername',
'dv360': 'filter_insertion_name',
'google ads': 'campaign_name',,
'the trade desk': 'campaign',
'yahoo dsp': 'campaign_name'
}
|
campaign_status | The Current Campaign Status | Dimensions |
CODE
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'Campaign status',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'campaign_status',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
campaign_type | The Campaign Type | Dimensions |
CODE
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'Campaign type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'campaign_advertising_channel_type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
campaign_objective | The Objective of the Campaign | Dimensions |
CODE
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
campaign_daily_budget | The Daily Budget of the Campaign | Metrics |
CODE
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'Budget',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'campaign_budget_amount',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
campaign_start_date | The Campaign Start Date | Dimensions |
CODE
{
'amazon dsp': 'Order start date',
'dv360': 'N/A',
'google ads': 'Campaign start date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'amazon dsp': 'orderstartdate',
'dv360': 'N/A',
'google ads': 'campaign_start_date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
campaign_end_date | The Campaign End Date | Dimensions |
CODE
{
'amazon dsp': 'Order end date',
'dv360': 'N/A',
'google ads': 'Campaign end date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'amazon dsp': 'orderenddate',
'dv360': 'N/A',
'google ads': 'campaign_end_date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
adgroup_id | The Adgroup Identifier | Dimensions |
CODE
{
'amazon dsp': 'Line item ID',
'dv360': 'coalesce(Toutube Ad Group ID, Line Item ID)',
'google ads': 'Ad group ID',
'the trade desk': 'Ad Group ID',
'yahoo dsp': 'TBD'
}
|
CODE
{
'amazon dsp': 'lineitemid',
'dv360': 'coalesce(filter_trueview_ad_group_ad_id, filter_line_item)',
'google ads': 'ad_group_id',
'the trade desk': 'ad_group_id',
'yahoo dsp': 'line_id'
}
|
adgroup_name | The Adgroup Name | Dimensions |
CODE
{
'amazon dsp': 'Line item name',
'dv360': 'coalesce(Toutube Ad Group, Line Item)',
'google ads': 'Ad group',
'the trade desk': 'Ad Group',
'yahoo dsp': 'TBD'
}
|
CODE
{
'amazon dsp': 'lineitemname',
'dv360': 'coalesce(filter_trueview_ad_group, filter_line_item_name)',
'google ads': 'ad_group_name',
'the trade desk': 'ad_group',
'yahoo dsp': 'line_name'
}
|
adgroup_type | The Adgroup Type | Dimensions |
CODE
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'ad_group_type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
adgroup_status | The Current Adgroup Status | Dimensions |
CODE
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'Status (under Ad group tab)',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'ad_group_status',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
|
domain | URL of the Group Placement, for example, the Mobile Application in App Store, or a Youtube Channel URL | Dimensions |
CODE
{
'amazon dsp': 'Site name',
'dv360': 'App/URL',
'google ads': '',
'the trade desk': 'Site',
'yahoo dsp': ''
}
|
CODE
{
'amazon dsp': 'sitename',
'dv360': 'filter_app_url',
'google ads': 'detail_placement_view_group_placement_target_url',
'the trade desk': 'site',
'yahoo dsp': 'domain'
}
|
exchange | The Marketplace where Advertisers and Publishers to Buy and Sell Ad Space | Dimensions |
CODE
{
'amazon dsp': 'Supply source name',
'dv360': 'Exchange',
'google ads': 'N/A',
'the trade desk': 'Supply Vendor',
'yahoo dsp': 'N/A'
}
|
CODE
{
'amazon dsp': 'supplysourcename',
'dv360': 'filter_exchange',
'google ads': 'N/A',
'the trade desk': 'supply_vendor',
'yahoo dsp': 'N/A'
}
|
ad_format | The Format of the Ad | Categorization | N/A
| N/A
|
audience_strategy | The Strategy Towards the Audience | Categorization | N/A
| N/A
|
audience_type | The Type of the Audience | Categorization | N/A
| N/A
|
marketing_objective | The Objective of the Marketing Tactic | Categorization | N/A
| N/A
|
geo | The Geographic Info | Categorization | N/A
| N/A
|
query_type | Query Type | Categorization | N/A
| N/A
|
funnel | Marketing Funnel | Categorization | N/A
| N/A
|
channel | The Default Alli Data Library Channel (Hard Coded Value)
| Dimensions | N/A
|
CODE
{
'amazon dsp': 'DISPLAY',
'dv360': 'DISPLAY',
'google ads': 'SEARCH',
'the trade desk': 'DISPLAY',
'yahoo dsp': 'DISPLAY'
}
|
cost | Costs (Ad Spend) | Metrics |
CODE
{
'amazon dsp': 'Total cost',
'dv360': 'Revenue (Advertise Currency)',
'google ads': 'Cost',
'the trade desk': 'Advertiser Cost (USD)',
'yahoo dsp': 'Cost'
}
|
CODE
{
'amazon dsp': 'totalcost',
'dv360': 'metric_revenue_advertiser',
'google ads': 'cost',
'the trade desk': 'advertiser_cost_usd',
'yahoo dsp': 'cost'
}
|
profit | Profit that the Inventory can Make | Metrics |
CODE
{
'amazon dsp': 'N/A',
'dv360': 'Profit (Advertiser Currency)',
'google ads': 'N/A',
'the trade desk': 'Profit (USD)',
'yahoo dsp': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'dv360': 'metric_profit_advertiser',
'google ads': 'N/A',
'the trade desk': 'profit_usd',
'yahoo dsp': 'N/A'
}
|
impressions | Impressions | Metrics |
CODE
{
'amazon dsp': 'Impressions',
'dv360': 'Impressions',
'google ads': 'Impr.',
'the trade desk': 'Impressions',
'yahoo dsp': 'impressions'
}
|
CODE
{
'amazon dsp': 'impressions',
'dv360': 'metric_impressions',
'google ads': 'impressions',
'the trade desk': 'impressions',
'yahoo dsp': 'impressions'
}
|
clicks | Clicks | Metrics |
CODE
{
'amazon dsp': 'Click-throughs',
'dv360': 'Clicks',
'google ads': 'Clicks',
'the trade desk': 'Clicks',
'yahoo dsp': 'Clicks'
}
|
CODE
{
'amazon dsp': 'clickthroughs',
'dv360': 'metric_clicks',
'google ads': 'clicks',
'the trade desk': 'clicks',
'yahoo dsp': 'clicks'
}
|
total_conversions | The Total Number of Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'dv360': '',
'google ads': 'All conv.',
'the trade desk': 'Total Click + View Conversions 01',
'yahoo dsp': 'Conversions'
}
|
CODE
{
'amazon dsp': 'N/A',
'dv360': 'metric_last_clicks + metric_last_impressions',
'google ads': 'all_conversions',
'the trade desk': 'total_click_view_conversions_01',
'yahoo dsp': 'conversions'
}
|
total_conversions_value | The Value associated with the Total Number of Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'dv360': '',
'google ads': 'All conv. value',
'the trade desk': 'Total Click + View Conversion Revenue 01',
'yahoo dsp': 'Conversions Value'
}
|
CODE
{
'amazon dsp': 'N/A',
'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'
}
|
click_through_conversions | The Number of Click Through Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'dv360': '',
'google ads': 'N/A',
'the trade desk': 'Click Conversion 01',
'yahoo dsp': 'Click Through Conversions'
}
|
CODE
{
'amazon dsp': 'N/A',
'dv360': 'metric_last_clicks',
'google ads': 'N/A',
'the trade desk': 'click_conversion_01',
'yahoo dsp': 'click_through_conversions'
}
|
click_through_conversions_value | The Value associated with the Click Through Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'dv360': '',
'google ads': 'N/A',
'the trade desk': 'Click Conversion Revenue 01',
'yahoo dsp': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'dv360': 'metric_cm_post_click_revenue',
'google ads': 'N/A',
'the trade desk': 'click_conversion_revenue_01',
'yahoo dsp': 'N/A'
}
|
view_through_conversions | The Number of View Through Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'dv360': '',
'google ads': 'View-through conv.',
'the trade desk': 'View Through Conversion 01',
'yahoo dsp': 'View Through Conversion'
}
|
CODE
{
'amazon dsp': 'N/A',
'dv360': 'metric_last_impressions',
'google ads': 'view_through_conversions',
'the trade desk': 'view_through_conversion_01',
'yahoo dsp': 'view_through_conversions'
}
|
view_through_conversions_value | The Value associated with the View Through Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'dv360': '',
'google ads': 'N/A',
'the trade desk': 'View Through Conversion Revenue 01',
'yahoo dsp': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'dv360': 'metric_cm_post_view_revenue',
'google ads': 'N/A',
'the trade desk': 'view_through_conversion_revenue_01',
'yahoo dsp': 'N/A'
}
|