Skip to main content
Skip table of contents

Data Library Field Mapping - Ad Hourly Performance

Overview

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

The value N/A identifies that the platform does not have a mapping for the corresponding column.

The value TBD identifies that the platform mapping is still being identified and will be updated once confirmed in the UI.

Column

Description

Dimensions / Metrics / Categorization

Platform UI Name Mapping

Platform API 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 
{
'facebook ads': 'Date',
'snapchat ads': 'Date',
'tiktok ads': 'Date',
'reddit ads': 'Date'
}
CODE 
{
'facebook ads': 'date_start',
'snapchat ads': 'date',
'tiktok ads': 'date',
'reddit ads': 'date'
}

hour

The Hour of Performance Data

Dimensions

CODE 
{
'facebook ads': 'Hour',
'snapchat ads': 'Hour',
'tiktok ads': 'Hour',
'reddit ads': 'Hour'
}
CODE 
{
'facebook ads': 'hour',
'snapchat ads': 'hour',
'tiktok ads': 'hour',
'reddit ads': 'hour'
}

core_media_channel

The channel that the platform is a part of

Categorization

N/A

N/A

platform

The Platform the Campaign belongs to. (Hard Coded)

Dimensions

N/A

CODE 
{
'facebook ads': 'Facebook Ads',
'snapchat ads': 'Snapchat Ads',
'tiktok ads': 'TikTok Ads',
'reddit ads': 'Reddit Ads'
}

publisher_platform

The Publisher Platform on where the Campaign Delivered Ads

For Twitter Ads, there are Datasources that pull data from Ads on Twitter and the Twitter Audience Network which is hardcoded into this column.

Dimensions

CODE 
{
'facebook ads': 'Publisher Platform',
'snapchat ads': 'N/A',
'tiktok ads': 'Placements',
'reddit ads': 'N/A'
}
CODE 
{
'facebook ads': 'publisher_platform',
'snapchat ads': 'N/A',
'tiktok ads': 'placement',
'reddit ads': 'N/A'
}

account_id

The Ad Account Identifier

Dimensions

CODE 
{
'facebook ads': 'Account ID',
'snapchat ads': 'Account',
'tiktok ads': 'Account',
'reddit ads': 'Account ID'
}
CODE 
{
'facebook ads': 'account_id',
'snapchat ads': 'accountId',
'tiktok ads': 'advertiser_id',
'reddit ads': 'account_id'
}

account_name

The Ad Account Name

Dimensions

CODE 
{
'facebook ads': 'Account Name',
'snapchat ads': 'Account',
'tiktok ads': 'Account',
'reddit ads': 'Account Name'
}
CODE 
{
'facebook ads': 'account_name',
'snapchat ads': 'name' (from account structure datasource),
'tiktok ads': 'advertiser_name',
'reddit ads': 'account_name'
}

campaign_id

The Campaign Identifier

Dimensions

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

campaign_name

The Campaign Name

Dimensions

CODE 
{
'facebook ads': 'Campaign',
'snapchat ads': 'Campaign Name',
'tiktok ads': 'Campaign Name',
'reddit ads': 'Campaign Name'
}
CODE 
{
'facebook ads': 'campaign_name',
'snapchat ads': 'campaignname',
'tiktok ads': 'campaign_name',
'reddit ads': 'campaign_name'
}

adgroup_id

The Adgroup Identifier

Dimensions

CODE 
{
'facebook ads': 'Ad set ID',
'snapchat ads': 'Ad Sets ID',
'tiktok ads': 'Adgroup ID',
'reddit ads': 'Adgroup ID'
}
CODE 
{
'facebook ads': 'adset_id',
'snapchat ads': 'adsquadid',
'tiktok ads': 'adgroup_id',
'reddit ads': 'adgroup_id'
}

adgroup_name

The Adgroup Name

Dimensions

CODE 
{
'facebook ads': 'Ad Set Name',
'snapchat ads': 'Ad Sets Name',
'tiktok ads': 'Adgroup Name',
'reddit ads': 'Adgroup Name'
}
CODE 
{
'facebook ads': 'adset_name',
'snapchat ads': 'adsquadname',
'tiktok ads': 'adgroup_name',
'reddit ads': 'adgroup_name'
}

ad_id

The Ad Identifier

Dimensions

CODE 
{
'facebook ads': 'Ad ID',
'snapchat ads': 'Ads ID',
'tiktok ads': 'TBD',
'reddit ads': 'Ad ID'
}
CODE 
{
'facebook ads': 'ad_id',
'snapchat ads': 'adid',
'tiktok ads': 'ad_id',
'reddit ads': 'ad_id'
}

