TikTok

This page will help you learn about how Daasity replicates data from TikTok, limitations to the data we can extract and where the data is stored in the TikTok schema.

Overview

TikTok is a popular social media app that allows users to create, watch, and share videos. With its personalized feeds of short videos set to music and sound effects, the app is notable for its high levels of engagement.

This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.

Integration Availability

This integration is available for:

• Enterprise

• Growth

API Endpoints

The Daasity TikTok extractor is built based on this TikTok API Documentation. The following endpoints are used by Daasity to replicate data from TikTok:

• Ad

• Ad Group

• Advertisers

• Campaigns

• Reports

Entity Relationship Diagram (ERD)

Click here to view the ERD for the Daasity TikTok integration illustrating the different tables and keys to join across tables.

TikTok Schema

The Daasity TikTok extractor creates these tables using the endpoints and replication methods listed. The data is mapped from the source API endpoint to the table based on the mapping logic outlined in each table.

• Ad Groups

• Ad Group Audience

• Ad Group Device Model

• Ad Group Placement

• Ads

• Ad Spend Auction Metrics

• Ad Spend Auction Ad

• Ad Spend Auction Ad Group

• Ad Spend Auction Campaign

• Ad Spend Reservation Metrics

• Ad Spend Reservation Ad

• Ad Spend Reservation Ad Group

• Ad Spend Reservation Campaign

• Advertisers

• Campaigns

Ad Groups

• Endpoint: Ad Group

• Update Method: UPSERT

• Table Name: [tiktok.ad_groups]

JSON Element	Database Column
advertiser_id	advertiser_id
campaign_id	campaign_id
adgroup_id	adgroup_id
adgroup_name	adgroup_name
split_test_group_id	split_test_group_id
split_test_status	split_test_status
share_disabled	share_disabled
placement_type	placement_type
inventory_filter_enabled	inventory_filter_enabled
comment_disabled	comment_disabled
app_id	app_id
promotion_type	promotion_type
store_id	store_id
store_authorized_bc_id	store_authorized_bc_id
identity_id	identity_id
identity_type	identity_type
identity_authorized_bc_id	identity_authorized_bc_id
app_download_url	app_download_url
pixel_id	pixel_id
optimization_event	optimization_event
secondary_optimization_event	secondary_optimization_event
creative_material_mode	creative_material_mode
audience_type	audience_type
is_hfss	is_hfss
gender	gender
min_android_version	min_android_version
min_ios_version	min_ios_version
ios14_targeting	ios14_targeting
budget_mode	budget_mode
budget	budget
scheduled_budget	scheduled_budget
schedule_type	schedule_type
schedule_start_time	schedule_start_time
schedule_end_time	schedule_end_time
dayparting	dayparting
optimization_goal	optimization_goal
bid_display_mode	bid_display_mode
cpv_video_duration	cpv_video_duration
conversion_window	conversion_window
pacing	pacing
billing_event	billing_event
skip_learning_phase	skip_learning_phase
bid_type	bid_type
bid_price	bid_price
conversion_bid_price	conversion_bid_price
deep_bid_type	deep_bid_type
deep_cpa_bid	deep_cpa_bid
next_day_retention	next_day_retention
secondary_status	secondary_status
operation_status	operation_status
frequency	frequency
frequency_schedule	frequency_schedule
statistic_type	statistic_type
video_download_disabled	video_download_disabled
rf_purchased_type	rf_purchased_type
purchased_impression	purchased_impression
purchased_reach	purchased_reach
rf_estimated_cpr	rf_estimated_cpr
rf_estimated_frequency	rf_estimated_frequency
is_new_structure	is_new_structure
catalog_id	catalog_id
product_set_id	product_set_id
catalog_authorized_bc_id	catalog_authorized_bc_id
shopping_ads_retargeting_type	shopping_ads_retargeting_type
brand_safety_type	brand_safety_type
brand_safety_partner	brand_safety_partner
promotion_website_type	promotion_website_type
ios_quota_type	ios_quota_type
roas_bid	roas_bid
auto_targeting_enabled	auto_targeting_enabled
targeting_expansion::expansion_enabled	targeting_expansion_expansion_enabled
targeting_expansion::expansion_type	targeting_expansion_expansion_types
adgroup_app_profile_page_state	adgroup_app_profile_page_state
shopping_ads_type	shopping_ads_type
product_source	product_source
MD5(advertiser_id + adgroup_id + campaign_id )	__sync_key

