Skip to main content
Skip table of contents

Data Library Field Mapping - AdGroup Performance

Overview

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

To understand which Alli Data Datasources are used within the adgroup_performance report, see the following link: Data Library 2.0 Report DAGs | adgroup_performance & https://agencypmg.atlassian.net/wiki/spaces/PTD/whiteboard/3019210793

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',
'facebook ads': 'Date',
'google ads': 'Date',
'linkedin ads': 'Date',
'microsoft ads': 'Date',
'pinterest ads': 'Date',
'snapchat ads': 'Date',
'twitter ads': 'Date',
'tiktok ads': 'Date',
'the trade desk': 'date',
'yahoo dsp': 'Date',
'reddit ads': 'Date',
'apple search ads': 'Date',
'vistar dsp': 'Day',
'criteo': 'Date',
'taboola': 'Date'
}
CODE 
{
'amazon dsp': 'date',
'bidtellect': 'ndsp_client_reporting_hour_date',
'dv360': 'filter_date',
'facebook ads': 'date_start',
'google ads': 'date',
'linkedin ads': 'date',
'microsoft ads': 'TimePeriod',
'pinterest ads': 'date',
'snapchat ads': 'date',
'twitter ads': 'date',
'tiktok ads': 'date',
'the trade desk': 'date',
'yahoo dsp': 'day',
'reddit ads': 'date',
'apple search ads': 'date',
'vistar dsp': 'date',
'criteo': 'day',
'taboola': 'date'
}

core_media_channel

The channel that the platform is a part of

Categorization

N/A

N/A

platform

The Platform the Campaign belongs to. (Hard Coded)

Dimensions

N/A

CODE 
{
'amazon dsp': 'Amazon DSP',
'bidtellect': 'Bidtellect',
'dv360': 'DV360',
'facebook ads': 'Facebook Ads',
'google ads': 'Google Ads',
'linkedin ads': 'LinkedIn Ads',
'microsoft ads': 'Microsoft Bing',
'pinterest ads': 'Pinterest Ads',
'snapchat ads': 'Snapchat Ads',
'twitter ads': 'Twitter Ads',
'tiktok ads': 'TikTok Ads',
'the trade desk': 'The Trade Desk',
'yahoo dsp': 'Yahoo DSP',
'reddit ads': 'Reddit Ads',
'apple search ads': 'Apple Search Ads',
'vistar dsp': 'Vistar DSP',
'criteo': 'Criteo',
'taboola': 'Taboola'
}

publisher_platform

The Publisher Platform on where the Campaign Delivered Ads

For Twitter Ads, there are Datasources that pull data from Ads on Twitter and the Twitter Audience Network which is hardcoded into this column.

Dimensions

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Publisher Platform',
'google ads': 'Networks',
'linkedin ads': 'N/A',
'microsoft ads': 'Ad Distribution',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': '',
'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'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'publisher_platform',
'google ads': 'ad_network_type',
'linkedin ads': 'N/A',
'microsoft ads': 'AdDistribution',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'Ads on Twitter',
'tiktok ads': 'placement',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

account_id

The Ad Account Identifier

Dimensions

CODE 
{
'amazon dsp': 'Advertiser Id',
'bidtellect': 'Brand Id',
'dv360': 'Advertiser ID',
'facebook ads': 'Account ID',
'google ads': 'Account ID',
'linkedin ads': 'TBD',
'microsoft ads': 'Account ID',
'pinterest ads': 'Account ID',
'snapchat ads': 'Account',
'twitter ads': 'Account ID',
'tiktok ads': 'Account',
'the trade desk': 'Advertiser ID',
'yahoo dsp': 'Advertiser ID',
'reddit ads': 'Account ID',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'Advertiser ID'
}
CODE 
{
'amazon dsp': 'advertiserid',
'bidtellect': 'ndsp_client_reporting_customer_brand_id',
'dv360': 'filter_advertiser',
'facebook ads': 'account_id',
'google ads': 'customer_id',
'linkedin ads': 'account',
'microsoft ads': 'accountid',
'pinterest ads': 'advertiser_id',
'snapchat ads': 'accountId',
'twitter ads': 'account_id',
'tiktok ads': 'advertiser_id',
'the trade desk': 'advertiser_id',
'yahoo dsp': 'advertiser_id',
'reddit ads': 'account_id',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'AdvertiserId',
'taboola': 'advertiser_id'
}

account_name

The Ad Account Name

Dimensions

