Breadcrumbs

Data Library Field Mapping - Inventory Performance

Overview

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


Platforms include:

  • Amazon DSP

  • DV360

  • Google Ads

  • The Trade Desk

  • Yahoo DSP


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


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

 
{
'amazon dsp': 'Date',
'dv360': 'Date',
'google ads': 'Date',
'the trade desk': 'Date',
'yahoo dsp': 'Date',
'teads': 'Day',
}

{
'amazon dsp': 'date',
'dv360': 'filter_date',
'google ads': 'date',
'the trade desk': 'date',
'yahoo dsp': 'day',
'teads': 'day',
}

core_media_channel

The channel that the platform is a part of

Categorization

N/A

N/A

platform

The Platform the Campaign belongs to. (Hard Coded)

Dimensions

N/A

 
{
'amazon dsp': 'Amazon DSP',
'dv360': 'DV360',
'google ads': 'Google Ads',
'the trade desk': 'The Trade Desk',
'yahoo dsp': 'Yahoo DSP',
'teads': 'Teads',
}

publisher_platform

The Publisher Platform on where the Campaign Delivered Ads

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

Dimensions

 
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'Networks',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'ad_network_type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

account_id

The Ad Account Identifier

Dimensions

 
{
'amazon dsp': 'Advertiser Id',
'dv360': 'Advertiser ID',
'google ads': 'Account ID',
'the trade desk': 'Advertiser ID',
'yahoo dsp': 'Advertiser ID',
'teads': 'Advertiser ID',
}

{
'amazon dsp': 'advertiserid',
'dv360': 'filter_advertiser',
'google ads': 'customer_id',
'the trade desk': 'advertiser_id',
'yahoo dsp': 'advertiser_id',
'teads': 'advertiser_id',
}

account_name

The Ad Account Name

Dimensions

 
{
'amazon dsp': 'Advertiser Name',
'dv360': 'Advertiser',
'google ads': 'Account',
'the trade desk': 'Advertiser',
'yahoo dsp': 'Advertiser Name',
'teads': 'Advertiser Name',
}

{
'amazon dsp': 'advertisername',
'dv360': 'filter_advertiser_name',
'google ads': 'customer_name',
'the trade desk': 'advertiser_name',
'yahoo dsp': 'advertiser_name',
'teads': 'advertiser_name',
}

campaign_id

The Campaign Identifier

Dimensions

 
{
'amazon dsp': 'Order ID',
'dv360': 'Insertion Order ID',
'google ads': 'Campaign ID',
'the trade desk': 'Campaign ID',
'yahoo dsp': 'Campaign ID',
'teads': 'Campaign ID',
}

{
'amazon dsp': 'orderid',
'dv360': 'filter_insertion_order',
'google ads': 'campaign_id',
'the trade desk': 'campaign_id',
'yahoo dsp': 'campaign_id',
'teads': 'ad_id',
}

campaign_name

The Campaign Name

Dimensions

 
{
'amazon dsp': 'Order Name',
'dv360': 'Insertion Order',
'google ads': 'Campaign',
'the trade desk': 'Campaign',
'yahoo dsp': 'Campaign Name',
'teads': 'Campaign Name',
}

{
'amazon dsp': 'ordername',
'dv360': 'filter_insertion_name',
'google ads': 'campaign_name',,
'the trade desk': 'campaign',
'yahoo dsp': 'campaign_name',
'teads': 'ad_external_name',
}

campaign_status

The Current Campaign Status

Dimensions

 
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'Campaign status',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'campaign_status',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

campaign_type

The Campaign Type

Dimensions

 
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'Campaign type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'campaign_advertising_channel_type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

campaign_objective

The Objective of the Campaign

Dimensions

 
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}         

{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'N/A',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

campaign_daily_budget

The Daily Budget of the Campaign

Metrics

 
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'Budget',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}         

