Skip to main content
Skip table of contents

Data Library Field Mapping - Campaign Settings

Overview

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

Platforms include:

  • Google Ads

  • Microsoft Ads

  • Facebook Ads

  • Pinterest Ads

  • Snapchat Ads

  • TikTok Ads

  • Twitter Ads

  • Linkedin Ads

  • Reddit 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',
'google ads': 'Google Ads',
'linkedin ads': 'LinkedIn Ads',
'microsoft ads': 'Microsoft Bing',
'pinterest ads': 'Pinterest Ads',
'snapchat ads': 'Snapchat Ads',
'twitter ads': 'Twitter Ads',
'tiktok ads': 'Tiktok Ads'
'reddit ads': 'Reddit Ads'
}

account_id

The Ad Account Identifier

CODE
{
'facebook ads': 'Account ID',
'google ads': 'Account ID',
'linkedin ads': 'TBD',
'microsoft ads': 'Account ID',
'pinterest ads': 'Account ID',
'snapchat ads': 'Account',
'twitter ads': 'Account ID',
'tiktok ads': 'Account',
'reddit ads': 'Account ID'
}
CODE
{
'facebook ads': 'account_id',
'google ads': 'customer_id',
'linkedin ads': 'account_id',
'microsoft ads': 'accountid',
'pinterest ads': 'advertiser_id',
'snapchat ads': 'accountId',
'twitter ads': 'account_id',
'tiktok ads': 'advertiser_id'
'reddit ads': 'account_id'
}

account_name

The Ad Account Name

CODE
{
'facebook ads': 'Account Name',
'google ads': 'Account',
'linkedin ads': 'N/A',
'microsoft ads': 'Account name',
'pinterest ads': 'Account',
'snapchat ads': 'Account',
'twitter ads': 'Account',
'tiktok ads': 'Account',
'reddit ads': 'N/A'
}
CODE
{
'facebook ads': 'account_name',
'google ads': 'customer_name',
'linkedin ads': 'name',
'microsoft ads': 'accountName',
'pinterest ads': 'advertiser_name',
'snapchat ads': 'N/A',
'twitter ads': 'account_name',
'tiktok ads': 'advertiser_name',
'reddit ads': 'N/A'
}

campaign_id

The Campaign Identifier

CODE
{
'facebook ads': 'Campaign Id',
'google ads': 'Campaign ID',
'linkedin ads': 'N/A',
'microsoft ads': 'Campaign ID',
'pinterest ads': 'Campaign ID',
'snapchat ads': 'Campaign Id',
'twitter ads': 'Campaign ID',
'tiktok ads': 'Campaign ID',
'reddit ads': 'Campaign Id'
}
JSON
{
'facebook ads': 'campaign_id',
'google ads': 'campaign_id',
'linkedin ads': 'id',
'microsoft ads': 'campaignid',
'pinterest ads': 'campaign_id',
'snapchat ads': 'campaignid',
'twitter ads': 'campaign_id',
'tiktok ads': 'campaign_id',
'reddit ads': 'campaign_id'
}

campaign_name

The Campaign Name

CODE
{
'facebook ads': 'Campaign',
'google ads': 'Campaign',
'linkedin ads': 'N/A',
'microsoft ads': 'Campaign',
'pinterest ads': 'Campaign name',
'snapchat ads': 'Campaign Name',
'twitter ads': 'Campaign Name',
'tiktok ads': 'Campaign Name',
'reddit ads': 'Campaign Name'
}
CODE
{
'facebook ads': 'campaign_name',
'google ads': 'campaign_name',
'linkedin ads': 'name',
'microsoft ads': 'campaignname',
'pinterest ads': 'campaign_name',
'snapchat ads': 'campaignname',
'twitter ads': 'campaign_name',
'tiktok ads': 'campaign_name',
'reddit ads': 'campaign_name'
}

campaign_status

The Campaign Status