CODE 
{
'amazon dsp': 'Advertiser Name',
'bidtellect': 'Brand',
'dv360': 'Advertiser',
'facebook ads': 'Account Name',
'google ads': 'Account',
'linkedin ads': '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'
}
CODE 
{
'amazon dsp': 'advertisername',
'bidtellect': 'ndsp_client_reporting_customer_brand_name',
'dv360': 'filter_advertiser_name',
'facebook ads': 'account_name',
'google ads': 'customer_name',
'linkedin ads': 'name',
'microsoft ads': 'AccountName',
'pinterest ads': 'advertiser_name',
'snapchat ads': 'accountName',
'twitter ads': 'account_name',
'tiktok ads': 'advertiser_name',
'the trade desk': 'advertiser_name',
'yahoo dsp': 'advertiser_name',
'reddit ads': 'account_name',
'apple search ads': 'N/A',
'vistar dsp': 'advertiser_name',
'criteo': 'Advertiser',
'taboola': 'advertiser_name'
}

campaign_id

The Campaign Identifier

Dimensions

CODE 
{
'amazon dsp': 'Order ID',
'bidtellect': 'Insertion Order Id',
'dv360': 'Insertion Order ID',
'facebook ads': 'Campaign Id',
'google ads': 'Campaign ID',
'linkedin ads': 'N/A',
'microsoft ads': 'Campaign ID',
'pinterest ads': 'Campaign ID',
'snapchat ads': 'Campaign Id',
'twitter ads': 'Campaign ID',
'tiktok ads': 'Campaign ID'
'the trade desk': 'Campaign ID',
'yahoo dsp': 'Campaign ID',
'reddit ads': 'Campaign Id',
'apple search ads': 'Campaign Id',
'vistar dsp': 'N/A',
'criteo': 'Campaign Id',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'orderid',
'bidtellect': 'ndsp_client_reporting_campaign_id',
'dv360': 'filter_insertion_order',
'facebook ads': 'campaign_id',
'google ads': 'campaign_id',
'linkedin ads': 'campaigngroup',
'microsoft ads': 'campaignid',
'pinterest ads': 'id',
'snapchat ads': 'campaignid',
'twitter ads': 'campaign_id',
'tiktok ads': 'campaign_id',
'the trade desk': 'campaign_id',
'yahoo dsp': 'campaign_id',
'reddit ads': 'id',
'apple search ads': 'campaignid',
'vistar dsp': 'insertion_order',
'criteo': 'CampaignId',
'taboola': 'N/A'
}

campaign_name

The Campaign Name

Dimensions

CODE 
{
'amazon dsp': 'Order name',
'bidtellect': 'Insertion Order Name',
'dv360': 'Insertion Order',
'facebook ads': 'Campaign',
'google ads': 'Campaign',
'linkedin ads': 'N/A',
'microsoft ads': 'Campaign',
'pinterest ads': 'Campaign name',
'snapchat ads': 'Campaign Name',
'twitter ads': 'Campaign Name',
'tiktok ads': 'Campaign Name'
'the trade desk': 'Campaign',
'yahoo dsp': 'Campaign Name',
'reddit ads': 'Campaign Name',
'apple search ads': 'Campaign Name',
'vistar dsp': 'Insertion Order',
'Criteo': 'Campaign',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'ordername',
'bidtellect': 'ndsp_client_reporting_campaign_name',
'dv360': 'filter_insertion_name',
'facebook ads': 'campaign_name',
'google ads': 'campaign_name',
'linkedin ads': 'name',
'microsoft ads': 'campaignname',
'pinterest ads': 'name',
'snapchat ads': 'campaignname',
'twitter ads': 'campaign_name',
'tiktok ads': 'campaign_name',
'the trade desk': 'campaign',
'yahoo dsp': 'campaign_name',
'reddit ads': 'name',
'apple search ads': 'N/A',
'vistar dsp': 'insertion_order_name',
'Criteo': 'Campaign',
'taboola': 'N/A'
}

campaign_status

The Current Campaign Status

Dimensions

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Status',
'google ads': 'Campaign status',
'linkedin ads': 'N/A',
'microsoft ads': 'Status',
'pinterest ads': 'Status',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A'
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Status',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'Delivery status',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_campaign_status',
'dv360': 'N/A',
'facebook ads': 'effective_status',
'google ads': 'campaign_status',
'linkedin ads': 'N/A',
'microsoft ads': 'campaignstatus',
'pinterest ads': 'status',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'effective_status',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

campaign_type

The Campaign Type

Dimensions

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'Campaign type',
'linkedin ads': 'N/A',
'microsoft ads': 'Campaign type',
'pinterest ads': 'Type',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A'
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Objective',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'campaign_advertising_channel_type',
'linkedin ads': 'N/A',
'microsoft ads': 'campaigntype',
'pinterest ads': 'type',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

campaign_objective

The Objective of the Campaign

