Skip to main content
Skip table of contents

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 )

CODE
data_library_googleads_geo_reporting_enabled: true
data_library_facebookads_geo_reporting_enabled: true
data_library_snapchatads_geo_reporting_enabled: true

DAG overview of Alli Data Library performance models used in geo_dma_performancereport :

https://whimsical.com/geo-dma-performance-EpedBdhRQWiahidapEPSAD@6HYTAunKLgTRPcaxoKGWN9MkAHy4QifD8bJHBpJ7GX2R2DL


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

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
{
'google ads': 'date',
'facebook ads': 'date',
'snapchat ads': 'date'
}
CODE
{
'google ads': 'date',
'facebook ads': 'date',
'snapchat ads': '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
{
'google ads': 'Google Ads',
'facebook ads': 'Facebook Ads',
'snapchat ads': 'Snapchat Ads'
}

publisher_platform

The Publisher Platform on where the Campaign Delivered Ads

Dimensions

CODE
{
'google ads': 'Networks',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}
CODE
{
'google ads': 'ad_network_type',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}

account_id

The Ad Account Identifier

Dimensions

CODE
{
'google ads': 'Account ID',
'facebook ads': 'Account ID',
'snapchat ads': 'Account'
}
CODE
{
'google ads': 'customer_id',
'facebook ads': 'account_id',
'snapchat ads': 'accountId'
}

account_name

The Ad Account Name

Dimensions

CODE
{
'google ads': 'Account Name',
'facebook ads': 'Account',
'snapchat ads': 'Account'
}
CODE
{
'google ads': 'customer_name',
'facebook ads': 'account_name',
'snapchat ads': 'name' (from account structure datasource)
}

campaign_id

The Campaign Identifier

Dimensions

CODE
{
'google ads': 'Campaign ID',
'facebook ads': 'Campaign ID',
'snapchat ads': 'Campaign ID'
}
CODE
{
'google ads': 'campaign_id',
'facebook ads': 'campaign_id',
'snapchat ads': 'campaignid'
}

campaign_name

The Campaign Name

Dimensions

CODE
{
'google ads': 'Campaign',
'facebook ads': 'Campaign',
'snapchat ads': 'Campaign Name'
}
CODE
{
'google ads': 'campaign_name',
'facebook ads': 'campaign_name',
'snapchat ads': 'Campaign Name'
}

campaign_status

The Current Campaign Status

Dimensions

CODE
{
'google ads': 'Campaign status',
'facebook ads': 'Status',
'snapchat ads': 'Status'
}
CODE
{
'google ads': 'campaign_status',
'facebook ads': 'status',
'snapchat ads': 'status' (from campaign structure datasource)
}

campaign_type

The Campaign Type

Dimensions

CODE
{
'google ads': 'Campaign status',
'facebook ads': 'Status',
'snapchat ads': 'Status'
}
CODE
{
'google ads': 'Campaign status',
'facebook ads': 'Status',
'snapchat ads': 'Status'
}

campaign_objective

The Objective of the Campaign

Dimensions

CODE
{
'google ads': 'N/A',
'facebook ads': 'Objective',
'snapchat ads': 'Objective'
}
CODE
{
'google ads': 'N/A',
'facebook ads': 'objective',
'snapchat ads': 'objective'
}

campaign_daily_budget

The Daily Budget of the Campaign

Metrics

CODE
{
'google ads': 'Budget',
'facebook ads': 'Budget',
'snapchat ads': 'Daily Spend Cap'
}
CODE
{
'google ads': 'campaign_budget_amount',
'facebook ads': 'daily_budget/100',
'snapchat ads': 'daily_budget_micro / 1000000'
}

campaign_start_date

The Campaign Start Date

Dimensions

CODE
{
'google ads': 'Campaign start date',
'facebook ads': 'Starts',
'snapchat ads': 'Start Time'
}
CODE
{
'google ads': 'campaign_start_date',
'facebook ads': 'start_time',
'snapchat ads': 'start_time'
}

campaign_end_date

The Campaign End Date

Dimensions

CODE
{
'google ads': 'Campaign start date',
'facebook ads': 'Starts',
'snapchat ads': 'Start Time'
}
CODE
{
'google ads': 'campaign_end_date',
'facebook ads': 'stop_time',
'snapchat ads': 'end_time'
}

adgroup_id

The Adgroup Identifier

Dimensions

CODE
{
'google ads': 'Ad group ID',
'facebook ads': 'Ad set ID',
'snapchat ads': 'Ad Sets ID'
}
CODE
{
'google ads': 'ad_group_id',
'facebook ads': 'adset_id',
'snapchat ads': 'adsquadid'
}

adgroup_name

The Adgroup Name

Dimensions

CODE
{
'google ads': 'Ad group ID',
'facebook ads': 'Ad set ID',
'snapchat ads': 'Ad Sets ID'
}
CODE
{
'google ads': 'ad_group_name',
'facebook ads': 'adset_name',
'snapchat ads': 'adsquadname'
}

adgroup_type

The Adgroup Type

Dimensions

CODE
{
'google ads': 'type',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}
CODE
{
'google ads': 'ad_group_type',
'facebook ads': 'N/A',
'snapchat ads': 'type' (from adgroup structure datasource)
}

adgroup_status

The Current Adgroup Status

Dimensions

CODE
{
'google ads': 'Status' (under Ad group tab),
'facebook ads': 'Status',
'snapchat ads': 'Ad Sets Status'
}
CODE
{
'google ads': 'ad_group_status',
'facebook ads': 'effective_status',
'snapchat ads': 'status'
}

ad_id

The Ad Identifier

Dimensions

CODE
{
'google ads': 'N/A',
'facebook ads': 'Ad ID',
'snapchat ads': 'Ads ID'
}
CODE
{
'google ads': 'N/A',
'facebook ads': 'ad_id',
'snapchat ads': 'adid'
}

ad_name

The Ad Name

Dimensions

CODE
{
'google ads': 'N/A',
'facebook ads': 'Ad',
'snapchat ads': 'Ads name'
}
CODE
{
'google ads': 'N/A',
'facebook ads': 'ad_name',
'snapchat ads': 'adname'
}

ad_type

The Ad Type

Dimensions

CODE
{
'google ads': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'Ads Type'
}
CODE
{
'google ads': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'type' (from ad structure datasource)
}

ad_status

The Current Ad Status

Dimensions

CODE
{
'google ads': 'N/A',
'facebook ads': 'status',
'snapchat ads': 'Ads Status'
}
CODE
{
'google ads': 'N/A',
'facebook ads': 'status',
'snapchat ads': 'status'
}

cm_placement_id

The ID associated with a placement (CM360)

Dimensions

N/A

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 data in Data Library

Dimensions

N/A

CODE
{
'google ads': 'SEARCH',
'facebook ads': 'SOCIAL',
'snapchat ads': 'SOCIAL'
}

dma

The DMA (Designated Market Area) Name within region

Dimension

CODE
{
'google ads': 'Matched Location' (under where Ads showed section),
'facebook ads': 'dma',
'snapchat ads': 'dma' (exported from reports)
}
CODE
{
'google ads': 'dma',
'facebook ads': 'dma',
'snapchat ads': 'geo_target_metro'
}

cost

Costs (Ad Spend)

Metrics

CODE
{
'google ads': 'Cost',
'facebook ads': 'Amount Spend',
'snapchat ads': 'Spend'
}
CODE
{
'google ads': 'cost',
'facebook ads': 'spend',
'snapchat ads': 'spend'
}

profit

Profit that the Inventory can Make

Metrics

CODE
{
'google ads': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}
CODE
{
'google ads': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}

impressions

Impressions

Metrics

CODE
{
'google ads': 'Impr.',
'facebook ads': 'Impressions',
'snapchat ads': 'Paid Impressions'
}
CODE
{
'google ads': 'impressions',
'facebook ads': 'impressions',
'snapchat ads': 'impressions'
}

clicks

Clicks

Metrics

CODE
{
'google ads': 'Link clicks',
'facebook ads': 'Clicks',
'snapchat ads': 'Clicks'
}
CODE
{
'google ads': 'clicks',
'facebook ads': 'inline_link_clicks',
'snapchat ads': 'swipes'
}

total_conversions

The Total Number of Conversions

Metrics

CODE
{
'google ads': 'All conv.',
'facebook ads': 'Actions',
'snapchat ads': 'N/A'
}
CODE
{
'google ads': 'all_conversions',
'facebook ads': 'actions',
'snapchat ads': 'N/A'
}

total_conversions_value

The Value associated with the Total Number of Conversions

Metrics

CODE
{
'google ads': 'All conv. value',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}
CODE
{
'google ads': 'all_conversions_value',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}

click_through_conversions

The Number of Click Through Conversions

Metrics

CODE
{
'google ads': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}
CODE
{
'google ads': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}

click_through_conversions_value

The Value associated with the Click Through Conversions

Metrics

CODE
{
'google ads': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}
CODE
{
'google ads': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}

view_through_conversions

The Number of View Through Conversions

Metrics

CODE
{
'google ads': 'View-through conv.',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}
CODE
{
'google ads': 'view_through_conversions',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}

view_through_conversions_value

The Value associated with the View Through Conversions

Metrics

CODE
{
'google ads': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}
CODE
{
'google ads': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A'
}

JavaScript errors detected

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

If this problem persists, please contact our support.