Tiktok Ads

Explore the interactive ERD

Table & Field Reference

pixel_event

Column	Type	Keys
`_fivetran_id`	String	PK
`pixel_id`	Long	FK
`code`	String
`currency`	String
`currency_value`	String
`custom_event_type`	String
`deprecated`	Boolean
`id`	Long
`name`	String
`optimization_event`	String
`statistic_type`	String
`type`	String

gmv_max_campaign_history

Column	Type	Keys
`campaign_id`	Long	PK
`updated_at`	Instant	PK
`advertiser_id`	Long	FK
`campaign_name`	String
`create_time`	Instant
`gmx_max_promotion_type`	String
`objective_type`	String
`operation_status`	String
`roi_protection_compensation_status`	String
`secondary_status`	String

pixel_statistic

Column	Type	Keys
`_fivetran_id`	String	PK
`advertiser_id`	Long	PKFK
`pixel_id`	Long	PKFK
`attributed_count`	Long
`browser_event_total_count`	Long
`pixel_event_type`	String
`preview_count`	Long
`server_event_total_count`	Long
`total_count`	Long

utm_param

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_id`	Long	PKFK
`custom_parameters`	Json
`utm_campaign`	String
`utm_content`	String
`utm_medium`	String
`utm_source`	String
`utm_term`	String

smart_creative_material_ad_title_history

Column	Type	Keys
`material_id`	Long	PK
`adgroup_id`	Long	PKFK
`advertiser_id`	Long	PKFK
`material_operation_status`	String
`title`	String

ad_history

Column	Type	Keys
`ad_id`	Long	PK
`updated_at`	Instant	PK
`adgroup_id`	Long	FK
`advertiser_id`	Long	FK
`campaign_id`	Long	FK
`video_id`	String	FK
`ad_format`	String
`ad_name`	String
`ad_text`	String
`adgroup_name`	String
`aigc_disclosure_type`	String
`app_name`	String
`avatar_icon_web_uri`	String
`brand_safety_postbid_partner`	String
`brand_safety_vast_url`	String
`branded_content_disabled`	Boolean
`buying_type`	String
`call_to_action`	String
`call_to_action_id`	String
`campaign_automation_type`	String
`campaign_name`	String
`card_id`	String
`carousel_image_index`	Int
`click_tracking_url`	String
`cpp_url`	String
`create_time`	Instant
`creative_authorized`	Boolean
`creative_type`	String
`dark_post_status`	String
`deeplink`	String
`deeplink_type`	String
`display_name`	String
`dynamic_destination`	String
`dynamic_format`	String
`fallback_type`	String
`identity_authorized_bc_id`	String
`identity_id`	String
`identity_type`	String
`image_ids`	Json
`impression_tracking_url`	String
`is_aco`	Boolean
`is_new_structure`	Boolean
`item_duet_status`	String
`item_stitch_status`	String
`landing_page_url`	String
`music_id`	String
`operation_status`	String
`optimization_event`	String
`page_id`	String
`phone_number`	String
`phone_region_calling_code`	String
`phone_region_code`	String
`playable_url`	String
`product_set_id`	String
`product_specific_type`	String
`profile_image_url`	String
`promotional_music_disabled`	Boolean
`secondary_status`	String
`shopping_ads_deeplink_type`	String
`shopping_ads_fallback_type`	String
`shopping_ads_video_package_id`	String
`smart_plus_ad_id`	String
`tiktok_item_id`	String
`tiktok_page_category`	String
`tracking_app_id`	String
`tracking_pixel_id`	String
`vast_moat_enabled`	Boolean
`vertical_video_strategy`	String
`viewability_postbid_partner`	String
`viewability_vast_url`	String

campaign_history

Column	Type	Keys
`campaign_id`	Long	PK
`updated_at`	Instant	PK
`advertiser_id`	Long	FK
`app_id`	String
`app_promotion_type`	String
`bid_type`	String
`budget`	Double
`budget_mode`	String
`budget_optimize_on`	Boolean
`buying_type`	String
`campaign_app_profile_page_state`	String
`campaign_automation_type`	String
`campaign_name`	String
`campaign_product_source`	String
`campaign_type`	String
`create_time`	Instant
`deep_bid_type`	String
`is_advanced_dedicated_campaign`	Boolean
`is_new_structure`	String
`is_search_campaign`	Boolean
`is_smart_performance_campaign`	Boolean
`objective`	String
`objective_type`	String
`operation_status`	String
`optimization_goal`	String
`postback_window_mode`	String
`rf_campaign_type`	String
`roas_bid`	Double
`rta_id`	String
`rta_product_selection_enabled`	Boolean
`secondary_status`	String
`split_test_variable`	String

adgroup_history

Column	Type	Keys
`adgroup_id`	Long	PK
`updated_at`	Instant	PK
`advertiser_id`	Long	FK
`campaign_id`	Long	FK
`action_categories`	Json
`action_days`	Int
`adgroup_app_profile_page_state`	String
`adgroup_name`	String
`age_groups`	Json
`app_config_app_ids`	Json
`app_download_url`	String
`app_id`	Long
`app_name`	String
`app_type`	String
`attribution_event_count`	String
`audience`	Json
`audience_type`	String
`automated_keywords_enabled`	Boolean
`bid_display_mode`	String
`bid_price`	Double
`bid_type`	String
`billing_event`	String
`brand_safety_partner`	String
`brand_safety_type`	String
`budget`	Double
`budget_mode`	String
`buying_type`	String
`category`	Int
`click_attribution_window`	String
`comment_disabled`	Boolean
`conversion_bid_price`	Double
`cpm`	Double
`cpv_video_duration`	String
`create_time`	Instant
`creative_material_mode`	String
`custom_conversion_id`	String
`dayparting`	String
`deep_bid_type`	String
`deep_cpa_bid`	Double
`deep_funnel_event_source`	String
`deep_funnel_event_source_id`	String
`deep_funnel_optimization_event`	String
`deep_funnel_optimization_status`	String
`delivery_mode`	String
`discount_amount`	Double
`discount_percentage`	Double
`discount_type`	String
`display_name`	String
`engaged_view_attribution_window`	String
`excluded_audience`	Json
`fallback_type`	String
`feed_type`	String
`frequency`	Int
`frequency_schedule`	Int
`gender`	String
`identity_authorized_bc_id`	String
`identity_id`	String
`identity_type`	String
`interest_category_v_2`	Json
`inventory_filter_enabled`	Boolean
`ios_14_quota_type`	String
`ios_14_targeting`	String
`is_comment_disable`	Int
`is_hfss`	Boolean
`is_lhf_compliance`	Boolean
`is_new_structure`	Boolean
`is_smart_performance_campaign`	Boolean
`keywords`	Json
`landing_page_url`	String
`languages`	Json
`location`	Json
`message_event_set_id`	String
`messaging_app_account_id`	String
`messaging_app_type`	String
`min_android_version`	String
`min_ios_version`	String
`network_types`	Json
`next_day_retention`	Double
`open_url`	String
`open_url_type`	String
`operating_systems`	Json
`operation_status`	String
`optimization_event`	String
`optimization_goal`	String
`pacing`	String
`package`	String
`pangle_block_app_list_id`	Json
`phone_number`	String
`phone_region_calling_code`	String
`phone_region_code`	String
`pixel_id`	Long
`placement_type`	String
`placements`	Json
`pre_discount_budget`	Double
`pre_discount_cpm`	Double
`predict_impression`	Int
`product_source`	String
`profile_image`	String
`promotion_target_type`	String
`promotion_type`	String
`promotion_website_type`	String
`purchased_impression`	Int
`purchased_reach`	Int
`rf_estimated_cpr`	Double
`rf_estimated_frequency`	Double
`rf_purchased_type`	String
`roas_bid`	Double
`saved_audience_id`	String
`schedule_end_time`	Instant
`schedule_start_time`	Instant
`schedule_type`	String
`scheduled_budget`	Double
`search_result_enabled`	Boolean
`secondary_optimization_event`	String
`secondary_status`	String
`share_disabled`	Boolean
`shopping_ads_retargeting_actions_days`	Int
`shopping_ads_retargeting_custom_audience_relation`	String
`shopping_ads_retargeting_type`	String
`shopping_ads_type`	String
`skip_learning_phase`	Int
`smart_audience_enabled`	Boolean
`smart_interest_behavior_enabled`	Boolean
`spending_power`	String
`split_test_group_id`	String
`split_test_status`	String
`statistic_type`	String
`store_authorized_bc_id`	String
`store_id`	String
`tiktok_subplacements`	Json
`vbo_window`	String
`vertical_sensitivity_id`	String
`video_actions`	Json
`video_download`	String
`video_download_disabled`	Boolean
`view_attribution_window`	String

smart_plus_ad_history

Column	Type	Keys
`smart_plus_ad_id`	Long	PK
`updated_at`	Instant	PK
`adgroup_id`	Long	FK
`advertiser_id`	Long	FK
`campaign_id`	Long	FK
`ad_name`	String
`ad_text_list`	Json
`adgroup_name`	String
`auto_disclaimer_types`	Json
`auto_message_list`	Json
`call_to_action_id`	String
`call_to_action_list`	Json
`campaign_name`	String
`catalog_creative_toggle`	Boolean
`create_time`	Instant
`creative_auto_add_toggle`	Boolean
`custom_product_page_list`	Json
`dark_post_status`	String
`deeplink_list`	Json
`end_card_cta`	String
`fallback_type`	String
`identity_id`	String
`identity_type`	String
`interactive_add_on_list`	Json
`landing_page_url_list`	Json
`operation_status`	String
`page_list`	Json
`phone_info_phone_number`	String
`phone_info_phone_region_calling_code`	String
`phone_info_phone_region_code`	String
`product_display_field_list`	Json
`product_ids`	Json
`product_info_selling_points`	Json
`product_set_id`	String
`product_specific_type`	String
`secondary_status`	String
`tracking_info_click_tracking_url`	String
`tracking_info_impression_tracking_url`	String
`tracking_info_tracking_app_id`	String
`tracking_info_tracking_message_event_set_id`	String

ad_image

Column	Type	Keys
`ad_id`	Long	PKFK
`image_id`	String	PKFK

smart_creative_material_media_info_history

Column	Type	Keys
`material_id`	Long	PK
`adgroup_id`	Long	PKFK
`advertiser_id`	Long	PKFK
`material_operation_status`	String
`media_info_`

location

Column	Type	Keys
`region_id`	String	PK
`advertiser_id`	Long	PKFK
`area_type`	String
`country_code`	String
`parent_id`	String
`region_level`	String
`region_name`	String
`support_below_18`	Boolean

image_history

Column	Type	Keys
`image_id`	String	PK
`updated_at`	Instant	PK
`advertiser_id`	String	FK
`created_at`	Instant
`displayable`	Boolean
`file_name`	String
`format`	String
`height`	Int
`image_url`	String
`is_carousel_usable`	Boolean
`material_id`	String
`signature`	String
`size`	Int
`width`	Int

adgroup_search_keyword_history

Column	Type	Keys
`_fivetran_id`	String	PK
`adgroup_id`	Long	FK
`audit_status`	String
`keyword`	String
`keyword_bid`	Double
`keyword_bid_type`	String
`match_type`	String

smart_plus_ad_creative_info

Column	Type	Keys
`ad_material_id`	Long	PK
`smart_plus_ad_id`	Long	FK
`ad_format`	String
`aigc_disclosure_type`	String
`identity_authorized_bc_id`	String
`identity_id`	String
`identity_type`	String
`image_info`	Json
`material_name`	String
`material_operation_status`	String
`music_info_music_id`	String
`tiktok_item_id`	String
`video_info_file_name`	String
`video_info_video_id`	String

smart_creative_material_history

Column	Type	Keys
`adgroup_id`	Long	PKFK
`advertiser_id`	Long	PKFK
`avatar_icon_list`	Json
`call_to_action_list`	Json
`card_list`	Json
`deeplink_list`	Json
`display_name_list`	Json
`landing_page_urls`	Json
`page_list`	Json
`common_material_`

creative_history

Column	Type	Keys
`creative_id`	Long	PK
`updated_at`	Instant	PK
`adgroup_id`	Long	FK
`advertiser_id`	Long	FK
`campaign_id`	Long	FK
`smart_plus_ad_id`	String	FK
`video_id`	String	FK
`ad_text`	String
`adgroup_name`	String
`campaign_automation_type`	String
`campaign_name`	String
`create_time`	Instant
`creative_name`	String
`identity_id`	String
`identity_type`	String
`image_ids`	Json
`operation_status`	String
`secondary_status`	String

smart_plus_ad_deeplink_utm_param

Column	Type	Keys
`_fivetran_id`	String	PK
`smart_plus_ad_id`	Long	FK
`custom_parameters`	Json
`utm_campaign`	String
`utm_content`	String
`utm_medium`	String
`utm_source`	String

pixel

Column	Type	Keys
`id`	Long	PK
`advertiser_id`	Long	PKFK
`advanced_matching_field_email`	Boolean
`advanced_matching_field_phone_number`	Boolean
`code`	String
`create_time`	Instant
`name`	String
`partner_name`	String
`script`	String
`setup_mode`	String
`asset_ownership_`

video_history

Column	Type	Keys
`updated_at`	Instant	PK
`video_id`	String	PK
`advertiser_id`	String	FK
`allow_download`	Boolean
`allowed_placements`	Json
`bit_rate`	Double
`create_time`	String
`displayable`	Boolean
`duration`	Float
`file_name`	String
`format`	String
`height`	Int
`material_id`	String
`preview_url`	String
`preview_url_expire_time`	String
`signature`	String
`size`	Int
`video_cover_url`	String
`width`	Int

smart_plus_ad_utm_param

Column	Type	Keys
`_fivetran_id`	String	PK
`smart_plus_ad_id`	Long	FK
`custom_parameters`	Json
`utm_campaign`	String
`utm_content`	String
`utm_medium`	String
`utm_source`	String

advertiser

Column	Type	Keys
`id`	Long	PK
`address`	String
`advertiser_account_type`	String
`balance`	Double
`cellphone_number`	String
`company`	String
`company_name_editable`	Boolean
`contacter`	String
`country`	String
`create_time`	Instant
`currency`	String
`description`	String
`email`	String
`industry`	String
`language`	String
`license_no`	String
`license_url`	String
`name`	String
`promotion_area`	String
`rejection_reason`	String
`role`	String
`status`	String
`telephone_number`	String
`timezone`	String

pixel_event_rule

Column	Type	Keys
`_fivetran_id`	String	PK
`event_id`	Long	PKFK
`operator`	String
`trigger`	String
`value`	String
`variable`	String