Breadcrumbs

Data Library Field Mapping - Audience Performance

Overview

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


Platforms include:

  • Google Ads

  • Microsoft Bing


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

https://whimsical.com/audience-performance-UVo2KqAqwGp8VpDXeWAZpe


The value N/A identifies that the platform does not have a mapping for the corresponding column.

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

 
{
'google ads': 'Date',
'microsoft ads': 'Date'
}

{
'google ads': 'date',
'microsoft ads': 'TimePeriod'
}

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

 
{
'google ads': 'Google Ads',
'microsoft ads': 'Microsoft Bing'
}

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

 
{
'google ads': 'Networks',
'microsoft ads': 'Ad Distribution'
}

{
'google ads': 'ad_network_type',
'microsoft ads': 'AdDistribution'
}

account_id

The Ad Account Identifier

Dimensions

 
{
'google ads': 'Account ID',
'microsoft ads': 'Account ID'
}

{
'google ads': 'customer_id',
'microsoft ads': 'accountid'
}

account_name

The Ad Account Name

Dimensions

 
{
'google ads': 'Account',
'microsoft ads': 'Account name'
}

{
'google ads': 'customer_name',
'microsoft ads': 'AccountName'
}

campaign_id

The Campaign Identifier

Dimensions

 
{
'google ads': 'Campaign ID',
'microsoft ads': 'Campaign ID'
}

{
'google ads': 'campaign_id',
'microsoft ads': 'campaignid'
}

campaign_name

The Campaign Name

Dimensions

 
{
'google ads': 'Campaign',
'microsoft ads': 'Campaign'
}

{
'google ads': 'campaign_name',
'microsoft ads': 'campaignname'
}

campaign_status

The Current Campaign Status

Dimensions

 
{
'google ads': 'Campaign status',
'microsoft ads': 'Status'
}

{
'google ads': 'campaign_status',
'microsoft ads': 'campaignstatus'
}

campaign_type

The Campaign Type

Dimensions

 
{
'google ads': 'Campaign type',
'microsoft ads': 'Campaign type'
}

{
'google ads': 'campaign_advertising_channel_type',
'microsoft ads': 'campaigntype'
}

campaign_daily_budget

The Daily Budget of the Campaign

Metrics

 
{
'google ads': 'Budget',
'microsoft ads': 'Budget'
}

{
'google ads': 'campaign_budget_amount',
'microsoft ads': 'dailybudget'
}

campaign_start_date

The Campaign Start Date

Dimensions

 
{
'google ads': 'Campaign start date',
'microsoft ads': 'N/A'
}

{
'google ads': 'campaign_start_date',
'microsoft ads': 'N/A'
}

campaign_end_date

The Campaign End Date

Dimensions

 
{
'google ads': 'Campaign end date',
'microsoft ads': 'N/A'
}

{
'google ads': 'campaign_end_date',
'microsoft ads': 'N/A'
}

adgroup_id

The Adgroup Identifier

Dimensions

 
{
'google ads': 'Ad group ID',
'microsoft ads': 'Ad group ID'
}

{
'google ads': 'ad_group_id',
'microsoft ads': 'adgroupid'
}

adgroup_name

The Adgroup Name

Dimensions

 
{
'google ads': 'Ad group',
'microsoft ads': 'Ad group'
}

{
'google ads': 'ad_group_name',
'microsoft ads': 'adgroupname'
}

adgroup_type

The Adgroup Type

Dimensions

 
{
'google ads': 'type',
'microsoft ads': 'N/A'
}

{
'google ads': 'ad_group_type',
'microsoft ads': 'N/A'
}

adgroup_status

The Current Adgroup Status

Dimensions

 
{
'google ads': 'Status (under Ad group tab)',
'microsoft ads': 'Status: All ad groups'
}

{
'google ads': 'ad_group_status',
'microsoft ads': 'status'
}

audience_id

The Audience Identifier

Dimensions

 
{
'google ads': 'Audience ID',
'microsoft ads': 'Audience ID'
}         

{
'google ads': 'user_list_id',
'microsoft ads': 'audienceid'
}

audience_name

The Audience Name

Dimensions

 
{
'google ads': 'Audience name',
'microsoft ads': 'Audience'
}         

{
'google ads': 'user_list_name',
'microsoft ads': 'audiencename'
}

audience_status

The Audience Status

Dimensions

 
{
'google ads': 'Status',
'microsoft ads': 'Status'
}         

{
'google ads': 'user_list_account_user_list_status',
'microsoft ads': 'audiencestatus'
}

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

 
{
'google ads': 'SEARCH',
'microsoft ads': 'SEARCH'
}

cost

Costs (Ad Spend)

Metrics

 
{
'google ads': 'Cost',
'microsoft ads': 'Spend'
}

{
'google ads': 'cost',
'microsoft ads': 'spend'
}

impressions

Impressions

Metrics

 
{
'google ads': 'Impr.',
'microsoft ads': 'Impr.'
}

{
'google ads': 'impressions',
'microsoft ads': 'impressions'
}

clicks

Clicks

Metrics

 
{
'google ads': 'Clicks',
'microsoft ads': 'Clicks'
}

{
'google ads': 'clicks',
'microsoft ads': 'clicks'
}

conversions

The Number of Conversions

Metrics

 
{
'google ads': 'Conversions',
'microsoft ads': 'Conv.'
}

{
'google ads': 'conversions',
'microsoft ads': 'conversions'
}

conversions_value

The Value associated with Conversions

Metrics

 
{
'google ads': 'Conv. value',
'microsoft ads': 'Revenue'
}

{
'google ads': 'conversions_value',
'microsoft ads': 'revenue'
}