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',
'google ads': 'Date',
'dv360': 'Date'
}
|
CODE
{
'cm360': 'date',
'facebook ads': 'TimePeriod',
'snapchat ads': 'date',
'taboola / yahoo native network': 'date',
'tiktok ads': 'date',
'google ads': 'date',
'dv360': '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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'site',
'facebook ads': 'publisher_platform',
'snapchat ads': 'N/A',
'taboola / yahoo native network': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'Google Ads',
'dv360': 'DV360'
}
|
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',
'google ads': 'YouTube',
'dv360': 'YouTube'
}
|
channel | The Default Alli Data Library Channel (Hard Coded) | Dimensions | N/A
|
CODE
{
'cm360': 'DISPLAY',
'facebook ads': 'SOCIAL',
'snapchat ads': 'SOCIAL',
'tiktok ads': 'SOCIAL',
'google ads': 'DISPLAY',
'dv360': 'DISPLAY'
}
|
account_id | The Ad Account Identifier | Dimensions |
CODE
{
'cm360': 'Advertiser ID',
'facebook ads': 'Account ID',
'snapchat ads': 'Account',
'tiktok ads': 'Advertiser account ID',
'google ads': 'Customer ID',
'dv360': 'Advertiser ID'
}
|
CODE
{
'cm360': 'advertiser_id',
'facebook ads': 'account_id',
'snapchat ads': 'accountId',
'tiktok ads': 'advertiser_id',
'google ads': 'customer_id',
'dv360': 'filter_advertiser'
}
|
account_name | The Ad Account Name | Dimensions |
CODE
{
'cm360': 'Advertiser',
'facebook ads': 'Account Name',
'snapchat ads': 'Account',
'tiktok ads': 'N/A',
'google ads': 'Customer Descrpitive Name',
'dv360': 'Advertiser Name'
}
|
CODE
{
'cm360': 'advertiser',
'facebook ads': 'account_name',
'snapchat ads': 'name' (from structure datasource),
'tiktok ads': 'N/A',
'google ads': 'customer_descriptive_name', (from structure datasource)
'dv360': 'filter_advertiser_name'
}
|
campaign_id | The Campaign Identifier | Dimensions |
CODE
{
'cm360': 'Campaign ID',
'facebook ads': 'Campaign Id',
'snapchat ads': 'Campaign Id',
'tiktok ads': 'Campaign Id',
'google ads': 'Campaign Id',
'dv360': 'Insertion Order'
}
|
CODE
{
'cm360': 'campaign_id',
'facebook ads': 'campaign_id',
'snapchat ads': 'campaignid',
'tiktok ads': 'campaign_id',
'google ads': 'campaign_id',
'dv360': 'filter_insertion_order'
}
|
campaign_name | The Campaign Name | Dimensions |
CODE
{
'cm360': 'Campaign',
'facebook ads': 'Campaign',
'snapchat ads': 'Campaign Name',
'google ads': 'Campaign Name',
'dv360': 'Insertion Order Name'
}
|
CODE
{
'cm360': 'campaign',
'facebook ads': 'campaign_name',
'snapchat ads': 'campaignname',
'tiktok ads': 'campaign_name' (from campaign structure datasource),
'google ads': 'campaign_name',
'dv360': 'filter_insertion_order_name'
}
|
campaign_status | The Current Campaign Status | Dimensions |
CODE
{
'cm360': 'N/A',
'facebook ads': 'Status',
'snapchat ads': 'Campaign Status',
'tiktok ads': 'N/A',
'google ads': 'Campaign Status',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'campaign_status',
'snapchat ads': 'status' (from campaign structure datasource),
'tiktok ads': 'N/A',
'google ads': 'campaign_status' (from campaign settings datasource),
'dv360': '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',
'google ads': 'Campaign Advertising Channel Type',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'campaign_system_origin' (from campaign structure datasource),
'google ads': 'campaign_advertising_channel_type' (from campaign settings datasource),
'dv360': 'N/A'
}
|
campaign_objective | The Objective of the Campaign | Dimensions |
CODE
{
'cm360': 'N/A',
'facebook ads': 'Objective',
'snapchat ads': 'Objective',
'tiktok ads': 'Advertising objective',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'objective',
'snapchat ads': 'objective',
'tiktok ads': 'objective_type',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
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',
'google ads': 'Campaign Budget Amount',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'daily_budget/100',
'snapchat ads': 'daily_budget_micro / 1000000',
'tiktok ads': 'N/A',
'google ads': 'campaign_budget_amount' (from campaign settings datasource),
'dv360': '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',
'google ads': 'Campaign Start Date',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'campaignstartdate',
'facebook ads': 'start_time',
'snapchat ads': 'start_time',
'tiktok ads': 'N/A',
'google ads': 'campaign_start_date' (from campaign settings datasource),
'dv360': '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',
'google ads': 'Campaign End Date',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'campaignenddate',
'facebook ads': 'stop_time',
'snapchat ads': 'end_time',
'tiktok ads': 'N/A',
'google ads': 'campaign_end_date' (from campaign settings datasource),
'dv360': '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',
'google ads': 'Ad group ID',
'dv360': 'Trueview Adgroup ID'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'adset_id',
'snapchat ads': 'adsquadid',
'tiktok ads': 'adgroup_id',
'google ads': 'adgroup_id',
'dv360': 'filter_trueview_ad_group_id' (from dv360_trueview_performance)
}
|
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',
'google ads': 'Ad group Name',
'dv360': 'Trueview Adgroup'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'adset_name',
'snapchat ads': 'adsquadname',
'tiktok ads': 'adgroup_name',
'google ads': 'adgroup_name' (from adgroup settings datasource),
'dv360': 'filter_trueview_ad_group' (from dv360_trueview_performance)
}
|
adgroup_type | The Adgroup Type | Dimensions |
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'Ad group Type',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'type' (from adgroup structure datasource),
'tiktok ads': 'N/A',
'google ads': 'adgroup_type',
'dv360': 'N/A'
}
|
adgroup_status | The Adgroup Status | Dimensions |
CODE
{
'cm360': 'N/A',
'facebook ads': 'Status',
'snapchat ads': 'Ad Sets Status',
'tiktok ads': 'N/A',
'google ads': 'Ad group Status',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'effective_status',
'snapchat ads': 'status' (from adgroup structure datasource),
'tiktok ads': 'N/A',
'google ads': 'adgroup_status',
'dv360': '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',
'google ads': 'N/A',
'dv360': 'Line Item ID'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'adset_id',
'snapchat ads': 'adsquadid',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'filter_line_item'
}
|
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',
'google ads': 'N/A',
'dv360': 'Line Item'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'adset_name',
'snapchat ads': 'adsquadname',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'filter_line_item_name'
}
|
ad_id | The Ad Identifier | Dimensions |
CODE
{
'cm360': 'N/A',
'facebook ads': 'Ad ID',
'snapchat ads': 'Ads ID',
'tiktok ads': 'Ad ID',
'google ads': 'Ad ID',
'dv360': 'Trueview Ad ID'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'ad_id',
'snapchat ads': 'adid',
'tiktok ads': 'ad_id',
'google ads': 'ad_id',
'dv360': 'filter_trueview_ad_group_ad_id'
}
|
ad_name | The Ad Name | Dimensions |
CODE
{
'cm360': 'N/A',
'facebook ads': 'Ad',
'snapchat ads': 'Ads Name',
'tiktok ads': 'Ad Name',
'google ads': 'Ad Name',
'dv360': 'Trueview Ad'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'ad_name',
'snapchat ads': 'adname',
'tiktok ads': 'ad_name' (from campaign structure datasource or from ads datasource),
'google ads': 'ad_name' (from ad settings datasource),
'dv360': 'filter_trueview_ad'
}
|
ad_type | The Ad Type | Dimensions |
CODE
{
'cm360': 'Ad Type',
'facebook ads': 'N/A',
'snapchat ads': 'Ads Type',
'tiktok ads': 'Ad Format',
'google ads': 'Ad Type',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'adtype',
'facebook ads': 'N/A',
'snapchat ads': 'type' (from ad structure datasource),
'tiktok ads': 'ad_format' (from campaign structure datasource),
'google ads': 'ad_type',
'dv360': 'N/A'
}
|
ad_status | The Ad Status | Dimensions |
CODE
{
'cm360': 'N/A',
'facebook ads': 'Ad Status',
'snapchat ads': 'Ads Status',
'tiktok ads': 'Secondary Status',
'google ads': 'Ad Group Ad Status',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'ad_status',
'snapchat ads': 'status' (from ad structure datasource),
'tiktok ads': 'status' (from campaign structure datasource),
'google ads': 'ad_group_ad_status',
'dv360': 'N/A'
}
|
cm_placement_id | Placement Identifier for CM260 | Dimensions |
CODE
{
'cm360': 'Placement Id',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'placementid',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'siteKeyname',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
placement_id | The Placement Identifier | Dimensions |
CODE
{
'cm360': 'Placement ID',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'placementid',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
placement_name | The Placement Name | Dimensions |
CODE
{
'cm360': 'Placement',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'placement',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'Youtube Video ID',
'dv360': 'Video ID'
}
|
CODE
{
'cm360': 'creativeid',
'facebook ads': 'creative_id',
'snapchat ads': 'creative_id',
'tiktok ads': 'video_id or image_ids' (from campaign structure datasource),
'google ads': 'youtube_video_id',
'dv360': 'video_id'
}
|
creative_name | The Creative Name | Dimensions |
CODE
{
'cm360': 'Creative',
'facebook ads': 'Ad Creative',
'snapchat ads': 'Creative details',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'creative',
'facebook ads': 'creative_name',
'snapchat ads': 'creative_name',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'coalesce(creativeSize, '0x0')',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': '{{ agencypmg_utils.creative_size('creative') }}',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'preview_shareable_link',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'call_to_action_type',
'snapchat ads': 'call_to_action',
'tiktok ads': 'call_to_action' (from campaign structure datasource),
'google ads': 'N/A',
'dv360': 'N/A'
}
|
destination_url | The destination URL | Dimensions |
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'URL',
'tiktok ads': 'Landing page URL',
'google ads': 'Ad Display URL',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'landing_page_url' (from campaign structure datasource),
'google ads': 'ad_display_url',
'dv360': 'N/A'
}
|
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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'music_id' (from campaign structure datasource),
'google ads': 'N/A',
'dv360': 'N/A'
}
|
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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'vertical_video_strategy' (from campaign structure datasource),
'google ads': 'N/A',
'dv360': 'N/A'
}
|
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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'carousel_image_index' (from campaign structure datasource),
'google ads': 'N/A',
'dv360': 'N/A'
}
|
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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'promotional_music_disabled' (from campaign structure datasource),
'google ads': 'N/A',
'dv360': 'N/A'
}
|
creative_type | Creative type for Shopping Ad | Dimensions |
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'Creative Type',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'creative_type' (from campaign structure datasource),
'google ads': 'N/A',
'dv360': 'N/A'
}
|
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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
cost | Costs (Ad Spend) | Metrics |
CODE
{
'cm360': 'Media Cost (Advertise Currency)',
'facebook ads': 'Amount Spend',
'snapchat ads': 'Spend',
'tiktok ads': 'Cost',
'google ads': 'Cost',
'dv360': 'Media Cost (Advertiser Currency)'
}
|
CODE
{
'cm360': 'mediacost',
'facebook ads': 'spend',
'snapchat ads': 'spend',
'tiktok ads': 'spend',
'google ads': 'cost',
'dv360': 'metric_media_cost_advertiser'
}
|
impressions | Impressions | Metrics |
CODE
{
'cm360': 'Impressions',
'facebook ads': 'Impressions',
'snapchat ads': 'Impressions',
'tiktok ads': 'Impressions',
'google ads': 'Impressions',
'dv360': 'Impressions'
}
|
CODE
{
'cm360': 'impressions',
'facebook ads': 'impressions'.
'snapchat ads': 'impressions',
'tiktok ads': 'impressions',
'google ads': 'impressions',
'dv360': 'metric_impressions'
}
|
clicks | Clicks | Metrics |
CODE
{
'cm360': 'Clicks',
'facebook ads': 'Link clicks',
'snapchat ads': 'Clicks',
'tiktok ads': 'Clicks',
'google ads': 'Clicks',
'dv360': 'Clicks'
}
|
CODE
{
'cm360': 'clicks',
'facebook ads': 'inline_link_clicks',
'snapchat ads': 'swipes',
'tiktok ads': 'clicks',
'google ads': 'clicks',
'dv360': 'metric_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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'action_landing_page_view',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'reach',
'snapchat ads': 'uniques',
'tiktok ads': 'reach',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
conversions | The Number of Conversions | Metrics |
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'Conversions',
'google ads': 'Conversions',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'conversion',
'google ads': 'conversions',
'dv360': 'N/A'
}
|
conversions_value | The Value associated with Conversions | Metrics |
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'Conversions Value',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'conversions_value',
'dv360': 'N/A'
}
|
purchase_conversions | The Number of Purchase Conversions | Metrics |
CODE
{
'cm360': 'N/A',
'facebook ads': 'Purchases'
'snapchat ads': 'Conversions: Purchases',
'tiktok ads': 'Purchases (app)',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'action_offsite_conversion_fb_pixel_purchase',
'snapchat ads': 'conversion_purchases',
'tiktok ads': 'complete_payment_conversions',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
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)',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'action_values_offsite_conversion_fb_pixel_purchase',
'snapchat ads': 'conversion_purchases_value',
'tiktok ads': 'complete_payment_conversion_value',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
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)',
'google ads': 'Conversions',
'dv360': 'N/A'
}
|
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',
'google ads': 'conversions',
'dv360': 'N/A'
}
|
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',
'google ads': 'Conversions Value',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'conversions_value',
'dv360': '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',
'google ads': 'Conversions',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'action_mobile_app_install',
'snapchat ads': 'total_installs',
'tiktok ads': 'app_install',
'google ads': 'conversions',
'dv360': 'N/A'
}
|
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',
'google ads': 'Conversions Value',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'conversions_value',
'dv360': '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',
'google ads': 'Conversions',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'action_offsite_conversion_fb_pixel_complete_registration',
'snapchat ads': 'conversion_sign_ups',
'tiktok ads': 'N/A',
'google ads': 'conversions',
'dv360': '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',
'google ads': 'Conversions Value',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'conversions_value',
'dv360': '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',
'google ads': 'All Conversions',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'actions'
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'all_conversions',
'dv360': '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',
'google ads': 'All Conversions Value',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'all_conversions_value',
'dv360': '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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'activityclickthroughconversions',
'facebook ads': 'N/A',
'snapchat ads': 'conversion_purchases_swipe_up',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'activityclickthroughrevenue',
'facebook ads': 'N/A',
'snapchat ads': 'conversion_purchases_value_swipe_up',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'activityviewthroughconversions',
'facebook ads': 'N/A',
'snapchat ads': 'conversion_purchases_view',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'activityviewthroughrevenue',
'facebook ads': 'N/A',
'snapchat ads': 'conversion_purchases_value_view',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
video_starts | Video Starts | Metrics |
CODE
{
'cm360': 'Video Plays',
'facebook ads': 'Video plays',
'snapchat ads': 'N/A',
'tiktok ads': 'Video views',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'richMediaVideoPlays',
'facebook ads': 'action_video_play',
'snapchat ads': 'N/A',
'tiktok ads': 'video_play_actions',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
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',
'google ads': 'Video Views',
'dv360': 'Trueview: Views'
}
|
CODE
{
'cm360': 'richMediaVideoViews',
'facebook ads': 'action_video_view',
'snapchat ads': 'video_views',
'tiktok ads': 'video_watched_2s',
'google ads': 'video_views',
'dv360': 'trueview_views'
}
|
video_3s_watched | Video 3-Second Watched | Metrics |
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': '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%',
'google ads': 'Video Views * Video Quartile p25 Rate',
'dv360': 'First-Quartile Views (Video)'
}
|
CODE
{
'cm360': 'richMediaVideoFirstQuartileCompletes',
'facebook ads': 'video_p25_watched_actions',
'snapchat ads': 'quartile_1',
'tiktok ads': 'video_views_p25',
'google ads': 'video_views * video_quartile_p25_rate',
'dv360': 'metric_rich_media_video_first_quartile_completes'
}
|
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%',
'google ads': 'Video Views * Video Quartile p50 Rate',
'dv360': 'Midpoint Views (Video)'
}
|
CODE
{
'cm360': 'richMediaVideoMidpoints',
'facebook ads': 'video_p50_watched_actions',
'snapchat ads': 'quartile_2',
'tiktok ads': 'video_views_p50',
'google ads': 'video_views * video_quartile_p50_rate',
'dv360': 'metric_rich_media_video_midpoints'
}
|
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%',
'google ads': 'Video Views * Video Quartile p75 Rate',
'dv360': 'Third-Quartile Views (Video)'
}
|
CODE
{
'cm360': 'richMediaVideoThirdQuartileCompletes',
'facebook ads': 'video_p75_watched_actions',
'snapchat ads': 'quartile_3',
'tiktok ads': 'video_views_p75',
'google ads': 'video_views * video_quartile_p75_rate',
'dv360': 'metric_rich_media_video_third_quartile_completes'
}
|
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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'video_p95_watched_actions',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': '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%',
'google ads': 'Video Views * Video Quartile p100 Rate',
'dv360': 'Complete Views (Video)'
}
|
CODE
{
'cm360': 'richMediaVideoCompletions',
'facebook ads': 'video_p100_watched_actions',
'snapchat ads': 'view_completion',
'tiktok ads': 'video_views_p100',
'google ads': 'video_views * video_quartile_p100_rate',
'dv360': 'metric_rich_media_video_completions'
}
|
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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'video_watched_continuous_2s',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'engaged_view',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
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',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
CODE
{
'cm360': 'N/A',
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'engaged_view_15s',
'google ads': 'N/A',
'dv360': 'N/A'
}
|
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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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',
'google ads': 'N/A',
'dv360': '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
|
