TikTok Ads → Google BigQuery: схема данных

Данные TikTok Ads импортируются в 13 отдельных таблиц Google BigQuery.

advertisers

Filed Type
address STRING
balance NUMBER
company STRING
contacter STRING
country STRING
create_time INTEGER
currency STRING
description STRING
email STRING
id INTEGER
industry STRING
language STRING
license_no STRING
license_url STRING
name STRING
phonenumber STRING
promotion_area STRING
reason STRING
role STRING
status STRING
timezone STRING



advertiser_ids

Filed Type
advertiser_id INTEGER
advertiser_name STRING



ads

Filed Type
ad_format STRING
ad_id INTEGER
ad_name STRING
ad_text STRING
ad_texts ARRAY
adgroup_id INTEGER
adgroup_name STRING
advertiser_id INTEGER
app_name STRING
call_to_action STRING
call_to_action_id STRING
campaign_id INTEGER
campaign_name STRING
card_id INTEGER
click_tracking_url STRING
create_time STRING
disclaimer_clickable_texts OBJECT
disclaimer_clickable_texts.text STRING
disclaimer_clickable_texts.url STRING
disclaimer_text OBJECT
disclaimer_text.text STRING
disclaimer_type STRING
display_name STRING
dpa_fallback_type STRING
dpa_open_url_type STRING
dpa_video_tpl_id STRING
fallback_type STRING
image_ids ARRAY
image_mode STRING
impression_tracking_url STRING
is_aco BOOLEAN
is_creative_authorized BOOLEAN
is_new_structure BOOLEAN
item_duet_status STRING
item_stitch_status STRING
landing_page_url STRING
landing_page_urls ARRAY
modify_time STRING
open_url STRING
open_url_type STRING
opt_status STRING
page_id NUMBER
playable_url STRING
premium_badge_id STRING
profile_image STRING
promotional_music_disabled BOOLEAN
status STRING
tiktok_item_id STRING
vast_moat BOOLEAN
video_id STRING



ad_groups

Filed Type
action_categories ARRAY
action_days INTEGER
action_v2 ARRAY
adgroup_id INTEGER
adgroup_name STRING
advertiser_id INTEGER
age ARRAY
android_osv STRING
app_download_url STRING
app_id INTEGER
audience ARRAY
audience_rule OBJECT
audience_type STRING
bid NUMBER
bid_type STRING
billing_event STRING
brand_safety STRING
brand_safety_partner STRING
budget NUMBER
budget_mode STRING
buy_impression NUMBER
buy_reach NUMBER
campaign_id INTEGER
carriers ARRAY
carriers_v2 ARRAY
catalog_authorized_bc INTEGER
catalog_id INTEGER
connection_type ARRAY
conversion_bid NUMBER
conversion_window STRING
cpv_video_duration STRING
create_time STRING
creative_material_mode STRING
dayparting STRING
deep_bid_type STRING
deep_cpabid NUMBER
deep_external_action STRING
device_models ARRAY
device_price ARRAY
dpa_retargeting_type STRING
enable_inventory_filter BOOLEAN
exclude_custom_actions ARRAY
excluded_audience ARRAY
external_action STRING
external_type STRING
frequency INTEGER
frequency_schedule INTEGER
gender STRING
include_custom_actions ARRAY
interest_category_v2 ARRAY
interest_keywords ARRAY
ios_osv STRING
ios_quota_type STRING
ios_target_device STRING
is_comment_disable INTEGER
is_hfss BOOLEAN
is_new_structure BOOLEAN
languages ARRAY
location ARRAY
modify_time STRING
operation_system ARRAY
opt_status STRING
optimize_goal STRING
pacing STRING
package STRING
pangle_audience_package_exclude ARRAY
pangle_audience_package_include ARRAY
pangle_block_app_list_id ARRAY
pixel_id INTEGER
placement ARRAY
placement_type STRING
product_set_id INTEGER
promotion_website_type STRING
rf_buy_type STRING
rf_predict_cpr NUMBER
rf_predict_frequency NUMBER
roas_bid NUMBER
schedule_end_time STRING
schedule_start_time STRING
schedule_type STRING
skip_learning_phase INTEGER
split_test_adgroup_ids ARRAY
statistic_type STRING
status STRING
targeting_expansion OBJECT
targeting_expansion.enable_expansion BOOLEAN
targeting_expansion.expansion_types ARRAY
video_actions ARRAY
video_download STRING



campaigns

Filed Type
advertiser_id INTEGER
bid_type STRING
budget NUMBER
budget_mode STRING
budget_optimize_switch NUMBER
campaign_id INTEGER
campaign_name STRING
campaign_type STRING
create_time STRING
deep_bid_type STRING
is_new_structure BOOLEAN
modify_time STRING
objective STRING
objective_type STRING
opt_status STRING
optimize_goal STRING
split_test_variable STRING
status STRING



