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