Skip to main content
Skip table of contents

Data Library Field Mapping - Platform Device Performance

Overview

This document describes how all ad platform columns are mapped to the platform_device_performance certified data source.

Platforms include:

  • Facebookads

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

date

The Date of Performance Data

Dimensions

CODE
{
'facebook ads': 'Date'
}
CODE
{
'facebook ads': 'date'
}

source

The Source Table of Row

N/A

N/A

N/A

platform

The platform the Advertising Platform of each row.

Dimensions

N/A

CODE
{
'facebook ads': 'Facebook Ads'
}

impression_device

Target age buckets

Dimensions

CODE
{
'facebook ads': 'impression device'
}
CODE
{
'facebook ads': 'impression_device'
}

platform_position

Target gender.

Dimensions

CODE
{
'facebook ads': 'platform position'
}
CODE
{
'facebook ads': 'platform_position'
}

cost

Costs (Ad Spend)

Metrics

CODE
{
'facebook ads': 'Amount Spend'
}
CODE
{
'facebook ads': 'spend'
}

impressions

Impressions

Metrics

CODE
{
'facebook ads': 'Impressions'
}
CODE
{
'facebook ads': 'impressions'
}

clicks

Clicks

Metrics

CODE
{
'facebook ads': 'Link clicks'
}
CODE
{
'facebook ads': 'clicks'
}

landing_page_views

The Number of Landing Page Views

Metrics

CODE
{
'facebook ads': 'Landing page views'
}
CODE
{
'facebook ads': 'landing_page_view'
}

reach

The Total Number of People who Saw the Ad Content

Metrics

CODE
{
'facebook ads': 'reach'
}
CODE
{
'facebook ads': 'reach'
}

conversions

The Number of Conversions

Metrics

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'N/A'
}

conversions_value

The Value associated with Conversions

Metrics

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'N/A'
}

purchase_conversions

The Number of Purchase Conversions

Metrics

CODE
{
'facebook ads': 'Purchases'
}
CODE
{
'facebook ads': 'offline_purchase_conversions'
}

purchase_conversions_value

The Value associated with the Purchase Conversions

Metrics

CODE
{
'facebook ads': 'Purchase Value'
}
CODE
{
'facebook ads': 'offsite_purchase_conversions_valu'
}

add_to_cart_conversions

The Number of Add To Cart Conversions

Metrics

CODE
{
'facebook ads': 'Adds to car'
}
CODE
{
'facebook ads': 'offsite_add_to_cart_conversions'
}

add_to_cart_conversions_value

The Value associated with the Add to Cart Conversions

Metrics

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'N/A'

app_install_conversions

The Number of App Install Conversions

Metrics

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'mobile_app_installs'
}

app_install_conversions_value

The Value associated with App Install Conversions

Metrics

CODE
{
'facebook ads': 'App Installs'
}
CODE
{
'facebook ads': 'N/A'
}

sign_up_conversions

The Number of Sign Up Conversions

Metrics

CODE
{
'facebook ads': 'Registration completed'
}
CODE
{
'facebook ads': 'sign_up_conversions'
}

sign_up_conversions_value

The Value associated with Sign Up Conversions

Metrics

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'sign_up_conversions_value'
}

total_conversions

The Total Number of Conversions

Metrics

CODE
{
'facebook ads': 'Actions'
}
CODE
{
'facebook ads': 'actions'
}

total_conversions_value

The Value associated with the Total Number of Conversions

Metrics

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'N/A'
}

click_through_conversions

The Number of Click Through Conversions

Metrics

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'N/A'
}

click_through_conversions_value

The Value Associated with the Click Through Conversions

Metrics

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'N/A'
}

view_through_conversions

The Number of View-Through Conversions

Metrics

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'N/A'
}

view_through_conversions_value

The Value associated with the View Through Conversions

Metrics

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'N/A'
}

video_starts

Video Starts

Metrics

CODE
{
'facebook ads': 'Video Plays'
}
CODE
{
'facebook ads': 'video_plays'
}

video_views

Video Views

Metrics

CODE
{
'facebook ads': 'Video Views'
}
CODE
{
'facebook ads': 'video_views'
}

video_3s_watched

Video 3-Second Watched

Metrics

CODE
{
'facebook ads': '3-second video plays'
}
CODE
{
'facebook ads': 'video_views'
}

video_p25_watched

Video Completions - 25%

Metrics

