Skip to main content
Skip table of contents

Data Library Field Mapping - Creative Performance

Overview

This document describes how the columns from all the ad platforms are mapped to the creative_performance Alli Data Library Report.

To understand which Alli Data Datasources are used within the creative_performance report, see the following link: Data Library 2.0 Report DAGs | creative_performance & https://agencypmg.atlassian.net/wiki/spaces/PTD/whiteboard/3019210800

Platforms include:

  • CM360

  • Facebook Ads

  • Snapchat Ads

  • TikTok Ads

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

CODE
{
'cm360': 'Date',
'facebook ads': 'Date',
'snapchat ads': 'Date',
'taboola / yahoo native network': 'Date',
'tiktok ads': 'Date'
}
CODE
{
'cm360': 'date',
'facebook ads': 'TimePeriod',
'snapchat ads': 'date',
'taboola / yahoo native network': 'date',
'tiktok ads': 'date'
}

publisher_platform

The Publisher Platform on where the Creative delivered ads

Dimensions

CODE
{
'cm360': 'Site (CM360)',
'facebook ads': 'Publisher Platform',
'snapchat ads': 'N/A',
'taboola / yahoo native network': 'N/A',
'tiktok ads': 'N/A'
}

CODE
{
'cm360': 'site',
'facebook ads': 'publisher_platform',
'snapchat ads': 'N/A',
'taboola / yahoo native network': 'N/A',
'tiktok ads': 'N/A'
}

platform

The platform the Creative belongs to (Hard Coded)

Dimensions

N/A

CODE
{
'cm360': 'CM360',
'facebook ads': 'Facebook Ads',
'snapchat ads': 'Snapchat Ads',
'taboola / yahoo native network': 'Taboola / Yahoo Native Network',
'tiktok ads': 'TikTok Ads'
}

channel

The Default Alli Data Library Channel (Hard Coded)

Dimensions

N/A

CODE
{
'cm360': 'DISPLAY',
'facebook ads': 'SOCIAL',
'snapchat ads': 'SOCIAL',
'tiktok ads': 'SOCIAL'
}

account_id

The Ad Account Identifier

Dimensions

CODE
{
'cm360': 'Advertiser ID',
'facebook ads': 'Account ID',
'snapchat ads': 'Account',
'tiktok ads': 'Advertiser account ID'
}

(just adding this line so I can add comment)

CODE
{
'cm360': 'advertiser_id',
'facebook ads': 'account_id',
'snapchat ads': 'accountId',
'tiktok ads': 'advertiser_id'
}

account_name

The Ad Account Name

Dimensions

CODE
{
'cm360': 'Advertiser',
'facebook ads': 'Account Name',
'snapchat ads': 'Account',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'advertiser',
'facebook ads': 'account_name',
'snapchat ads': 'name' (from structure datasource),
'tiktok ads': 'N/A'
}

campaign_id

The Campaign Identifier

Dimensions

CODE
{
'cm360': 'Campaign ID',
'facebook ads': 'Campaign Id',
'snapchat ads': 'Campaign Id',
'tiktok ads': 'Campaign ID'
}
CODE
{
'cm360': 'campaign_id',
'facebook ads': 'campaign_id',
'snapchat ads': 'campaignid',
'tiktok ads': 'campaign_id'
}

campaign_name

The Campaign Name

Dimensions

CODE
{
'cm360': 'Campaign',
'facebook ads': 'Campaign',
'snapchat ads': 'Campaign name'
}
CODE
{
'cm360': 'campaign',
'facebook ads': 'campaign_name',
'snapchat ads': 'campaignname',
'tiktok ads': 'campaign_name' (from campaign structure datasource)
}

campaign_status

The Current Campaign Status

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'Status',
'snapchat ads': 'Campaign Status',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'campaign_status',
'snapchat ads': 'status' (from campaign structure datasource),
'tiktok ads': 'N/A'
}

campaign_type

The Campaign Type

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'campaign System Origin'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'campaign_system_origin' (from campaign structure datasource)
}

campaign_objective

The Objective of the Campaign

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'Objective',
'snapchat ads': 'Objective',
'tiktok ads': 'Advertising objective'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'objective',
'snapchat ads': 'objective',
'tiktok ads': 'objective_type'
}

