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

  • Google Ads

  • DV360

  • Microsoft Ads

  • Yahoo DSP

  • Bidtellect

  • Amazon DSP

  • The Trade Desk

  • Teads

  • Twitter Ads

  • Linkedin Ads

  • Criteo

  • Reddit Ads

  • Taboola

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',
'google ads': 'Google Ads',
'dv360': 'DV360',
'microsoft ads': 'Microsoft Bing',
'yahoo dsp': 'Yahoo DSP',
'bidtellect': 'Bidtellect',
'amazon dsp': 'Amazon DSP',
'the trade desk': 'The Trade Desk',
'teads': 'Teads',
'twitter ads': 'Twitter Ads',
'linkedin ads': 'LinkedIn Ads',
'criteo': 'Criteo',
'reddit ads': 'Reddit Ads',
'taboola': 'Taboola'
}

account_id

The Ad Account Identifier

CODE 
{
'facebook ads': 'Account ID',
'pinterest ads': 'Account ID',
'snapchat ads': 'Account',
'tiktok ads': 'Account',
'google ads': 'Account ID',
'dv360': 'Advertiser ID',
'microsoft ads': 'Account ID',
'yahoo dsp': 'Advertiser ID',
'bidtellect': 'Brand Id',
'amazon dsp': 'Advertiser Id',
'the trade desk': 'Advertiser ID',
'teads': 'Advertiser ID',
'twitter ads': 'Account ID',
'linkedin ads': 'Account ID',
'criteo': 'N/A',
'reddit ads': 'Account ID',
'taboola': 'Advertiser ID'
}
CODE 
{
'facebook ads': 'account_id',
'pinterest ads': 'advertiser_id',
'snapchat ads': 'accountId',
'tiktok ads': 'advertiser_id',
'google ads': 'customer_id',
'dv360': 'filter_advertiser',
'microsoft ads': 'accountid',
'yahoo dsp': 'advertiser_id',
'bidtellect': 'ndsp_client_reporting_customer_brand_id',
'amazon dsp': 'advertiserid',
'the trade desk': 'advertiser_id',
'teads': 'advertiser_id',
'twitter ads': 'account_id',
'linkedin ads': 'account_id',
'criteo': 'AdvertiserId',
'reddit ads': 'account_id',
'taboola': 'advertiser_id'
}

account_name

The Ad Account Name

