Sponsored Ads

Campaigns

​Table Name: tiktok_source_data.campaigns

Column Name	Data type	Description
account_id	bigint	Account Id
account_name	varchar	Account Name
currency_code	varchar	Currency Code
country_code	varchar	Country Code
advertiser_id	varchar	Advertiser Id
campaign_id	varchar	Campaign Id
campaign_system_origin	varchar	Campaign Origin. Enum: Promote
create_time	timestamp(0)	Create Time
modify_time	timestamp(0)	Modify Time
campaign_name	varchar	Campaign Name
operation_status	varchar	Operation Status. Enum: Enable, Disable
secondary_status	varchar	Campaign Secondary Status. See Enumeration - Campaign Status.
objective_type	varchar	REACH -> Maximize ad impressions in your target audience. TRAFFIC -> Drive users to a URL such as a website or app. VIDEO_VIEWS -> Increase views from users likely to watch your video. LEAD_GENERATION -> Collect leads using in-app customizable forms. ENGAGEMENT -> Boost followers and profile visits. APP_PROMOTION -> Promote app installs, re-engagement, or pre-registration. WEB_CONVERSIONS -> Drive actions on your website or TikTok Instant Page. PRODUCT_SALES -> Sell products via TikTok Shop, website, or app using shopping ads.
app_promotion_type	varchar	App Promotion Type. Enum: App Install, App Retargeting, App Preregistration, App Posts Promotion
is_search_campaign	boolean	Search Campaign Flag. Enum: True, False
is_smart_performance_campaign	boolean	Smart Or Smart Performance Web Campaign Flag. Enum: True, False
campaign_type	varchar	Campaign Type
app_id	varchar	App Id Of Promoted App.
is_advanced_dedicated_campaign	boolean	Whether The Campaign Is An Advanced Dedicated Campaign. Enum: True, False
disable_skan_campaign	boolean	Disable Skan Attribution. Enum: True, False
bid_align_type	varchar	Attribution Type. Enum: San, Skan
campaign_app_profile_page_state	varchar	App Profile Page Status. Enum: Invalid, Unset, On, Off
rf_campaign_type	varchar	Reservation Campaign Type. Enum: Standard, Pulse, Topview
campaign_product_source	varchar	Product Source Of The Campaign. Enum: Catalog, Store
catalog_enabled	boolean	Catalog Usage Flag (Automotive Ads). Enum: True, False
special_industries	varchar	Special Ad Categories. Enum: Housing, Employment, Credit
budget_optimize_on	boolean	Campaign Budget Optimization Enabled. Enum: True
bid_type	varchar	Bidding Strategy.
deep_bid_type	varchar	In-App Event Bidding Strategy.
roas_bid	numeric	Roas Goal For Value Optimization.
optimization_goal	varchar	Optimization Goal. See Enumeration - Optimization Goals.
budget_mode	varchar	Budget Mode. Enum: Budget Mode Infinite, Budget Mode Total, Budget Mode Day, Budget Mode Dynamic Daily Budget
budget	numeric	Campaign Budget.
rta_id	varchar	Real-Time Api Strategy Identifier.
rta_product_selection_enabled	boolean	Enable Rta Product Selection. Enum: True, False
postback_window_mode	varchar	Skan 4.0 Postback Mode. Enum: Postback Window Mode1, Postback Window Mode2, Postback Window Mode3
is_new_structure	boolean	New Structure Flag.
objective	varchar	Campaign Objective Type. Enum: App, Landing Page
intentwise_account_id	bigint	Intentwise Account Id
created_at	timestamp(0)	Created At
updated_at	timestamp(0)	Updated At
system_updated_time	timestamp(0)	System Updated Time

Adgroup

​Table Name: tiktok_source_data.adgroup

