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' }`