CODE
{
'facebook ads': 'Video plays at 25%'
}
CODE
{
'facebook ads': 'video_p25_watched'
}

video_p50_watched

Video Completions - 50%

Metrics

CODE
{
'facebook ads': 'Video plays at 50%'
}
CODE
{
'facebook ads': 'video_p50_watched'
}

video_p75_watched

Video Completions - 75%

Metrics

CODE
{
'facebook ads': 'Video plays at 75%
}
CODE
{
'facebook ads': 'video_p75_watched'
}

video_p95_watched

Video Completions - 95%

Metrics

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'video_p95_watched'
}

video_p100_watched

Video Completions - 100%

Metrics

CODE
{
'facebook ads': 'Video plays at 100%'
}
CODE
{
'facebook ads': 'video_p100_watched'
}

publisher_platform

The Publisher Platform on where the Creative delivered ads

Dimensions

CODE
{
'facebook ads': 'Publisher Platform'
}

CODE
{
'facebook ads': 'publisher_platform'
}

account_id

The Ad Account Identifier

Dimensions

CODE
{
'facebook ads': 'Account ID'
}
CODE
{
'facebook ads': 'accdount_id'
}

account_name

The Ad Account Name

Dimensions

CODE
{
'facebook ads': 'Account Name'
}
CODE
{
'facebook ads': 'account_name'
}

campaign_id

The Campaign Identifier

Dimensions

CODE
{
'facebook ads': 'Campaign Id'
}
CODE
{
'facebook ads': 'campaign_id'
}

campaign_name

The Campaign Name

Dimensions

CODE
{
'facebook ads': 'Campaign'
}
CODE
{
'facebook ads': 'campaign_name'
}

campaign_status

The Current Campaign Status

Dimensions

CODE
{
'facebook ads': 'Status'
}
CODE
{
'facebook ads': 'campaign_status'
}

campaign_type

The Campaign Type

Dimensions

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'N/A'
}

campaign_objective

The Objective of the Campaign

Dimensions

CODE
{
'facebook ads': 'Objective'
}
CODE
{
'facebook ads': 'campaign_objective'
}

campaign_daily_budget

The Daily Budget of the Campaign

Metrics

CODE
{
'facebook ads': 'Budget'
}
CODE
{
'facebook ads': 'daily_budget/100'
}

campaign_start_date

The Campaign Start Date

Dimensions

CODE
{
'facebook ads': 'Starts Start Date'
}
CODE
{
'facebook ads': 'campaign_start_time'
}

campaign_end_date

The Campaign End Date

Dimensions

CODE
{
'facebook ads': 'Ends End Date'
}
CODE
{
'facebook ads': 'campaign_end_time'
}

adgroup_id

The Adgroup Identifier

Dimensions

CODE
{
'facebook ads': 'Ad set ID'
}
CODE
{
'facebook ads': 'adset_id'
}

adgroup_name

The Adgroup Name

Dimensions

CODE
{
'facebook ads': 'Ad Set Name'
}
CODE
{
'facebook ads': 'adset_name'
}

adgroup_type

The Adgroup Type

Dimensions

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'N/A'
}

adgroup_status

The Adgroup Status

Dimensions

CODE
{
'facebook ads': 'Status'
}
CODE
{
'facebook ads': 'adset_effective_status'
}

ad_id

The Ad Identifier

Dimensions

CODE
{
'facebook ads': 'Ad ID'
}
CODE
{
'facebook ads': 'ad_id'
}

ad_name

The Ad Name

Dimensions

CODE
{
'facebook ads': 'Ad'
}
CODE
{
'facebook ads': 'ad_name'
}

ad_type

The Ad Type

Dimensions

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'N/A'
}

ad_status

The Ad Status

Dimensions

CODE
{
'facebook ads': 'Status'
}
CODE
{
'facebook ads': 'ad_effective_status'
}

cm_placement_id

Placement Identifier for CM260

Dimensions

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook ads': 'N/A'
}

channel

The Default Alli Data Library Channel (Hard Coded)

Dimensions

N/A

CODE
{
'facebook ads': 'SOCIAL'
}

sign_up_conversions

The Number of Sign Up Conversions

Metrics

CODE
{
'facebook ads': 'sign_up_conversions'
}

CODE
{
'facebook ads': 'offsite_complete_registration_conversion'
}

sign_up_conversions_value

The Value associated with Sign Up Conversions

Metrics

CODE
{
'facebook ads': 'N/A'
}
CODE
{
'facebook 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.