Dimensions

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Objective',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Objective',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'Objective',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Objective',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'objective',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'objective_type',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'objective_type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'objective',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

campaign_daily_budget

The Daily Budget of the Campaign

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Budget',
'google ads': 'Budget',
'linkedin ads': 'N/A',
'microsoft ads': 'Budget',
'pinterest ads': 'Daily Budget',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A'
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'daily_budget/100',
'google ads': 'campaign_budget_amount',
'linkedin ads': 'N/A',
'microsoft ads': 'dailybudget',
'pinterest ads': 'daily_spend_cap',
'snapchat ads': 'N/A',
'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': 'Oder start date',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Starts',
'google ads': 'Campaign start date',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Campaign start date',
'snapchat ads': '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': 'orderstartdate',
'bidtellect': 'ndsp_client_reporting_campaign_start_date',
'dv360': 'N/A',
'facebook ads': 'start_time',
'google ads': 'campaign_start_date',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'start_time',
'snapchat ads': 'N/A',
'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': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Ends',
'google ads': 'Campaign end date',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Campaign end date',
'snapchat ads': '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': 'orderenddate',
'bidtellect': 'ndsp_client_reporting_campaign_end_date',
'dv360': 'N/A',
'facebook ads': 'stop_time',
'google ads': 'campaign_end_date',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'end_time',
'snapchat ads': 'N/A',
'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': 'Camapign ID',
'dv360': 'coalesce(Toutube Ad Group ID, Line Item ID)',
'facebook ads': 'Ad set ID',
'google ads': 'Ad group ID',
'linkedin ads': 'Campaign ID',
'microsoft ads': 'Ad group ID',
'pinterest ads': 'Ad group ID',
'snapchat ads': 'Ad Sets Id',
'twitter ads': 'TBD',
'tiktok ads': 'Adgroup ID',
'the trade desk': 'Ad Group ID',
'yahoo dsp': 'TBD',
'reddit ads': 'Adgroup Id',
'apple search ads': 'Ad Group Id',
'vistar dsp': 'N/A',
'criteo': 'Adset Id',
'taboola': 'Line ID'
}
CODE 
{
'amazon dsp': 'lineitemid',
'bidtellect': 'ndsp_client_reporting_campaign_id',
'dv360': 'coalesce(filter_trueview_ad_group_ad_id, filter_line_item)',
'facebook ads': 'adset_id',
'google ads': 'ad_group_id',
'linkedin ads': 'campaignid',
'microsoft ads': 'adgroupid',
'pinterest ads': 'id',
'snapchat ads': 'adsquadid',
'twitter ads': 'line_item_id',
'tiktok ads': 'adgroup_id',
'the trade desk': 'ad_group_id',
'yahoo dsp': 'line_id',
'reddit ads': 'adgroup_id',
'apple search ads': 'adgroupid',
'vistar dsp': 'campaign' or 'campaign_id',
'criteo': 'AdsetId',
'taboola': 'campaign'
}

adgroup_name

The Adgroup Name

Dimensions

CODE 
{
'amazon dsp': 'Line item name',
'bidtellect': 'Campaign Name',
'dv360': 'coalesce(Toutube Ad Group, Line Item)',
'facebook ads': 'Ad Set Name',
'google ads': 'Ad group',
'linkedin ads': 'Campaign Name',
'microsoft ads': 'Ad group',
'pinterest ads': 'Ad group name',
'snapchat ads': 'Ad Sets Name',
'twitter ads': 'TBD',
'tiktok ads': 'Adgroup Name',
'the trade desk': 'Ad Group',
'yahoo dsp': 'TBD',
'reddit ads': 'Adgroup Name',
'apple search ads': 'Ad Group Name',
'vistar dsp': 'Campaign',
'criteo': 'Ad set',
'taboola': 'Line Name'
}
CODE 
{
'amazon dsp': 'lineitemname',
'bidtellect': 'ndsp_client_reporting_campaign_name',
'dv360': 'coalesce(filter_trueview_ad_group, filter_line_item_name)',
'facebook ads': 'adset_name',
'google ads': 'ad_group_name',
'linkedin ads': 'campaignname',
'microsoft ads': 'adgroupname',
'pinterest ads': 'name',
'snapchat ads': 'adsquadname',
'twitter ads': 'line_item_name',
'tiktok ads': 'adgroup_name',
'the trade desk': 'ad_group',
'yahoo dsp': 'line_name',
'reddit ads': 'name',
'apple search ads': 'adgroupname',
'vistar dsp': 'campaign_name',
'criteo': 'Adset',
'taboola': 'campaign_name'
}

adgroup_type

The Adgroup Type

