Skip to main content
Skip table of contents

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

CODE
{
'google ads': 'Date',
'microsoft ads': 'Date'
}
CODE
{
'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

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

CODE
{
'google ads': 'Networks',
'microsoft ads': 'Ad Distribution'
}
CODE
{
'google ads': 'ad_network_type',
'microsoft ads': 'AdDistribution'
}

account_id

The Ad Account Identifier

Dimensions

CODE
{
'google ads': 'Account ID',
'microsoft ads': 'Account ID'
}
CODE
{
'google ads': 'customer_id',
'microsoft ads': 'accountid'
}

account_name

The Ad Account Name

Dimensions

CODE
{
'google ads': 'Account',
'microsoft ads': 'Account name'
}
CODE
{
'google ads': 'customer_name',
'microsoft ads': 'AccountName'
}         

campaign_id

The Campaign Identifier

Dimensions

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

campaign_name

The Campaign Name

Dimensions

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

campaign_status

The Current Campaign Status

Dimensions

CODE
{
'google ads': 'Campaign status',
'microsoft ads': 'Status'
}
CODE
{
'google ads': 'campaign_status',
'microsoft ads': 'campaignstatus'
}         

campaign_type

The Campaign Type

Dimensions

CODE
{
'google ads': 'Campaign type',
'microsoft ads': 'Campaign type'
}
CODE
{
'google ads': 'campaign_advertising_channel_type',
'microsoft ads': 'campaigntype'
}         

campaign_daily_budget

The Daily Budget of the Campaign

Metrics

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

campaign_start_date

The Campaign Start Date

Dimensions

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

campaign_end_date

The Campaign End Date

Dimensions

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

adgroup_id

The Adgroup Identifier

Dimensions

CODE
{
'google ads': 'Ad group ID',
'microsoft ads': 'Ad group ID'
}
CODE
{
'google ads': 'ad_group_id',
'microsoft ads': 'adgroupid'
}         

adgroup_name

The Adgroup Name

Dimensions

CODE
{
'google ads': 'Ad group',
'microsoft ads': 'Ad group'
}
CODE
{
'google ads': 'ad_group_name',
'microsoft ads': 'adgroupname'
}         

adgroup_type

The Adgroup Type

Dimensions

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

adgroup_status

The Current Adgroup Status

Dimensions

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

audience_id

The Audience Identifier

Dimensions

CODE
{
'google ads': 'Audience ID',
'microsoft ads': 'Audience ID'
}         
CODE
{
'google ads': 'user_list_id',
'microsoft ads': 'audienceid'
}         

audience_name

The Audience Name

Dimensions

CODE
{
'google ads': 'Audience name',
'microsoft ads': 'Audience'
}         
CODE
{
'google ads': 'user_list_name',
'microsoft ads': 'audiencename'
}         

audience_status

The Audience Status

Dimensions

CODE
{
'google ads': 'Status',
'microsoft ads': 'Status'
}         
CODE
{
'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 data in Data Library

Dimensions

N/A

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

cost

Costs (Ad Spend)

Metrics

CODE
{
'google ads': 'Cost',
'microsoft ads': 'Spend'
}
CODE
{
'google ads': 'cost',
'microsoft ads': 'spend'
}         

impressions

Impressions

Metrics

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

clicks

Clicks

Metrics

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

conversions

The Number of Conversions

Metrics

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

conversions_value

The Value associated with Conversions

Metrics

CODE
{
'google ads': 'Conv. value',
'microsoft ads': 'Revenue'
}
CODE
{
'google ads': 'conversions_value',
'microsoft ads': 'revenue'
}         
JavaScript errors detected

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

If this problem persists, please contact our support.