| Column | Description | Dimensions / Metrics | 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',
'cm360': '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',
'teads': 'Day',
}
 | 
        
        CODE
     {
'amazon dsp': 'date',
'bidtellect': 'ndsp_client_reporting_hour_date',
'dv360': 'filter_date',
'cm360': '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',
'teads': 'day',
}
 | 
| platform | The Platform the Campaign belongs to. (Hard Coded) | Dimensions | N/A
 | 
        
        CODE
     {
'amazon dsp': 'Amazon DSP',
'bidtellect': 'Bidtellect',
'dv360': 'DV360',
'cm360': 'CM360',
'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',
'teads': 'Teads',
}
 | 
| publisher_platform | The Publisher Platform on where the Campaign Delivered Ads 
    
    
                For Twitter Ads, there are Datasources that pull data from Ads on Twitterand theTwitter Audience Networkwhich is hardcoded into this column. | Dimensions | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': 'Site (CM360)',
'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',
'taboola': 'N/A',
'teads': 'N/A',
}
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': 'site',
'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',
'teads': 'N/A',
}
 | 
| account_id | The Ad Account Identifier | Dimensions | 
        
        CODE
     {
'amazon dsp': 'Advertiser Id',
'bidtellect': 'Brand Id',
'dv360': 'Advertiser ID',
'cm360': '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',
'teads': 'Advertiser ID',
}
 | 
        
        CODE
     {
'amazon dsp': 'advertiserid',
'bidtellect': 'ndsp_client_reporting_customer_brand_id',
'dv360': 'filter_advertiser',
'cm360': 'advertiser_id',
'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',
'teads': 'advertiser_id',
}
 | 
| account_name | The Ad Account Name | Dimensions | 
        
        CODE
     {
'amazon dsp': 'Advertiser Name',
'bidtellect': 'Brand',
'dv360': 'Advertiser',
'cm360': 'Advertiser',
'facebook ads': 'Account Name',
'google ads': 'Account',
'linkedin ads': 'N/A',
'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',
'teads': 'Advertiser Name',
}         
 | 
        
        CODE
     {
'amazon dsp': 'advertisername',
'bidtellect': 'ndsp_client_reporting_customer_brand_name',
'dv360': 'filter_advertiser_name',
'cm360': 'advertiser',
'facebook ads': 'account_name',
'google ads': 'customer_descriptive_name',
'linkedin ads': 'name',
'microsoft ads': 'AccountName',
'pinterest ads': 'advertiser_name',
'snapchat ads': 'accountName',
'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',
'teads': 'advertiser_name',
}         
 | 
| channel | The Default Alli Data Library Channel (Hard Coded Value)   | Dimensions | N/A
 | 
        
        CODE
     {
'amazon dsp': 'DISPLAY',
'bidtellect': 'DISPLAY',
'dv360': 'DISPLAY',
'cm360': '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',
'teads': 'DISPLAY',
}         
 | 
| cost | Costs (Ad Spend) | Metrics | 
        
        CODE
     {
'amazon dsp': 'Total cost',
'bidtellect': 'Spend',
'dv360': 'Revenue (Advertiser Currency)',
'cm360': 'Media Cost (Advertise 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',
'teads': 'Budget Spent',
}         
 | 
        
        CODE
     {
'amazon dsp': 'totalcost',
'bidtellect': 'ndsp_client_reporting_spend',
'dv360': 'metric_revenue_advertiser',
'cm360': 'mediacost',
'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',
'teads': 'turnover_value',
}         
 | 
| impressions | Impressions | Metrics | 
        
        CODE
     {
'amazon dsp': 'Impressions',
'bidtellect': 'Impressions',
'dv360': 'Impressions',
'cm360': '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': 'Cmpressions',
'reddit ads': 'Impressions',
'apple search ads': 'Impressions',
'vistar dsp': 'Impressions',
'criteo': 'Displays',
'taboola': 'Impressions',
'teads': 'Impressions',
}         
 | 
        
        CODE
     {
'amazon dsp': 'impressions',
'bidtellect': 'ndsp_client_reporting_impressions',
'dv360': 'metric_impressions',
'cm360': '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',
'teads': 'impression',
}         
 | 
| clicks | Clicks | Metrics | 
        
        CODE
     {
'amazon dsp': 'Click-throughs',
'bidtellect': 'Clicks',
'dv360': 'Clicks',
'cm360': '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',
'teads': 'Clicks',
}         
 | 
        
        CODE
     {
'amazon dsp': 'clickthroughs',
'bidtellect': 'ndsp_client_reporting_clicks',
'dv360': 'metric_clicks',
'cm360': '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',
'teads': 'click',
}         
 | 
| landing_page_views | The Number of Landing Page Views | Metrics | N/A
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'N/A',
}         
 | 
| reach | Reach | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'N/A',
}         
 | 
| conversions | The Number of Conversions | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'N/A',
}         
 | 
| conversions_value | The Value associated with Conversions | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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': 'Conversion Value',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'N/A',
}         
 | 
| purchase_conversions | The Number of Purchase Conversions | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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 + Conversions: Purchases View',
'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',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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_swipe_up + conversion_purchases_view',
'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',
'teads': 'N/A',
}         
 | 
| purchase_conversions_value | The Value associated with the Purchase Conversions | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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 + Conversions: Purchases Value View',
'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',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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_swipe_up + conversion_purchases_value_view',
'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',
'teads': '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',
'cm360': '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',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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 + total_view_add_to_cart',
'snapchat ads': 'N/A',
'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',
'teads': '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',
'cm360': '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',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'N/A',
}         
 | 
| app_install_conversions | The Number of App Install Conversions | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'N/A',
}         
 | 