Column Name	Data type	Description
account_id	Integer	Intentwise Account Id
account_name	String	Account Display Name
currency_code	String	Currency Code
country_code	String	Country Code
advertiser_id	Integer	Advertiser Id.
campaign_id	Integer	Campaign Id
adgroup_id	Integer	Ad Group Id.
adgroup_name	String	Ad Group Name.
budget_mode	String	Budget Mode.
budget	Numeric	Ad Group Budget.
bid_type	String	Bid Type
bid_price	Numeric	Bid Price
optimization_goal	String	Optimization Goal. Enum: Conversions, Reach, Video Views, Clicks, Landing Page Views, Lead Generation, Value, App Installs, Product Sales
deep_bid_type	String	Deep Bid Type
deep_cpa_bid	Numeric	Cost Per Action Bid.
conversion_bid_price	Numeric	Conversion bid price.
billing_event	String	Billing Event. Enum: Cpc, Cpm, Ocpm, Cpv
schedule_type	String	Schedule Type. Enum: Schedule Start End, Schedule From Now
schedule_start_time	DateTime	Schedule Start Time
schedule_end_time	DateTime	Schedule End Time
dayparting	String	Dayparting
pacing	String	Pacing
operation_status	String	Operation Status. Enum: Enable, Disable, Frozen
secondary_status	String	Secondary Status
placement_type	String	Placement Type. Enum: Placement Type Automatic, Placement Type Normal
creative_material_mode	String	Creative Material Strategy. Enum: Custom, Dynamic, Smart Creative
promotion_type	String	Type Of Promoted Content. Enum: Download Url, External Url, App Android, App Ios
gender	String	Target Gender. Enum: Gender Female, Gender Male, Gender Unlimited
brand_safety_type	String	Brand Safety Type. Enum: No Brand Safety, Expanded Inventory, Standard Inventory, Limited Inventory, Third Party
ios14_quota_type	String	Ios Quota Type. Enum: Occupied, Unoccupied
bid_display_mode	String	Bid Display Mode
is_new_structure	Boolean	Is New Structure
auto_targeting_enabled	Boolean	Auto Targeting Enabled
share_disabled	Boolean	Share Disabled
video_download_disabled	Boolean	Video Download Disabled
is_hfss	Boolean	Is Hfss
search_result_enabled	Boolean	Search Result Enabled
inventory_filter_enabled	Boolean	Inventory Filter Enabled
comment_disabled	Boolean	Comment Disabled
skip_learning_phase	Boolean	Skip Learning Phase
create_time	DateTime	Create Time
modify_time	DateTime	Modify Time
placements	String	Placements
network_types	String	Network Types
actions	String	Actions
location_ids	String	Geographic Targeting By Location Id.
audience_ids	String	Audience Ids
excluded_audience_ids	String	Excluded Audience Ids
languages	String	Languages
operating_systems	String	Operating Systems
interest_category_ids	String	Interest Category Ids
interest_keyword_ids	String	Interest Keyword Ids
included_custom_actions	String	Included Custom Actions
excluded_custom_actions	String	Excluded Custom Actions
delivery_mode	String	Delivery Mode
pixel_id	String	Pixel Id
conversion_window	String	Conversion Window
schedule_infos	String	Schedule Infos
app_type	String	App Type. Enum: App Android, App Ios
frequency	String	Frequency
next_day_retention	String	Next Day Retention
device_price_ranges	String	Device Price Ranges
optimization_event	String	Optimization Event
secondary_optimization_event	String	Secondary Optimization Event
rf_estimated_cpr	Numeric	Rf Estimated Cpr
rf_purchased_type	String	Rf Purchased Type
adgroup_app_profile_page_state	String	App Profile Page State. Enum: Invalid, Unset, On, Off
rf_estimated_frequency	Integer	Rf Estimated Frequency
statistic_type	String	Statistic Type
purchased_reach	Integer	Purchased Reach
keywords	String	Keywords
frequency_schedule	String	Frequency Schedule
purchased_impression	Integer	Purchased Impression
created_at	DateTime	Created At
updated_at	DateTime	Updated At
system_updated_time	DateTime	System Updated Time

Ads

​Table Name: tiktok_source_data.ads