ads_reports

Filed Type
dimensions OBJECT
dimensions.ad_id INTEGER
dimensions.adgroup_id INTEGER
dimensions.advertiser_id INTEGER
dimensions.campaign_id INTEGER
dimensions.stat_time_day STRING
metrics OBJECT
metrics.ad_name STRING
metrics.ad_text STRING
metrics.adgroup_id INTEGER
metrics.adgroup_name STRING
metrics.campaign_id INTEGER
metrics.campaign_name STRING
metrics.cash_spend NUMBER
metrics.clicks INTEGER
metrics.conversion INTEGER
metrics.conversion_rate NUMBER
metrics.cost_per_1000_reached NUMBER
metrics.cost_per_conversion NUMBER
metrics.cost_per_result NUMBER
metrics.cost_per_secondary_goal_result NUMBER
metrics.cpc NUMBER
metrics.cpm NUMBER
metrics.ctr NUMBER
metrics.dpa_target_audience_type STRING
metrics.frequency NUMBER
metrics.impressions INTEGER
metrics.mobile_app_id STRING
metrics.placement STRING
metrics.promotion_type STRING
metrics.reach INTEGER
metrics.real_time_conversion INTEGER
metrics.real_time_conversion_rate NUMBER
metrics.real_time_cost_per_conversion NUMBER
metrics.real_time_cost_per_result NUMBER
metrics.real_time_result NUMBER
metrics.real_time_result_rate NUMBER
metrics.result NUMBER
metrics.result_rate NUMBER
metrics.secondary_goal_result NUMBER
metrics.secondary_goal_result_rate NUMBER
metrics.spend NUMBER
metrics.tt_app_id INTEGER
metrics.tt_app_name STRING
metrics.voucher_spend NUMBER



ad_groups_reports

Filed Type
dimensions OBJECT
dimensions.ad_id INTEGER
dimensions.adgroup_id INTEGER
dimensions.advertiser_id INTEGER
dimensions.campaign_id INTEGER
dimensions.stat_time_day STRING
metrics OBJECT
metrics.ad_name STRING
metrics.ad_text STRING
metrics.adgroup_id INTEGER
metrics.adgroup_name STRING
metrics.campaign_id INTEGER
metrics.campaign_name STRING
metrics.cash_spend NUMBER
metrics.clicks INTEGER
metrics.conversion INTEGER
metrics.conversion_rate NUMBER
metrics.cost_per_1000_reached NUMBER
metrics.cost_per_conversion NUMBER
metrics.cost_per_result NUMBER
metrics.cost_per_secondary_goal_result NUMBER
metrics.cpc NUMBER
metrics.cpm NUMBER
metrics.ctr NUMBER
metrics.dpa_target_audience_type STRING
metrics.frequency NUMBER
metrics.impressions INTEGER
metrics.mobile_app_id STRING
metrics.placement STRING
metrics.promotion_type STRING
metrics.reach INTEGER
metrics.real_time_conversion INTEGER
metrics.real_time_conversion_rate NUMBER
metrics.real_time_cost_per_conversion NUMBER
metrics.real_time_cost_per_result NUMBER
metrics.real_time_result NUMBER
metrics.real_time_result_rate NUMBER
metrics.result NUMBER
metrics.result_rate NUMBER
metrics.secondary_goal_result NUMBER
metrics.secondary_goal_result_rate NUMBER
metrics.spend NUMBER
metrics.tt_app_id INTEGER
metrics.tt_app_name STRING
metrics.voucher_spend NUMBER



campaigns_reports

Filed Type
dimensions OBJECT
dimensions.ad_id INTEGER
dimensions.adgroup_id INTEGER
dimensions.advertiser_id INTEGER
dimensions.campaign_id INTEGER
dimensions.stat_time_day STRING
metrics OBJECT
metrics.ad_name STRING
metrics.ad_text STRING
metrics.adgroup_id INTEGER
metrics.adgroup_name STRING
metrics.campaign_id INTEGER
metrics.campaign_name STRING
metrics.cash_spend NUMBER
metrics.clicks INTEGER
metrics.conversion INTEGER
metrics.conversion_rate NUMBER
metrics.cost_per_1000_reached NUMBER
metrics.cost_per_conversion NUMBER
metrics.cost_per_result NUMBER
metrics.cost_per_secondary_goal_result NUMBER
metrics.cpc NUMBER
metrics.cpm NUMBER
metrics.ctr NUMBER
metrics.dpa_target_audience_type STRING
metrics.frequency NUMBER
metrics.impressions INTEGER
metrics.mobile_app_id STRING
metrics.placement STRING
metrics.promotion_type STRING
metrics.reach INTEGER
metrics.real_time_conversion INTEGER
metrics.real_time_conversion_rate NUMBER
metrics.real_time_cost_per_conversion NUMBER
metrics.real_time_cost_per_result NUMBER
metrics.real_time_result NUMBER
metrics.real_time_result_rate NUMBER
metrics.result NUMBER
metrics.result_rate NUMBER
metrics.secondary_goal_result NUMBER
metrics.secondary_goal_result_rate NUMBER
metrics.spend NUMBER
metrics.tt_app_id INTEGER
metrics.tt_app_name STRING
metrics.voucher_spend NUMBER