campaign_daily_budget

The Daily Budget of the Campaign

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'Budget',
'snapchat ads': 'Daily Spend Cap',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'daily_budget/100',
'snapchat ads': 'daily_budget_micro / 1000000',
'tiktok ads': 'N/A'
}

campaign_start_date

The Campaign Start Date

Dimensions

CODE
{
'cm360': 'Campaign Start Date',
'facebook ads': 'Starts',
'snapchat ads': 'Start Time',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'campaignstartdate',
'facebook ads': 'start_time',
'snapchat ads': 'start_time',
'tiktok ads': 'N/A'
}

campaign_end_date

The Campaign End Date

Dimensions

CODE
{
'cm360': 'Campaign End Date',
'facebook ads': 'Ends',
'snapchat ads': 'End Time',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'campaignenddate',
'facebook ads': 'stop_time',
'snapchat ads': 'end_time',
'tiktok ads': 'N/A'
}

adgroup_id

The Adgroup Identifier

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'Ad set ID',
'snapchat ads': 'Ad Sets ID',
'tiktok ads': 'Ad group ID'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'adset_id',
'snapchat ads': 'adsquadid',
'tiktok ads': 'adgroup_id'
}

adgroup_name

The Adgroup Name

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'Ad Set Name',
'snapchat ads': 'Ad Sets Name',
'tiktok ads': 'Ad group name'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'adset_name',
'snapchat ads': 'adsquadname',
'tiktok ads': 'adgroup_name'
}

adgroup_type

The Adgroup Type

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'type' (from adgroup structure datasource),
'tiktok ads': 'N/A'
}

adgroup_status

The Adgroup Status

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'Status',
'snapchat ads': 'Ad Sets Status',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'effective_status',
'snapchat ads': 'status' (from adgroup structure datasource),
'tiktok ads': 'N/A'
}

line_item_id

The Line Item Identifier

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'Ad set ID',
'snapchat ads': 'Ad Sets ID',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'adset_id',
'snapchat ads': 'adsquadid',
'tiktok ads': 'N/A'
}

line_item_name

The Line Item Name

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'Ad set Name',
'snapchat ads': 'Ad Sets Name',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'adset_name',
'snapchat ads': 'adsquadname',
'tiktok ads': 'N/A'
}

ad_id

The Ad Identifier

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'Ad ID',
'snapchat ads': 'Ads ID',
'tiktok ads': 'Ad ID'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'ad_id',
'snapchat ads': 'adid',
'tiktok ads': 'ad_id'
}

ad_name

The Ad Name

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'Ad',
'snapchat ads': 'Ads Name',
'tiktok ads': 'Ad name'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'ad_name',
'snapchat ads': 'adname',
'tiktok ads': 'ad_name' (from campaign structure datasource or from ads datasource)
}

ad_type

The Ad Type

Dimensions

CODE
{
'cm360': 'Ad Type',
'facebook ads': 'N/A',
'snapchat ads': 'Ads Type',
'tiktok ads': 'Ad Format'
}
CODE
{
'cm360': 'adtype',
'facebook ads': 'N/A',
'snapchat ads': 'type' (from ad structure datasource),
'tiktok ads': 'ad_format' (from campaign structure datasource)
}

ad_status

The Ad Status

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'Ad Status',
'snapchat ads': 'Ads Status',
'tiktok ads': 'Secondary Status'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'ad_status',
'snapchat ads': 'status' (from ad structure datasource),
'tiktok ads': 'status' (from campaign structure datasource)
}

cm_placement_id

Placement Identifier for CM260

Dimensions