Column Name	Data type	Description
account_id	Integer	Account Id
account_name	String	Account Name
currency_code	String	Currency Code
country_code	String	Country Code
advertiser_id	Integer	Advertiser Id
campaign_id	Integer	Campaign Id
adgroup_id	Integer	Adgroup Id
ad_id	Integer	Ad Id
ad_name	String	Ad Name
create_time	DateTime	Time Ad Was Created.
modify_time	DateTime	Time Ad Was Modified.
operation_status	String	Operation Status
secondary_status	String	Secondary Ad Status.
identity_id	String	Identity Id
identity_type	String	Identity Type. Enum Values: Customized User, Auth Code, Tt User, Bc Auth Tt
identity_authorized_bc_id	String	Business Center Id For Bc Auth Tt.
catalog_id	String	Catalog Id
product_specific_type	String	Product Selection Type. Enum: All, Product Set, Customized Products
product_set_id	String	Product Set Id
ad_format	String	Ad Format. Enum: Single Image, Single Video, Live Content, Carousel Ads, Catalog Carousel
vertical_video_strategy	String	Video Strategy. Enum: Unset, Single Video, Catalog Videos, Catalog Uploaded Videos, Live Stream
dynamic_format	String	Dynamic Creative Format. Enum: Unset, Dynamic Creative
video_id	String	Video Id
carousel_image_index	Integer	Index For Carousel Image.
end_card_cta	String	End Card Cta. Enum: Search Inventory, Learn More, Shop Now, Sign Up, Contact Us, Book Now, Read More, View More, Order Now
music_id	String	Music Id
tiktok_item_id	String	Spark Ad Post Id.
promotional_music_disabled	Boolean	Promotional Music Disabled
item_duet_status	String	Duet Status. Enum: Enable, Disable
item_stitch_status	String	Stitch Status. Enum: Enable, Disable
dark_post_status	String	Dark Post Status. Enum: On, Off
branded_content_disabled	Boolean	Branded Content Disabled
shopping_ads_video_package_id	String	Catalog Video Template Id.
ad_text	String	Ad Text
call_to_action	String	Call To Action.
call_to_action_id	String	Cta Portfolio Id.
card_id	String	Creative Portfolio Id.
landing_page_url	String	Landing Page Url
page_id	Integer	Page Id
cpp_url	String	Custom Product Page Url.
tiktok_page_category	String	Tiktok Page Category
phone_region_code	String	Phone Region Code
phone_region_calling_code	String	Phone Region Calling Code
phone_number	String	Phone Number
deeplink	String	App Deeplink.
deeplink_type	String	Deeplink Type. Enum: Normal, Deferred Deeplink
deeplink_format_type	String	Deeplink Format. Enum: Universal Or App Link, Scheme Link, None
shopping_ads_deeplink_type	String	Shopping Ads Deeplink Source. Enum: None, Custom, Shopping Ads
item_group_ids	String	Product Spu Ids.
sku_ids	String	Sku Ids
vehicle_ids	String	Vehicle Ids
image_ids	String	List Of Image Ids.
ad_texts	String	List Of Ad Texts.
product_display_field_list	String	Product Display Fields. Enum Includes: Dealer Name, Make, Model, Etc.
showcase_products	String	Showcase Product Details.
utm_params	String	Utm Parameters List.
intentwise_account_id	Integer	Intentwise Account Id
created_at	DateTime	Created At
updated_at	DateTime	Updated At
system_updated_time	DateTime	System Updated Time

Campaign Report

​Table Name: tiktok_source_data.campaign_report

