Data Library Field Mapping - Searchterm Performance
Overview
This document describes how the columns from search ad platforms are mapped to the searchterm_performance
Alli Data Library Report.
Platforms include:
Google Ads
Microsoft Bing
Apple Search Ads
To understand which Alli Data Datasources are used within the searchterm_performance
report, see the following link: Data Library 2.0 Report DAGs | searchterm_performance & https://agencypmg.atlassian.net/wiki/spaces/PTD/whiteboard/3018555479
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 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 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_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
|
search_query | The Search Query Text | Dimensions |
CODE
|
CODE
|
query_match_type_with_variant | The Match Type of the Search Term | Dimensions |
CODE
|
CODE
|
query_targeting_status | Indicates whether the Search Term is currently one of the Targeted or Excluded Keywords | Dimensions |
CODE
|
CODE
|
searchquery_destination_url | The Destination URL of the Search Query | Dimensions |
CODE
|
CODE
|
bid_match_type | The Match Type of Bidding Action | Dimensions |
CODE
|
CODE
|
delivered_match_type | The Match Type used to Deliver an Ad | Dimensions |
CODE
|
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 |
|
|
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
|
total_conversions | The Total Number of Conversions | Metrics |
CODE
|
CODE
|