CODE
{
'facebook ads': 'Status',
'google ads': 'Campaign status',
'linkedin ads': 'N/A',
'microsoft ads': 'Status',
'pinterest ads': 'Status',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'reddit ads': 'Status'
}
CODE
{
'facebook ads': 'campaign_status',
'google ads': 'campaign_status',
'linkedin ads': 'status',
'microsoft ads': 'status',
'pinterest ads': 'status',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'reddit ads': 'effective_status'
}

campaign_type

The Campaign Type

CODE
{
'facebook ads': 'N/A',
'google ads': 'Campaign type',
'linkedin ads': 'N/A',
'microsoft ads': 'Campaign type',
'pinterest ads': 'Type',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'reddit ads': 'N/A'
}
CODE
{
'facebook ads': 'N/A',
'google ads': 'campaign_advertising_channel_type',
'linkedin ads': 'N/A',
'microsoft ads': 'campaigntype',
'pinterest ads': 'type',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'reddit ads': 'N/A'
}

campaign_objective

The Campaign Objective

CODE
{
'facebook ads': 'Objective',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'Objective',
'twitter ads': 'N/A',
'tiktok ads': 'Advertising objective',
'reddit ads': 'Objective'
}
CODE
{
'facebook ads': 'objective',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'objective',
'twitter ads': 'N/A',
'tiktok ads': 'objective_type',
'reddit ads': 'objective'
}

campaign_daily_budget

The Campaign Daily Budget

CODE
{
'facebook ads': 'Budget',
'google ads': 'Budget',
'linkedin ads': 'N/A',
'microsoft ads': 'Budget',
'pinterest ads': 'Daily Budget',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'reddit ads': 'N/A'
}
CODE
{
'facebook ads': 'campaign_daily_budget',
'google ads': 'campaign_budget_amount',
'linkedin ads': 'N/A',
'microsoft ads': 'dailybudget',
'pinterest ads': 'daily_spend_cap',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'reddit ads': 'N/A'
}

campaign_start_date

The Campaign Start Date

CODE
{
'facebook ads': 'Starts',
'google ads': 'Campaign start date',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Campaign start date',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A'
'reddit ads': 'N/A'
}
CODE
{
'facebook ads': 'campaign_start_time',
'google ads': 'campaign_start_date',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'start_time',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'reddit ads': 'N/A'
}

campaign_end_date

The Campaign End Date

CODE
{
'facebook ads': 'Ends',
'google ads': 'Campaign end date',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'Campaign end date',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'reddit ads': 'N/A'
}
CODE
{
'facebook ads': 'campaign_end_time',
'google ads': 'campaign_end_date',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'end_time',
'snapchat ads': 'N/A',
'twitter ads': 'N/A',
'tiktok ads': 'N/A',
'reddit ads': 'N/A'
}

campaign_created_date

The Campaign Created Date

CODE
{
'facebook ads': 'Date created',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'Date created',
'twitter ads': 'TBD',
'tiktok ads': 'N/A',
'reddit ads': 'Campaign Created On'
}
CODE
{
'facebook ads': 'created_time',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'created_time',
'snapchat ads': 'created_at',
'twitter ads': 'created_at',
'tiktok ads': 'N/A',
'reddit ads': 'created_at'
}

campaign_updated_date

The Campaign Update Date

CODE
{
'facebook ads': 'Date last edited',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'Last updated time',
'twitter ads': 'TBD',
'tiktok ads': 'N/A',
'reddit ads': 'Campaign Last Modified'
}
CODE
{
'facebook ads': 'updated_time',
'google ads': 'N/A',
'linkedin ads': 'N/A',
'microsoft ads': 'N/A',
'pinterest ads': 'updated_time',
'snapchat ads': 'updated_at',
'twitter ads': 'updated_at',
'tiktok ads': 'N/A',
'reddit ads': 'modified_at'
}
JavaScript errors detected

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

If this problem persists, please contact our support.