Data Library Field Mapping - Geo DMA Performance
Overview
This document describes how platform columns are mapped in the geo_dma_performance
Alli Data Library Report.
Platforms include:
Google Ads
Facebook Ads
Snapchat Ads
TikTok Ads
If the Alli Data Library 2.0 - Refresh
Marketplace app exists for your customer, enable platform geo report var like below in dbt_vars
file and trigger the App to build the geo_dma_performance
reports to your client: (refer Onboarding a platform to Data Library )
data_library_googleads_geo_reporting_enabled: true
data_library_facebookads_geo_reporting_enabled: true
data_library_snapchatads_geo_reporting_enabled: true
data_library_tiktokads_geo_reporting_enabled: true
Meanwhile, for those dma reporting enabled clients, Alli Data Library is providing a new certified datasource named dma_dimensions
which could be found on Explorer Page. Users can query the model to check all available DMA dimensions. The current available dimensions are:
dma_id
snapchatads_dma_name
facebookads_dma_name
googleads_dma_name
tiktokads_dma_name
dma_name_nielsen
dma_short_name
latitude
longitude
hex_row
hex_col
dma_abbreviation
population_adult
households
DAG overview of Alli Data Library performance models used in geo_dma_performance
report :
The value N/A
identifies that the platform does not have a mapping for the corresponding column.
Column | Description | Dimensions / Metrics / Categorizations | Platform UI Name Mapping | Platform Mapping |
---|---|---|---|---|
id | The Internal Alli ID of the Record |
|
|
|
source | The Source Table of Row |
|
|
|
date | The Date of Performance Data | Dimensions |
CODE
|
CODE
|
core_media_channel | The channel that the platform is a part of | Categorization |
|
|
platform | The Platform the Campaign belongs to. (Hard Coded) | Dimensions |
|
CODE
|
publisher_platform | The Publisher Platform on where the Campaign Delivered Ads | Dimensions |
CODE
|
CODE
|
account_id | The Ad Account Identifier | Dimensions |
CODE
|
CODE
|
account_name | The Ad Account Name | Dimensions |
CODE
|
CODE
|
campaign_id | The Campaign Identifier | Dimensions |
CODE
|
CODE
|
campaign_name | The Campaign Name | Dimensions |
CODE
|
CODE
|
campaign_status | The Current Campaign Status | Dimensions |
CODE
|
CODE
|
campaign_type | The Campaign Type | Dimensions |
CODE
|
CODE
|
campaign_objective | The Objective of the Campaign | Dimensions |
CODE
|
CODE
|
campaign_daily_budget | The Daily Budget of the Campaign | Metrics |
CODE
|
CODE
|
campaign_start_date | The Campaign Start Date | Dimensions |
CODE
|
CODE
|
campaign_end_date | The Campaign End Date | Dimensions |
CODE
|
CODE
|
adgroup_id | The Adgroup Identifier | Dimensions |
CODE
|
CODE
|
adgroup_name | The Adgroup Name | Dimensions |
CODE
|
CODE
|
adgroup_type | The Adgroup Type | Dimensions |
CODE
|
CODE
|
adgroup_status | The Current Adgroup Status | Dimensions |
CODE
|
CODE
|
ad_id | The Ad Identifier | Dimensions |
CODE
|
CODE
|
ad_name | The Ad Name | Dimensions |
CODE
|
CODE
|
ad_type | The Ad Type | Dimensions |
CODE
|
CODE
|
ad_status | The Current Ad Status | Dimensions |
CODE
|
CODE
|
cm_placement_id | The ID associated with a placement (CM360) | Dimensions |
|
|
ad_format | The Format of the Ad | Categorization |
|
|
audience_strategy | The Strategy Towards the Audience | Categorization |
|
|
audience_type | The Type of the Audience | Categorization |
|
|
marketing_objective | The Objective of the Marketing Tactic | Categorization |
|
|
geo | The Geographic Info | Categorization |
|
|
query_type | Query Type | Categorization |
|
|
funnel | Marketing Funnel | Categorization |
|
|
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 |
|
CODE
|
dma | The DMA ( | Dimension |
CODE
|
CODE
|
dma_id | The 3-digit DMA ( | Dimension |
CODE
|
CODE
|
dma_name_nielsen | The DMA ( | Dimension |
|
CODE
|
dma_short_name | The universal short name of the Designated Market Area (DMA) within the region, shown as primary city, state | Dimension |
|
CODE
|
dma_abbreviation | The abbreviation of the name for the Designated Market Area (DMA) within the region | Dimension |
|
CODE
|
latitude | The latitude of the primary city within the Designated Market Area (DMA) | Dimension |
|
CODE
|
longitude | The longitude of the primary city within the Designated Market Area (DMA) | Dimension |
|
CODE
|
hex_row | The y coordinate for the shape based hextile map of the Designated Market Area (DMA) | Dimension |
|
CODE
|
hex_col | The x coordinate for the shape based hextile map of the Designated Market Area (DMA) | Dimension |
|
CODE
|
population_adult | The adult population within the Designated Market Area (DMA) | Dimension |
|
CODE
|
households | The number of households within the Designated Market Area (DMA) | Dimension |
|
CODE
|
cost | Costs (Ad Spend) | Metrics |
CODE
|
CODE
|
profit | Profit that the Inventory can Make | Metrics |
CODE
|
CODE
|
impressions | Impressions | Metrics |
CODE
|
CODE
|
clicks | Clicks | Metrics |
CODE
|
CODE
|
total_conversions | The Total Number of Conversions | Metrics |
CODE
|
CODE
|
total_conversions_value | The Value associated with the Total Number of Conversions | Metrics |
CODE
|
CODE
|
click_through_conversions | The Number of Click Through Conversions | Metrics |
CODE
|
CODE
|
click_through_conversions_value | The Value associated with the Click Through Conversions | Metrics |
CODE
|
CODE
|
view_through_conversions | The Number of View Through Conversions | Metrics |
CODE
|
CODE
|
view_through_conversions_value | The Value associated with the View Through Conversions | Metrics |
CODE
|
CODE
|