| app_install_conversions_value | The Value associated with App Install Conversions. | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'case when conversion_action_category = 'PURCHASE' 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': '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',
'teads': 'N/A',
}         
 | 
| sign_up_conversions | The Number of Sign Up Conversions | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'N/A',
}         
 | 
| sign_up_conversions_value | The Value associated with Sign Up Conversions | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'case when conversion_action_category = 'PURCHASE' then conversions_value',
'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',
'teads': 'N/A',
}         
 | 
| total_conversions | The Total Number of Conversions | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'TBD',
'dv360': 'N/A',
'cm360': 'Total Conversions',
'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': 'otal Click + View Conversions 01',
'yahoo dsp': 'Conversions',
'reddit ads': 'N/A',
'apple search ads': 'installs',
'vistar dsp': 'N/A',
'criteo': 'Sales',
'taboola': 'Conversions',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_total_conversions',
'dv360': 'metric_last_clicks + metric_last_impressions',
'cm360': 'totalconversions',
'facebook ads': 'actions',
'google ads': 'all_conversions',
'linkedin ads': 'N/A',
'microsoft ads': 'conversions',
'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': 'SalesAllClientAttribution',
'taboola': 'actions',
'teads': 'N/A',
}         
 | 
| total_conversions_value | The Value associated with the Total Number of Conversions | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'TBD',
'cm360': 'Total Revenue',
'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',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'metric_cm360_post_click_revenue + metric_cm360_post_view_revenue',
'cm360': 'totalconversionsrevenue',
'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',
'teads': 'N/A',
}         
 | 
| click_through_conversions | The Number of Click Through Conversions | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'TBD',
'dv360': 'TBD',
'cm360': 'Click-through Conversions',
'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: Purchases',
'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',
'teads': 'Post Click Conversions',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_click_through_conversions',
'dv360': 'metric_last_clicks',
'cm360': 'activityclickthroughconversions',
'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',
'teads': 'post_click_conversion',
}         
 | 
| click_through_conversions_value | The Value associated with the Click Through Conversions | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'TBD',
'cm360': 'Click-through revenue',
'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: Purchases Value',
'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',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'metric_cm_post_click_revenue',
'cm360': 'activityclickthroughrevenue',
'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',
'teads': 'N/A',
}         
 | 
| view_through_conversions | The Number of View Through Conversions | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'TBD',
'dv360': 'TBD',
'cm360': 'View-through Conversions',
'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',
'teads': 'Post View Conversions',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_view_through_conversions',
'dv360': 'metric_last_impressions',
'cm360': 'activityviewthroughconversions',
'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',
'teads': 'post_view_conversion',
}         
 | 
| view_through_conversions_value | The Value associated with the View Through Conversions | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'TBD',
'cm360': 'View-through Revenue',
'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': 'Conversions: 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',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'metric_cm_post_view_revenue',
'cm360': 'activityviewthroughrevenue',
'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',
'teads': 'N/A',
}         
 | 
| video_starts | Video Starts | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'Video Started',
'dv360': 'N/A',
'cm360': 'Video Plays',
'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': 'Start Views',
'reddit ads': 'Video Starts',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A',
'teads': 'Video Starts',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_starts',
'dv360': 'N/A',
'cm360': 'richmediavideoplays',
'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',
'teads': 'video_start',
}         
 | 
| video_views | Video Views | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'TrueView: Views',
'cm360': 'Video 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': 'N/A',
'reddit ads': 'Video Views',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'metric_trueview_views',
'cm360': 'richmediavideoviews',
'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': 'N/A',
'reddit ads': 'video_viewable_impressions',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A',
'teads': 'N/A',
}         
 | 
| video_3s_watched | Video 3-Second Watched | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'Video Progress 3 Second',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'video_progress_3',
}         
 | 
| video_p25_watched | Video Completions - 25% | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'Video Q1',
'dv360': 'First-Quartile Views (Video)',
'cm360': 'Video First Quartile Completions',
'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',
'teads': 'Video First Quartile',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_first_quartiles',
'dv360': 'metric_rich_media_video_first_quartile_completes',
'cm360': 'richmediavideofirstquartilecompletes',
'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',
'teads': 'video_firstQuartile',
}         
 | 
| video_p50_watched | Video Completions - 50% | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'Video Midpoint',
'dv360': 'Midpoint Views(Video)',
'cm360': 'Video Midpoints',
'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',
'teads': 'Video Midpoint',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_mid_points',
'dv360': 'metric_rich_media_video_midpoints',
'cm360': 'richmediavideomidpoints',
'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',
'teads': 'video_midpoint',
}         
 | 
| video_p75_watched | Video Completions - 75% | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'Video Q3',
'dv360': 'Third-Quartile Views (Video)',
'cm360': 'Video Third Quartile Completions',
'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',
'teads': 'Video Third Quartile',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_third_quartiles',
'dv360': 'metric_rich_media_video_third_quartile_completes',
'cm360': 'richmediavideothirdquartilecompletes',
'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',
'teads': 'video_thirdQuartile',
}         
 | 
| video_p95_watched | Video Completions - 95% | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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',
'teads': 'N/A',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': 'N/A',
'facebook ads': 'N/A',
'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',
'teads': 'N/A',
}         
 | 
| video_p100_watched | Video Completions | Metrics | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'Video Completed',
'dv360': 'Complete Views (Video)',
'cm360': 'Video Completions',
'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',
'teads': 'Video Completes',
}         
 | 
        
        CODE
     {
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_completes',
'dv360': 'metric_rich_media_video_completions',
'cm360': 'richmediavideocompletions',
'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',
'teads': 'video_complete',
}         
 |