CODE
{
'cm360': 'Placement Id',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'placementid',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

site_key_name

A Unique Identifier that's included in the CM360 Tags of Placements associated with a Given Site

Dimensions

CODE
{
'cm360': 'Site Keyname',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'siteKeyname',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

placement_id

The Placement Identifier

Dimensions

CODE
{
'cm360': 'Placement ID',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'placementid',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

placement_name

The Placement Name

Dimensions

CODE
{
'cm360': 'Placement',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'placement',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

creative_id

The Creative Identifier

Dimensions

CODE
{
'cm360': 'Creative ID',
'facebook ads': 'Ad Creative ID',
'snapchat ads': 'N/A',
'tiktok ads': 'Video ID or Image IDs'
}
CODE
{
'cm360': 'creativeid',
'facebook ads': 'creative_id',
'snapchat ads': 'creative_id',
'tiktok ads': 'video_id or image_ids' (from campaign structure datasource)
}

creative_name

The Creative Name

Dimensions

CODE
{
'cm360': 'Creative',
'facebook ads': 'Ad Creative',
'snapchat ads': 'Creative details',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'creative',
'facebook ads': 'creative_name',
'snapchat ads': 'creative_name',
'tiktok ads': 'N/A'
}

creative_size

The Creative Size

Dimensions

CODE
{
'cm360': 'coalesce(Creative Pixel Size, '0x0')',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'coalesce(creativeSize, '0x0')',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

creative_size_from_name

The Creative Size Extracted from the Name of the Creative

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': '{{ agencypmg_utils.creative_size('creative') }}',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

ad_preview_link

The Preview Link of the Ad

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'Preview link',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'preview_shareable_link',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

call_to_action_type

Type of Call to Action Button in the Ad

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'Call to action',
'snapchat ads': 'Call To Action',
'tiktok ads': 'Call to Action'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'call_to_action_type',
'snapchat ads': 'call_to_action',
'tiktok ads': 'call_to_action' (from campaign structure datasource)
}

destination_url

The destination URL

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'URL',
'tiktok ads': 'Landing page URL'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'landing_page_url' (from campaign structure datasource)
}

music_id

The ID of the piece of music that is used in the Ad

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'Music ID'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'music_id' (from campaign structure datasource)
}

vertical_vid_strategy

The video type used for Product Sales scenarios

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'Vertical Video Strategy'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'vertical_video_strategy' (from campaign structure datasource)
}

carousel_image_index

The index that specifies the additional images to be used in the Carousel ad

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'Carousel Image Index'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'carousel_image_index' (from campaign structure datasource)
}

promotional_music_disabled

Whether to disable the promotional use of the music in the Ad post

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'Promotional Music Disabled'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'promotional_music_disabled' (from campaign structure datasource)
}

creative_type

Creative type for Shopping Ad

Dimensions

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'Creative Type'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'creative_type' (from campaign structure datasource)
}

video_duration

The Length of Time A Video runs

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cost

Costs (Ad Spend)

Metrics

CODE
{
'cm360': 'Media Cost (Advertise Currency)',
'facebook ads': 'Amount Spend',
'snapchat ads': 'Spend',
'tiktok ads': 'Cost'
}
CODE
{
'cm360': 'mediacost',
'facebook ads': 'spend',
'snapchat ads': 'spend',
'tiktok ads': 'spend'
}

impressions

Impressions

Metrics

CODE
{
'cm360': 'Impressions',
'facebook ads': 'Impressions',
'snapchat ads': 'Impressions',
'tiktok ads': 'Impressions'
}
CODE
{
'cm360': 'impressions',
'facebook ads': 'impressions'.
'snapchat ads': 'impressions',
'tiktok ads': 'impressions'
}

clicks

Clicks

Metrics

CODE
{
'cm360': 'Clicks',
'facebook ads': 'Link clicks',
'snapchat ads': 'Clicks',
'tiktok ads': 'Clicks'
}
CODE
{
'cm360': 'clicks',
'facebook ads': 'inline_link_clicks',
'snapchat ads': 'swipes',
'tiktok ads': 'clicks'
}

landing_page_views

The Number of Landing Page Views

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'Landing page views',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'action_landing_page_view',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

reach

The Total Number of People who Saw the Ad Content

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'Reach',
'snapchat ads': 'Paid Reach',
'tiktok ads': 'Reach'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'reach',
'snapchat ads': 'uniques',
'tiktok ads': 'reach'
}

conversions

The Number of Conversions

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'Content views (app)'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'total_view_content'
}

conversions_value

The Value associated with Conversions

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'Content view value (app)'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'total_view_content_value'
}

purchase_conversions