Column Name	Data type	Description
account_id	Integer	Account Id
account_name	String	Account Name
currency_code	String	Currency Code
country_code	String	Country Code
intentwise_account_id	Integer	Intentwise Account Id
advertiser_id	Integer	Advertiser Id
campaign_id	Integer	Campaign Id
stat_time_day	Date	Stat Time Day
spend	Numeric	Spend
cpc	Numeric	Average cost of each click to a specified destination.
cpm	Numeric	Average amount you spent per 1,000 impressions.
impressions	Integer	Impressions
gross_impressions	Integer	Gross Impressions (Includes Invalid Impressions)
clicks	Integer	Number of clicks from your ads to a specified destination.
ctr	Numeric	Percentage of impressions that resulted in a destination click out of all impressions.
reach	Integer	Number of unique users who saw your ads at least once.
cost_per_1000_reached	Numeric	Cost Per 1000 Reached
frequency	Numeric	The average number of times each user saw your ad over a given time period.
conversion	Integer	Number of times your ad resulted in the optimization event you selected.
cost_per_conversion	Numeric	Cost Per Conversion
conversion_rate	Numeric	Conversion Rate
conversion_rate_v2	Numeric	Conversion Rate V2
real_time_conversion	Integer	Real Time Conversion
real_time_cost_per_conversion	Numeric	Real Time Cost Per Conversion
video_play_actions	Integer	Video Play Actions
video_watched_2s	Integer	2-Second Video Views
video_watched_6s	Integer	6-Second Video Views
engaged_view	Integer	6-Second Views (Focused View)
paid_engaged_view	Integer	Paid Engaged View
paid_engagement_engaged_view	Integer	Paid Engagement Engaged View
engaged_view_15s	Integer	15-Second Views (Focused View)
paid_engaged_view_15s	Integer	Paid Engaged View 15S
paid_engagement_engaged_view_15s	Integer	Paid Engagement Engaged View 15S
video_views_p25	Integer	Video Views At 25%
video_views_p50	Integer	Video Views At 50%
video_views_p75	Integer	Video Views At 75%
video_views_p100	Integer	Video Views At 100%
average_video_play	Numeric	Average Video Play
average_video_play_per_user	Numeric	Average Video Play Per User
engagements	Integer	Engagements
engagement_rate	Numeric	Engagement Rate
follows	Integer	Follows
likes	Integer	Likes
comments	Integer	Comments
shares	Integer	Number of shares of your ad during the ad impression.
profile_visits	Integer	Profile Visits
profile_visits_rate	Numeric	Profile Visits Rate
complete_payment	integer	Number of website purchase actions attributed to your ads.
cost_per_complete_payment	numeric	Average cost per website purchase action attributed to your ads.
complete_payment_rate	numeric	Percentage of website purchase actions from all clicks attributed to your ads.
total_complete_payment_rate	numeric	Total value of website purchase actions attributed to your ads.
onsite_total_purchase	integer	The number of TikTok purchase actions attributed to your ads.
onsite_cost_per_purchase	numeric	The average cost per TikTok purchase action attributed to your ads.
onsite_purchase_rate	numeric	The percentage of TikTok purchase actions from all clicks attributed to your ads.
onsite_value_per_purchase	numeric	The average value per TikTok purchase action attributed to your ads.
onsite_total_purchase_value	numeric	The total value of TikTok purchase actions attributed to your ads.
system_updated_time	DateTime	System Updated Time

Campaign Gender Report

​Table Name: tiktok_source_data.campaign_gender_report

Column Name	Data type	Description
account_id	Integer	Account Id
account_name	String	Account Name
currency_code	String	Currency Code
country_code	String	Country Code
advertiser_id	Integer	Advertiser Id
intentwise_account_id	Integer	Intentwise Account Id
campaign_id	Integer	Campaign Id
stat_time_day	Date	Stat Time Day
gender	String	Gender
spend	Numeric	Spend
ctr	Numeric	Percentage of impressions that resulted in a destination click out of all impressions.
cpc	Numeric	Average cost of each click to a specified destination.
cpm	Numeric	Average amount you spent per 1,000 impressions.
impressions	Integer	Impressions
gross_impressions	Integer	Gross Impressions (Includes Invalid Impressions)
clicks	Integer	Clicks
reach	Integer	Number of unique users who saw your ads at least once.
frequency	Numeric	The average number of times each user saw your ad over a given time period.
conversions	Integer	Number of times your ad resulted in the optimization event you selected.
conversion_rate	Numeric	Conversion Rate
conversion_rate_v2	Numeric	Conversion Rate V2
cost_per_conversion	Numeric	Cost Per Conversion
real_time_conversion	Integer	Real Time Conversion
real_time_cost_per_conversion	Numeric	Real Time Cost Per Conversion
video_play_actions	Integer	Video Play Actions
video_watched_2s	Integer	2-Second Video Views
video_watched_6s	Integer	6-Second Video Views
engaged_view	Integer	6-Second Views (Focused View)
engaged_view_15s	Integer	15-Second Views (Focused View)
video_views_p25	Integer	Video Views At 25%
video_views_p50	Integer	Video Views At 50%
video_views_p75	Integer	Video Views At 75%
video_views_p100	Integer	Video Views At 100%
average_video_play	Numeric	Average Video Play
average_video_play_per_user	Numeric	Average Video Play Per User
follows	Integer	Follows
likes	Integer	Likes
comments	Integer	Comments
shares	Integer	Shares
profile_visits	Integer	Profile Visits
profile_visits_rate	Numeric	Profile Visits Rate
cost_per_1000_reached	Numeric	Cost Per 1000 Reached
system_updated_time	Date Time	System Updated Time