Dimensions

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'TBD',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'type',
'linkedin ads': 'Campaign Type',
'microsoft ads': 'N/A',
'pinterest ads': 'type',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_goal_type',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'ad_group_type',
'linkedin ads': 'type',
'microsoft ads': 'N/A',
'pinterest ads': 'type',
'snapchat ads': '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'
}

adgroup_status

The Current Adgroup Status

Dimensions

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'Campaign Status',
'dv360': 'N/A',
'facebook ads': 'Status',
'google ads': 'Status (under Ad group tab)',
'linkedin ads': 'N/A',
'microsoft ads': 'Status: All ad groups',
'pinterest ads': 'Ad group Status',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Status',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_campaign_status',
'dv360': 'N/A',
'facebook ads': 'effective_status',
'google ads': 'ad_group_status',
'linkedin ads': 'status',
'microsoft ads': 'status',
'pinterest ads': 'status',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'effective_status',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

line_item_id

The Line Item Identifier

Dimensions

CODE 
{
'amazon dsp': 'Line Item ID',
'bidtellect': 'Campaign Id',
'dv360': 'Line Item ID',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'Campaign ID',
'microsoft ads': 'N/A',
'pinterest ads': 'Ad group ID',
'snapchat ads': 'Ad Sets Id',
'twitter ads': 'TBD',
'tiktok ads': 'Adgroup ID',
'the trade desk': 'Ad Group ID',
'yahoo dsp': 'TBD',
'reddit ads': 'Adgroup Id',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'Line ID'
}
CODE 
{
'amazon dsp': 'lineitemid',
'bidtellect': 'ndsp_client_reporting_insertion_order_id',
'dv360': 'filter_line_item',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'campaignid',
'microsoft ads': 'N/A',
'pinterest ads': 'id',
'snapchat ads': 'adsquadid',
'twitter ads': 'line_item_id',
'tiktok ads': 'adgroup_id',
'the trade desk': 'ad_group_id',
'yahoo dsp': 'line_id',
'reddit ads': 'id',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'campaign'
}

line_item_name

The Line Item Name

Dimensions

CODE 
{
'amazon dsp': 'Line item name',
'bidtellect': 'Campaign Name',
'dv360': 'Line Item',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'Campaign Name',
'microsoft ads': 'N/A',
'pinterest ads': 'Ad group name',
'snapchat ads': 'Ad Sets Name',
'twitter ads': 'TBD',
'tiktok ads': 'Adgroup Name',
'the trade desk': 'Ad Group',
'yahoo dsp': 'TBD',
'reddit ads': 'Adgroup Name',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'Line Name'
}
CODE 
{
'amazon dsp': 'lineitemname',
'bidtellect': 'ndsp_client_reporting_insertion_order_name',
'dv360': 'filter_line_item_name',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'campaignname',
'microsoft ads': 'N/A',
'pinterest ads': 'name',
'snapchat ads': 'adsquadname',
'twitter ads': 'line_item_name',
'tiktok ads': 'adgroup_name',
'the trade desk': 'ad_group',
'yahoo dsp': 'line_name',
'reddit ads': 'name',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'campaign_name'
}

ad_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 Data Library

Dimensions

N/A

CODE 
{
'amazon dsp': 'DISPLAY',
'bidtellect': 'DISPLAY',
'dv360': 'DISPLAY',
'facebook ads': 'SOCIAL',
'google ads': 'SEARCH',
'linkedin ads': 'SOCIAL',
'microsoft ads': 'SEARCH',
'pinterest ads': 'SOCIAL',
'snapchat ads': 'SOCIAL',
'twitter ads': 'SOCIAL',
'tiktok ads': 'SOCIAL',
'the trade desk': 'DISPLAY',
'yahoo dsp': 'DISPLAY',
'reddit ads': 'SOCIAL',
'apple search ads': 'SEARCH',
'vistar dsp': 'DISPLAY',
'criteo': 'DISPLAY',
'taboola': 'DISPLAY'
}

cost

Costs (Ad Spend)

Metrics

CODE 
{
'amazon dsp': 'Total cost',
'bidtellect': 'Spend',
'dv360': 'Revenue (Advertiser Currency)',
'facebook ads': 'Amount Spend',
'google ads': 'Cost',
'linkedin ads': 'Total Spent',
'microsoft ads': 'Spend',
'pinterest ads': 'Spend',
'snapchat ads': 'Spend',
'twitter ads': 'Spend',
'tiktok ads': 'Total cost',
'the trade desk': 'Advertiser Cost (USD)',
'yahoo dsp': 'Cost',
'reddit ads': 'Amount Spent',
'apple search ads': 'Spend',
'vistar dsp': 'Revenue',
'criteo': 'Cost',
'taboola': 'Spent'
}
CODE 
{
'amazon dsp': 'totalcost',
'bidtellect': 'ndsp_client_reporting_spend',
'dv360': 'metric_revenue_advertiser',
'facebook ads': 'spend',
'google ads': 'cost',
'linkedin ads': 'costinusd',
'microsoft ads': 'spend',
'pinterest ads': 'spend_in_dollar',
'snapchat ads': 'spend',
'twitter ads': 'billed_charge_local_micro / 1000000',
'tiktok ads': 'spend',
'the trade desk': 'advertiser_cost_usd',
'yahoo dsp': 'cost',
'reddit ads': 'spend / 1000000',
'apple search ads': 'localspend',
'vistar dsp': 'client_revenue',
'criteo': 'AdvertiserCost',
'taboola': 'spent'
}