ads_audience_reports

Filed Type
dimensions OBJECT
dimensions.ac STRING
dimensions.ad_id INTEGER
dimensions.adgroup_id INTEGER
dimensions.advertiser_id INTEGER
dimensions.age STRING
dimensions.campaign_id INTEGER
dimensions.country_code STRING
dimensions.gender STRING
dimensions.interest_category STRING
dimensions.language STRING
dimensions.placement STRING
dimensions.platform STRING
dimensions.stat_time_day STRING
metrics OBJECT
metrics.ad_name STRING
metrics.ad_text STRING
metrics.adgroup_id INTEGER
metrics.adgroup_name STRING
metrics.campaign_id INTEGER
metrics.campaign_name STRING
metrics.clicks INTEGER
metrics.conversion INTEGER
metrics.conversion_rate NUMBER
metrics.cost_per_1000_reached NUMBER
metrics.cost_per_conversion NUMBER
metrics.cost_per_result NUMBER
metrics.cpc NUMBER
metrics.cpm NUMBER
metrics.ctr NUMBER
metrics.dpa_target_audience_type STRING
metrics.impressions INTEGER
metrics.mobile_app_id INTEGER
metrics.placement STRING
metrics.promotion_type STRING
metrics.reach INTEGER
metrics.real_time_conversion INTEGER
metrics.real_time_conversion_rate NUMBER
metrics.real_time_cost_per_conversion NUMBER
metrics.real_time_cost_per_result NUMBER
metrics.real_time_result NUMBER
metrics.real_time_result_rate NUMBER
metrics.result NUMBER
metrics.result_rate NUMBER
metrics.spend NUMBER
metrics.tt_app_id INTEGER
metrics.tt_app_name STRING



ad_group_audience_reports

Filed Type
dimensions OBJECT
dimensions.ac STRING
dimensions.ad_id INTEGER
dimensions.adgroup_id INTEGER
dimensions.advertiser_id INTEGER
dimensions.age STRING
dimensions.campaign_id INTEGER
dimensions.country_code STRING
dimensions.gender STRING
dimensions.interest_category STRING
dimensions.language STRING
dimensions.placement STRING
dimensions.platform STRING
dimensions.stat_time_day STRING
metrics OBJECT
metrics.ad_name STRING
metrics.ad_text STRING
metrics.adgroup_id INTEGER
metrics.adgroup_name STRING
metrics.campaign_id INTEGER
metrics.campaign_name STRING
metrics.clicks INTEGER
metrics.conversion INTEGER
metrics.conversion_rate NUMBER
metrics.cost_per_1000_reached NUMBER
metrics.cost_per_conversion NUMBER
metrics.cost_per_result NUMBER
metrics.cpc NUMBER
metrics.cpm NUMBER
metrics.ctr NUMBER
metrics.dpa_target_audience_type STRING
metrics.impressions INTEGER
metrics.mobile_app_id INTEGER
metrics.placement STRING
metrics.promotion_type STRING
metrics.reach INTEGER
metrics.real_time_conversion INTEGER
metrics.real_time_conversion_rate NUMBER
metrics.real_time_cost_per_conversion NUMBER
metrics.real_time_cost_per_result NUMBER
metrics.real_time_result NUMBER
metrics.real_time_result_rate NUMBER
metrics.result NUMBER
metrics.result_rate NUMBER
metrics.spend NUMBER
metrics.tt_app_id INTEGER
metrics.tt_app_name STRING



campaigns_audience_reports_by_country