ad_name

The Ad Name

Dimensions

CODE 
{
'facebook ads': 'Ad',
'snapchat ads': 'Ads name',
'tiktok ads': 'TBD',
'reddit ads': 'Ad Name'
}
CODE 
{
'facebook ads': 'ad_name',
'snapchat ads': 'adname',
'tiktok ads': 'ad_name',
'reddit ads': 'ad_name'
}

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

channel

The Default Alli Data Library Channel (Hard Coded Value)

 

If you would like to change the Channel associated with the Campaign please see the following document: How-To: Reclassify Media Channel

Dimensions

N/A

CODE 
{
'facebook ads': 'SOCIAL',
'snapchat ads': 'SOCIAL',
'tiktok ads': 'SOCIAL',
'reddit ads': 'SOCIAL'
}

cost

Costs (Ad Spend)

Metrics

CODE 
{
'facebook ads': 'Amount Spend',
'snapchat ads': 'Spend',
'tiktok ads': 'Total cost',
'reddit ads': 'Cost'
}
CODE 
{
'facebook ads': 'spend',
'snapchat ads': 'spend',
'tiktok ads': 'spend',
'reddit ads': 'cost'
}

impressions

Impressions

Metrics

CODE 
{
'facebook ads': 'Impressions',
'snapchat ads': 'Paid Impressions',
'tiktok ads': 'Impressions',
'reddit ads': 'impressions'
}
CODE 
{
'facebook ads': 'impressions',
'snapchat ads': 'impressions',
'tiktok ads': 'impressions',
'reddit ads': 'impressions'
}

clicks

Clicks

Metrics

CODE 
{
'facebook ads': 'Link clicks',
'snapchat ads': 'Clicks',
'tiktok ads': 'Clicks (Destination)',
'reddit ads': 'Clicks'
}
CODE 
{
'facebook ads': 'inline_link_clicks',
'snapchat ads': 'swipes',
'tiktok ads': 'clicks',
'reddit ads': 'clicks'
}

conversions

The Number of Conversions

Metrics

CODE 
{
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'Conversion',
'reddit ads': 'N/A'
}
CODE 
{
'facebook ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'conversion',
'reddit ads': 'N/A'
}

conversions_value

The Value associated with Conversions

Metrics

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

purchase_conversions

The Number of Purchase Conversions

Metrics

CODE 
{
'facebook ads': 'Website Purchases',
'snapchat ads': 'Conversions: Purchases',
'tiktok ads': 'Total Purchase',
'reddit ads': 'Click: Purchase + View: Purchase'
}
CODE 
{
'facebook ads': 'action_offsite_conversion_fb_pixel_purchase',
'snapchat ads': 'conversion_purchases',
'tiktok ads': 'total_purchase',
'reddit ads': 'purchase_view_through_conversions + purchase_click_through_conversions'(of all attribution window)'
}

purchase_conversions_value

The Value associated with the Purchase Conversions

Metrics

CODE 
{
'facebook ads': 'Website Purchases Conversion Value',
'snapchat ads': 'Conversions: Purchases Value',
'tiktok ads': 'Purchase Total Value',
'reddit ads': 'Total Value: Purchase'
}
CODE 
{
'facebook ads': 'action_values_offsite_conversion_fb_pixel_purchase',
'snapchat ads': 'conversion_purchases_value',
'tiktok ads': 'total_purchase_value',
'reddit ads': 'conversion_purchase_total_value'
}

total_conversions

The Total Number of Conversions

Metrics

CODE 
{
'facebook ads': 'Actions',
'snapchat ads': 'N/A',
'tiktok ads': 'Conversion',
'reddit ads': 'N/A'
}
CODE 
{
'facebook ads': 'actions',
'snapchat ads': 'N/A',
'tiktok ads': 'conversion',
'reddit ads': 'N/A'
}

total_conversions_value

The Value associated with the Total Number of Conversions

Metrics

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

video_views

Video Views

Metrics

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

video_p25_watched

Video Completions - 25%

Metrics

CODE 
{
'facebook ads': 'Video plays at 25%',
'snapchat ads': 'Video Plays at 25%',
'tiktok ads': 'Video views at 25%',
'reddit ads': 'Watches at 25%',
}
CODE 
{
'facebook ads': 'video_p25_watched_actions',
'snapchat ads': 'quartile_1',
'tiktok ads': 'video_views_p25',
'reddit ads': 'video_watched_25_percent',
}

video_p100_watched

Video Completions

Metrics

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

 

JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close