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 |
|
|
|
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 For Twitter Ads, there are Datasources that pull data from | 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_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
|
audience_id | The Audience Identifier | Dimensions |
CODE
|
CODE
|
audience_name | The Audience Name | Dimensions |
CODE
|
CODE
|
audience_status | The Audience Status | Dimensions |
CODE
|
CODE
|
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
|
cost | Costs (Ad Spend) | Metrics |
CODE
|
CODE
|
impressions | Impressions | Metrics |
CODE
|
CODE
|
clicks | Clicks | Metrics |
CODE
|
CODE
|
conversions | The Number of Conversions | Metrics |
CODE
|
CODE
|
conversions_value | The Value associated with Conversions | Metrics |
CODE
|
CODE
|