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'
}
|
campaign_id | The Campaign Identifier |
CODE
{
'facebook ads': 'Campaign Id',
'pinterest ads': 'Campaign ID',
'snapchat ads': 'Campaign Id',
'tiktok ads': 'Campaign ID'
}
|
JSON
{
'facebook ads': 'campaign_id',
'pinterest ads': 'campaign_id',
'snapchat ads': 'campaignid',
'tiktok ads': 'campaign_id'
}
|
campaign_name | The Campaign Name |
CODE
{
'facebook ads': 'Campaign',
'pinterest ads': 'Campaign name',
'snapchat ads': 'Campaign Name',
'tiktok ads': 'Campaign Name'
}
|
CODE
{
'facebook ads': 'campaign_name',
'pinterest ads': 'campaign_name',
'snapchat ads': 'campaignname',
'tiktok ads': 'campaign_name'
}
|
adgroup_id | The Adgroup Identifier |
CODE
{
'facebook ads': 'Ad set ID',
'pinterest ads': 'Ad group ID',
'snapchat ads': 'Ad Sets Id',
'tiktok ads': 'Adgroup ID'
}
|
CODE
{
'facebook ads': 'adset_id',
'pinterest ads': 'id',
'snapchat ads': 'adsquadid',
'tiktok ads': 'adgroup_id'
}
|
adgroup_name | The Adgroup Name |
CODE
{
'facebook ads': 'Ad Set Name',
'pinterest ads': 'Ad group name',
'snapchat ads': 'Ad Sets Name',
'tiktok ads': 'Adgroup Name'
}
|
CODE
{
'facebook ads': 'adset_name',
'pinterest ads': 'name',
'snapchat ads': 'adsquadname',
'tiktok ads': 'adgroup_name'
}
|
ad_id | The Ad Identifier |
CODE
{
'facebook ads': 'Ad ID',
'pinterest ads': 'Ad ID',
'snapchat ads': 'Ads ID',
'tiktok ads': 'Ad ID'
}
|
CODE
{
'facebook ads': 'ad_id',
'pinterest ads': 'id',
'snapchat ads': 'adid',
'tiktok ads': 'ad_id'
}
|
ad_name | The Ad name |
CODE
{
'facebook ads': 'Ad',
'pinterest ads': 'Ad name',
'snapchat ads': 'Ads Name',
'tiktok ads': 'Ad Name'
}
|
CODE
{
'facebook ads': 'ad_name',
'pinterest ads': 'name',
'snapchat ads': 'adname',
'tiktok ads': 'ad_name'
}
|
ad_status | The Ad Status |
CODE
{
'facebook ads': 'Delivery',
'pinterest ads': 'Status',
'snapchat ads': 'Status',
'tiktok ads': 'Status'
}
|
CODE
{
'facebook ads': 'effective_status',
'pinterest ads': 'status',
'snapchat ads': 'status' (from ad structure datasource),
'tiktok ads': 'status'
}
|
ad_type | The Ad Type |
CODE
{
'facebook ads': 'N/A',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
|
CODE
{
'facebook ads': 'N/A',
'pinterest ads': 'type',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
|
ad_start_date | The Ad 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'
}
|
ad_end_date | The Ad 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'
}
|
ad_created_date | The Ad Created Date |
CODE
{
'facebook ads': 'Date created',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'Created on'
}
|
CODE
{
'facebook ads': 'created_time',
'pinterest ads': 'created_time',
'snapchat ads': 'N/A',
'tiktok ads': 'create_time'
}
|
ad_updated_date | The Ad Update Date |
CODE
{
'facebook ads': 'Date last edited',
'pinterest ads': 'N/A',
'snapchat ads': 'N/A',
'tiktok ads': 'N/A'
}
|
CODE
{
'facebook ads': 'updated_time',
'pinterest ads': 'updated_time',
'snapchat ads': 'N/A',
'tiktok ads': 'modify_time'
}
|