The Number of Purchase Conversions

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'Purchases'
'snapchat ads': 'Conversions: Purchases',
'tiktok ads': 'Purchases (app)'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'action_offsite_conversion_fb_pixel_purchase',
'snapchat ads': 'conversion_purchases',
'tiktok ads': 'total_purchase'
}

purchase_conversions_value

The Value associated with the Purchase Conversions

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'Purchase Value',
'snapchat ads': 'Conversions: Purchases Value',
'tiktok ads': 'Purchase value (app)'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'action_values_offsite_conversion_fb_pixel_purchase',
'snapchat ads': 'conversion_purchases_value',
'tiktok ads': 'total_purchase_value'
}

add_to_cart_conversions

The Number of Add To Cart Conversions

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'Adds to cart',
'snapchat ads': 'N/A',
'tiktok ads': 'Adds to cart (app)'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'action_offsite_conversion_fb_pixel_add_to_cart',
'snapchat ads': 'N/A',
'tiktok ads': 'total_app_event_add_to_cart'
}

add_to_cart_conversions_value

The Value associated with the Add to Cart Conversions

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

app_install_conversions

The Number of App Install Conversions

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'App installs',
'snapchat ads': 'App Installs',
'tiktok ads': 'App Install'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'action_mobile_app_install',
'snapchat ads': 'total_installs',
'tiktok ads': 'app_install'
}

app_install_conversions_value

The Value associated with App Install Conversions

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

sign_up_conversions

The Number of Sign Up Conversions

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'Registration completed',
'snapchat ads': 'Conversions: Sign Ups',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'action_offsite_conversion_fb_pixel_complete_registration',
'snapchat ads': 'conversion_sign_ups',
'tiktok ads': 'N/A'
}

sign_up_conversions_value

The Value associated with Sign Up Conversions

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

total_conversions

The Total Number of Conversions

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'Actions',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'actions'
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

total_conversions_value

The Value associated with the Total Number of Conversions

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

click_through_conversions

The Number of Click Through Conversions

Metrics

CODE
{
'cm360': 'Click-through Conversions',
'facebook ads': 'N/A',
'snapchat ads': 'Conversions Click: Purchases Click',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'activityclickthroughconversions',
'facebook ads': 'N/A',
'snapchat ads': 'conversion_purchases_swipe_up',
'tiktok ads': 'N/A'
}

click_through_conversions_value

The Value associated with the Click Through Conversions

Metrics

CODE
{
'cm360': 'Click-through Revenue',
'facebook ads': 'N/A',
'snapchat ads': 'Conversions Click: Purchases Value Click',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'activityclickthroughrevenue',
'facebook ads': 'N/A',
'snapchat ads': 'conversion_purchases_value_swipe_up',
'tiktok ads': 'N/A'
}

view_through_conversions

The Number of View Through Conversions

Metrics

CODE
{
'cm360': 'View-through Conversions',
'facebook ads': 'N/A',
'snapchat ads': 'Converions View: Purchases View',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'activityviewthroughconversions',
'facebook ads': 'N/A',
'snapchat ads': 'conversion_purchases_view',
'tiktok ads': 'N/A'
}

view_through_conversions_value

The Value associated with the View Through Conversions

Metrics

CODE
{
'cm360': 'View-through Revenue',
'facebook ads': 'N/A',
'snapchat ads': 'Converions View: Purchases Value View',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'activityviewthroughrevenue',
'facebook ads': 'N/A',
'snapchat ads': 'conversion_purchases_value_view',
'tiktok ads': 'N/A'
}

video_starts

Video Starts

Metrics

CODE
{
'cm360': 'Video Plays',
'facebook ads': 'Video plays',
'snapchat ads': 'N/A',
'tiktok ads': 'Video views'
}
CODE
{
'cm360': 'richMediaVideoPlays',
'facebook ads': 'action_video_play',
'snapchat ads': 'N/A',
'tiktok ads': 'video_play_actions'
}

video_views

Video Views

Metrics

CODE
{
'cm360': 'Video Views',
'facebook ads': '3-second video plays',
'snapchat ads': '2 Second Video Views',
'tiktok ads': '2-second video views'
}
CODE
{
'cm360': 'richMediaVideoViews',
'facebook ads': 'action_video_view',
'snapchat ads': 'video_views',
'tiktok ads': 'video_watched_2s'
}

