Breadcrumbs

Data Library Field Mapping - Ad Settings

Overview

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


Platforms include:

  • Facebook Ads

  • Pinterest Ads

  • Snapchat Ads

  • TikTok Ads


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

Column

Description

Platform UI Name Mapping

Platform API Mapping

id

The Internal Alli Id of the Record

N/A

N/A

source

The Source Table of Row

N/A

N/A

platform

The Platform the Campaign belongs to. (Hard Coded)

N/A

 
{
'facebook ads': 'Facebook Ads',
'pinterest ads': 'Pinterest Ads',
'snapchat ads': 'Snapchat Ads',
'tiktok ads': 'TikTok Ads'
}

account_id

The Ad Account Identifier

 
{
'facebook ads': 'Account ID',
'pinterest ads': 'Account ID',
'snapchat ads': 'Account',
'tiktok ads': 'Account'
}

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

account_name

The Ad Account Name

 
{
'facebook ads': 'Account Name',
'pinterest ads': 'Account',
'snapchat ads': 'Account',
'tiktok ads': 'Account'
}         

{
'facebook ads': 'account_name',
'pinterest ads': 'advertiser_name',
'snapchat ads': 'accountName',
'tiktok ads': 'advertiser_name'
}

campaign_id

The Campaign Identifier

 
{
'facebook ads': 'Campaign Id',
'pinterest ads': 'Campaign ID',
'snapchat ads': 'Campaign Id',
'tiktok ads': 'Campaign ID'
}
JSON
{
'facebook ads': 'campaign_id',
'pinterest ads': 'campaign_id',
'snapchat ads': 'campaignid',
'tiktok ads': 'campaign_id'
}

campaign_name

The Campaign Name

 
{
'facebook ads': 'Campaign',
'pinterest ads': 'Campaign name',
'snapchat ads': 'Campaign Name',
'tiktok ads': 'Campaign Name'
}

{
'facebook ads': 'campaign_name',
'pinterest ads': 'campaign_name',
'snapchat ads': 'campaignname',
'tiktok ads': 'campaign_name'
}

adgroup_id

The Adgroup Identifier

 
{
'facebook ads': 'Ad set ID',
'pinterest ads': 'Ad group ID',
'snapchat ads': 'Ad Sets Id',
'tiktok ads': 'Adgroup ID'
}

{
'facebook ads': 'adset_id',
'pinterest ads': 'id',
'snapchat ads': 'adsquadid',
'tiktok ads': 'adgroup_id'
}

adgroup_name

The Adgroup Name

 
{
'facebook ads': 'Ad Set Name',
'pinterest ads': 'Ad group name',
'snapchat ads': 'Ad Sets Name',
'tiktok ads': 'Adgroup Name'
}

{
'facebook ads': 'adset_name',
'pinterest ads': 'name',
'snapchat ads': 'adsquadname',
'tiktok ads': 'adgroup_name'
}

ad_id

The Ad Identifier

 
{
'facebook ads': 'Ad ID',
'pinterest ads': 'Ad ID',
'snapchat ads': 'Ads ID',
'tiktok ads': 'Ad ID'
}

{
'facebook ads': 'ad_id',
'pinterest ads': 'id',
'snapchat ads': 'adid',
'tiktok ads': 'ad_id'
}

ad_name

The Ad name

 
{
'facebook ads': 'Ad',
'pinterest ads': 'Ad name',
'snapchat ads': 'Ads Name',
'tiktok ads': 'Ad Name'
}

{
'facebook ads': 'ad_name',
'pinterest ads': 'name',
'snapchat ads': 'adname',
'tiktok ads': 'ad_name'
}

ad_status

The Ad Status

 
{
'facebook ads': 'Delivery',
'pinterest ads': 'Status',
'snapchat ads': 'Status',
'tiktok ads': 'Status'
}        

{
'facebook ads': 'effective_status',
'pinterest ads': 'status',
'snapchat ads': 'status' (from ad structure datasource),
'tiktok ads': 'status'
}

ad_type

The Ad Type

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

{
'facebook ads': 'N/A',
'pinterest ads': 'type',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}

ad_start_date

The Ad Start Date

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

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

ad_end_date

The Ad End Date

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

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

ad_created_date

The Ad Created Date

 
{
'facebook ads': 'Date created',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'Created on'
}         

{
'facebook ads': 'created_time',
'pinterest ads': 'created_time',
'snapchat ads': 'N/A',
'tiktok ads': 'create_time'
}

ad_updated_date

The Ad Update Date

 
{
'facebook ads': 'Date last edited',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}         

{
'facebook ads': 'updated_time',
'pinterest ads': 'updated_time',
'snapchat ads': 'N/A',
'tiktok ads': 'modify_time'
}