Breadcrumbs

Data Library Field Mapping - Adgroup 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'
}

adgroup_status

The Adgroup Status

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

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

adgroup_type

The Adgroup Type

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

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

adgroup_start_date

The Adgroup Start Date

 
{
'facebook ads': 'Starts',
'pinterest ads': 'Ad group start date/time',
'snapchat ads': 'Start time',
'tiktok ads': 'N/A'
}         

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

adgroup_end_date

The Adgroup End Date

 
{
'facebook ads': 'Ends',
'pinterest ads': 'Ad group end date/time',
'snapchat ads': 'End time',
'tiktok ads': 'N/A'
}         

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

adgroup_created_date

The Adgroup Created Date

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

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

adgroup_updated_date

The Adgroup Update Date

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

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