Data Library Field Mapping - Dynamic Creative Performance
Overview
This document describes how all ad platform columns are mapped to the dynamic_creative_performance
certified data source.
To understand which Alli Data Data sources are used within the dynamic_creative_performance
report, see the following link: https://agencypmg.atlassian.net/wiki/spaces/PTD/whiteboard/4051271721?atl_f=PAGETREE
Platforms include:
CM360
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 Mapping |
---|---|---|---|---|
id | The Internal Alli Id of the Record |
|
|
|
source | The Source Table of Row |
|
|
|
date | The Date of Performance Data | Dimensions |
CODE
|
CODE
|
publisher_platform | The Publisher Platform on where the Creative delivered ads | Dimensions |
CODE
|
CODE
|
platform | The platform the Creative belongs to (Hard Coded) | Dimensions |
|
CODE
|
channel | The Default Alli Data Library Channel (Hard Coded) | Dimensions |
|
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 Adgroup Status | Dimensions |
CODE
|
CODE
|
line_item_id | The Line Item Identifier | Dimensions |
CODE
|
CODE
|
line_item_name | The Line Item Name | Dimensions |
CODE
|
CODE
|
ad_id | The Ad Identifier | Dimensions |
CODE
|
CODE
|
ad_name | The Ad Name | Dimensions |
CODE
|
CODE
|
ad_type | The Ad Type | Dimensions |
CODE
|
CODE
|
ad_status | The Ad Status | Dimensions |
CODE
|
CODE
|
cm_placement_id | Placement Identifier for CM260 | Dimensions |
CODE
|
CODE
|
placement_id | The Placement Identifier | Dimensions |
CODE
|
CODE
|
placement_name | The Placement Name | Dimensions |
CODE
|
CODE
|
creative_id | The Creative Identifier | Dimensions |
CODE
|
CODE
|
creative_name | The Creative Name | Dimensions |
CODE
|
CODE
|
creative_type | Creative type for Shopping Ad | Dimensions |
CODE
|
CODE
|
dynamic_template_id | Dynamic profile ID | Dimensions |
CODE
|
CODE
|
dynamic_template | Dynamic profile Name | Dimensions |
CODE
|
CODE
|
dynamic_variant_id | Dynamic Feed ID | Dimensions |
CODE
|
CODE
|
dynamic_variant | Dynamic Feed Label | Dimensions |
CODE
|
CODE
|
cost | Costs (Ad Spend) | Metrics |
CODE
|
CODE
|
impressions | Impressions | Metrics |
CODE
|
CODE
|
clicks | Clicks | Metrics |
CODE
|
CODE
|
landing_page_views | The Number of Landing Page Views | Metrics |
CODE
|
CODE
|
reach | The Total Number of People who Saw the Ad Content | 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 Sign Up 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 - 100% | Metrics |
CODE
|
CODE
|
core_media_channel | The channel that the platform is a part of | Categorization |
|
|
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 |
|
|
social_asc | Whether Campaign contains ASC or Advantage | Categorization |
|
|