Adgroup Report

​Table Name: tiktok_source_data.adgroup_report

Column Name	Data type	Description
account_id	Integer	Account Id
account_name	String	Account Name
currency_code	String	Currency Code
country_code	String	Country Code
intentwise_account_id	Integer	Intentwise Account Id
advertiser_id	Integer	Advertiser Id
campaign_id	Integer	Campaign Id
adgroup_id	Integer	Adgroup Id
stat_time_day	Date	Report date
spend	Numeric	Total Cost
cpc	Numeric	Average cost of each click to a specified destination.
cpm	Numeric	Average amount you spent per 1,000 impressions.
impressions	Integer	Impressions
gross_impressions	Integer	Gross Impressions (Includes Invalid Impressions)
clicks	Integer	Clicks
ctr	Numeric	Percentage of impressions that resulted in a destination click out of all impressions.
reach	Integer	Number of unique users who saw your ads at least once.
cost_per_1000_reached	Numeric	Cost Per 1000 Reached
frequency	Numeric	The average number of times each user saw your ad over a given time period.
conversion	Integer	Number of times your ad resulted in the optimization event you selected.
cost_per_conversion	Numeric	Cost Per Conversion
conversion_rate	Numeric	Conversion Rate
conversion_rate_v2	Numeric	Conversion Rate V2
real_time_conversion	Integer	Real Time Conversion
real_time_cost_per_conversion	Numeric	Real Time Cost Per Conversion
video_play_actions	Integer	Video Views
video_watched_2s	Integer	2-Second Video Views
video_watched_6s	Integer	6-Second Video Views
engaged_view	Integer	Engaged View
paid_engaged_view	Integer	Paid Engaged View
paid_engagement_engaged_view	Integer	Paid Engagement Engaged View
engaged_view_15s	Integer	Engaged View 15S
paid_engaged_view_15s	Integer	Paid Engaged View 15S
paid_engagement_engaged_view_15s	Integer	Paid Engagement Engaged View 15S
video_views_p25	Integer	Video Views At 25%
video_views_p50	Integer	Video Views At 50%
video_views_p75	Integer	Video Views At 75%
video_views_p100	Integer	Video Views At 100%
average_video_play	Numeric	Average Watch Time Per Video View
average_video_play_per_user	Numeric	Average Watch Time Per Video View Per User
engagements	Integer	Engagements
engagement_rate	Numeric	Engagement Rate
follows	Integer	Follows
likes	Integer	Likes
comments	Integer	Comments
shares	Integer	Shares
profile_visits	Integer	Paid Profile Visits
profile_visits_rate	Numeric	Paid Profile Visit Rate
system_updated_time	DateTime	System Updated Time
complete_payment	Integer	Number of website purchase actions attributed to your ads.
cost_per_complete_payment	Numeric	Average cost per website purchase action attributed to your ads.
complete_payment_rate	Numeric	Percentage of website purchase actions from all clicks attributed to your ads.
value_per_complete_payment	Numeric	Average value per website purchase action attributed to your ads.
total_complete_payment_rate	Numeric	Total value of website purchase actions attributed to your ads.
onsite_total_purchase	Integer	The number of TikTok purchase actions attributed to your ads.
onsite_cost_per_purchase	Numeric	The average cost per TikTok purchase action attributed to your ads.
onsite_purchase_rate	Numeric	The percentage of TikTok purchase actions from all clicks attributed to your ads.
onsite_value_per_purchase	Numeric	The average value per TikTok purchase action attributed to your ads.
onsite_total_purchase_value	Numeric	The total value of TikTok purchase actions attributed to your ads.