CODE 
{
'facebook ads': 'Account Name',
'pinterest ads': 'Account',
'snapchat ads': 'Account',
'tiktok ads': 'Account',
'google ads': 'Account',
'dv360': 'Advertiser',
'microsoft ads': 'Account name',
'yahoo dsp': 'Advertiser Name',
'bidtellect': 'Brand',
'amazon dsp': 'Advertiser Name',
'the trade desk': 'Advertiser',
'teads': 'Advertiser Name',
'twitter ads': 'Account',
'linkedin ads': 'Account',
'criteo': 'Account',
'reddit ads': 'N/A',
'taboola': 'Advertiser'
}
CODE 
{
'facebook ads': 'account_name',
'pinterest ads': 'advertiser_name',
'snapchat ads': 'accountName',
'tiktok ads': 'advertiser_name',
'google ads': 'customer_descriptive_name',
'dv360': 'filter_advertiser_name',
'microsoft ads': 'accountname',
'yahoo dsp': 'advertiser_name',
'bidtellect': 'ndsp_client_reporting_customer_brand_name',
'amazon dsp': 'advertisername',
'the trade desk': 'advertiser_name',
'teads': 'advertiser_name',
'twitter ads': 'account_name',
'linkedin ads': 'name',
'criteo': 'Advertiser',
'reddit ads': 'N/A',
'taboola': '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',
'google ads': 'Account Status',
'dv360': 'N/A',
'microsoft ads': 'Account Status',
'yahoo dsp': 'N/A',
'bidtellect': 'N/A',
'amazon dsp': 'N/A',
'the trade desk': 'N/A',
'teads': 'N/A',
'twitter ads': 'Account Status',
'linkedin ads': 'Account Status',
'criteo': 'N/A',
'reddit ads': 'Account Status',
'taboola': 'N/A'
}
CODE 
{
'facebook ads': 'account_status',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A',
'microsoft ads': 'accountstatus',
'yahoo dsp': 'N/A',
'bidtellect': 'N/A',
'amazon dsp': 'N/A',
'the trade desk': 'N/A',
'teads': 'N/A',
'twitter ads': 'N/A',
'linkedin ads': 'status',
'criteo': 'N/A',
'reddit ads': 'status',
'taboola': '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',
'google ads': 'N/A',
'dv360': 'N/A',
'microsoft ads': 'N/A',
'yahoo dsp': 'N/A',
'bidtellect': 'N/A',
'amazon dsp': 'N/A',
'the trade desk': 'N/A',
'teads': 'N/A',
'twitter ads': 'N/A',
'linkedin ads': 'TBD',
'criteo': 'N/A',
'reddit ads': 'TBD',
'taboola': 'N/A'
}
CODE 
{
'facebook ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'type',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A',
'microsoft ads': 'N/A',
'yahoo dsp': 'N/A',
'bidtellect': 'N/A',
'amazon dsp': 'N/A',
'the trade desk': 'N/A',
'teads': 'N/A',
'twitter ads': 'N/A',
'linkedin ads': 'type',
'criteo': 'N/A',
'reddit ads': 'type',
'taboola': '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',
'google ads': 'N/A',
'dv360': 'N/A',
'microsoft ads': 'N/A',
'yahoo dsp': 'N/A',
'bidtellect': 'N/A',
'amazon dsp': 'N/A',
'the trade desk': 'N/A',
'teads': 'N/A',
'twitter ads': 'N/A',
'linkedin ads': 'N/A',
'criteo': 'N/A',
'reddit ads': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'facebook ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A',
'microsoft ads': 'N/A',
'yahoo dsp': 'N/A',
'bidtellect': 'N/A',
'amazon dsp': 'N/A',
'the trade desk': 'N/A',
'teads': 'N/A',
'twitter ads': 'N/A',
'linkedin ads': 'N/A',
'criteo': 'N/A',
'reddit ads': 'N/A',
'taboola': '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',
'google ads': 'N/A',
'dv360': 'N/A',
'microsoft ads': 'N/A',
'yahoo dsp': 'N/A',
'bidtellect': 'N/A',
'the trade desk': 'N/A',
'teads': 'N/A',
'twitter ads': 'N/A',
'linkedin ads': 'N/A',
'reddit ads': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'facebook ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A',
'microsoft ads': 'N/A',
'yahoo dsp': 'N/A',
'bidtellect': 'N/A',
'the trade desk': 'N/A',
'teads': 'N/A',
'twitter ads': 'N/A',
'linkedin ads': 'N/A',
'reddit ads': 'N/A',
'taboola': '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',
'google ads': 'N/A',
'dv360': 'N/A',
'microsoft ads': 'N/A',
'yahoo dsp': 'N/A',
'bidtellect': 'N/A',
'amazon dsp': 'N/A',
'the trade desk': 'N/A',
'teads': 'N/A',
'twitter ads': 'N/A',
'linkedin ads': 'N/A',
'criteo': 'N/A',
'reddit ads': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'facebook ads': 'created_time',
'pinterest ads': 'created_time',
'snapchat ads': 'updated_at',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A',
'microsoft ads': 'N/A',
'yahoo dsp': 'N/A',
'bidtellect': 'N/A',
'amazon dsp': 'N/A',
'the trade desk': 'N/A',
'teads': 'N/A',
'twitter ads': 'N/A',
'linkedin ads': 'N/A',
'criteo': 'N/A',
'reddit ads': 'created_at',
'taboola': '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',
'google ads': 'N/A',
'dv360': 'N/A',
'microsoft ads': 'N/A',
'yahoo dsp': 'N/A',
'bidtellect': 'N/A',
'amazon dsp': 'N/A',
'the trade desk': 'N/A',
'teads': 'TBD',
'twitter ads': 'N/A',
'linkedin ads': 'N/A',
'criteo': 'N/A',
'reddit ads': 'N/A',
'taboola': 'N/A'
}
CODE 
{
'facebook ads': 'N/A',
'pinterest ads': 'updated_time',
'snapchat ads': 'created_at',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A',
'microsoft ads': 'N/A',
'yahoo dsp': 'N/A',
'bidtellect': 'N/A',
'amazon dsp': 'N/A',
'the trade desk': 'N/A',
'teads': 'advertiser_updated_at',
'twitter ads': 'N/A',
'linkedin ads': 'N/A',
'criteo': 'N/A',
'reddit ads': 'modified_at',
'taboola': 'N/A'
}

currency

The Ad Account Currency

CODE 
{
'facebook ads': 'Currency',
'pinterest ads': 'Currency',
'snapchat ads': 'Currency',
'tiktok ads': 'N/A',
'google ads': 'N/A',
'dv360': 'N/A',
'microsoft ads': 'N/A',
'yahoo dsp': 'N/A',
'bidtellect': 'N/A',
'amazon dsp': 'N/A',
'the trade desk': 'Currency',
'teads': 'N/A',
'twitter ads': 'N/A',
'linkedin ads': 'Currency',
'criteo': 'N/A',
'reddit ads': 'N/A',
'taboola': 'Currency'
}
CODE 
{
'facebook ads': 'currency',
'pinterest ads': 'currency',
'snapchat ads': 'currency',
'tiktok ads': 'N/A',
'google ads': 'customer_currency_code',
'dv360': 'N/A',
'microsoft ads': 'N/A',
'yahoo dsp': 'N/A',
'bidtellect': 'N/A',
'amazon dsp': 'N/A',
'the trade desk': 'advertiser_currency_code',
'teads': 'N/A',
'twitter ads': 'N/A',
'linkedin ads': 'currency',
'criteo': 'N/A',
'reddit ads': 'currency',
'taboola': 'currency'
}
JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close