Column | Description | Dimensions / Metrics / Categorization | Platform UI Name Mapping | Platform API 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',
'bidtellect': 'Day',
'dv360': 'Date',
'facebook ads': 'Date',
'google ads': 'Date',
'linkedin ads': 'Date',
'microsoft ads': 'Date',
'pinterest ads': 'Date',
'snapchat ads': 'Date',
'twitter ads': 'Date',
'tiktok ads': 'Date',
'the trade desk': 'Date',
'yahoo dsp': 'Date',
'reddit ads': 'Date',
'apple search ads': 'Date',
'vistar dsp': 'Day',
'criteo': 'Date',
'taboola': 'Date'
}
|
CODE
{
'amazon dsp': 'date',
'bidtellect': 'ndsp_client_reporting_hour_date',
'dv360': 'filter_date',
'facebook ads': 'date_start',
'google ads': 'date',
'linkedin ads': 'date',
'microsoft ads': 'TimePeriod',
'pinterest ads': 'date',
'snapchat ads': 'date',
'twitter ads': 'date',
'tiktok ads': 'date',
'the trade desk': 'date',
'yahoo dsp': 'day',
'reddit ads': 'date',
'apple search ads': 'date',
'vistar dsp': 'date',
'criteo': 'day',
'taboola': 'date'
}
|
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',
'bidtellect': 'Bidtellect',
'dv360': 'DV360',
'dv360 trueview': 'YouTube',
'facebook ads': 'Facebook Ads',
'google ads': 'Google Ads',
'linkedin ads': 'LinkedIn Ads',
'microsoft ads': 'Microsoft Bing',
'pinterest ads': 'Pinterest Ads',
'snapchat ads': 'Snapchat Ads',
'twitter ads': 'Twitter Ads',
'tiktok ads': 'TikTok Ads',
'the trade desk': 'The Trade Desk',
'yahoo dsp': 'Yahoo DSP',
'reddit ads': 'Reddit Ads',
'apple search ads': 'Apple Search Ads',
'vistar dsp': 'vistar dsp',
'criteo': 'criteo',
'taboola': 'Taboola'
}
|
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',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Publisher Platform',
'google ads': 'Networks',
'linkedin ads': 'N/A',
'microsoft ads': 'Ad Distribution',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'Placements',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'tabo': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'publisher_platform',
'google ads': 'ad_network_type',
'linkedin ads': 'N/A',
'microsoft ads': 'AdDistribution',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'Ads on Twitter',
'tiktok ads': 'placement',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
account_id | The Ad Account Identifier | Dimensions |
CODE
{
'amazon dsp': 'Advertiser Id',
'bidtellect': 'Brand Id',
'dv360': 'Advertiser ID',
'facebook ads': 'Account ID',
'google ads': 'Account ID',
'linkedin ads': 'TBD',
'microsoft ads': 'Account ID',
'pinterest ads': 'Account ID',
'snapchat ads': 'Account',
'twitter ads': 'Account ID',
'tiktok ads': 'Account',
'the trade desk': 'Advertiser ID',
'yahoo dsp': 'Advertiser ID',
'reddit ads': 'Account ID',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'Advertiser ID'
}
|
CODE
{
'amazon dsp': 'advertiserid',
'bidtellect': 'ndsp_client_reporting_customer_brand_id',
'dv360': 'filter_advertiser',
'facebook ads': 'account_id',
'google ads': 'customer_id',
'linkedin ads': 'account_id',
'microsoft ads': 'accountid',
'pinterest ads': 'advertiser_id',
'snapchat ads': 'accountId',
'twitter ads': 'account_id',
'tiktok ads': 'advertiser_id',
'the trade desk': 'advertiser_id',
'yahoo dsp': 'advertiser_id',
'reddit ads': 'account_id',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'AdvertiserId',
'taboola': 'advertiser_id'
}
|
account_name | The Ad Account Name | Dimensions |
CODE
{
'amazon dsp': 'Advertiser Name',
'bidtellect': 'Brand',
'dv360': 'Advertiser',
'facebook ads': 'Account Name',
'google ads': 'Account',
'linkedin ads': 'Account Name',
'microsoft ads': 'Account name',
'pinterest ads': 'Account',
'snapchat ads': 'Account',
'twitter ads': 'Account',
'tiktok ads': 'Account',
'the trade desk': 'Advertiser',
'yahoo dsp': 'Advertiser Name',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'Advertiser',
'criteo': 'Account',
'taboola': 'Advertiser'
}
|
CODE
{
'amazon dsp': 'advertisername',
'bidtellect': 'ndsp_client_reporting_customer_brand_name',
'dv360': 'filter_advertiser_name',
'facebook ads': 'account_name',
'google ads': 'customer_name',
'linkedin ads': 'name',
'microsoft ads': 'AccountName',
'pinterest ads': 'advertiser_name',
'snapchat ads': 'name' (from account structure datasource),
'twitter ads': 'account_name',
'tiktok ads': 'advertiser_name',
'the trade desk': 'advertiser_name',
'yahoo dsp': 'advertiser_name',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'advertiser_name',
'criteo': 'Advertiser',
'taboola': 'advertiser_name'
}
|
campaign_id | The Campaign Identifier | Dimensions |
CODE
{
'amazon dsp': 'Order ID',
'bidtellect': 'Insertion Order Id',
'dv360': 'Insertion Order ID',
'facebook ads': 'Campaign Id',
'google ads': 'Campaign ID',
'linkedin ads': 'N/A',
'microsoft ads': 'Campaign ID',
'pinterest ads': 'Campaign ID',
'snapchat ads': 'Campaign ID',
'twitter ads': 'Campaign ID',
'tiktok ads': 'Campaign ID'
'the trade desk': 'Campaign ID',
'yahoo dsp': 'Campaign ID',
'reddit ads': 'Campaign Id',
'apple search ads': 'Campaign Id',
'vistar dsp': 'N/A',
'criteo': 'Campaign Id',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'orderid',
'bidtellect': 'ndsp_client_reporting_insertion_order_id',
'dv360': 'filter_insertion_order',
'facebook ads': 'campaign_id',
'google ads': 'campaign_id',
'linkedin ads': 'id',
'microsoft ads': 'campaignid',
'pinterest ads': 'campaign_id',
'snapchat ads': 'campaignid',
'twitter ads': 'campaign_id',
'tiktok ads': 'campaign_id',
'the trade desk': 'campaign_id',
'yahoo dsp': 'campaign_id',
'reddit ads': 'campaign_id',
'apple search ads': 'campaignid',
'vistar dsp': 'insertion_order',
'criteo': 'CampaignId',
'taboola': 'N/A'
}
|
campaign_name | The Campaign Name | Dimensions |
CODE
{
'amazon dsp': 'Order name',
'bidtellect': 'Insertion Order Name',
'dv360': 'Insertion Order',
'facebook ads': 'Campaign',
'google ads': 'Campaign',
'linkedin ads': 'N/A',
'microsoft ads': 'Campaign',
'pinterest ads': 'Campaign name',
'snapchat ads': 'Campaign Name',
'twitter ads': 'Campaign Name',
'tiktok ads': 'Campaign Name'
'the trade desk': 'Campaign',
'yahoo dsp': 'Campaign Name',
'reddit ads': 'Campaign Name',
'apple search ads': 'Campaign Name',
'vistar dsp': 'Insertion Order',
'Criteo': 'Campaign',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'ordername',
'bidtellect': 'ndsp_client_reporting_insertion_order_name',
'dv360': 'filter_insertion_name',
'facebook ads': 'campaign_name',
'google ads': 'campaign_name',
'linkedin ads': 'name',
'microsoft ads': 'campaignname',
'pinterest ads': 'name',
'snapchat ads': 'campaignname',
'twitter ads': 'campaign_name',
'tiktok ads': 'campaign_name',
'the trade desk': 'campaign',
'yahoo dsp': 'campaign_name',
'reddit ads': 'name',
'apple search ads': 'campaignname',
'vistar dsp': 'insertion_order_name',
'Criteo': 'Campaign',
'taboola': 'N/A'
}
|
campaign_status | The Current Campaign Status | Dimensions |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'Campaign Status',
'dv360': 'N/A',
'facebook ads': 'Status',
'google ads': 'Campaign status',
'linkedin ads': 'N/A',
'microsoft ads': 'Status',
'pinterest ads': 'Status',
'snapchat ads': 'Status',
'twitter ads': 'N/A',
'tiktok ads': 'N/A'
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Status',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'Delivery status',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_campaign_status',
'dv360': 'N/A',
'facebook ads': 'status',
'google ads': 'campaign_status',
'linkedin ads': 'status',
'microsoft ads': 'status',
'pinterest ads': 'status',
'snapchat ads': 'status' (from campaign structure datasource),
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'effective_status',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
campaign_type | The Campaign Type | Dimensions |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'Campaign type',
'linkedin ads': 'N/A',
'microsoft ads': 'Campaign type',
'pinterest ads': 'Type',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A'
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Objective',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'campaign_advertising_channel_type',
'linkedin ads': 'N/A',
'microsoft ads': 'campaigntype',
'pinterest ads': 'type',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
campaign_objective | The Objective of the Campaign | Dimensions |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Objective',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Objective',
'snapchat ads': 'Objective',
'twitter ads': 'N/A',
'tiktok ads': 'Objective',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Objective',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'objective',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'objective_type',
'snapchat ads': 'objective',
'twitter ads': 'N/A',
'tiktok ads': 'objective_type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'objective',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
campaign_daily_budget | The Daily Budget of the Campaign | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Budget',
'google ads': 'Budget',
'linkedin ads': 'N/A',
'microsoft ads': 'Budget',
'pinterest ads': 'Daily Budget',
'snapchat ads': 'Daily Spend Cap',
'twitter ads': 'Daily Budget,
'tiktok ads': 'N/A'
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'daily_budget/100',
'google ads': 'campaign_budget_amount',
'linkedin ads': 'N/A',
'microsoft ads': 'dailybudget',
'pinterest ads': 'daily_spend_cap',
'snapchat ads': 'daily_budget_micro / 1000000',
'twitter ads': 'daily_budget_amount_local_micro / 1000000',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
campaign_start_date | The Campaign Start Date | Dimensions |
CODE
{
'amazon dsp': 'Order start date',
'bidtellect': 'Campaign Start Date',
'dv360': 'N/A',
'facebook ads': 'Starts',
'google ads': 'Campaign start date',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Campaign start date',
'snapchat ads': 'Start Time',
'twitter ads': 'Campaign start,
'tiktok ads': 'N/A'
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'orderstartdate',
'bidtellect': 'ndsp_client_reporting_campaign_start_date',
'dv360': 'N/A',
'facebook ads': 'start_time',
'google ads': 'campaign_start_date',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'start_time',
'snapchat ads': 'start_time',
'twitter ads': 'start_time',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
campaign_end_date | The Campaign End Date | Dimensions |
CODE
{
'amazon dsp': 'Order end date',
'bidtellect': 'Campaign End Date',
'dv360': 'N/A',
'facebook ads': 'Ends',
'google ads': 'Campaign end date',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Campaign end date',
'snapchat ads': 'End Time',
'twitter ads': 'Campaign end',
'tiktok ads': 'N/A'
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'orderenddate',
'bidtellect': 'ndsp_client_reporting_campaign_end_date',
'dv360': 'N/A',
'facebook ads': 'stop_time',
'google ads': 'campaign_end_date',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'end_time',
'snapchat ads': 'end_time',
'twitter ads': 'end_time',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
adgroup_id | The Adgroup Identifier | Dimensions |
CODE
{
'amazon dsp': 'Line item ID',
'bidtellect': 'Campaign Id',
'dv360': 'coalesce(Toutube Ad Group ID, Line Item ID)',
'facebook ads': 'Ad set ID',
'google ads': 'Ad group ID',
'linkedin ads': 'CAmpaign ID',
'microsoft ads': 'Ad group ID',
'pinterest ads': 'Ad group ID',
'snapchat ads': 'Ad Sets ID',
'twitter ads': 'TBD',
'tiktok ads': 'Adgroup ID',
'the trade desk': 'Ad Group ID',
'yahoo dsp': 'TBD',
'reddit ads': 'Adgroup Id',
'apple search ads': 'Ad Group Id',
'vistar dsp': 'N/A',
'criteo': 'Adset Id',
'taboola': 'Line ID'
}
|
CODE
{
'amazon dsp': 'lineitemid',
'bidtellect': 'ndsp_client_reporting_campaign_id',
'dv360': 'coalesce(filter_trueview_ad_group_ad_id, filter_line_item)',
'facebook ads': 'adset_id',
'google ads': 'ad_group_id',
'linkedin ads': 'campaignid',
'microsoft ads': 'adgroupid',
'pinterest ads': 'id',
'snapchat ads': 'adsquadid',
'twitter ads': 'line_item_id',
'tiktok ads': 'adgroup_id',
'the trade desk': 'ad_group_id',
'yahoo dsp': 'line_id',
'reddit ads': 'id',
'apple search ads': 'adgroupid',
'vistar dsp': 'campaign' or 'campaign_id',
'criteo': 'AdsetId',
'taboola': 'campaign'
}
|
adgroup_name | The Adgroup Name | Dimensions |
CODE
{
'amazon dsp': 'Line item name',
'bidtellect': 'Campaign Name',
'dv360': 'coalesce(Toutube Ad Group, Line Item)',
'facebook ads': 'Ad Set Name',
'google ads': 'Ad group',
'linkedin ads': 'Campaign Name',
'microsoft ads': 'Ad group',
'pinterest ads': 'Ad group name',
'snapchat ads': 'Ad Sets Name',
'twitter ads': 'TBD',
'tiktok ads': 'Adgroup Name',
'the trade desk': 'Ad Group',
'yahoo dsp': 'TBD',
'reddit ads': 'Adgroup Name',
'apple search ads': 'Ad Group Name',
'vistar dsp': 'Campaign',
'criteo': 'Ad set',
'taboola': 'Line Name'
}
|
CODE
{
'amazon dsp': 'lineitemname',
'bidtellect': 'ndsp_client_reporting_campaign_name',
'dv360': 'coalesce(filter_trueview_ad_group, filter_line_item_name)',
'facebook ads': 'adset_name',
'google ads': 'ad_group_name',
'linkedin ads': 'campaignname',
'microsoft ads': 'adgroupname',
'pinterest ads': 'name',
'snapchat ads': 'adsquadname',
'twitter ads': 'line_item_name',
'tiktok ads': 'adgroup_name',
'the trade desk': 'ad_group',
'yahoo dsp': 'line_name',
'reddit ads': 'name',
'apple search ads': 'adgroupname',
'vistar dsp': 'campaign_name',
'criteo': 'Adset',
'taboola': 'campaign_name'
}
|
adgroup_type | The Adgroup Type | Dimensions |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'type',
'linkedin ads': 'Campaign Type',
'microsoft ads': 'N/A',
'pinterest ads': 'type',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_goal_type',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'ad_group_type',
'linkedin ads': 'type',
'microsoft ads': 'N/A',
'pinterest ads': 'type',
'snapchat ads': 'type' (from adgroup structure datasource),
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
adgroup_status | The Current Adgroup Status | Dimensions |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'Campaign Status',
'dv360': 'N/A',
'facebook ads': 'Status',
'google ads': 'Status (under Ad group tab)',
'linkedin ads': 'N/A',
'microsoft ads': 'Status: All ad groups',
'pinterest ads': 'Ad group Status',
'snapchat ads': 'Ad Sets Status',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Status',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_campaign_status',
'dv360': 'N/A',
'facebook ads': 'effective_status',
'google ads': 'ad_group_status',
'linkedin ads': 'status',
'microsoft ads': 'status',
'pinterest ads': 'status',
'snapchat ads': 'status' (from adgroup structure datasource),
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'effective_status',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
line_item_id | The Line Item Identifier | Dimensions |
CODE
{
'amazon dsp': 'Line item ID',
'bidtellect': 'Campaign Id',
'dv360': 'Line Item ID',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'Campaign ID',
'microsoft ads': 'N/A',
'pinterest ads': 'Ad group ID',
'snapchat ads': 'Ad Sets Id',
'twitter ads': 'TBD',
'tiktok ads': 'Adgroup ID',
'the trade desk': 'Ad Group ID',
'yahoo dsp': 'TBD',
'reddit ads': 'Adgroup Id',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'Line ID'
}
|
CODE
{
'amazon dsp': 'lineitemid',
'bidtellect': 'ndsp_client_reporting_campaign_id',
'dv360': 'filter_line_item',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'campaignid',
'microsoft ads': 'N/A',
'pinterest ads': 'id',
'snapchat ads': 'adsquadid',
'twitter ads': 'line_item_id',
'tiktok ads': 'adgroup_id',
'the trade desk': 'ad_group_id',
'yahoo dsp': 'line_id',
'reddit ads': 'id',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'campaign'
}
|
line_item_name | The Line Item Name | Dimensions |
CODE
{
'amazon dsp': 'Line item name',
'bidtellect': 'Campaign Name',
'dv360': 'Line Item',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'Campaign Name',
'microsoft ads': 'N/A',
'pinterest ads': 'Ad group name',
'snapchat ads': 'Ad Sets Name',
'twitter ads': 'TBD',
'tiktok ads': 'Adgroup Name',
'the trade desk': 'Ad Group',
'yahoo dsp': 'TBD',
'reddit ads': 'Adgroup Name',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'Line Name'
}
|
CODE
{
'amazon dsp': 'lineitemname',
'bidtellect': 'ndsp_client_reporting_campaign_name',
'dv360': 'filter_line_item_name',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'campaignname',
'microsoft ads': 'N/A',
'pinterest ads': 'name',
'snapchat ads': 'adsquadname',
'twitter ads': 'line_item_name',
'tiktok ads': 'adgroup_name',
'the trade desk': 'ad_group',
'yahoo dsp': 'line_name',
'reddit ads': 'name',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'campaign_name'
}
|
ad_id | The Ad Identifier | Dimensions |
CODE
{
'amazon dsp': 'Cretive id',
'bidtellect': 'Creative Id',
'dv360': 'coalesce(Youtube Ad Group Ad ID, Creative ID)',
'facebook ads': 'Ad ID',
'google ads': 'Ad ID',
'linkedin ads': 'Ad ID',
'microsoft ads': 'Ad ID',
'pinterest ads': 'TBD',
'snapchat ads': 'Ads ID',
'twitter ads': 'Tweet ID',
'tiktok ads': 'TBD',
'the trade desk': 'Creative ID',
'yahoo dsp': 'Ad ID',
'reddit ads': 'Ad Id',
'apple search ads': 'N/A',
'vistar dsp': 'Creative ID',
'criteo': 'N/A',
'taboola': 'Creative'
}
|
CODE
{
'amazon dsp': 'creativeadid',
'bidtellect': 'ndsp_client_reporting_creative_id',
'dv360': 'coalesce(filter_trueview_ad_group_ad_id, filter_creative_id)',
'facebook ads': 'ad_id',
'google ads': 'ad_id',
'linkedin ads': 'creativeid',
'microsoft ads': 'adid',
'pinterest ads': 'id',
'snapchat ads': 'adid',
'twitter ads': 'promoted_tweet_tweet_id',
'tiktok ads': 'ad_id',
'the trade desk': 'creative_id',
'yahoo dsp': 'ad_id',
'reddit ads': 'ad_id',
'apple search ads': 'N/A',
'vistar dsp': 'creative' or 'creative_id',
'criteo': 'N/A',
'taboola': 'item'
}
|
ad_name | The Ad Name | Dimensions |
CODE
{
'amazon dsp': 'Creative name',
'bidtellect': 'Creative Name',
'dv360': 'coalesce(Youtube Ad Group Ad, Creative)',
'facebook ads': 'Ad',
'google ads': 'Ad',
'linkedin ads': 'Creative Name',
'microsoft ads': 'Ad',
'pinterest ads': 'TBD',
'snapchat ads': 'Ads name',
'twitter ads': 'Ad name',
'tiktok ads': 'TBD',
'the trade desk': 'Creative',
'yahoo dsp': 'Ad',
'reddit ads': 'Ad',
'apple search ads': 'N/A',
'vistar dsp': 'Creative',
'criteo': 'N/A',
'taboola': 'Creative Name'
}
|
CODE
{
'amazon dsp': 'creativename',
'bidtellect': 'ndsp_client_reporting_creative_name',
'dv360': 'coalesce(filter_trueview_ad, filter_creative)',
'facebook ads': 'ad_name',
'google ads': 'ad_name',
'linkedin ads': 'adcontext_dscname',
'microsoft ads': 'headline',
'pinterest ads': 'name',
'snapchat ads': 'adname',
'twitter ads': 'name',
'tiktok ads': 'ad_name',
'the trade desk': 'creative',
'yahoo dsp': 'ad_name',
'reddit ads': 'name',
'apple search ads': 'N/A',
'vistar dsp': 'creative_name',
'criteo': 'N/A',
'taboola': 'ad_name'
}
|
ad_type | The Ad Type | Dimensions |
CODE
{
'amazon dsp': 'Creative Type',
'bidtellect': 'Campaign Product Type',
'dv360': 'Creative Type',
'facebook ads': 'N/A',
'google ads': 'type',
'linkedin ads': 'N/A',
'microsoft ads': 'Ad type',
'pinterest ads': 'TBD',
'snapchat ads': 'Ads Type',
'twitter ads': 'TBD',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'creativetype',
'bidtellect': 'ndsp_client_reporting_campaign_product_type',
'dv360': 'fliter_creative_type',
'facebook ads': 'N/A',
'google ads': 'ad_type',
'linkedin ads': 'adcontext_dscadtype',
'microsoft ads': 'adtype',
'pinterest ads': 'type',
'snapchat ads': 'type' (from ad structure datasource),
'twitter ads': 'card_type',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
ad_status | The Current Ad Status | Dimensions |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'status',
'google ads': 'Status (under Ad tab)',
'linkedin ads': 'N/A',
'microsoft ads': 'Status',
'pinterest ads': 'status (from pinterestads_settings_ad)',
'snapchat ads': 'Ads Status',
'twitter ads': 'Tweet media type',
'tiktok ads': 'Status',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Status',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'Delivery Status'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'effective_status',
'google ads': 'ad_group_ad_status',
'linkedin ads': 'intendedstatus',
'microsoft ads': 'adstatus',
'pinterest ads': 'status',
'snapchat ads': 'status' (from ad structure datasource),
'twitter ads': 'tweet_type',
'tiktok ads': 'status',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'effective_status',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'learning_display_status'
}
|
cm_placement_id | The ID associated with a placement (CM360) | Dimensions | | |
cm_site_id | The ID associated with a Campaign Manager 360 site. Each site ID is associated with a site in Site Directory. | Dimensions | | |
cm_site | A representation in your Campaign Manager 360 account of a website, part of a website, or group of websites from which an advertiser or agency has purchased ad space. | Dimensions | | |
cm_site_key_name | A unique identifier that's included in the Campaign Manager 360 tags of placements associated with a given site. | Dimensions | | |
cm_account_id | The ID associated with an advertiser (CM360) | Dimensions | | |
cm_account_name | An organization that creates and distributes a commercial message. In Campaign Manager 360, each campaign is associated with an advertiser | Dimensions | | |
cm_campaign_id | The ID associated with a campaign (CM360) | Dimensions | | |
cm_campaign_name | Associated with an advertiser, a campaign is a basic framework for managing your advertising. (CM360) | Dimensions | | |
cm_campaign_start_date | The start date of a campaign (CM360) | Dimensions | | |
cm_campaign_end_date | The end date of a campaign (CM360) | Dimensions | | |
cm_placement_name | The name of a placement (CM360) | Dimensions | | |
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',
'bidtellect': 'DISPLAY',
'dv360': 'DISPLAY',
'facebook ads': 'SOCIAL',
'google ads': 'SEARCH',
'linkedin ads': 'SOCIAL',
'microsoft ads': 'SEARCH',
'pinterest ads': 'SOCIAL',
'snapchat ads': 'SOCIAL',
'twitter ads': 'SOCIAL',
'tiktok ads': 'SOCIAL',
'the trade desk': 'DISPLAY',
'yahoo dsp': 'DISPLAY',
'reddit ads': 'SOCIAL',
'apple search ads': 'SEARCH',
'vistar dsp': 'DISPLAY',
'criteo': 'DISPLAY',
'taboola': 'DISPLAY'
}
|
cost | Costs (Ad Spend) | Metrics |
CODE
{
'amazon dsp': 'Total cost',
'bidtellect': 'Spend',
'dv360': 'Revenue (Advertiser Currency)',
'facebook ads': 'Amount Spend',
'google ads': 'Cost',
'linkedin ads': 'Total Spent',
'microsoft ads': 'Spend',
'pinterest ads': 'Spend',
'snapchat ads': 'Spend',
'twitter ads': 'Spend',
'tiktok ads': 'Total cost',
'the trade desk': 'Advertiser Cost (USD)',
'yahoo dsp': 'Cost',
'reddit ads': 'Amount Spent',
'apple search ads': 'Spend',
'vistar dsp': 'Revenue',
'criteo': 'Cost',
'taboola': 'Spent'
}
|
CODE
{
'amazon dsp': 'totalcost',
'bidtellect': 'ndsp_client_reporting_spend',
'dv360': 'metric_revenue_advertiser',
'facebook ads': 'spend',
'google ads': 'cost',
'linkedin ads': 'costinusd',
'microsoft ads': 'spend',
'pinterest ads': 'spend_in_dollar',
'snapchat ads': 'spend',
'twitter ads': 'billed_charge_local_micro / 1000000',
'tiktok ads': 'spend',
'the trade desk': 'advertiser_cost_usd',
'yahoo dsp': 'cost',
'reddit ads': 'spend / 1000000',
'apple search ads': 'localspend',
'vistar dsp': 'client_revenue',
'criteo': 'AdvertiserCost',
'taboola': 'spent'
}
|
impressions | Impressions | Metrics |
CODE
{
'amazon dsp': 'Impressions',
'bidtellect': 'Impressions',
'dv360': 'Impressions',
'facebook ads': 'Impressions',
'google ads': 'Impr.',
'linkedin ads': 'Impressions',
'microsoft ads': 'Impr.',
'pinterest ads': 'Impr.',
'snapchat ads': 'Paid Impressions',
'twitter ads': 'Impressions',
'tiktok ads': 'Impressions',
'the trade desk': 'Impressions',
'yahoo dsp': 'impressions',
'reddit ads': 'Impressions',
'apple search ads': 'Impressions',
'vistar dsp': 'Impressions',
'criteo': 'Displays',
'taboola': 'Impressions'
}
|
CODE
{
'amazon dsp': 'impressions',
'bidtellect': 'ndsp_client_reporting_impressions',
'dv360': 'metric_impressions',
'facebook ads': 'impressions',
'google ads': 'impressions',
'linkedin ads': 'impressions',
'microsoft ads': 'impressions',
'pinterest ads': 'impressions_1 + impressions_2',
'snapchat ads': 'impressions',
'twitter ads': 'impressions',
'tiktok ads': 'impressions',
'the trade desk': 'impressions',
'yahoo dsp': 'impressions',
'reddit ads': 'impressions',
'apple search ads': 'impressions',
'vistar dsp': 'impressions',
'criteo': 'Displays',
'taboola': 'impressions'
}
|
clicks | Clicks | Metrics |
CODE
{
'amazon dsp': 'Click-throughs',
'bidtellect': 'Clicks',
'dv360': 'Clicks',
'facebook ads': 'Link clicks',
'google ads': 'Clicks',
'linkedin ads': 'Clicks',
'microsoft ads': 'Clicks',
'pinterest ads': 'Result: Clicks',
'snapchat ads': 'Clicks',
'twitter ads': 'Clicks',
'tiktok ads': 'Clicks (Destination)',
'the trade desk': 'Clicks',
'yahoo dsp': 'Clicks',
'reddit ads': 'Clicks',
'apple search ads': 'Taps',
'vistar dsp': 'N/A',
'criteo': 'Clicks',
'taboola': 'Clicks'
}
|
CODE
{
'amazon dsp': 'clickthroughs',
'bidtellect': 'ndsp_client_reporting_clicks',
'dv360': 'metric_clicks',
'facebook ads': 'inline_link_clicks',
'google ads': 'clicks',
'linkedin ads': 'landingpageclicks',
'microsoft ads': 'clicks',
'pinterest ads': 'clickthrough_1 + clickthrough_2',
'snapchat ads': 'swipes',
'twitter ads': 'url_clicks',
'tiktok ads': 'clicks',
'the trade desk': 'clicks',
'yahoo dsp': 'clicks',
'reddit ads': 'clicks',
'apple search ads': 'taps',
'vistar dsp': 'N/A',
'criteo': 'Clicks',
'taboola': 'clicks'
}
|
landing_page_views | The Number of Landing Page Views | Metrics | N/A
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
reach | Reach | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'reach',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Reach',
'snapchat ads': 'Paid Reach',
'twitter ads': 'N/A',
'tiktok ads': 'Reach',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'reach',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_impression_user',
'snapchat ads': 'uniques',
'twitter ads': 'N/A',
'tiktok ads': 'reach',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
conversions | The Number of Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'Conversions',
'linkedin ads': 'Conversions',
'microsoft ads': 'Conv.',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'Conversion',
'the trade desk': 'N/A',
'yahoo dsp': 'Conversions',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'Sales',
'taboola': 'Conversions'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'conversions',
'linkedin ads': 'externalwebsiteconversions',
'microsoft ads': 'conversions',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'conversion',
'the trade desk': 'N/A',
'yahoo dsp': 'conversions',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'SalesClientAttribution',
'taboola': 'actions'
}
|
conversions_value | The Value associated with Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'Conv. value',
'linkedin ads': 'N/A',
'microsoft ads': 'Revenue',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'Conversion Value',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'Revenue',
'taboola': 'Converison Value'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'conversions_value',
'linkedin ads': 'N/A',
'microsoft ads': 'revenue',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'conversion_value',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'RevenueGeneratedClientAttribution',
'taboola': 'conversions_value'
}
|
purchase_conversions | The Number of Purchase Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Website Purchases',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total conversions (Checkout)',
'snapchat ads': 'Conversions: Purchases',
'twitter ads': 'Purchases',
'tiktok ads': 'Total Purchase',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Click: Purchase + View: Purchase',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'action_offsite_conversion_fb_pixel_purchase',
'google ads': 'case when conversion_action_category = 'PURCHASE' then conversions',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_checkout',
'snapchat ads': 'conversion_purchases',
'twitter ads': 'conversion_purchases_metric',
'tiktok ads': 'total_purchase',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'purchase_view_through_conversions + purchase_click_through_conversions'(of all attribution window)',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
purchase_conversions_value | The Value associated with the Purchase Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Website Purchases Conversion Value',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total order value (Checkout)',
'snapchat ads': 'Conversions: Purchases Value',
'twitter ads': 'Purchases - sale amount',
'tiktok ads': 'Purchase Total Value',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Total Value: Purchase',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'action_values_offsite_conversion_fb_pixel_purchase',
'google ads': 'case when conversion_action_category = 'PURCHASE' then conversions_value',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_checkout_value_in_micro_dollar/1000000',
'snapchat ads': 'conversion_purchases_value',
'twitter ads': 'conversion_purchases_sale_amount',
'tiktok ads': 'total_purchase_value',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'conversion_purchase_total_value',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
add_to_cart_conversions | The Number of Add To Cart Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Adds to cart',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total conversions (Add to cart)',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'Total Add-to-cart',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Add to Cart: purchase',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'action_offsite_conversion_fb_pixel_add_to_cart',
'google ads': 'case when conversion_action_category = 'ADD_TO_CART' then conversions',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_click_add_to_cart',
'snapchat ads': 'conversion_add_cart',
'twitter ads': 'N/A',
'tiktok ads': 'total_app_event_add_to_cart',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'add_to_cart_click_through_conversions+add_to_cart_view_through_conversions(of all attribution window)',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
add_to_cart_conversions_value | The Value associated with the Add to Cart Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'Add-to-cart Total Value',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'conversion: add to cart value',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'case when conversion_action_category = 'ADD_TO_CART' then conversions_value',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'total_app_event_add_to_cart_value',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'conversion_add_to_cart_total_value',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
app_install_conversions | The Number of App Install Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'App installs',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'App Installs',
'twitter ads': 'N/A',
'tiktok ads': 'App Install',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': '(MMP) Total App Installs',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'Post-Install Sales',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'action_mobile_app_install',
'google ads': 'case when conversion_action_category = 'APP_INSTALL' then conversions',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'total_installs',
'twitter ads': 'N/A',
'tiktok ads': 'app_install',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'app_install_metrics_install',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'PostInstallSales',
'taboola': 'N/A'
}
|
app_install_conversions_value DEPRECATED ` | The Value associated with App Install Conversions.
This column is currently deprecated and will be removed in a future version of Data Library
| Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'Post-Install Order Value',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'case when conversion_action_category = 'APP_INSTALL' then conversions',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'PostInstallOrderValue',
'taboola': 'N/A'
}
|
sign_up_conversions | The Number of Sign Up Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Registration completed',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total conversions (Signup)',
'snapchat ads': 'Conversions: Sign Ups',
'twitter ads': 'TBD',
'tiktok ads': 'Total Registration',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Sign Up: Purchase',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'action_offsite_conversion_fb_pixel_complete_registration',
'google ads': 'case when conversion_action_category = 'SIGNUP' then conversions',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_signup',
'snapchat ads': 'conversion_sign_ups',
'twitter ads': 'conversion_sign_ups',
'tiktok ads': 'total_registration',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
sign_up_conversions_value | The Value associated with App Install Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total order value (Signup)',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'case when conversion_action_category = 'SIGNUP' then conversions',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_signup_value_in_micro_dollar/1000000',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
total_conversions | The Total Number of Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'TBD',
'dv360': 'N/A',
'facebook ads': 'Actions',
'google ads': 'All conv.',
'linkedin ads': 'N/A',
'microsoft ads': 'Conv.',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'Conversion',
'the trade desk': 'Total Click + View Conversions 01',
'yahoo dsp': 'Conversions',
'reddit ads': 'N/A',
'apple search ads': 'installs',
'vistar dsp': 'N/A',
'criteo': 'Sales',
'taboola': 'Conversions'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_total_conversions',
'dv360': 'metric_last_clicks + metric_last_impressions',
'facebook ads': 'actions',
'google ads': 'all_conversions',
'linkedin ads': 'N/A',
'microsoft ads': 'conversions',
'pinterest ads': 'total_conversions',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'conversion',
'the trade desk': 'total_click_view_conversions_01',
'yahoo dsp': 'conversions',
'reddit ads': 'N/A',
'apple search ads': 'installs',
'vistar dsp': 'N/A',
'criteo: 'SalesAllClientAttribution',
'taboola': 'conversions'
}
|
total_conversions_value | The Value associated with the Total Number of Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'All conv. value',
'linkedin ads': 'N/A',
'microsoft ads': 'Revenue',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'Total Click + View Conversion Revenue 01',
'yahoo dsp': Conversion value,
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'Revenue',
'taboola': 'Conversion value'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'metric_cm360_post_click_revenue + metric_cm360_post_view_revenue',
'facebook ads': 'N/A',
'google ads': 'all_conversions_value',
'linkedin ads': 'N/A',
'microsoft ads': 'revenue',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'total_click_view_conversion_revenue_01',
'yahoo dsp': 'conversions_value',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'RevenueGeneratedAllClientAttribution',
'taboola': 'conversions_value'
}
|
click_through_conversions | The Number of Click Through Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'TBD',
'dv360': 'TBD',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'Post-Click Conversions',
'microsoft ads': 'N/A',
'pinterest ads': 'Total click-through conversions (Checkout)',
'snapchat ads': 'Conversions Click: Purchases Click',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'Click Conversion 01',
'yahoo dsp': 'Click Through Conversions',
'reddit ads': 'Click: Purchase',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'Click Through Conversions'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_click_through_conversions',
'dv360': 'metric_last_clicks',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'externalwebsitepostclickconversions',
'microsoft ads': 'N/A',
'pinterest ads': 'total_click_checkout',
'snapchat ads': 'conversion_purchases_swipe_up',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'click_conversion_01',
'yahoo dsp': 'click_through_conversions',
'reddit ads': 'purchase_click_through_conversions_attribution_window_{day/week/month}',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'actions_num_from_clicks'
}
|
click_through_conversions_value | The Value associated with the Click Through Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'TBD',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total click-through order value (Checkout)',
'snapchat ads': 'Conversions Click: Purchases Value Click',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'Click Conversion Revenue 01',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'metric_cm_post_click_revenue',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_click_checkout_value_in_micro_dollar/1000000',
'snapchat ads': 'conversion_purchases_value_swipe_up',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'click_conversion_revenue_01',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
view_through_conversions | The Number of View Through Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'TBD',
'dv360': 'TBD',
'facebook ads': 'N/A',
'google ads': 'View-through conv.',
'linkedin ads': 'View-through Conversions',
'microsoft ads': 'N/A',
'pinterest ads': 'Total view-through conversions (Checkout)',
'snapchat ads': 'Conversions: Purchases View',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'View Through Conversion 01',
'yahoo dsp': 'View Through Conversion',
'reddit ads': 'View: Purchase',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'View Through Conversions'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_view_through_conversions',
'dv360': 'metric_last_impressions',
'facebook ads': 'N/A',
'google ads': 'view_through_conversions',
'linkedin ads': 'externalwebsitepostviewconversions',
'microsoft ads': 'N/A',
'pinterest ads': 'total_view_checkout',
'snapchat ads': 'conversion_purchases_view',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'view_through_conversion_01',
'yahoo dsp': 'view_through_conversions',
'reddit ads': 'purchase_view_through_conversions_attribution_window_{day/week/month}',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'actions_num_from_views'
}
|
view_through_conversions_value | The Value associated with the View Through Conversions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'TBD',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total view-through conversions (Checkout)',
'snapchat ads': 'Converions View: Purchases View',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'View Through Conversion Revenue 01',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'metric_cm_post_view_revenue',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_view_checkout_value_in_micro_dollar/1000000',
'snapchat ads': 'conversion_purchases_value_view',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'view_through_conversion_revenue_01',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
video_starts | Video Starts | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'Video Started',
'dv360': 'N/A',
'facebook ads': 'Video plays',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total video starts',
'snapchat ads': 'N/A',
'twitter ads': 'Video starts',
'tiktok ads': 'Video views',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Video Starts',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_starts',
'dv360': 'N/A',
'facebook ads': 'action_video_play',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_p0_combined',
'snapchat ads': 'N/A',
'twitter ads': 'video_content_starts',
'tiktok ads': 'video_play_actions',
'the trade desk': 'N/A',
'yahoo dsp': 'video_views_starts',
'reddit ads': 'video_started',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
video_views | Video Views | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'TrueView: Views',
'facebook ads': '3-second video plays',
'google ads': 'Views',
'linkedin ads': 'Video Views',
'microsoft ads': 'N/A',
'pinterest ads': 'Video views',
'snapchat ads': '2 Second Video Views',
'twitter ads': '3s/100% video views',
'tiktok ads': '2-second video views',
'the trade desk': 'N/A',
'yahoo dsp': 'View starts',
'reddit ads': 'Video Views',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'metric_trueview_views',
'facebook ads': 'action_video_view',
'google ads': 'video_views',
'linkedin ads': 'videoviews',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_mrc_views',
'snapchat ads': 'video_views',
'twitter ads': 'video_3s100pct_views',
'tiktok ads': 'video_watched_2s',
'the trade desk': 'N/A',
'yahoo dsp': 'video_view_starts',
'reddit ads': 'video_viewable_impressions',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
video_3s_watched | Video 3-Second Watched | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': '3s video views',
'snapchat ads': 'N/A',
'twitter ads': '3s/100% video views',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': '3 Second Views',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_3sec_views',
'snapchat ads': 'N/A',
'twitter ads': 'video_3s100pct_views',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'video_watched_3_seconds',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
video_p25_watched | Video Completions - 25% | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'Video Q1',
'dv360': 'First-Quartile Views (Video)',
'facebook ads': 'Video plays at 25%',
'google ads': 'Video played to 25%',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total video played at 25%',
'snapchat ads': 'Video Plays at 25%',
'twitter ads': 'Video played 25%',
'tiktok ads': 'Video views at 25%',
'the trade desk': 'N/A',
'yahoo dsp': '25% Completions',
'reddit ads': 'Watches at 25%',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_first_quartiles',
'dv360': 'metric_rich_media_video_first_quartile_completes',
'facebook ads': 'video_p25_watched_actions',
'google ads': 'video_views * video_quartile_p25_rate',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_p25_combined',
'snapchat ads': 'quartile_1',
'twitter ads': 'video_views_25',
'tiktok ads': 'video_views_p25',
'the trade desk': 'N/A',
'yahoo dsp': 'video_25p_completions',
'reddit ads': 'video_watched_25_percent',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
video_p50_watched | Video Completions - 50% | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'Video Midpoint',
'dv360': 'Midpoint Views(Video)',
'facebook ads': 'Video plays at 50%',
'google ads': 'Video played to 50%',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total video played at 50%',
'snapchat ads': 'Video Plays at 50%',
'twitter ads': 'Video played 50%',
'tiktok ads': 'Video views at 50%',
'the trade desk': 'N/A',
'yahoo dsp': '50% Completions',
'reddit ads': 'Watches at 50%',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_mid_points',
'dv360': 'metric_rich_media_video_midpoints',
'facebook ads': 'video_p50_watched_actions',
'google ads': 'video_views * video_quartile_p50_rate',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_p50_combined',
'snapchat ads': 'quartile_2',
'twitter ads': 'video_views_50',
'tiktok ads': 'video_views_p50',
'the trade desk': 'N/A',
'yahoo dsp': 'video_50p_completions',
'reddit ads': 'video_watched_50_percent',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
video_p75_watched | Video Completions - 75% | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'Video Q3',
'dv360': 'Third-Quartile Views (Video)',
'facebook ads': 'Video plays at 75%',
'google ads': 'Video played to 75%',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total video played at 75%',
'snapchat ads': 'Video Plays at 75%',
'twitter ads': 'Video played 75%',
'tiktok ads': 'Video views at 75%',
'the trade desk': 'N/A',
'yahoo dsp': '75% Completions',
'reddit ads': 'Watches at 75%',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_third_quartiles',
'dv360': 'metric_rich_media_video_third_quartile_completes',
'facebook ads': 'video_p75_watched_actions',
'google ads': 'video_views * video_quartile_p75_rate',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_p75_combined',
'snapchat ads': 'quartile_3',
'twitter ads': 'video_views_75',
'tiktok ads': 'video_views_p75',
'the trade desk': 'N/A',
'yahoo dsp': 'video_75p_completions',
'reddit ads': 'video_watched_75_percent',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
video_p95_watched | Video Completions - 95% | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total video played at 95%',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Watches at 95%',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'video_p95_watched_actions',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_p95_combined',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'video_watched_95_percent',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
video_p100_watched | Video Completions | Metrics |
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'Video Completed',
'dv360': 'Complete Views (Video)',
'facebook ads': 'Video plays at 100%',
'google ads': 'Video played to 100%',
'linkedin ads': 'Video Completions',
'microsoft ads': 'N/A',
'pinterest ads': 'Total video played at 100%',
'snapchat ads': 'Video Completions',
'twitter ads': 'Video completions',
'tiktok ads': 'Video views at 100%',
'the trade desk': 'N/A',
'yahoo dsp': '100% Completions',
'reddit ads': 'Watches at 100%',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_completes',
'dv360': 'metric_rich_media_video_completions',
'facebook ads': 'video_p100_watched_actions',
'google ads': 'video_views * video_quartile_p100_rate',
'linkedin ads': 'videocompletions',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_p100_complete',
'snapchat ads': 'view_completion',
'twitter ads': 'video_views_100',
'tiktok ads': 'video_views_p100',
'the trade desk': 'N/A',
'yahoo dsp': 'video_completions',
'reddit ads': 'video_watched_100_percent',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
|
cm_cost | The cost of all impressions, clicks, and activities during the specified date range, based on the schedule and pricing information that was entered for each placement. See Media Cost. (CM360) | Metrics | | |
cm_impressions | The number of times that a user’s client (browser or mobile device) sent a ping to our ad server that creative content was requested and has started to download during the specified date range. (CM360) | Metrics | | |
cm_clicks | The number of times that users clicked on a creative during the specified date range. A click is recorded even if the user does not actually reach the landing page. (CM360) For YouTube ads, this is the number of clicks on a call to action that leads to a destination URL. These are clicks that lead outside of the video. | Metrics | | |
cm_click_through_conversions | All conversions in the reporting period that are attributed to a click on an ad. (CM360) | Metrics |
CODE
Click-through Conversions
|
CODE
click_through_conversions
|
cm_view_through_conversions | Conversions that are attributed to an ad that was displayed but not clicked on. (CM360) | Metrics |
CODE
View-through Conversions
|
CODE
view_through_conversions
|
cm_total_conversions | All conversions in the reporting period, including both click-through and view-through conversions. (CM360) | Metrics | | |
cm_click_through_conversions_value | The total amount of revenue attributed to click-through conversions. (CM360) | Metrics |
CODE
Click-through Revenue
|
CODE
click_through_revenue
|
cm_view_through_conversions_value | The total amount of revenue attributed to view-through conversions. (CM360) | Metrics |
CODE
View-through Revenue
|
CODE
view_through_revenue
|
cm_total_conversions_value | The total amount of revenue attributed to all conversions in the reporting period, including both click-through and view-through conversions. (CM360) | Metrics | | |
cm_video_starts | The number of served video impressions, counted when the video clip was played or started by the user. Only one video play is counted, even if the user stopped and restarted the video. (CM360) | Metrics | | |
cm_video_views | The number of impressions for which a video clip was played. An event is logged only once per impression. (CM360) | Metrics | | |
cm_video_p25_watched | The number of impressions for which an ad clip played to the end of the first quarter of the video's total length. (CM360) | Metrics |
CODE
Video First Quartile Completions
|
CODE
video_first_quartile_completions
|
cm_video_p50_watched | The number of impressions for which an ad clip played to the midpoint of the video's total length. (CM360) | Metrics | | |
cm_video_p75_watched | The number of impressions for which an ad clip played to the end of the third quarter of the video's total length. (CM360) | Metrics |
CODE
Video Third Quartile Completions
|
CODE
video_third_quartile_completions
|
cm_video_p100_watched | The number of impressions for which an ad clip played to completion. (CM360) | Metrics | | |
cm_effective_cpm | The amount of revenue per 1000 impressions that is generated by your ads, calculated as: (Media cost * 1,000)/ Impressions
| Metrics |
CODE
Effective CPM (eCPM)
| |