Breadcrumbs

Data Library Field Mapping - Geo Region Performance

Overview

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


Platforms include:

  • DV360

  • Google Ads

  • The Trade Desk

  • Yahoo DSP

  • Facebook Ads

  • Snapchat Ads

  • Teads


To understand which Alli Data Datasources are used within the geo_region_performance report see the following DAG:

https://whimsical.com/geo-region-performance-Dxy94TwKPm25YFBZCyuhRs


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

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

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

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

platform

The Platform the Campaign belongs to. (Hard Coded)

Dimensions

N/A

 
{
'dv360': 'DV360',
'google ads': 'Google Ads',
'the trade desk': 'The Trade Desk',
'yahoo dsp': 'Yahoo DSP',
'facebook ads': 'Facebook Ads'
'snapchat ads': 'Snapchat Ads'
'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

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



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

account_id

The Ad Account Identifier

Dimensions

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

{
'dv360': 'filter_advertiser',
'google ads': 'customer_id',
'the trade desk': 'advertiser_id',
'yahoo dsp': 'advertiser_id',
'facebook ads': 'account_id',
'snapchat ads': 'accountId',
'teads': 'advertiser_id',
}

account_name

The Ad Account Name

Dimensions

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

{
'dv360': 'filter_advertiser_name',
'google ads': 'customer_name',
'the trade desk': 'advertiser_name',
'yahoo dsp': 'advertiser_name',
'facebook ads': 'account_name',
'snapchat ads': 'name' (from account structure datasource),
'teads': 'advertiser_name',
}

campaign_id

The Campaign Identifier

Dimensions

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

{
'dv360': 'filter_insertion_order',
'google ads': 'campaign_id',
'the trade desk': 'campaign_id',
'yahoo dsp': 'campaign_id',
'facebook ads': 'campaign_id',
'snapchat ads': 'campaignid',
'teads': 'ad_id',
}

campaign_name

The Campaign Name

Dimensions

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

{
'dv360': 'filter_insertion_name',
'google ads': 'campaign_name',,
'the trade desk': 'campaign',
'yahoo dsp': 'campaign_name',
'facebook ads': 'campaign_name',
'snapchat ads': 'name' (from campaign structure datasource),
'teads': 'ad_external_name',
}

campaign_status

The Current Campaign Status

Dimensions

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

{
'dv360': 'N/A',
'google ads': 'campaign_status',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'campaign_status',
'snapchat ads': 'status' (from campaign structure datasource),
'teads': 'N/A',
}

campaign_type

The Campaign Type

Dimensions

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

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

campaign_objective

The Objective of the Campaign

Dimensions

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

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

campaign_daily_budget

The Daily Budget of the Campaign

Metrics

 
{
'dv360': 'N/A',
'google ads': 'Budget',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'Budget',
'snapchat ads': 'Daily Spend Cap',
'teads': 'N/A',
}

{
'dv360': 'N/A',
'google ads': 'campaign_budget_amount',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'daily_budget_micro / 1000000',
'teads': 'N/A',
}

campaign_start_date

The Campaign Start Date

Dimensions

 
{
'dv360': 'N/A',
'google ads': 'Campaign start date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'Starts',
'snapchat ads': 'Start Time',
'teads': 'N/A',
}

{
'dv360': 'N/A',
'google ads': 'campaign_start_date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'start_time',
'teads': 'N/A',
}

campaign_end_date

The Campaign End Date

Dimensions

 
{
'dv360': 'N/A',
'google ads': 'Campaign end date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'Ends',
'snapchat ads': 'End Time',
'teads': 'N/A',
}

{
'dv360': 'N/A',
'google ads': 'campaign_end_date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'end_time',
'teads': 'N/A',
}

country_name

The Country Name

Dimensions

 
{
'dv360': 'Country',
'google ads': 'Location',
'the trade desk': 'Country',
'yahoo dsp': 'N/A',
'facebook ads': 'Country',
'snapchat ads': 'N/A',
'teads': 'Country Name',
}         

{
'dv360': 'filter_country',
'google ads': 'geo_target_constant_name',
'the trade desk': 'country',
'yahoo dsp': 'country',
'facebook ads': 'country',
'snapchat ads': 'N/A',
'teads': 'country_name',
}

region_name

The Region Name

Dimensions

 
{
'dv360': 'Region',
'google ads': 'Location',
'the trade desk': 'Region',
'yahoo dsp': 'N/A',
'facebook ads': 'Region',
'snapchat ads': 'Region',
'teads': 'Region Name',
}         

{
'dv360': 'filter_region_name',
'google ads': 'geo_target_constant_name',
'the trade desk': 'region',
'yahoo dsp': 'region',
'facebook ads': 'region',
'snapchat ads': 'region',
'teads': 'region_name',
}

city_name

The City Name

Dimensions

 
{
'dv360': 'City',
'google ads': 'Location',
'the trade desk': 'City',
'yahoo dsp': 'N/A',
'facebook ads': 'City',
'snapchat ads': 'N/A',
'teads': 'N/A',
}         

{
'dv360': 'filter_city_name',
'google ads': 'geo_target_constant_name',
'the trade desk': 'city',
'yahoo dsp': 'city',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'teads': '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

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

cost

Costs (Ad Spend)

Metrics

 
{
'dv360': 'Revenue (Advertiser Currency)',
'google ads': 'Cost',
'the trade desk': 'Advertiser Cost (USD)',
'yahoo dsp': 'Cost',
'facebook ads': 'Amount Spend',
'snapchat ads': 'Spend',
'teads': 'Budget Spent',  
}         

{
'dv360': 'metric_revenue_advertiser',
'google ads': 'cost',
'the trade desk': 'advertiser_cost_usd',
'yahoo dsp': 'cost',
'facebook ads': 'spend',
'snapchat ads': 'spend',
'teads': 'turnover_value',
}

profit

Profit that the Inventory can Make

Metrics

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

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

impressions

Impressions

Metrics

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

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

clicks

Clicks

Metrics

 
{
'dv360': 'Clicks',
'google ads': 'clicks',
'the trade desk': 'clicks',
'yahoo dsp': 'clicks',
'facebook ads': 'Clicks',
'snapchat ads': 'Clicks',
'teads': 'Clicks',
}         

{
'dv360': 'metric_clicks',
'google ads': 'clicks',
'the trade desk': 'clicks',
'yahoo dsp': 'clicks',
'facebook ads': 'clicks',
'snapchat ads': 'swipes',
'teads': 'click',
}

total_conversions

The Total Number of Conversions

Metrics

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

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

total_conversions_value

The Value associated with the Total Number of Conversions

Metrics

 
{
'dv360': 'N/A',
'google ads': 'All conv. value',
'the trade desk': 'Total Click + View Conversion Revenue 01',
'yahoo dsp': 'Conversions Value',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'teads': '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',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'teads': 'N/A',
}

click_through_conversions

The Number of Click Through Conversions

Metrics

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

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

click_through_conversions_value

The Value associated with the Click Through Conversions

Metrics

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

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

view_through_conversions

The Number of View Through Conversions

Metrics

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

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

view_through_conversions_value

The Value associated with the View Through Conversions

Metrics

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

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