Integration: TikTok

This article 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.

Key Topics

Click on the links below to take you to the section where you can learn more about this Integration.

Integration Availability

This integration is available for:

  • Pro V2

NOTE: You are considered V2 if...

  • You are a Growth customer
  • Your account says Pro V2 in the Daasity App

Not sure? Reach out to Support@Daasity.com 

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: 

Entity Relationship Diagram (ERD)

The embedded diagram houses the ERD for the Daasity TikTok integration illustrating the different tables and keys to join across tables.  Hover over the embedded diagram to reveal controls to zoom and scroll.

TikTok Schema

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

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 Support@Daasity.com  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: 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.

NOTE: Daasity has currently disabled the endpoint for reservation reports.  Please contact Support@Daasity.com  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: 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.

NOTE: Daasity has currently disabled the endpoint for reservation reports.  Please contact Support@Daasity.com  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: 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.

NOTE: Daasity has currently disabled the endpoint for reservation reports.  Please contact Support@Daasity.com  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

 

Related Resources

August 15, 2022