Ad Group Audience

• Endpoint: Ad Group

• Update Method: UPSERT

• Table Name: [tiktok.adgroup_audience]

JSON Element	Database Column
advertiser_id	advertiser_id
campaign_id	campaign_id
adgroup_id	adgroup_id
audience_id	audience_id
MD5(advertiser_id + campaign_id + adgroup_id + audience_id)	__sync_key

Ad Group Device Model

• Endpoint: Ad Group

• Update Method: UPSERT

• Table Name: [tiktok.adgroup_device_model]

JSON Element	Database Column
advertiser_id	advertiser_id
campaign_id	campaign_id
adgroup_id	adgroup_id
device_model_id	device_model_id
MD5(advertiser_id + campaign_id + adgroup_id + device_model_id)	__sync_key

Ad Group Placement

• Endpoint: Ad Group

• Update Method: UPSERT

• Table Name: [tiktok.adgroup_placement]

JSON Element	Database Column
advertiser_id	advertiser_id
campaign_id	campaign_id
adgroup_id	adgroup_id
placement	placement
MD5(advertiser_id + campaign_id + ad)	__sync_key

Ads

• Endpoint: Ad

• Update Method: UPSERT

• Table Name: [tiktok.ads]

JSON Element	Database Columnd
advertiser_id	advertiser_id
campaign_id	campaign_id
campaign_name	campaign_name
adgroup_id	adgroup_id
adgroup_name	adgroup_name
ad_id	ad_id
ad_name	ad_name
identity_id	identity_id
identity_type	identity_type
identity_authorized_bc_id	identity_authorized_bc_id
call_to_action	call_to_action
call_to_action_id	call_to_action_id
card_id	card_id
secondary_status	secondary_status
operation_status	operation_status
is_aco	is_aco
ad_format	ad_format
ad_text	ad_text
ad_texts	ad_texts
video_id	video_id
tiktok_item_id	tiktok_item_id
app_name	app_name
landing_page_url	landing_page_url
landing_page_urls	landing_page_urls
display_name	display_name
profile_image_url	profile_image_url
impression_tracking_url	impression_tracking_url
click_tracking_url	click_tracking_url
deeplink	deeplink
deeplink_type	deeplink_type
fallback_type	fallback_type
playable_url	playable_url
page_id	page_id
vast_moat_enabled	vast_moat_enabled
creative_authorized	creative_authorized
is_new_structure	is_new_structure
create_time	create_time
modify_time	modify_time
shopping_ads_fallback_type	shopping_ads_fallback_type
shopping_ads_deeplink_type	shopping_ads_deeplink_type
shopping_ads_video_package_id	shopping_ads_video_package_id
promotional_music_disabled	promotional_music_disabled
dark_post_status	dark_post_status
branded_content_disabled	branded_content_disabled
item_duet_status	item_duet_status
item_stitch_status	item_stitch_status
brand_safety_postbid_partner	brand_safety_postbid_partner
product_specific_type	product_specific_type
catalog_id	catalog_id
product_set_id	product_set_id
sku_ids	sku_ids
dynamic_format	dynamic_format
vertical_video_strategy	vertical_video_strategy
dynamic_destination	dynamic_destination
MD5((advertiser_id + ad_id + adgroup_id + campaign_id)	__sync_key

Ad Spend Auction Metrics

• API Endpoint: Reports

• Update Method: UPSERT

• Table Names: tiktok.adspend_auction_ad, tiktok.adspend_auction_adgroup, tiktok.adspend_auction_campaign

The following metrics are extracted from the Reports API Endpoint and can be queried at the ad, ad group, and campaign level for all Ad Spend Auction tables. The metrics included are:

JSON Element	Database Column
campaign_name	campaign_name
objective_type	objective_type
adgroup_name	adgroup_name
placement_type	placement_type
ad_name	ad_name
ad_text	ad_text
tt_app_id	tt_app_id
tt_app_name	tt_app_name
mobile_app_id	mobile_app_id
promotion_type	promotion_type
dpa_target_audience_type	dpa_target_audience_type
spend	spend
cpc	cpc
cpm	cpm
impressions	impressions
clicks	clicks
ctr	ctr
reach	reach
cost_per_1000_reached	cost_per_1000_reached
conversion	conversion
cost_per_conversion	cost_per_conversion
conversion_rate	conversion_rate
real_time_conversion	real_time_conversion
real_time_cost_per_conversion	real_time_cost_per_conversion
result	result
cost_per_result	cost_per_result
result_rate	result_rate
real_time_result	real_time_result
real_time_cost_per_result	real_time_cost_per_result
real_time_result_rate	real_time_result_rate
secondary_goal_result	secondary_goal_result
cost_per_secondary_goal_result	cost_per_secondary_goal_result
secondary_goal_result_rate	secondary_goal_result_rate
frequency	frequency
currency	currency
video_play_actions	video_play_actions
video_watched_2s	video_watched_2s
video_watched_6s	video_watched_6s
average_video_play	average_video_play
average_video_play_per_user	average_video_play_per_user
video_views_p25	video_views_p25
video_views_p50	video_views_p50
video_views_p75	video_views_p75
video_views_p100	video_views_p100
profile_visits	profile_visits
profile_visits_rate	profile_visits_rate
likes	likes
comments	comments
shares	shares
follows	follows
real_time_app_install	real_time_app_install
real_time_app_install_cost	real_time_app_install_cost
app_install	app_install
cost_per_app_install	cost_per_app_install
registration	registration
cost_per_registration	cost_per_registration
registration_rate	registration_rate
total_registration	total_registration
cost_per_total_registration	cost_per_total_registration
purchase	purchase
cost_per_purchase	cost_per_purchase
purchase_rate	purchase_rate
total_purchase	total_purchase
cost_per_total_purchase	cost_per_total_purchase
value_per_total_purchase	value_per_total_purchase
total_purchase_value	total_purchase_value
total_active_pay_roas	total_active_pay_roas
app_event_add_to_cart	app_event_add_to_cart
cost_per_app_event_add_to_cart	cost_per_app_event_add_to_cart
app_event_add_to_cart_rate	app_event_add_to_cart_rate
total_app_event_add_to_cart	total_app_event_add_to_cart
cost_per_total_app_event_add_to_cart	cost_per_total_app_event_add_to_cart
value_per_total_app_event_add_to_cart	value_per_total_app_event_add_to_cart
total_app_event_add_to_cart_value	total_app_event_add_to_cart_value
checkout	checkout
cost_per_checkout	cost_per_checkout
checkout_rate	checkout_rate
total_checkout	total_checkout
cost_per_total_checkout	cost_per_total_checkout
value_per_checkout	value_per_checkout
total_checkout_value	total_checkout_value
view_content	view_content
cost_per_view_content	cost_per_view_content
view_content_rate	view_content_rate
total_view_content	total_view_content
cost_per_total_view_content	cost_per_total_view_content
value_per_total_view_content	value_per_total_view_content
total_view_content_value	total_view_content_value
next_day_open	next_day_open
cost_per_next_day_open	cost_per_next_day_open
next_day_open_rate	next_day_open_rate
total_next_day_open	total_next_day_open
cost_per_total_next_day_open	cost_per_total_next_day_open
add_payment_info	add_payment_info
cost_per_add_payment_info	cost_per_add_payment_info
add_payment_info_rate	add_payment_info_rate
total_add_payment_info	total_add_payment_info
cost_total_add_payment_info	cost_total_add_payment_info
add_to_wishlist	add_to_wishlist
cost_per_add_to_wishlist	cost_per_add_to_wishlist
add_to_wishlist_rate	add_to_wishlist_rate
total_add_to_wishlist	total_add_to_wishlist
cost_per_total_add_to_wishlist	cost_per_total_add_to_wishlist
value_per_total_add_to_wishlist	value_per_total_add_to_wishlist
total_add_to_wishlist_value	total_add_to_wishlist_value
launch_app	launch_app
cost_per_launch_app	cost_per_launch_app
launch_app_rate	launch_app_rate
total_launch_app	total_launch_app
cost_per_total_launch_app	cost_per_total_launch_app
complete_tutorial	complete_tutorial
cost_per_complete_tutorial	cost_per_complete_tutorial
complete_tutorial_rate	complete_tutorial_rate
total_complete_tutorial	total_complete_tutorial
cost_per_total_complete_tutorial	cost_per_total_complete_tutorial
value_per_total_complete_tutorial	value_per_total_complete_tutorial
total_complete_tutorial_value	total_complete_tutorial_value
create_group	create_group
cost_per_create_group	cost_per_create_group
create_group_rate	create_group_rate
total_create_group	total_create_group
cost_per_total_create_group	cost_per_total_create_group
value_per_total_create_group	value_per_total_create_group
total_create_group_value	total_create_group_value
join_group	join_group
cost_per_join_group	cost_per_join_group
join_group_rate	join_group_rate
total_join_group	total_join_group
cost_per_total_join_group	cost_per_total_join_group
value_per_total_join_group	value_per_total_join_group
total_join_group_value	total_join_group_value
create_gamerole	create_gamerole
cost_per_create_gamerole	cost_per_create_gamerole
create_gamerole_rate	create_gamerole_rate
total_create_gamerole	total_create_gamerole
cost_per_total_create_gamerole	cost_per_total_create_gamerole
value_per_total_create_gamerole	value_per_total_create_gamerole
total_create_gamerole_value	total_create_gamerole_value
spend_credits	spend_credits
cost_per_spend_credits	cost_per_spend_credits
spend_credits_rate	spend_credits_rate
total_spend_credits	total_spend_credits
cost_per_total_spend_credits	cost_per_total_spend_credits
value_per_total_spend_credits	value_per_total_spend_credits
total_spend_credits_value	total_spend_credits_value
achieve_level	achieve_level
cost_per_achieve_level	cost_per_achieve_level
achieve_level_rate	achieve_level_rate
total_achieve_level	total_achieve_level
cost_per_total_achieve_level	cost_per_total_achieve_level
value_per_total_achieve_level	value_per_total_achieve_level
total_achieve_level_value	total_achieve_level_value
unlock_achievement	unlock_achievement
cost_per_unlock_achievement	cost_per_unlock_achievement
unlock_achievement_rate	unlock_achievement_rate
total_unlock_achievement	total_unlock_achievement
cost_per_total_unlock_achievement	cost_per_total_unlock_achievement
value_per_total_unlock_achievement	value_per_total_unlock_achievement
total_unlock_achievement_value	total_unlock_achievement_value
sales_lead	sales_lead
cost_per_sales_lead	cost_per_sales_lead
sales_lead_rate	sales_lead_rate
total_sales_lead	total_sales_lead
cost_per_total_sales_lead	cost_per_total_sales_lead
value_per_total_sales_lead	value_per_total_sales_lead
total_sales_lead_value	total_sales_lead_value
in_app_ad_click	in_app_ad_click
cost_per_in_app_ad_click	cost_per_in_app_ad_click
in_app_ad_click_rate	in_app_ad_click_rate
total_in_app_ad_click	total_in_app_ad_click
cost_per_total_in_app_ad_click	cost_per_total_in_app_ad_click
value_per_total_in_app_ad_click	value_per_total_in_app_ad_click
total_in_app_ad_click_value	total_in_app_ad_click_value
in_app_ad_impr	in_app_ad_impr
cost_per_in_app_ad_impr	cost_per_in_app_ad_impr
in_app_ad_impr_rate	in_app_ad_impr_rate
total_in_app_ad_impr	total_in_app_ad_impr
cost_per_total_in_app_ad_impr	cost_per_total_in_app_ad_impr
value_per_total_in_app_ad_impr	value_per_total_in_app_ad_impr
total_in_app_ad_impr_value	total_in_app_ad_impr_value
loan_apply	loan_apply
cost_per_loan_apply	cost_per_loan_apply
loan_apply_rate	loan_apply_rate
total_loan_apply	total_loan_apply
cost_per_total_loan_apply	cost_per_total_loan_apply
loan_credit	loan_credit
cost_per_loan_credit	cost_per_loan_credit
loan_credit_rate	loan_credit_rate
total_loan_credit	total_loan_credit
cost_per_total_loan_credit	cost_per_total_loan_credit
loan_disbursement	loan_disbursement
cost_per_loan_disbursement	cost_per_loan_disbursement
loan_disbursement_rate	loan_disbursement_rate
total_loan_disbursement	total_loan_disbursement
cost_per_total_loan_disbursement	cost_per_total_loan_disbursement
login	login
cost_per_login	cost_per_login
login_rate	login_rate
total_login	total_login
cost_per_total_login	cost_per_total_login
ratings	ratings
cost_per_ratings	cost_per_ratings
ratings_rate	ratings_rate
total_ratings	total_ratings
cost_per_total_ratings	cost_per_total_ratings
value_per_total_ratings	value_per_total_ratings
total_ratings_value	total_ratings_value
search	search
cost_per_search	cost_per_search
search_rate	search_rate
total_search	total_search
cost_per_total_search	cost_per_total_search
start_trial	start_trial
cost_per_start_trial	cost_per_start_trial
start_trial_rate	start_trial_rate
total_start_trial	total_start_trial
cost_per_total_start_trial	cost_per_total_start_trial
subscribe	subscribe
cost_per_subscribe	cost_per_subscribe
subscribe_rate	subscribe_rate
total_subscribe	total_subscribe
cost_per_total_subscribe	cost_per_total_subscribe
value_per_total_subscribe	value_per_total_subscribe
total_subscribe_value	total_subscribe_value
vta_app_install	vta_app_install
vta_conversion	vta_conversion
cost_per_vta_conversion	cost_per_vta_conversion
vta_registration	vta_registration
cost_per_vta_registration	cost_per_vta_registration
vta_purchase	vta_purchase
cost_per_vta_purchase	cost_per_vta_purchase
cta_app_install	cta_app_install
cta_conversion	cta_conversion
cost_per_cta_conversion	cost_per_cta_conversion
cta_registration	cta_registration
cost_per_cta_registration	cost_per_cta_registration
cta_purchase	cta_purchase
cost_per_cta_purchase	cost_per_cta_purchase
complete_payment_roas	complete_payment_roas
complete_payment	complete_payment
cost_per_complete_payment	cost_per_complete_payment
complete_payment_rate	complete_payment_rate
value_per_complete_payment	value_per_complete_payment
total_complete_payment_rate	total_complete_payment_rate
page_browse_view	page_browse_view
cost_per_page_browse_view	cost_per_page_browse_view
page_browse_view_rate	page_browse_view_rate
total_page_browse_view_value	total_page_browse_view_value
value_per_page_browse_view	value_per_page_browse_view
button_click	button_click
cost_per_button_click	cost_per_button_click
button_click_rate	button_click_rate
value_per_button_click	value_per_button_click
total_button_click_value	total_button_click_value
online_consult	online_consult
cost_per_online_consult	cost_per_online_consult
online_consult_rate	online_consult_rate
value_per_online_consult	value_per_online_consult
total_online_consult_value	total_online_consult_value
user_registration	user_registration
cost_per_user_registration	cost_per_user_registration
user_registration_rate	user_registration_rate
value_per_user_registration	value_per_user_registration
total_user_registration_value	total_user_registration_value
product_details_page_browse	product_details_page_browse
cost_per_product_details_page_browse	cost_per_product_details_page_browse
product_details_page_browse_rate	product_details_page_browse_rate
value_per_product_details_page_browse	value_per_product_details_page_browse
total_product_details_page_browse_value	total_product_details_page_browse_value
web_event_add_to_cart	web_event_add_to_cart
cost_per_web_event_add_to_cart	cost_per_web_event_add_to_cart
web_event_add_to_cart_rate	web_event_add_to_cart_rate
value_per_web_event_add_to_cart	value_per_web_event_add_to_cart
total_web_event_add_to_cart_value	total_web_event_add_to_cart_value
on_web_order	on_web_order
cost_per_on_web_order	cost_per_on_web_order
on_web_order_rate	on_web_order_rate
value_per_on_web_order	value_per_on_web_order
total_on_web_order_value	total_on_web_order_value
initiate_checkout	initiate_checkout
cost_per_initiate_checkout	cost_per_initiate_checkout
initiate_checkout_rate	initiate_checkout_rate
value_per_initiate_checkout	value_per_initiate_checkout
total_initiate_checkout_value	total_initiate_checkout_value
add_billing	add_billing
cost_per_add_billing	cost_per_add_billing
add_billing_rate	add_billing_rate
value_per_add_billing	value_per_add_billing
total_add_billing_value	total_add_billing_value
page_event_search	page_event_search
cost_per_page_event_search	cost_per_page_event_search
page_event_search_rate	page_event_search_rate
value_per_page_event_search	value_per_page_event_search
total_page_event_search_value	total_page_event_search_value
form	form
cost_per_form	cost_per_form
form_rate	form_rate
value_per_form	value_per_form
total_form_value	total_form_value
download_start	download_start
cost_per_download_start	cost_per_download_start
download_start_rate	download_start_rate
value_per_download_start	value_per_download_start
total_download_start_value	total_download_start_value
on_web_add_to_wishlist	on_web_add_to_wishlist
cost_per_on_web_add_to_wishlist	cost_per_on_web_add_to_wishlist
on_web_add_to_wishlist_per_click	on_web_add_to_wishlist_per_click
value_per_on_web_add_to_wishlist	value_per_on_web_add_to_wishlist
total_on_web_add_to_wishlist_value	total_on_web_add_to_wishlist_value
on_web_subscribe	on_web_subscribe
cost_per_on_web_subscribe	cost_per_on_web_subscribe
on_web_subscribe_per_click	on_web_subscribe_per_click
value_per_on_web_subscribe	value_per_on_web_subscribe
total_on_web_subscribe_value	total_on_web_subscribe_value
onsite_shopping_roas	onsite_shopping_roas
onsite_shopping	onsite_shopping
onsite_initiate_checkout_count	onsite_initiate_checkout_count
onsite_on_web_detail	onsite_on_web_detail
onsite_add_to_wishlist	onsite_add_to_wishlist
onsite_add_billing	onsite_add_billing
onsite_on_web_cart	onsite_on_web_cart
onsite_form	onsite_form
onsite_download_start	onsite_download_start
ix_page_view_count	ix_page_view_count
ix_button_click_count	ix_button_click_count
ix_product_click_count	ix_product_click_count

Ad Spend Auction Ad

• Endpoint: Reports

• Update Method: UPSERT

• Table Name: [tiktok.adspend_auction_ad]

JSON Element	Database Column
campaign_id	campaign_id
adgroup_id	adgroup_id
ad_id	ad_id
stat_time_day	_date
MD5(advertiser_id + adgroup_id + campaign_id + ad_id + stat_time_day)	__sync_key
metrics[]	All columns specified in Ad Spend Auction Metrics schema above

NOTE: There are two extractions being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables (tables ending in _stg) will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys.

Ad Spend Auction Ad Group

• Endpoint: Reports

• Update Method: UPSERT

• Table Name: [tiktok.adspend_auction_adgroup]

JSON Element	Database Column
campaign_id	campaign_id
adgroup_id	adgroup_id
stat_time_day	_date
MD5(advertiser_id + adgroup_id + campaign_id + stat_time_day)	__sync_key
metrics[]	All columns specified in Ad Spend Auction Metrics schema above

NOTE: There are two extractions being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables (tables ending in _stg) will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys.

Ad Spend Auction Campaign

• Endpoint: Reports

• Update Method: UPSERT

• Table Name: [tiktok.adspend_auction_campaign]

JSON Element	Database Column
campaign_id	campaign_id
stat_time_day	_date
MD5(advertiser_id + campaign_id + stat_time_day)	__sync_key
metrics[]	All columns specified in Ad Spend Auction Metrics schema above

NOTE: There are two extractions being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables (tables ending in _stg) will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys.

Ad Spend Reservation Metrics

• Endpoint: Reports

• Update Method: UPSERT

• Table Name: [tiktok.adspend_reservation_ad], [tiktok.adspend_reservation_adgroup], [tiktok.adspend_reservation_campaign]

The following metrics are extracted from the Reports API Endpoint and can be queried at the ad, ad group, and campaign level for all Ad Spend Auction tables. The metrics included are:

JSON Element	Database Column
campaign_name	campaign_name
adgroup_name	adgroup_name
ad_name	ad_name
spend	spend
impressions	impressions
clicks	clicks
ctr	ctr
reach	reach
cost_per_1000_reached	cost_per_1000_reached
frequency	frequency
currency	currency
video_play_actions	video_play_actions
video_watched_2s	video_watched_2s
video_watched_6s	video_watched_6s
video_views_p25	video_views_p25
video_views_p50	video_views_p50
video_views_p75	video_views_p75
video_views_p100	video_views_p100
average_video_play	average_video_play
average_video_play_per_user	average_video_play_per_user
likes	likes
comments	comments
shares	shares
profile_visits	profile_visits
follows	follows
clicks_on_music_disc	clicks_on_music_disc
clicks_on_hashtag_challenge	clicks_on_hashtag_challenge
engagements	engagements
engagement_rate	engagement_rate
skip_ad	skip_ad
interact_card_show_cnt	interact_card_show_cnt
interact_card_a_click_cnt	interact_card_a_click_cnt
interact_card_b_click_cnt	interact_card_b_click_cnt
vote_card_show_cnt	vote_card_show_cnt
vote_card_a_click_cnt	vote_card_a_click_cnt
vote_card_b_click_cnt	vote_card_b_click_cnt
vote_card_convert_click_cnt	vote_card_convert_click_cnt
redpacket_show_cnt	redpacket_show_cnt
redpacket_click_cnt	redpacket_click_cnt
image_card_show_cnt	image_card_show_cnt
image_card_click_cnt	image_card_click_cnt

NOTE: Daasity has currently disabled the endpoint for reservation reports. Please contact [email protected] to enable the endpoint.

Ad Spend Reservation Ad

• Endpoint: Reports

• Update Method: UPSERT

• Table Name: [tiktok.adspend_reservation_ad]

JSON Element	Database Column
campaign_id	campaign_id
adgroup_id	adgroup_id
ad_id	ad_id
stat_time_day	_date
MD5(advertiser_id + adgroup_id + campaign_id + ad_id + stat_time_day)	__sync_key
metrics[]	All columns specified in Ad Spend Reservation Metrics schema above

NOTE: Two extractions are being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables (tables ending in _stg) will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys.

NOTE: Daasity has currently disabled the endpoint for reservation reports. Please contact [email protected] to enable the endpoint.

Ad Spend Reservation Ad Group

• Endpoint: Reports

• Update Method: UPSERT

• Table Name: [tiktok.adspend_reservation_adgroup]

JSON Element	Database Column
campaign_id	campaign_id
adgroup_id	adgroup_id
stat_time_day	_date
MD5(advertiser_id + adgroup_id + campaign_id + stat_time_day)	__sync_key
metrics[]	All columns specified in Ad Spend Reservation Metrics schema above

NOTE: Two extractions are being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables (tables ending in _stg) will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys.

NOTE: Daasity has currently disabled the endpoint for reservation reports. Please contact [email protected] to enable the endpoint.

Ad Spend Reservation Campaign

• Endpoint: Reports

• Update Method: UPSERT

• Table Name: [tiktok.adspend_reservation_campaign]

JSON Element	Database Column
campaign_id	campaign_id
stat_time_day	_date
MD5(advertiser_id + campaign_id + stat_time_day)	__sync_key
metrics[]	All columns specified in Ad Spend Reservation Metrics schema above

NOTE: Two extractions are being made for this report, due to dimension limits within an extraction. The primary table will contain the full set of columns while their stage tables (tables ending in _stg) will have a subset of metrics. Stage tables are stitched together to complete the primary table, updating rows with matching sync keys.

NOTE: Daasity has currently disabled the endpoint for reservation reports. Please contact [email protected] to enable the endpoint.

Advertisers

• Endpoint: Advertisers

• Update Method: UPSERT

• Table Name: [tiktok.advertisers]

JSON Element	Database Column
integration_id	integration_id
advertiser_id	advertiser_id
name	name
address	address
company	company
contacter	contacter
country	country
currency	currency
description	description
email	email
brand	brand
industry	industry
language	language
license_no	license_no
license_url	license_url
license_province	license_province
license_city	license_city
cellphone_number	cellphone_number
rejection_reason	rejection_reason
role	role
status	status
telephone_number	telephone_number
timezone	timezone
display_timezone	display_timezone
balance	balance
create_time	create_time
owner_bc_id	owner_bc_id
promotion_center_city	promotion_center_city
promotion_center_province	promotion_center_province
promotion_area	promotion_area
MD5(advertiser_id)	__sync_key

Campaigns

• Endpoint: Campaigns

• Update Method: UPSERT

• Table Name: [tiktok.campaigns]

JSON Element	Database Column
app_id	app_id
campaign_id	campaign_id
campaign_name	campaign_name
campaign_type	campaign_type
advertiser_id	advertiser_id
budget	budget
budget_mode	budget_mode
secondary_status	secondary_status
operation_status	operation_status
objective	objective
objective_type	objective_type
bid_type	bid_type
deep_bid_type	deep_bid_type
roas_bid	roas_bid
license_province	is_new_structure
create_time	create_time
modify_time	modify_time
campaign_app_profile_page_state	campaign_app_profile_page_state
MD5(campaign_id + advertiser_id)	__sync_key