Data Library Field Mapping - Keyword Performance
Overview
This document describes how the columns from search ad platforms are mapped to the keyword_performance
Alli Data Library Report.
Platforms include:
Google Ads
Microsoft Bing
Apple Search Ads
To understand which Alli Data Datasources are used within the keyword_performance
report, see the following link: Data Library 2.0 Report DAGs | keyword_performance & https://agencypmg.atlassian.net/wiki/spaces/PTD/whiteboard/3019145323
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 API 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 Keyword belongs to (Hard Coded) | Dimensions |
|
CODE
|
publisher_platform | The Publisher Platform on where the Keyword 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_objective | The Objective of the Campaign | 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
|
keyword_id | The Keyword Identifier | Dimensions |
CODE
|
CODE
|
keyword_name | The Keyword Name | Dimensions |
CODE
|
CODE
|
keyword_status | Th Current Keyword Status | Dimensions |
CODE
|
CODE
|
is_negative | Whether the Keyword is a Negative Keyword | Dimensions |
CODE
|
CODE
|
keyword_match_type | The Type of Keyword Matching, including | Dimensions |
CODE
|
CODE
|
final_url | The URL Address of the Webpage that People Reach after They Click the Ad | Dimensions |
CODE
|
CODE
|
keyword_destination_url | The Destination URL of the Keyword | Dimensions |
CODE
|
CODE
|
bid_strategy_type | The Strategy Type of Bidding Action | Dimensions |
CODE
|
CODE
|
enhanced_cpc_enabled | Whether Enhanced CPC (ECPC) Bidding Strategy is Enabled | Dimensions |
CODE
|
CODE
|
cpc_bid | How Much to Pay for Each Click on the Ad | Metrics |
CODE
|
CODE
|
quality_score | The Quality Score of the Keyword | Metrics |
CODE
|
CODE
|
item_line_id | The Line Item Identifier | Dimensions |
CODE
|
CODE
|
item_line_name | The Line Item Name | Dimensions |
CODE
|
CODE
|
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
|
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 |
|
|
impressions | Impressions | Metrics |
CODE
|
CODE
|
clicks | Clicks | Metrics |
CODE
|
CODE
|
landing_page_views | The Number of Landing Page Views | Metrics |
|
CODE
|
reach | Reach | Metrics |
CODE
|
CODE
|
conversions | The Number of Conversions | Metrics |
CODE
|
CODE
|
conversions_value | The Value associated with Conversions | Metrics |
CODE
|
CODE
|
purchase_conversions | The Number of Purchase Conversions | Metrics |
CODE
|
CODE
|
purchase_conversions_value | The Value associated with the Purchase Conversions | Metrics |
CODE
|
CODE
|
add_to_cart_conversions | The Number of Add To Cart Conversions | Metrics |
CODE
|
CODE
|
add_to_cart_conversions_value | The Value associated with the Add to Cart Conversions | Metrics |
CODE
|
CODE
|
app_install_conversions | The Number of App Install Conversions | Metrics |
CODE
|
CODE
|
app_install_conversions_value | The Value associated with App Install Conversions. | Metrics |
CODE
|
CODE
|
sign_up_conversions | The Number of Sign Up Conversions | Metrics |
CODE
|
CODE
|
sign_up_conversions_value | The Value associated with App Install Conversions | Metrics |
CODE
|
CODE
|
total_conversions | The Total Number of Conversions | Metrics |
CODE
|
CODE
|
total_conversions_value | The Value associated with the Total Number of Conversions | Metrics |
CODE
|
CODE
|
click_through_conversions | The Number of Click Through Conversions | Metrics |
CODE
|
CODE
|
click_through_conversions_value | The Value associated with the Click Through Conversions | Metrics |
CODE
|
CODE
|
view_through_conversions | The Number of View Through Conversions | Metrics |
CODE
|
CODE
|
view_through_conversions_value | The Value associated with the View Through Conversions | Metrics |
CODE
|
CODE
|
video_starts | Video Starts | Metrics |
CODE
|
CODE
|
video_views | Video Views | Metrics |
CODE
|
CODE
|
video_3s_watched | Video 3-Second Watched | Metrics |
CODE
|
CODE
|
video_p25_watched | Video Completions - 25% | Metrics |
CODE
|
CODE
|
video_p50_watched | Video Completions - 50% | Metrics |
CODE
|
CODE
|
video_p75_watched | Video Completions - 75% | Metrics |
CODE
|
CODE
|
video_p95_watched | Video Completions - 95% | Metrics |
CODE
|
CODE
|
video_p100_watched | Video Completions | Metrics |
CODE
|
CODE
|
impression_opportunities | The Potential Impressions that a Keyword could be Displayed | Metrics |
CODE
|
CODE
|
abs_top_search_impression_opportunities | The Potential Impressions that a Keyword could be Displayed at the absolute top location (the very first ad above the organic search results). | Metrics |
CODE
|
CODE
|
top_search_impressions | The Impressions that a Keyword could receive in the top location (anywhere above the organic search results). | Metrics |
CODE
|
CODE
|
abs_top_search_impressions | The Impressions that a Keyword could receive when shown as the very first ad above the organic search results. | Metrics |
CODE
|
CODE
|