Breadcrumbs

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

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

 
{
'cm360': 'Date',
}

{
'cm360': 'date',
}

publisher_platform

The Publisher Platform on where the Creative delivered ads

Dimensions

 
{
'cm360': 'Site (CM360)',
}



{
'cm360': 'site',
}

platform

The platform the Creative belongs to (Hard Coded)

Dimensions

N/A

 
{
'cm360': 'CM360',
}

channel

The Default Alli Data Library Channel (Hard Coded)

Dimensions

N/A

 
{
'cm360': 'DISPLAY',
}

account_id

The Ad Account Identifier

Dimensions

 
{
'cm360': 'Advertiser ID',
}

{
'cm360': 'advertiser_id',
}

account_name

The Ad Account Name

Dimensions

 
{
'cm360': 'Advertiser',
}

{
'cm360': 'advertiser',
}

campaign_id

The Campaign Identifier

Dimensions

 
{
'cm360': 'Campaign ID',
}

{
'cm360': 'campaign_id',
}

campaign_name

The Campaign Name

Dimensions

 
{
'cm360': 'Campaign',
}

{
'cm360': 'campaign',
}

campaign_status

The Current Campaign Status

Dimensions

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

campaign_type

The Campaign Type

Dimensions

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

campaign_objective

The Objective of the Campaign

Dimensions

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

campaign_daily_budget

The Daily Budget of the Campaign

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

campaign_start_date

The Campaign Start Date

Dimensions

 
{
'cm360': 'Campaign Start Date',
}

{
'cm360': 'campaignstartdate',
}

campaign_end_date

The Campaign End Date

Dimensions

 
{
'cm360': 'Campaign End Date',
}

{
'cm360': 'campaignenddate',
}

adgroup_id

The Adgroup Identifier

Dimensions

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

adgroup_name

The Adgroup Name

Dimensions

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

adgroup_type

The Adgroup Type

Dimensions

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

adgroup_status

The Adgroup Status

Dimensions

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

line_item_id

The Line Item Identifier

Dimensions

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

line_item_name

The Line Item Name

Dimensions

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

ad_id

The Ad Identifier

Dimensions

 
{
'cm360': 'Ad ID',
}

{
'cm360': 'ad_id',
}

ad_name

The Ad Name

Dimensions

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

ad_type

The Ad Type

Dimensions

 
{
'cm360': 'Ad Type',
}

{
'cm360': 'adtype',
}

ad_status

The Ad Status

Dimensions

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

cm_placement_id

Placement Identifier for CM260

Dimensions

 
{
'cm360': 'Placement Id',
}

{
'cm360': 'placementid',
}

placement_id

The Placement Identifier

Dimensions

 
{
'cm360': 'Placement ID',
}

{
'cm360': 'placementid',
}

placement_name

The Placement Name

Dimensions

 
{
'cm360': 'Placement',
}

{
'cm360': 'placement',
}

creative_id

The Creative Identifier

Dimensions

 
{
'cm360': 'Creative ID',
}

{
'cm360': 'creativeid',
}

creative_name

The Creative Name

Dimensions

 
{
'cm360': 'Creative',
}

{
'cm360': 'creative',
}

creative_type

Creative type for Shopping Ad

Dimensions

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

dynamic_template_id

Dynamic profile ID

Dimensions

 
{
'cm360': 'Dynamic Profile ID',
}

{
'cm360': 'dynamic_profile_id',
}

dynamic_template

Dynamic profile Name

Dimensions

 
{
'cm360': 'Dynamic Profile',
}

{
'cm360': 'dynamic_profile',
}

dynamic_variant_id

Dynamic Feed ID

Dimensions

 
{
'cm360': 'Feed 1 - Unique ID',
}

{
'cm360': 'feed_1_unique_id',
}

dynamic_variant

Dynamic Feed Label

Dimensions

 
{
'cm360': 'Feed 1 - Reporting Label',
}

{
'cm360': 'feed_1_reporting_label',
}

cost

Costs (Ad Spend)

Metrics

 
{
'cm360': 'Media Cost (Advertise Currency)',
}

{
'cm360': 'mediacost',
}

impressions

Impressions

Metrics

 
{
'cm360': 'Impressions',
}

{
'cm360': 'impressions',
}

clicks

Clicks

Metrics

 
{
'cm360': 'Clicks',
}

{
'cm360': 'clicks',
}

landing_page_views

The Number of Landing Page Views

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

reach

The Total Number of People who Saw the Ad Content

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

conversions

The Number of Conversions

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

conversions_value

The Value associated with Conversions

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

purchase_conversions

The Number of Purchase Conversions

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

purchase_conversions_value

The Value associated with the Purchase Conversions

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

add_to_cart_conversions

The Number of Add To Cart Conversions

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

add_to_cart_conversions_value

The Value associated with the Add to Cart Conversions

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

app_install_conversions

The Number of App Install Conversions

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

app_install_conversions_value

The Value associated with App Install Conversions

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

sign_up_conversions

The Number of Sign Up Conversions

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

sign_up_conversions_value

The Value associated with Sign Up Conversions

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

total_conversions

The Total Number of Conversions

Metrics

 
{
'cm360': 'Total Conversions',
}

{
'cm360': 'totalconversions',
}

total_conversions_value

The Value associated with the Total Number of Conversions

Metrics

 
{
'cm360': 'Total Revenue,
}

{
'cm360': 'totalconversionsrevenue',
}

click_through_conversions

The Number of Click Through Conversions

Metrics

 
{
'cm360': 'Click-through Conversions',
}

{
'cm360': 'activityclickthroughconversions',
}

click_through_conversions_value

The Value Associated with the Click Through Conversions

Metrics

 
{
'cm360': 'Click-through Revenue',
}

{
'cm360': 'activityclickthroughrevenue',
}

view_through_conversions

The Number of View-Through Conversions

Metrics

 
{
'cm360': 'View-through Conversions',
}

{
'cm360': 'activityviewthroughconversions',
}

view_through_conversions_value

The Value associated with the View Through Conversions

Metrics

 
{
'cm360': 'View-through Revenue',
}

{
'cm360': 'activityviewthroughrevenue',
}

video_starts

Video Starts

Metrics

 
{
'cm360': 'Video Plays',
}

{
'cm360': 'richMediaVideoPlays',
}

video_views

Video Views

Metrics

 
{
'cm360': 'Video Views',
}

{
'cm360': 'richMediaVideoViews',
}

video_3s_watched

Video 3-Second Watched

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

video_p25_watched

Video Completions - 25%

Metrics

 
{
'cm360': 'Video First Quartile Completions',
}

{
'cm360': 'richMediaVideoFirstQuartileCompletes',
}

video_p50_watched

Video Completions - 50%

Metrics

 
{
'cm360': 'Video Midpoints',
}

{
'cm360': 'richMediaVideoMidpoints',
}

video_p75_watched

Video Completions - 75%

Metrics

 
{
'cm360': 'Video Third Quartile Completions',
}

{
'cm360': 'richMediaVideoThirdQuartileCompletes',
}

video_p95_watched

Video Completions - 95%

Metrics

 
{
'cm360': 'N/A',
}

{
'cm360': 'N/A',
}

video_p100_watched

Video Completions - 100%

Metrics

 
{
'cm360': 'Video Completions',
}

{
'cm360': 'richMediaVideoCompletions',
}

core_media_channel

The channel that the platform is a part of

Categorization

N/A

N/A

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

social_asc

Whether Campaign contains ASC or Advantage

Categorization

N/A

N/A