Skip to main content
Skip table of contents

Data Library Field Mapping - Ad Performance

Overview

This document describes how the columns from all the ad platforms are mapped to the ad_performance Alli Data Library Report.

To understand which Alli Data Datasources are used within the ad_performance report, see the following link: Report Diagrams | ad_performance & https://agencypmg.atlassian.net/wiki/spaces/PTD/whiteboard/3018915969

The value N/A identifies that the platform does not have a mapping for the corresponding column.

The value TBD identifies that the platform mapping is still being identified and will be updated once confirmed in the UI.


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',
'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'
}
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'
}

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',
'cm360': 'CM360',
'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',
'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',
'tabo': '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'
}

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'
}
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'
}

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': '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',
'cm360': 'advertiser',
'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',
'cm360': 'Campaign 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',
'cm360': 'campaign_id',
'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',
'CM360': 'Campaign',
'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',
'cm360': 'campaign',
'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',
'cm360': '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',
'cm360': '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',
'cm360': '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',
'cm360': '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',
'cm360': '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',
'cm360': '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',
'cm360': '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',
'cm360': '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',
'cm360': 'Start date',
'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',
'cm360': 'startdate',
'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',
'cm360': 'End date',
'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',
'cm360': 'enddate',
'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)',
'cm360': 'Placement 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)',
'cm360': 'placement_id',
'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)',
'cm360': 'Placement',
'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)',
'cm360': 'placement',
'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',
'cm360': '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',
'cm360': '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',
'cm360': 'Placement Status',
'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',
'cm360': 'status',
'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',
'cm360': 'Placement 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',
'cm360': 'placement_id',
'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',
'cm360': 'Placement',
'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',
'cm360': 'placement',
'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)',
'cm360': 'Ad 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)',
'cm360': '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)',
'cm360': 'Ad',
'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)',
'cm360': 'ad',
'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',
'cm360': 'TBD',
'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',
'cm360': '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',
'dv360': 'Ad Status',
'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',
'cm360': 'status',
'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

CODE
Placement ID
CODE
placement_id

cm_site_id

The ID associated with a Campaign Manager 360 site. Each site ID is associated with a site in Site Directory.

Dimensions

CODE
Site ID
CODE
site_id

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

CODE
Site
CODE
site

cm_site_key_name

A unique identifier that's included in the Campaign Manager 360 tags of placements associated with a given site.

Dimensions

CODE
Site keyname
CODE
site_key_name

cm_account_id

The ID associated with an advertiser (CM360)

Dimensions

CODE
Advertiser ID
CODE
advertiser_id

cm_account_name

An organization that creates and distributes a commercial message. In Campaign Manager 360, each campaign is associated with an advertiser

Dimensions

CODE
Advertiser
CODE
advertiser

cm_campaign_id

The ID associated with a campaign (CM360)

Dimensions

CODE
Campaign ID
CODE
campaign_id

cm_campaign_name

Associated with an advertiser,  a campaign is a basic framework for managing your advertising. (CM360)

Dimensions

CODE
Campaign
CODE
campaign

cm_campaign_start_date

The start date of a campaign (CM360)

Dimensions

CODE
Campaign start date
CODE
campaign_start_date

cm_campaign_end_date

The end date of a campaign (CM360)

Dimensions

CODE
Campaign end date
CODE
campaign_end_date

cm_placement_name

The name of a placement (CM360)

Dimensions

CODE
Placement
CODE
placement

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)

 

If you would like to change the Channel associated with the Campaign please see the following document: How to reclassify media channel data in ADL

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'
}         

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'
}         
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'
}         

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': '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',
'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'
}         

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'
}         
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'
}         

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'
}         

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'
}         
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'
}         

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'
}         
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'
}         

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': 'Converison Value'
}         
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'
}         

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',
'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',
'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',
'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',
'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',
'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',
'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',
'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',
'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'
}         
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': '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',
'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'
}         
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'
}         

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'
}         
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'
}         

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',
'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'
}         
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 = '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',
'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'
}         
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'
}         

sign_up_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': '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',
'cm360': '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',
'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': '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',
'cm360': 'totalconversions',
'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',
'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'
}         
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'
}         

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 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',
'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'
}         

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 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',
'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'
}         

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'
}         
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'
}         

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': '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',
'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'
}         

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': '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',
'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'
}         

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': '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',
'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': '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',
'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'
}         
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'
}         

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'
}         
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'
}         

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'
}         
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'
}         

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'
}         
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'
}         

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'
}         
CODE
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'cm360': '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)',
'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'
}         
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'
}         

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

CODE
Media Cost
CODE
media_cost

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

CODE
Impressions
CODE
impressions

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

CODE
Clicks
CODE
clicks

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

CODE
Total Conversions
CODE
total_conversions

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

CODE
Total Revenue
CODE
total_revenue

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

CODE
Video Plays
CODE
video_plays

cm_video_views

The number of impressions for which a video clip was played. An event is logged only once per impression. (CM360)

Metrics

CODE
Video Views
CODE
video_views

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

CODE
Video Midpoints
CODE
video_midpoints

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

CODE
Video Completions
CODE
video_completions

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)
CODE
effective_cpm
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.