{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'campaign_budget_amount',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

campaign_start_date

The Campaign Start Date

Dimensions

 
{
'amazon dsp': 'Order start date',
'dv360': 'N/A',
'google ads': 'Campaign start date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}         

{
'amazon dsp': 'orderstartdate',
'dv360': 'N/A',
'google ads': 'campaign_start_date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

campaign_end_date

The Campaign End Date

Dimensions

 
{
'amazon dsp': 'Order end date',
'dv360': 'N/A',
'google ads': 'Campaign end date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}         

{
'amazon dsp': 'orderenddate',
'dv360': 'N/A',
'google ads': 'campaign_end_date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

adgroup_id

The Adgroup Identifier

Dimensions

 
{
'amazon dsp': 'Line item ID',
'dv360': 'coalesce(Toutube Ad Group ID, Line Item ID)',
'google ads': 'Ad group ID',
'the trade desk': 'Ad Group ID',
'yahoo dsp': 'TBD',
'teads': 'Line Item ID',
}         

{
'amazon dsp': 'lineitemid',
'dv360': 'coalesce(filter_trueview_ad_group_ad_id, filter_line_item)',
'google ads': 'ad_group_id',
'the trade desk': 'ad_group_id',
'yahoo dsp': 'line_id',
'teads': 'insertion_id',
}

adgroup_name

The Adgroup Name

Dimensions

 
{
'amazon dsp': 'Line item name',
'dv360': 'coalesce(Toutube Ad Group, Line Item)',
'google ads': 'Ad group',
'the trade desk': 'Ad Group',
'yahoo dsp': 'TBD',
'teads': 'Line Item Name',
}         

{
'amazon dsp': 'lineitemname',
'dv360': 'coalesce(filter_trueview_ad_group, filter_line_item_name)',
'google ads': 'ad_group_name',
'the trade desk': 'ad_group',
'yahoo dsp': 'line_name',
'teads': 'insertion_name',
}

adgroup_type

The Adgroup Type

Dimensions

 
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}         

{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'ad_group_type',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

adgroup_status

The Current Adgroup Status

Dimensions

 
{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'Status (under Ad group tab)',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}         

{
'amazon dsp': 'N/A',
'dv360': 'N/A',
'google ads': 'ad_group_status',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

domain

URL of the Group Placement, for example, the Mobile Application in App Store, or a Youtube Channel URL

Dimensions

 
{
'amazon dsp': 'Site name',
'dv360': 'App/URL',
'google ads': '',
'the trade desk': 'Site',
'yahoo dsp': '',
'teads': 'Website Domain',
}         

{
'amazon dsp': 'sitename',
'dv360': 'filter_app_url',
'google ads': 'detail_placement_view_group_placement_target_url',
'the trade desk': 'site',
'yahoo dsp': 'domain',
'teads': 'website_domain',
}

exchange

The Marketplace where Advertisers and Publishers to Buy and Sell Ad Space

Dimensions

 
{
'amazon dsp': 'Supply source name',
'dv360': 'Exchange',
'google ads': 'N/A',
'the trade desk': 'Supply Vendor',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

{
'amazon dsp': 'supplysourcename',
'dv360': 'filter_exchange',
'google ads': 'N/A',
'the trade desk': 'supply_vendor',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

ad_format

The Format of the Ad

Categorization

N/A

N/A

audience_strategy

The Strategy Towards the Audience

Categorization

N/A

N/A

audience_type

The Type of the Audience

Categorization

N/A

N/A

marketing_objective

The Objective of the Marketing Tactic

Categorization

N/A

N/A

geo

The Geographic Info

Categorization

N/A

N/A

query_type

Query Type

Categorization

N/A

N/A

funnel

Marketing Funnel

Categorization

N/A

N/A

channel

The Default Alli Data Library Channel (Hard Coded Value)

 

If you would like to change the Channel associated with the Campaign please see the following document: How-To: Reclassify Media Channel

Dimensions

N/A

 
{
'amazon dsp': 'DISPLAY',
'dv360': 'DISPLAY',
'google ads': 'SEARCH',
'the trade desk': 'DISPLAY',
'yahoo dsp': 'DISPLAY'
'teads': 'DISPLAY',
}

cost

Costs (Ad Spend)

Metrics

 
{
'amazon dsp': 'Total cost',
'dv360': 'Revenue (Advertise Currency)',
'google ads': 'Cost',
'the trade desk': 'Advertiser Cost (USD)',
'yahoo dsp': 'Cost',
'teads': 'Budget Spent',
}         

{
'amazon dsp': 'totalcost',
'dv360': 'metric_revenue_advertiser',
'google ads': 'cost',
'the trade desk': 'advertiser_cost_usd',
'yahoo dsp': 'cost',
'teads': 'turnover_value',
}

profit

Profit that the Inventory can Make

Metrics

 
{
'amazon dsp': 'N/A',
'dv360': 'Profit (Advertiser Currency)',
'google ads': 'N/A',
'the trade desk': 'Profit (USD)',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}         

{
'amazon dsp': 'N/A',
'dv360': 'metric_profit_advertiser',
'google ads': 'N/A',
'the trade desk': 'profit_usd',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

impressions

Impressions

Metrics

 
{
'amazon dsp': 'Impressions',
'dv360': 'Impressions',
'google ads': 'Impr.',
'the trade desk': 'Impressions',
'yahoo dsp': 'impressions',
'teads': 'Impressions',
}         



{
'amazon dsp': 'impressions',
'dv360': 'metric_impressions',
'google ads': 'impressions',
'the trade desk': 'impressions',
'yahoo dsp': 'impressions',
'teads': 'impression',
}

clicks

Clicks

Metrics

 
{
'amazon dsp': 'Click-throughs',
'dv360': 'Clicks',
'google ads': 'Clicks',
'the trade desk': 'Clicks',
'yahoo dsp': 'Clicks',
'teads': 'Clicks',
}         

{
'amazon dsp': 'clickthroughs',
'dv360': 'metric_clicks',
'google ads': 'clicks',
'the trade desk': 'clicks',
'yahoo dsp': 'clicks',
'teads': 'click',
}

total_conversions

The Total Number of Conversions

Metrics

 
{
'amazon dsp': 'N/A',
'dv360': '',
'google ads': 'All conv.',
'the trade desk': 'Total Click + View Conversions 01',
'yahoo dsp': 'Conversions',
'teads': 'N/A',
}         

{
'amazon dsp': 'N/A',
'dv360': 'metric_last_clicks + metric_last_impressions',
'google ads': 'all_conversions',
'the trade desk': 'total_click_view_conversions_01',
'yahoo dsp': 'conversions',
'teads': 'N/A',
}

total_conversions_value

The Value associated with the Total Number of Conversions

Metrics

 
{
'amazon dsp': 'N/A',
'dv360': '',
'google ads': 'All conv. value',
'the trade desk': 'Total Click + View Conversion Revenue 01',
'yahoo dsp': 'Conversions Value',
'teads': 'N/A',
}         

{
'amazon dsp': 'N/A',
'dv360': 'metric_cm360_post_click_revenue + metric_cm360_post_view_revenue',
'google ads': 'all_conversions_value',
'the trade desk': 'total_click_view_conversion_revenue_01',
'yahoo dsp': 'conversions_value',
'teads': 'N/A',
}

click_through_conversions

The Number of Click Through Conversions

Metrics

 
{
'amazon dsp': 'N/A',
'dv360': '',
'google ads': 'N/A',
'the trade desk': 'Click Conversion 01',
'yahoo dsp': 'Click Through Conversions',
'teads': 'Post Click Conversions',
}         

{
'amazon dsp': 'N/A',
'dv360': 'metric_last_clicks',
'google ads': 'N/A',
'the trade desk': 'click_conversion_01',
'yahoo dsp': 'click_through_conversions',
'teads': 'post_click_conversion',
}

click_through_conversions_value

The Value associated with the Click Through Conversions

Metrics

 
{
'amazon dsp': 'N/A',
'dv360': '',
'google ads': 'N/A',
'the trade desk': 'Click Conversion Revenue 01',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}         

{
'amazon dsp': 'N/A',
'dv360': 'metric_cm_post_click_revenue',
'google ads': 'N/A',
'the trade desk': 'click_conversion_revenue_01',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}

view_through_conversions

The Number of View Through Conversions

Metrics

 
{
'amazon dsp': 'N/A',
'dv360': '',
'google ads': 'View-through conv.',
'the trade desk': 'View Through Conversion 01',
'yahoo dsp': 'View Through Conversion',
'teads': 'Post View Conversions',
}         

{
'amazon dsp': 'N/A',
'dv360': 'metric_last_impressions',
'google ads': 'view_through_conversions',
'the trade desk': 'view_through_conversion_01',
'yahoo dsp': 'view_through_conversions',
'teads': 'post_view_conversion',
}

view_through_conversions_value

The Value associated with the View Through Conversions

Metrics

 
{
'amazon dsp': 'N/A',
'dv360': '',
'google ads': 'N/A',
'the trade desk': 'View Through Conversion Revenue 01',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}         

{
'amazon dsp': 'N/A',
'dv360': 'metric_cm_post_view_revenue',
'google ads': 'N/A',
'the trade desk': 'view_through_conversion_revenue_01',
'yahoo dsp': 'N/A',
'teads': 'N/A',
}