TikTok Ads data warehouse table groups

Prev Next

Table: AD

ad_group_id
ad_group_name
ad_group_opt_status
ad_group_status
ad_id
ad_name
ad_opt_status
ad_status
ad_text
add_billing
adgroup_placement
advertiser_address
advertiser_balance
advertiser_company
advertiser_country
advertiser_currency
advertiser_email
advertiser_id
advertiser_license_number
advertiser_name
advertiser_phone_number
advertiser_status
advertiser_timezone
app_download_url
app_id
app_install
app_name
app_package
app_type
audience_rule
audience_type
bid
bid_type
billing_event
button_click
call_to_action
campaign_budget
campaign_budget_mode
campaign_creation_date
campaign_id
campaign_modify_date
campaign_name
campaign_objective_type
campaign_operation_status
clicks
comments
complete_payment
consultation
conversion_bid
conversions
cost
cpv_video_duration
dataSourceName
date
deep_bid_type
deep_cpabid
deep_external_action
display_name
download_detail
external_action
follows
form
form_detail
image_mode
impressions
initiate_checkout
is_comment_disable
keywords
landing_page_url
likes
on_web_order
online_consult
optimize_goal
pacing
page_browse_consultation
page_browse_view
pixel_id
placement_type
playable_url
product_details_page_browse
profile_image
real_time_app_install
real_time_conversions
real_time_results
results
schedule_end_time
schedule_start_time
schedule_type
secondary_goal_result
shares
statistic_type
target_age
target_android_osv
target_connection_type
target_device_price
target_gender
target_ios_osv
target_languages
target_operation_system
total_achieve_level
total_achieve_level_value
total_add_billing_value
total_add_payment_info
total_add_to_wishlist
total_add_to_wishlist_value
total_app_event_add_to_cart
total_app_event_add_to_cart_value
total_button_click_consultation_value
total_button_click_value
total_checkout
total_checkout_value
total_complete_payment_rate
total_complete_tutorial
total_complete_tutorial_value
total_consultation_value
total_create_gamerole
total_create_gamerole_value
total_create_group
total_create_group_value
total_download_detail_value
total_download_start_value
total_form_button_value
total_form_detail_value
total_form_value
total_in_app_ad_click
total_in_app_ad_click_value
total_in_app_ad_impr
total_in_app_ad_impr_value
total_initiate_checkout_value
total_join_group
total_join_group_value
total_launch_app
total_loan_apply
total_loan_credit
total_loan_disbursement
total_login
total_next_day_open
total_on_web_order_value
total_online_consult_value
total_page_browse_consultation_value
total_page_event_search_value
total_product_details_page_browse_value
total_purchase
total_purchase_value
total_registration
total_search
total_spend_credits
total_spend_credits_value
total_start_trial
total_subscribe
total_subscribe_value
total_unlock_achievement
total_unlock_achievement_value
total_user_registration_value
total_view_content
total_view_content_value
total_web_event_add_to_cart_value
user_registration
video_id
video_play_actions
video_views_p100
video_views_p25
video_views_p50
video_views_p75
video_watched_2s
video_watched_6s
web_event_add_to_cart

Table: AGE_GENDER

ad_group_id
ad_group_name
ad_id
ad_name
ad_text
advertiser_id
advertiser_name
age
campaign_id
campaign_name
campaign_objective_type
clicks
cost
dataSourceName
date
gender
impressions

Table: GEO

ad_group_id
ad_group_name
ad_id
ad_name
ad_text
advertiser_id
advertiser_name
campaign_id
campaign_name
campaign_objective_type
clicks
cost
country_code
country_name
dataSourceName
date
impressions