Skip to main content
Skip table of contents

Data Library Field Mapping - AdGroup Hourly Performance

This document describes how the columns from all the ad platforms are mapped to the adgroup_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',
'google ads': 'Date',
'microsoft ads': 'Date',
'snapchat ads': 'Date',
'tiktok ads': 'Date',
}
CODE 
{
'facebook ads': 'date_start',
'google ads': 'date',
'microsoft ads': 'TimePeriod',
'snapchat ads': 'date',
'tiktok ads': 'date',
}

hour

The hour of Performance Data

Dimensions

CODE 
{
'facebook ads': 'Hour',
'google ads': 'Hour',
'microsoft ads': 'Hour',
'snapchat ads': 'Hour',
'tiktok ads': 'Hour',
}
CODE 
{
'facebook ads': 'hour',
'google ads': 'hour',
'microsoft ads': 'hour',
'snapchat ads': 'hour',
'tiktok 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',
'google ads': 'Google Ads',
'microsoft ads': 'Microsoft Bing',
'snapchat ads': 'Snapchat Ads',
'tiktok ads': 'TikTok Ads',
}

publisher_platform

The Publisher Platform on where the Campaign Delivered Ads

Dimensions

CODE 
{
'facebook ads': 'Publisher Platform',
'google ads': 'Networks',
'microsoft ads': 'Ad Distribution',
'snapchat ads': 'N/A',
'tiktok ads': 'Placements',
}
CODE 
{
'facebook ads': 'publisher_platform',
'google ads': 'ad_network_type',
'microsoft ads': 'AdDistribution',
'snapchat ads': 'N/A',
'tiktok ads': 'placement',
}

account_id

The Ad Account Identifier

Dimensions

CODE 
{
'facebook ads': 'Account ID',
'google ads': 'Account ID',
'microsoft ads': 'Account ID',
'snapchat ads': 'Account',
'tiktok ads': 'Account',
}
CODE 
{
'facebook ads': 'account_id',
'google ads': 'customer_id',
'microsoft ads': 'accountid',
'snapchat ads': 'accountId',
'tiktok ads': 'advertiser_id',
}

account_name

The Ad Account Name

Dimensions

CODE 
{
'facebook ads': 'Account Name',
'google ads': 'Account',
'microsoft ads': 'Account name',
'snapchat ads': 'Account',
'tiktok ads': 'Account',
}
CODE 
{
'facebook ads': 'account_name',
'google ads': 'customer_name',
'microsoft ads': 'AccountName',
'snapchat ads': 'accountName',
'tiktok ads': 'advertiser_name',
}

campaign_id

The Campaign Identifier

Dimensions

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

campaign_name

The Campaign Name

Dimensions

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

adgroup_id

The Adgroup Identifier

Dimensions

CODE 
{
'facebook ads': 'Ad set ID',
'google ads': 'Ad group ID',
'microsoft ads': 'Ad group ID',
'snapchat ads': 'Ad Sets Id',
'tiktok ads': 'Adgroup ID',
}
CODE 
{
'facebook ads': 'adset_id',
'google ads': 'ad_group_id',
'microsoft ads': 'adgroupid',
'snapchat ads': 'adsquadid',
'tiktok ads': 'adgroup_id',
}

adgroup_name

The Adgroup Name

Dimensions

CODE 
{
'facebook ads': 'Ad Set Name',
'google ads': 'Ad group',
'microsoft ads': 'Ad group',
'snapchat ads': 'Ad Sets Name',
'tiktok ads': 'Adgroup Name',
}
CODE 
{
'facebook ads': 'adset_name',
'google ads': 'ad_group_name',
'microsoft ads': 'adgroupname',
'snapchat ads': 'adsquadname',
'tiktok ads': 'adgroup_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',
'google ads': 'SEARCH',
'microsoft ads': 'SEARCH',
'snapchat ads': 'SOCIAL',
'tiktok ads': 'SOCIAL',
}

cost

Costs (Ad Spend)

Metrics

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

impressions

Impressions

Metrics

CODE 
{
'facebook ads': 'Impressions',
'google ads': 'Impr.',
'microsoft ads': 'Impr.',
'snapchat ads': 'Paid Impressions',
'tiktok ads': 'Impressions',
}
CODE 
{
'facebook ads': 'impressions',
'google ads': 'impressions',
'microsoft ads': 'impressions',
'snapchat ads': 'impressions',
'tiktok ads': 'impressions',
}

clicks

Clicks

Metrics

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

conversions

The Number of Conversions