impressions

Impressions

Metrics

CODE 
{
'amazon dsp': 'Impressions',
'bidtellect': 'Impressions',
'dv360': 'Impressions',
'facebook ads': 'Impressions',
'google ads': 'Impr.',
'linkedin ads': 'Impressions',
'microsoft ads': 'Impr.',
'pinterest ads': 'Impr.',
'snapchat ads': 'Paid Impressions',
'twitter ads': 'Impressions',
'tiktok ads': 'Impressions',
'the trade desk': 'Impressions',
'yahoo dsp': 'impressions',
'reddit ads': 'Impressions',
'apple search ads': 'Impressions',
'vistar dsp': 'Impressions',
'criteo': 'Displays',
'taboola': 'Impressions'
}
CODE 
{
'amazon dsp': 'impressions',
'bidtellect': 'ndsp_client_reporting_impressions',
'dv360': 'metric_impressions',
'facebook ads': 'impressions',
'google ads': 'impressions',
'linkedin ads': 'impressions',
'microsoft ads': 'impressions',
'pinterest ads': 'impressions_1 + impressions_2',
'snapchat ads': 'impressions',
'twitter ads': 'impressions',
'tiktok ads': 'impressions',
'the trade desk': 'impressions',
'yahoo dsp': 'impressions',
'reddit ads': 'impressions',
'apple search ads': 'impressions',
'vistar dsp': 'impressions',
'criteo': 'Displays',
'taboola': 'impressions'
}

clicks

Clicks

Metrics

CODE 
{
'amazon dsp': 'Click-throughs',
'bidtellect': 'Clicks',
'dv360': 'Clicks',
'facebook ads': 'Link clicks',
'google ads': 'Clicks',
'linkedin ads': 'Clicks',
'microsoft ads': 'Clicks',
'pinterest ads': 'Result: Clicks',
'snapchat ads': 'Clicks',
'twitter ads': 'Clicks',
'tiktok ads': 'Clicks (Destination)',
'the trade desk': 'Clicks',
'yahoo dsp': 'Clicks',
'reddit ads': 'Clicks',
'apple search ads': 'Taps',
'vistar dsp': 'N/A',
'criteo': 'Clicks',
'taboola': 'Clicks'
}
CODE 
{
'amazon dsp': 'clickthroughs',
'bidtellect': 'ndsp_client_reporting_clicks',
'dv360': 'metric_clicks',
'facebook ads': 'inline_link_clicks',
'google ads': 'clicks',
'linkedin ads': 'landingpageclicks',
'microsoft ads': 'clicks',
'pinterest ads': 'clickthrough_1 + clickthrough_2',
'snapchat ads': 'swipes',
'twitter ads': 'url_clicks',
'tiktok ads': 'clicks',
'the trade desk': 'clicks',
'yahoo dsp': 'clicks',
'reddit ads': 'clicks',
'apple search ads': 'taps',
'vistar dsp': 'N/A',
'criteo': 'Clicks',
'taboola': 'clicks'
}

landing_page_views

The Number of Landing Page Views

Metrics

N/A

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

reach

Reach

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'reach',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Reach',
'snapchat ads': 'Paid Reach',
'twitter ads': 'N/A',
'tiktok ads': 'Reach',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'reach',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_impression_user',
'snapchat ads': 'uniques',
'twitter ads': 'N/A',
'tiktok ads': 'reach',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

conversions

The Number of Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'Conversions',
'linkedin ads': 'Conversions',
'microsoft ads': 'Conv.',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'Conversion',
'the trade desk': 'N/A',
'yahoo dsp': 'Conversions',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'Sales',
'taboola': 'Conversions'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'conversions',
'linkedin ads': 'externalwebsiteconversions',
'microsoft ads': 'conversions',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'conversion',
'the trade desk': 'N/A',
'yahoo dsp': 'conversions',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'SalesClientAttribution',
'taboola': 'actions'
}

conversions_value

