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 ADL	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' }`