Ads Report

​Table Name: tiktok_source_data.ads_report

Column Name	Data type	Description
account_id	Integer	Account Id
account_name	String	Account Name
currency_code	String	Currency Code
country_code	String	Country Code
intentwise_account_id	Integer	Intentwise Account Id
advertiser_id	Integer	Advertiser Id
campaign_id	Integer	Campaign Id
adgroup_id	Integer	Adgroup Id
ad_id	Integer	Ad Id
stat_time_day	Date	Stat Time Day
spend	Numeric	Total Cost
cpc	Numeric	Average cost of each click to a specified destination.
cpm	Numeric	Average amount you spent per 1,000 impressions.
impressions	Integer	Impressions
gross_impressions	Integer	Gross Impressions (Includes Invalid Impressions)
clicks	Integer	Clicks
ctr	Numeric	Percentage of impressions that resulted in a destination click out of all impressions.
reach	Integer	Number of unique users who saw your ads at least once.
cost_per_1000_reached	Numeric	Cost Per 1000 Reached
frequency	Numeric	The average number of times each user saw your ad over a given time period.
conversion	Integer	Number of times your ad resulted in the optimization event you selected.
cost_per_conversion	Numeric	Cost Per Conversion
conversion_rate	Numeric	Conversion Rate
conversion_rate_v2	Numeric	Conversion Rate V2
real_time_conversion	Integer	Real Time Conversion
real_time_cost_per_conversion	Numeric	Real Time Cost Per Conversion
video_play_actions	Integer	Video Play Actions
video_watched_2s	Integer	2-Second Video Views
video_watched_6s	Integer	6-Second Video Views
engaged_view	Integer	6-second views (Focused view)
paid_engaged_view	Integer	Paid Engaged View
paid_engagement_engaged_view	Integer	Paid Engagement Engaged View
engaged_view_15s	Integer	15-second views (Focused view)
paid_engaged_view_15s	Integer	Paid Engaged View 15S
paid_engagement_engaged_view_15s	Integer	Paid Engagement Engaged View 15S
video_views_p25	Integer	Video Views at 25%
video_views_p50	Integer	Video Views at 50%
video_views_p75	Integer	Video Views at 75%
video_views_p100	Integer	Video Views at 100%
average_video_play	Numeric	Average Video Play
average_video_play_per_user	Numeric	Average Video Play Per User
engagements	Integer	Engagements
engagement_rate	Numeric	Engagement Rate
follows	Integer	Follows
likes	Integer	Likes
comments	Integer	Comments
shares	Integer	Shares
profile_visits	Integer	Profile Visits
profile_visits_rate	Numeric	Profile Visits Rate
system_updated_time	DateTime	System Updated Time
complete_payment	Integer	Number of website purchase actions attributed to your ads.
cost_per_complete_payment	Numeric	Average cost per website purchase action attributed to your ads.
complete_payment_rate	Numeric	Percentage of website purchase actions from all clicks attributed to your ads.
value_per_complete_payment	Numeric	Average value per website purchase action attributed to your ads.
total_complete_payment_rate	Numeric	Total value of website purchase actions attributed to your ads.
onsite_total_purchase	Integer	The number of TikTok purchase actions attributed to your ads.
onsite_cost_per_purchase	Numeric	The average cost per TikTok purchase action attributed to your ads.
onsite_purchase_rate	Numeric	The percentage of TikTok purchase actions from all clicks attributed to your ads.
onsite_value_per_purchase	Numeric	The average value per TikTok purchase action attributed to your ads.
onsite_total_purchase_value	Numeric	The total value of TikTok purchase actions attributed to your ads.