The Value associated with Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'Conv. value',
'linkedin ads': 'N/A',
'microsoft ads': 'Revenue',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'Conversion Value',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'Revenue',
'taboola': 'Conversion Value'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'conversions_value',
'linkedin ads': 'N/A',
'microsoft ads': 'revenue',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'conversion_value',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'RevenueGeneratedClientAttribution',
'taboola': 'conversions_value'
}

purchase_conversions

The Number of Purchase Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Website Purchases',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total conversions (Checkout)',
'snapchat ads': 'Conversions: Purchases + 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'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'action_offsite_conversion_fb_pixel_purchase',
'google ads': 'case when conversion_action_category = 'PURCHASE' then conversions',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_checkout',
'snapchat ads': 'conversion_purchases',
'twitter ads': 'conversion_purchases_metric',
'tiktok ads': 'total_purchase',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'purchase_view_through_conversions+ purchase_click_through_conversions'(of all attribution window)',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

purchase_conversions_value

The Value associated with the Purchase Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Website Purchases Conversion Value',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total order value (Checkout)',
'snapchat ads': 'Conversions: Purchases Value + 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'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'action_values_offsite_conversion_fb_pixel_purchase',
'google ads': 'case when conversion_action_category = 'PURCHASE' then conversions_value',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_checkout_value_in_micro_dollar/1000000',
'snapchat ads': 'conversion_purchases_value',
'twitter ads': 'conversion_purchases_sale_amount',
'tiktok ads': 'total_purchase_value',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'conversion_purchase_total_value',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

add_to_cart_conversions

The Number of Add To Cart Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Adds to cart',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total conversions (Add to cart)',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'Total Add-to-cart',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Add to Cart: purchase',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'action_offsite_conversion_fb_pixel_add_to_cart',
'google ads': 'case when conversion_action_category = 'ADD_TO_CART' then conversions',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_click_add_to_cart',
'snapchat ads': 'conversion_add_cart',
'twitter ads': 'N/A',
'tiktok ads': 'total_app_event_add_to_cart',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'add_to_cart_click_through_conversions+add_to_cart_view_through_conversions(of all attribution window)',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

add_to_cart_conversions_value

The Value associated with the Add to Cart Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'Add-to-cart Total Value',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'conversion: add to cart value',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'case when conversion_action_category = 'ADD_TO_CART' then conversions_value',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'total_app_event_add_to_cart_value',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'conversion_add_to_cart_total_value',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

app_install_conversions

The Number of App Install Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'App installs',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'App Installs',
'twitter ads': 'N/A',
'tiktok ads': 'App Install',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': '(MMP) Total App Installs',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'Post-Install Sales',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'action_mobile_app_install',
'google ads': 'case when conversion_action_category = 'APP_INSTALL' then conversions',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'total_installs',
'twitter ads': 'N/A',
'tiktok ads': 'app_install',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'app_install_metrics_install',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'PostInstallSales',
'taboola': 'N/A'
}

app_install_conversions_value DEPRECATED

The Value associated with App Install Conversions.

This column is currently deprecated and will be removed in a future version of Data Library

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'Post-Install Order Value',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'case when conversion_action_category = 'APP_INSTALL' then conversions_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'
}

sign_up_conversions

The Number of Sign Up Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'Registration completed',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total conversions (Signup)',
'snapchat ads': 'Conversions: Sign Ups',
'twitter ads': 'TBD',
'tiktok ads': 'Total Registration',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Sign Up: Purchase',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'action_offsite_conversion_fb_pixel_complete_registration',
'google ads': 'case when conversion_action_category = 'SIGNUP' then conversions',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_signup',
'snapchat ads': 'conversion_sign_ups',
'twitter ads': 'conversion_sign_ups',
'tiktok ads': 'total_registration',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

sign_up_conversions_value

The Value associated with Sign Up Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total order value (Signup)',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'case when conversion_action_category = 'SIGNUP' then conversions_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'
}

total_conversions

The Total Number of Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'TBD',
'dv360': 'N/A',
'facebook ads': 'Actions',
'google ads': 'All conv.',
'linkedin ads': 'N/A',
'microsoft ads': 'Conv.',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'Conversion',
'the trade desk': 'Total Click + View Conversions 01',
'yahoo dsp': 'Conversions',
'reddit ads': 'N/A',
'apple search ads': 'installs',
'vistar dsp': 'N/A',
'criteo': 'Sales',
'taboola': 'Conversions'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_total_conversions',
'dv360': 'metric_last_clicks + metric_last_impressions',
'facebook ads': 'actions',
'google ads': 'all_conversions',
'linkedin ads': 'N/A',
'microsoft ads': 'conversions',
'pinterest ads': 'total_conversions',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'conversion',
'the trade desk': 'total_click_view_conversions_01',
'yahoo dsp': 'conversions',
'reddit ads': 'N/A',
'apple search ads': 'installs',
'vistar dsp': 'N/A',
'criteo: 'SalesAllClientAttribution',
'taboola': 'actions'
}