Metrics

CODE 
{
'facebook ads': 'N/A',
'google ads': 'Conversions',
'microsoft ads': 'Conv.',
'snapchat ads': 'N/A',
'tiktok ads': 'Conversion',
}
CODE 
{
'facebook ads': 'N/A',
'google ads': 'conversions',
'microsoft ads': 'conversions',
'snapchat ads': 'N/A',
'tiktok ads': 'conversion',
}

conversions_value

The Value associated with Conversions

Metrics

CODE 
{
'facebook ads': 'N/A',
'google ads': 'Conv. value',
'microsoft ads': 'Revenue',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
}
CODE 
{
'facebook ads': 'N/A',
'google ads': 'conversions_value',
'microsoft ads': 'revenue',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
}

purchase_conversions

The Number of Purchase Conversions

Metrics

CODE 
{
'facebook ads': 'Website Purchases',
'google ads': 'N/A',
'microsoft ads': 'N/A',
'snapchat ads': 'Conversions: Purchases + Conversions: Purchases View',
'tiktok ads': 'Total Purchase',
}
CODE 
{
'facebook ads': 'action_offsite_conversion_fb_pixel_purchase',
'google ads': 'case when conversion_action_category = 'PURCHASE' then conversions',
'microsoft ads': 'N/A',
'snapchat ads': 'conversion_purchases',
'tiktok ads': 'total_purchase',
}

purchase_conversions_value

The Value associated with the Purchase Conversions

Metrics

CODE 
{
'facebook ads': 'Website Purchases Conversion Value',
'google ads': 'N/A',
'microsoft ads': 'N/A',
'snapchat ads': 'Conversions: Purchases Value + Conversions: Purchases Value View',
'tiktok ads': 'Purchase Total Value',
}
CODE 
{
'facebook ads': 'action_values_offsite_conversion_fb_pixel_purchase',
'google ads': 'case when conversion_action_category = 'PURCHASE' then conversions_value',
'microsoft ads': 'N/A',
'snapchat ads': 'conversion_purchases_value',
'tiktok ads': 'total_purchase_value',
}

total_conversions

The Total Number of Conversions

Metrics

CODE 
{
'facebook ads': 'Actions',
'google ads': 'All conv.',
'microsoft ads': 'Conv.',
'snapchat ads': 'N/A',
'tiktok ads': 'Conversion',
}
CODE 
{
'facebook ads': 'actions',
'google ads': 'all_conversions',
'microsoft ads': 'conversions',
'snapchat ads': 'N/A',
'tiktok ads': 'conversion',
}

total_conversions_value

The Value associated with the Total Number of Conversions

Metrics

CODE 
{
'facebook ads': 'N/A',
'google ads': 'All conv. value',
'microsoft ads': 'Revenue',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
}
CODE 
{
'facebook ads': 'N/A',
'google ads': 'all_conversions_value',
'microsoft ads': 'revenue',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
}

video_views

Video Views

Metrics

CODE 
{
'facebook ads': '3-second video plays',
'google ads': 'Views',
'microsoft ads': 'N/A',
'snapchat ads': '2 Second Video Views',
'tiktok ads': '2-second video views',
}
CODE 
{
'facebook ads': 'action_video_view',
'google ads': 'video_views',
'microsoft ads': 'N/A',
'snapchat ads': 'video_views',
'tiktok ads': 'video_watched_2s',
}

video_p25_watched

Video Completions - 25%

Metrics

CODE 
{
'facebook ads': 'Video plays at 25%',
'google ads': 'Video played to 25%',
'microsoft ads': 'N/A',
'snapchat ads': 'Video Plays at 25%',
'tiktok ads': 'Video views at 25%',
}
CODE 
{
'facebook ads': 'video_p25_watched_actions',
'google ads': 'video_views * video_quartile_p25_rate',
'microsoft ads': 'N/A',
'snapchat ads': 'quartile_1',
'tiktok ads': 'video_views_p25',
}

video_p100_watched

Video Completions

Metrics

CODE 
{
'facebook ads': 'Video plays at 100%',
'google ads': 'Video played to 100%',
'microsoft ads': 'N/A',
'snapchat ads': 'Video Completions',
'tiktok ads': 'Video views at 100%',
}
CODE 
{
'facebook ads': 'video_p100_watched_actions',
'google ads': 'video_views * video_quartile_p100_rate',
'microsoft ads': 'N/A',
'snapchat ads': 'view_completion',
'tiktok ads': 'video_views_p100',
}
JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close