video_3s_watched

Video 3-Second Watched

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

video_p25_watched

Video Completions - 25%

Metrics

CODE
{
'cm360': 'Video First Quartile Completions',
'facebook ads': 'Video plays at 25%',
'snapchat ads': 'Video Plays at 25%',
'tiktok ads': 'Video views at 25%'
}
CODE
{
'cm360': 'richMediaVideoFirstQuartileCompletes',
'facebook ads': 'video_p25_watched_actions',
'snapchat ads': 'quartile_1',
'tiktok ads': 'video_views_p25'
}

video_p50_watched

Video Completions - 50%

Metrics

CODE
{
'cm360': 'Video Midpoints',
'facebook ads': 'Video plays at 50%',
'snapchat ads': 'Video Plays at 50%',
'tiktok ads': 'Video views at 50%'
}
CODE
{
'cm360': 'richMediaVideoMidpoints',
'facebook ads': 'video_p50_watched_actions',
'snapchat ads': 'quartile_2',
'tiktok ads': 'video_views_p50'
}

video_p75_watched

Video Completions - 75%

Metrics

CODE
{
'cm360': 'Video Third Quartile Completions',
'facebook ads': 'Video plays at 75%',
'snapchat ads': 'Video Plays at 75%',
'tiktok ads': 'Video views at 75%'
}
CODE
{
'cm360': 'richMediaVideoThirdQuartileCompletes',
'facebook ads': 'video_p75_watched_actions',
'snapchat ads': 'quartile_3',
'tiktok ads': 'video_views_p75'
}

video_p95_watched

Video Completions - 95%

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'Video plays at 95%',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'video_p95_watched_actions',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

video_p100_watched

Video Completions - 100%

Metrics

CODE
{
'cm360': 'Video Completions',
'facebook ads': 'Video plays at 100%',
'snapchat ads': 'Video Completions',
'tiktok ads': 'Video views at 100%'
}
CODE
{
'cm360': 'richMediaVideoCompletions',
'facebook ads': 'video_p100_watched_actions',
'snapchat ads': 'view_completion',
'tiktok ads': 'video_views_p100'
}

video_watched_2s_continuous

2-second continuous video views

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': '2-second Continuous Video Views'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'video_watched_continuous_2s'
}

focused_view_6s

Number of times your video was played for at least 6 seconds

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': '6-second focused views'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'engaged_view'
}

focused_view_15s

Number of times your video was played for at least 15 seconds

Metrics

CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': '15-second focused views'
}
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'engaged_view_15s'
}

cm_cost

Cost (Ad Spend) for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(mediacost), 0.0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_impressions

Impressions for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(impressions), 0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_clicks

Clicks for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(clicks), 0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_click_through_conversions

The Number of Click Through Conversions for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(activityclickthroughconversions), 0.0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_view_through_conversions

The Number of View Through Conversions for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(activityviewthroughconversions), 0.0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_total_conversions

The Number of Total Conversions for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(totalconversions), 0.0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_click_through_conversions_value

The Value associated with the Click Through Conversions for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(activityclickthroughrevenue), 0.0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_view_through_conversions_value

The Value associated with the View Through Conversions for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(activityviewthroughrevenue), 0.0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_total_conversions_value

The Value associated with Total Conversions for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(totalconversionsrevenue), 0.0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_video_starts

Video Starts for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(richMediaVideoPlays), 0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_video_views

Video Views for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(richMediaVideoViews), 0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_video_p25_watched

Video Completions - 25% for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(richMediaVideoFirstQuartileCompletes), 0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_video_p50_watched

Video Completions - 50% for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(richMediaVideoMidpoints), 0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_video_p75_watched

Video Completions - 75% for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(richMediaVideoThirdQuartileCompletes), 0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_video_p100_watched

Video Completions - 100% for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(sum(richmediavideocompletions), 0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

cm_effective_cpm

Effective CPM for CM360

Metrics

N/A

CODE
{
'cm360': 'coalesce(max(effective_cpm), 0)',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.