Skip to main content
Skip table of contents

Data Library Field Mapping - Account Settings

Overview

This document describes how the columns from all the ad platforms are mapped to the account_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

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

account_id

The Ad Account Identifier

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

account_name

The Ad Account Name

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

account_status

The Ad Account Status

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

account_type

The Ad Account Type

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

account_start_date

The Ad Account Start Date

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

account_end_date

The Ad Account End Date

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

account_created_date

The Ad Account Created Date

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

account_updated_date

The Ad Account Update Date

CODE
{
'facebook ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}         
CODE
{
'facebook ads': 'N/A',
'pinterest ads': 'updated_time',
'snapchat ads': 'created_at',
'tiktok ads': 'N/A'
}
JavaScript errors detected

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

If this problem persists, please contact our support.