total_conversions_value

The Value associated with the Total Number of Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'All conv. value',
'linkedin ads': 'N/A',
'microsoft ads': 'Revenue',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'Total Click + View Conversion Revenue 01',
'yahoo dsp': 'TBD',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'cretio': 'Revenue',
'taboola': 'Conversion Value'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'metric_cm360_post_click_revenue + metric_cm360_post_view_revenue',
'facebook ads': 'N/A',
'google ads': 'all_conversions_value',
'linkedin ads': 'N/A',
'microsoft ads': 'revenue',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'total_click_view_conversion_revenue_01',
'yahoo dsp': 'conversions_value',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'RevenueGeneratedAllClientAttribution',
'taboola': 'conversions_value'
}

click_through_conversions

The Number of Click Through Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'TBD',
'dv360': 'TBD',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'Post-Click Conversions',
'microsoft ads': 'N/A',
'pinterest ads': 'Total click-through conversions (Checkout)',
'snapchat ads': 'Conversions: 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'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_click_through_conversions',
'dv360': 'metric_last_clicks',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'externalwebsitepostclickconversions',
'microsoft ads': 'N/A',
'pinterest ads': 'total_click_checkout',
'snapchat ads': 'conversion_purchases_swipe_up',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'click_conversion_01',
'yahoo dsp': 'click_through_conversions',
'reddit ads': 'purchase_click_through_conversions_attribution_window_{day/week/month}',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'actions_num_from_clicks'
}

click_through_conversions_value

The Value associated with the Click Through Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'TBD',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total click-through order value (Checkout)',
'snapchat ads': 'Conversions: 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'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'metric_cm_post_click_revenue',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_click_checkout_value_in_micro_dollar/1000000',
'snapchat ads': 'conversion_purchases_value_swipe_up',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'click_conversion_revenue_01',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

view_through_conversions

The Number of View Through Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'TBD',
'dv360': 'TBD',
'facebook ads': 'N/A',
'google ads': 'View-through conv.',
'linkedin ads': 'View-through Conversions',
'microsoft ads': 'N/A',
'pinterest ads': 'Total view-through conversions (Checkout)',
'snapchat ads': 'Conversions: Purchases View',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'View Through Conversion 01',
'yahoo dsp': 'View Through Conversion',
'reddit ads': 'View: Purchase',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'View Through Conversion'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_view_through_conversions',
'dv360': 'metric_last_impressions',
'facebook ads': 'N/A',
'google ads': 'view_through_conversions',
'linkedin ads': 'externalwebsitepostviewconversions',
'microsoft ads': 'N/A',
'pinterest ads': 'total_view_checkout',
'snapchat ads': 'conversion_purchases_view',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'view_through_conversion_01',
'yahoo dsp': 'view_through_conversions',
'reddit ads': 'purchase_view_through_conversions_attribution_window_{day/week/month}',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'actions_num_from_views'
}

view_through_conversions_value

The Value associated with the View Through Conversions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'TBD',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total view-through conversions (Checkout)',
'snapchat ads': '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'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'metric_cm_post_view_revenue',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_view_checkout_value_in_micro_dollar/1000000',
'snapchat ads': 'conversion_purchases_value_view',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'view_through_conversion_revenue_01',
'yahoo dsp': 'N/A',
'reddit ads': 'N/A',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

video_starts

Video Starts

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'Video Started',
'dv360': 'N/A',
'facebook ads': 'Video plays',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total video starts',
'snapchat ads': 'N/A',
'twitter ads': 'Video starts',
'tiktok ads': 'Video views',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Video Starts',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_starts',
'dv360': 'N/A',
'facebook ads': 'action_video_play',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_p0_combined',
'snapchat ads': 'N/A',
'twitter ads': 'video_content_starts',
'tiktok ads': 'video_play_actions',
'the trade desk': 'N/A',
'yahoo dsp': 'video_views_starts',
'reddit ads': 'video_started',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

video_views

Video Views

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'TrueView: Views',
'facebook ads': '3-second video plays',
'google ads': 'Views',
'linkedin ads': 'Video Views',
'microsoft ads': 'N/A',
'pinterest ads': 'Video views',
'snapchat ads': '2 Second Video Views',
'twitter ads': '3s/100% video views',
'tiktok ads': '2-second video views',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Video Views',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'metric_trueview_views',
'facebook ads': 'action_video_view',
'google ads': 'video_views',
'linkedin ads': 'videoviews',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_mrc_views',
'snapchat ads': 'video_views',
'twitter ads': 'video_3s100pct_views',
'tiktok ads': 'video_watched_2s',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'video_viewable_impressions',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

