Skip to main content
Skip table of contents

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

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

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

platform

The Platform the Campaign belongs to. (Hard Coded)

Dimensions

N/A

CODE
{
'dv360': 'DV360',
'google ads': 'Google Ads',
'the trade desk': 'The Trade Desk',
'yahoo dsp': 'Yahoo DSP',
'facebook ads': 'Facebook Ads'
}

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
{
'dv360': 'N/A',
'google ads': 'Networks',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}

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

account_id

The Ad Account Identifier

Dimensions

CODE
{
'dv360': 'Advertiser ID',
'google ads': 'Account ID',
'the trade desk': 'Advertiser ID',
'yahoo dsp': 'Advertiser ID'
}
CODE
{
'dv360': 'filter_advertiser',
'google ads': 'customer_id',
'the trade desk': 'advertiser_id',
'yahoo dsp': 'advertiser_id',
'facebook ads': 'account_id'
}

account_name

The Ad Account Name

Dimensions

CODE
{
'dv360': 'Advertiser',
'google ads': 'Account',
'the trade desk': 'Advertiser',
'yahoo dsp': 'Advertiser Name'
}         
CODE
{
'dv360': 'filter_advertiser_name',
'google ads': 'customer_name',
'the trade desk': 'advertiser_name',
'yahoo dsp': 'advertiser_name',
'facebook ads': 'account_name'
}         

campaign_id

The Campaign Identifier

Dimensions

CODE
{
'dv360': 'Insertion Order ID',
'google ads': 'Campaign ID',
'the trade desk': 'Campaign ID',
'yahoo dsp': 'Campaign ID'
}
CODE
{
'dv360': 'filter_insertion_order',
'google ads': 'campaign_id',
'the trade desk': 'campaign_id',
'yahoo dsp': 'campaign_id',
'facebook ads': 'campaign_id'
}         

campaign_name

The Campaign Name

Dimensions

CODE
{
'dv360': 'Insertion Order',
'google ads': 'Campaign',
'the trade desk': 'Campaign',
'yahoo dsp': 'Campaign Name'
}
CODE
{
'dv360': 'filter_insertion_name',
'google ads': 'campaign_name',,
'the trade desk': 'campaign',
'yahoo dsp': 'campaign_name',
'facebook ads': 'campaign_name'
}         

campaign_status

The Current Campaign Status

Dimensions

CODE
{
'dv360': 'N/A',
'google ads': 'Campaign status',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
CODE
{
'dv360': 'N/A',
'google ads': 'campaign_status',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'campaign_status'
}         

campaign_type

The Campaign Type

Dimensions

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

campaign_objective

The Objective of the Campaign

Dimensions

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

campaign_daily_budget

The Daily Budget of the Campaign

Metrics

CODE
{
'dv360': 'N/A',
'google ads': 'Budget',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
CODE
{
'dv360': 'N/A',
'google ads': 'campaign_budget_amount',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A'
}         

campaign_start_date

The Campaign Start Date

Dimensions

CODE
{
'dv360': 'N/A',
'google ads': 'Campaign start date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
CODE
{
'dv360': 'N/A',
'google ads': 'campaign_start_date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A'
}         

campaign_end_date

The Campaign End Date

Dimensions

CODE
{
'dv360': 'N/A',
'google ads': 'Campaign end date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A'
}
CODE
{
'dv360': 'N/A',
'google ads': 'campaign_end_date',
'the trade desk': 'N/A',
'yahoo dsp': 'N/A',
'facebook ads': 'N/A'
}         

country_name

The Country Name

Dimensions

CODE
{
'dv360': 'Country',
'google ads': 'Location',
'the trade desk': 'Country',
'yahoo dsp': 'N/A'
}         
CODE
{
'dv360': 'filter_country',
'google ads': 'geo_target_constant_name',
'the trade desk': 'country',
'yahoo dsp': 'country',
'facebook ads': 'country'
}         

region_name

The Region Name

Dimensions

CODE
{
'dv360': 'Region',
'google ads': 'Location',
'the trade desk': 'Region',
'yahoo dsp': 'N/A'
}         
CODE
{
'dv360': 'filter_region_name',
'google ads': 'geo_target_constant_name',
'the trade desk': 'region',
'yahoo dsp': 'region',
'facebook ads': 'region'
}         

city_name

The City Name

Dimensions

CODE
{
'dv360': 'City',
'google ads': 'Location',
'the trade desk': 'City',
'yahoo dsp': 'N/A'
}         
CODE
{
'dv360': 'filter_city_name',
'google ads': 'geo_target_constant_name',
'the trade desk': 'city',
'yahoo dsp': 'city',
'facebook ads': '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
{
'dv360': 'DISPLAY',
'google ads': 'SEARCH',
'the trade desk': 'DISPLAY',
'yahoo dsp': 'DISPLAY',
'facebook ads': 'SOCIAL'
}         

cost

Costs (Ad Spend)

Metrics

CODE
{
'dv360': 'Revenue (Advertiser Currency)',
'google ads': 'Cost',
'the trade desk': 'Advertiser Cost (USD)',
'yahoo dsp': 'Cost'     
}         
CODE
{
'dv360': 'metric_revenue_advertiser',
'google ads': 'cost',
'the trade desk': 'advertiser_cost_usd',
'yahoo dsp': 'cost',
'facebook ads': 'spend'
}         

profit

Profit that the Inventory can Make

Metrics

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

impressions

Impressions

Metrics

CODE
{
'dv360': 'Impressions',
'google ads': 'Impr.',
'the trade desk': 'Impressions',
'yahoo dsp': 'impressions'
}         
CODE
{
'dv360': 'metric_impressions',
'google ads': 'impressions',
'the trade desk': 'impressions',
'yahoo dsp': 'impressions',
'facebook ads': 'impressions'
}         

clicks

Clicks

Metrics

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

total_conversions

The Total Number of Conversions

Metrics

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

total_conversions_value

The Value associated with the Total Number of Conversions

Metrics

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

click_through_conversions

The Number of Click Through Conversions

Metrics

CODE
{
'dv360': 'TBD',
'google ads': 'N/A',
'the trade desk': 'Click Conversion 01',
'yahoo dsp': 'Click Through Conversions'
}         
CODE
{
'dv360': 'metric_last_clicks',
'google ads': 'N/A',
'the trade desk': 'click_conversion_01',
'yahoo dsp': 'click_through_conversions',
'facebook ads': 'N/A'
}         

click_through_conversions_value

The Value associated with the Click Through Conversions

Metrics

CODE
{
'dv360': 'TBD',
'google ads': 'N/A',
'the trade desk': 'Click Conversion Revenue 01',
'yahoo dsp': 'N/A'
}         
CODE
{
'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'
}         

view_through_conversions

The Number of View Through Conversions

Metrics

CODE
{
'dv360': 'TBD',
'google ads': 'View-through conv.',
'the trade desk': 'View Through Conversion 01',
'yahoo dsp': 'View Through Conversion'
}         
CODE
{
'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'
}         

view_through_conversions_value

The Value associated with the View Through Conversions

Metrics

CODE
{
'dv360': 'TBD',
'google ads': 'N/A',
'the trade desk': 'View Through Conversion Revenue 01',
'yahoo dsp': 'N/A'
}         
CODE
{
'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'
}         
JavaScript errors detected

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

If this problem persists, please contact our support.