Filed Type
dimensions OBJECT
dimensions.ac STRING
dimensions.ad_id INTEGER
dimensions.adgroup_id INTEGER
dimensions.advertiser_id INTEGER
dimensions.age STRING
dimensions.campaign_id INTEGER
dimensions.country_code STRING
dimensions.gender STRING
dimensions.interest_category STRING
dimensions.language STRING
dimensions.placement STRING
dimensions.platform STRING
dimensions.stat_time_day STRING
metrics OBJECT
metrics.ad_name STRING
metrics.ad_text STRING
metrics.adgroup_id INTEGER
metrics.adgroup_name STRING
metrics.campaign_id INTEGER
metrics.campaign_name STRING
metrics.clicks INTEGER
metrics.conversion INTEGER
metrics.conversion_rate NUMBER
metrics.cost_per_1000_reached NUMBER
metrics.cost_per_conversion NUMBER
metrics.cost_per_result NUMBER
metrics.cpc NUMBER
metrics.cpm NUMBER
metrics.ctr NUMBER
metrics.dpa_target_audience_type STRING
metrics.impressions INTEGER
metrics.mobile_app_id INTEGER
metrics.placement STRING
metrics.promotion_type STRING
metrics.reach INTEGER
metrics.real_time_conversion INTEGER
metrics.real_time_conversion_rate NUMBER
metrics.real_time_cost_per_conversion NUMBER
metrics.real_time_cost_per_result NUMBER
metrics.real_time_result NUMBER
metrics.real_time_result_rate NUMBER
metrics.result NUMBER
metrics.result_rate NUMBER
metrics.spend NUMBER
metrics.tt_app_id INTEGER
metrics.tt_app_name STRING



advertisers_reports

Filed Type
dimensions OBJECT
dimensions.ad_id INTEGER
dimensions.adgroup_id INTEGER
dimensions.advertiser_id INTEGER
dimensions.campaign_id INTEGER
dimensions.stat_time_day STRING
metrics OBJECT
metrics.ad_name STRING
metrics.ad_text STRING
metrics.adgroup_id INTEGER
metrics.adgroup_name STRING
metrics.campaign_id INTEGER
metrics.campaign_name STRING
metrics.cash_spend NUMBER
metrics.clicks INTEGER
metrics.conversion INTEGER
metrics.conversion_rate NUMBER
metrics.cost_per_1000_reached NUMBER
metrics.cost_per_conversion NUMBER
metrics.cost_per_result NUMBER
metrics.cost_per_secondary_goal_result NUMBER
metrics.cpc NUMBER
metrics.cpm NUMBER
metrics.ctr NUMBER
metrics.dpa_target_audience_type STRING
metrics.frequency NUMBER
metrics.impressions INTEGER
metrics.mobile_app_id STRING
metrics.placement STRING
metrics.promotion_type STRING
metrics.reach INTEGER
metrics.real_time_conversion INTEGER
metrics.real_time_conversion_rate NUMBER
metrics.real_time_cost_per_conversion NUMBER
metrics.real_time_cost_per_result NUMBER
metrics.real_time_result NUMBER
metrics.real_time_result_rate NUMBER
metrics.result NUMBER
metrics.result_rate NUMBER
metrics.secondary_goal_result NUMBER
metrics.secondary_goal_result_rate NUMBER
metrics.spend NUMBER
metrics.tt_app_id INTEGER
metrics.tt_app_name STRING
metrics.voucher_spend NUMBER



advertisers_audience_reports

Filed Type
dimensions OBJECT
dimensions.ac STRING
dimensions.ad_id INTEGER
dimensions.adgroup_id INTEGER
dimensions.advertiser_id INTEGER
dimensions.age STRING
dimensions.campaign_id INTEGER
dimensions.country_code STRING
dimensions.gender STRING
dimensions.interest_category STRING
dimensions.language STRING
dimensions.placement STRING
dimensions.platform STRING
dimensions.stat_time_day STRING
metrics OBJECT
metrics.ad_name STRING
metrics.ad_text STRING
metrics.adgroup_id INTEGER
metrics.adgroup_name STRING
metrics.campaign_id INTEGER
metrics.campaign_name STRING
metrics.clicks INTEGER
metrics.conversion INTEGER
metrics.conversion_rate NUMBER
metrics.cost_per_1000_reached NUMBER
metrics.cost_per_conversion NUMBER
metrics.cost_per_result NUMBER
metrics.cpc NUMBER
metrics.cpm NUMBER
metrics.ctr NUMBER
metrics.dpa_target_audience_type STRING
metrics.impressions INTEGER
metrics.mobile_app_id INTEGER
metrics.placement STRING
metrics.promotion_type STRING
metrics.reach INTEGER
metrics.real_time_conversion INTEGER
metrics.real_time_conversion_rate NUMBER
metrics.real_time_cost_per_conversion NUMBER
metrics.real_time_cost_per_result NUMBER
metrics.real_time_result NUMBER
metrics.real_time_result_rate NUMBER
metrics.result NUMBER
metrics.result_rate NUMBER
metrics.spend NUMBER
metrics.tt_app_id INTEGER
metrics.tt_app_name STRING



Была ли эта статья полезной?
Пользователи, считающие этот материал полезным: 0 из 0
Еще есть вопросы? Отправить запрос

0 Комментарии

Войдите в службу, чтобы оставить комментарий.