video_3s_watched

Video 3-Second Watched

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': '3s video views',
'snapchat ads': 'N/A',
'twitter ads': '3s/100% video views',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': '3 Second Views',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_3sec_views',
'snapchat ads': 'N/A',
'twitter ads': 'video_3s100pct_views',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'video_watched_3_seconds',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

video_p25_watched

Video Completions - 25%

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'Video Q1',
'dv360': 'First-Quartile Views (Video)',
'facebook ads': 'Video plays at 25%',
'google ads': 'Video played to 25%',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total video played at 25%',
'snapchat ads': 'Video Plays at 25%',
'twitter ads': 'Video played 25%',
'tiktok ads': 'Video views at 25%',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Watches at 25%',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_first_quartiles',
'dv360': 'metric_rich_media_video_first_quartile_completes',
'facebook ads': 'video_p25_watched_actions',
'google ads': 'video_views * video_quartile_p25_rate',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_p25_combined',
'snapchat ads': 'quartile_1',
'twitter ads': 'video_views_25',
'tiktok ads': 'video_views_p25',
'the trade desk': 'N/A',
'yahoo dsp': 'video_25p_completions',
'reddit ads': 'video_watched_25_percent',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

video_p50_watched

Video Completions - 50%

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'Video Midpoint',
'dv360': 'Midpoint Views(Video)',
'facebook ads': 'Video plays at 50%',
'google ads': 'Video played to 50%',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total video played at 50%',
'snapchat ads': 'Video Plays at 50%',
'twitter ads': 'Video played 50%',
'tiktok ads': 'Video views at 50%',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Watches at 50%',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_mid_points',
'dv360': 'metric_rich_media_video_midpoints',
'facebook ads': 'video_p50_watched_actions',
'google ads': 'video_views * video_quartile_p50_rate',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_p50_combined',
'snapchat ads': 'quartile_2',
'twitter ads': 'video_views_50',
'tiktok ads': 'video_views_p50',
'the trade desk': 'N/A',
'yahoo dsp': 'video_50p_completions',
'reddit ads': 'video_watched_50_percent',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

video_p75_watched

Video Completions - 75%

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'Video Q3',
'dv360': 'Third-Quartile Views (Video)',
'facebook ads': 'Video plays at 75%',
'google ads': 'Video played to 75%',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total video played at 75%',
'snapchat ads': 'Video Plays at 75%',
'twitter ads': 'Video played 75%',
'tiktok ads': 'Video views at 75%',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Watches at 75%',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_third_quartiles',
'dv360': 'metric_rich_media_video_third_quartile_completes',
'facebook ads': 'video_p75_watched_actions',
'google ads': 'video_views * video_quartile_p75_rate',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_p75_combined',
'snapchat ads': 'quartile_3',
'twitter ads': 'video_views_75',
'tiktok ads': 'video_views_p75',
'the trade desk': 'N/A',
'yahoo dsp': 'video_75p_completions',
'reddit ads': 'video_watched_75_percent',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

video_p95_watched

Video Completions - 95%

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'N/A',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Total video played at 95%',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Watches at 95%',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'N/A',
'dv360': 'N/A',
'facebook ads': 'video_p95_watched_actions',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_p95_combined',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'video_watched_95_percent',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}

video_p100_watched

Video Completions

Metrics

CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'Video Completed',
'dv360': 'Complete Views (Video)',
'facebook ads': 'Video plays at 100%',
'google ads': 'Video played to 100%',
'linkedin ads': 'Video Completions',
'microsoft ads': 'N/A',
'pinterest ads': 'Total video played at 100%',
'snapchat ads': 'Video Completions',
'twitter ads': 'Video completions',
'tiktok ads': 'Video views at 100%',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'reddit ads': 'Watches at 100%',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'amazon dsp': 'N/A',
'bidtellect': 'ndsp_client_reporting_video_completes',
'dv360': 'metric_rich_media_video_completions',
'facebook ads': 'video_p100_watched_actions',
'google ads': 'video_views * video_quartile_p100_rate',
'linkedin ads': 'videocompletions',
'microsoft ads': 'N/A',
'pinterest ads': 'total_video_p100_complete',
'snapchat ads': 'view_completion',
'twitter ads': 'video_views_100',
'tiktok ads': 'video_views_p100',
'the trade desk': 'N/A',
'yahoo dsp': 'video_completions',
'reddit ads': 'video_watched_100_percent',
'apple search ads': 'N/A',
'vistar dsp': 'N/A',
'criteo': 'N/A',
'taboola': 'N/A'
}
JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close