Tables
ERD
30 tables
Expand all
Collapse all
ad
43 columns
ad_image
2 columns
ad_group
70 columns
ad_group_age
3 columns
ad_group_audience
2 columns
ad_group_connection_type
3 columns
ad_group_device_model
2 columns
ad_group_excluded_audience
2 columns
ad_group_interest_category
2 columns
ad_group_interest_keyword
2 columns
ad_group_language
2 columns
ad_group_location
2 columns
ad_group_placement
3 columns
ad_group_split_test
2 columns
ad_group_targeting_expansion
2 columns
ad_age_gender_report
23 columns
campaign_language_report
23 columns
ad_language_report
22 columns
ad_group_hourly_report
46 columns
advertiser
22 columns
ad_country_report
22 columns
campaign_hourly_report
46 columns
campaign
20 columns
campaign_country_report
23 columns
campaign_platform_report
23 columns
campaign_daily_report
51 columns
ad_daily_report
51 columns
ad_group_daily_report
51 columns
ad_hourly_report
46 columns
campaign_age_gender_report
24 columns
Loading diagram…
ad
ad
id
string
ad_group_id
string
advertiser_id
string
campaign_id
string
card_id
string
dpa_video_tpl_id
string
identity_id
string
page_id
string
tiktok_item_id
string
video_id
string
ad_format
string
ad_name
string
ad_text
string
app_name
string
brand_safery_postbid_partner
string
branded_content_disabled
boolean
call_to_action
string
call_to_action_id
string
click_tracking_url
string
create_time
date
dark_post_status
string
display_name
string
dpa_fallback_type
string
dpa_open_url_type
string
fallback_type
string
identity_type
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
modify_time
date
open_url
string
open_url_type
string
playable_url
string
profile_image
string
promotional_music_disabled
boolean
status
string
opt_status
string
vast_moat
boolean
_weld_synced
date
ad_image
ad_id
string
image_id
string
ad_group
ad_group
id
string
advertiser_id
string
campaign_id
string
app_id
string
catalog_id
string
identity_id
string
pixel_id
string
product_set_id
string
store_id
string
adgroup_name
string
ad_app_profile_page_type
string
android_osv
string
app_download_url
string
audience_rule
string
audience_type
string
automated_targeting
boolean
bid
float
bid_type
string
billing_event
string
brand_safety
string
brand_safety_partner
string
budget_mode
string
budget
float
buy_impression
int
buy_reach
int
catalog_authorized_bc
string
conversion_bid
float
conversion_window
string
cpu_video_duration
string
creative_material_mode
string
daily_retention_ratio
float
dayparting
string
deep_bid_type
string
deep_cpabid
float
deep_external_action
string
dpa_retargeting_type
string
enable_inventory_filter
boolean
external_action
string
external_type
string
frequency
int
frequency_schedule
int
gender
string
identity_type
string
ios_osv
string
ios_quota_type
string
ios_target_device
string
is_comment_disable
boolean
is_hfss
boolean
is_new_structure
boolean
is_share_disable
boolean
operation_system
string
opt_status
string
optimize_goal
string
pacing
string
placement_type
string
promotion_website_type
string
rf_buy_type
string
rf_predict_cpr
double
rf_predict_frequency
double
roas_bid
float
schedule_start_time
string
schedule_end_time
string
schedule_type
string
skip_learning_phase
boolean
statistic_type
string
status
string
store_authorized_bc
string
targeting_expansion_enable
boolean
video_download
boolean
_weld_synced
date
ad_group_age
ad_group_id
string
index
int
age
string
ad_group_audience
ad_group_id
string
audience_id
string
ad_group_connection_type
ad_group_id
string
index
int
connection_type
string
ad_group_device_model
ad_group_id
string
device_model_id
string
ad_group_excluded_audience
ad_group_id
string
audience_id
string
ad_group_interest_category
ad_group_id
string
interest_category_id
string
ad_group_interest_keyword
ad_group_id
string
interest_keyword_id
string
ad_group_language
ad_group_id
string
language_id
string
ad_group_location
ad_group_id
string
location_id
string
ad_group_placement
ad_group_id
string
index
int
placement
string
ad_group_split_test
ad_group_id
string
split_test_ad_group_id
string
ad_group_targeting_expansion
ad_group_id
string
audience_id
string
ad_age_gender_report
advertiser_id
string
ad_id
string
age
string
clicks
int
conversion
int
conversion_rate
float
cost_per_conversion
float
cost_per_result
float
cpc
float
cpm
float
ctr
float
gender
string
impressions
int
real_time_conversion
int
real_time_conversion_rate
float
real_time_cost_per_result
float
real_time_result
int
real_time_result_rate
float
result
int
result_rate
float
spend
float
stat_time_day
string
_weld_synced
date
campaign_language_report
advertiser_id
string
campaign_id
string
clicks
int
conversion
int
conversion_rate
float
cost_per_conversion
float
cost_per_result
float
cpc
float
cpm
float
ctr
float
impressions
int
language
string
real_time_conversion
int
real_time_conversion_rate
float
real_time_cost_per_conversion
float
real_time_cost_per_result
float
real_time_result
int
real_time_result_rate
float
result
int
result_rate
float
spend
float
stat_time_day
string
_weld_synced
date
ad_language_report
advertiser_id
string
ad_id
string
clicks
int
conversion
int
conversion_rate
float
cost_per_conversion
float
cost_per_result
float
cpc
float
cpm
float
ctr
float
impressions
int
language
string
real_time_conversion
int
real_time_conversion_rate
float
real_time_cost_per_result
float
real_time_result
int
real_time_result_rate
float
result
int
result_rate
float
spend
float
stat_time_day
string
_weld_synced
date
ad_group_hourly_report
advertiser_id
string
ad_group_id
string
average_video_play
float
average_video_play_per_user
float
clicks
int
comments
int
conversion
int
conversion_rate
float
cost_per_1000_reached
float
cost_per_conversion
float
cost_per_result
float
cost_per_secondary_goal_result
float
cpc
float
cpm
float
ctr
float
follows
int
impressions
int
likes
int
profile_visits
int
profile_visits_rate
float
reach
int
real_time_conversion
int
real_time_conversion_rate
float
real_time_cost_per_result
float
real_time_result
int
real_time_result_rate
float
result
int
result_rate
float
sales_lead
int
secondary_goal_result
int
secondary_goal_result_rate
float
shares
int
spend
float
stat_time_hour
string
total_purchase
int
total_purchase_value
float
total_sales_lead
int
total_sales_lead_value
float
video_play_actions
int
video_views_p25
int
video_views_p50
int
video_views_p75
int
video_views_p100
int
video_watched_2s
int
video_watched_6s
int
_weld_synced
date
advertiser
id
string
address
string
balance
float
company
string
contacter
string
country
string
create_time
date
currency
string
description
string
email
string
industry
string
language
string
license_no
string
license_url
string
name
string
phone_number
string
reason
string
role
string
status
string
telephone
string
timezone
string
_weld_synced
date
ad_country_report
advertiser_id
string
ad_id
string
clicks
int
conversion
int
conversion_rate
float
cost_per_conversion
float
cost_per_result
float
country_code
string
cpc
float
cpm
float
ctr
float
impressions
int
real_time_conversion
int
real_time_conversion_rate
float
real_time_cost_per_result
float
real_time_result
int
real_time_result_rate
float
result
int
result_rate
float
spend
float
stat_time_day
string
_weld_synced
date
campaign_hourly_report
advertiser_id
string
campaign_id
string
average_video_play
float
average_video_play_per_user
float
clicks
int
comments
int
conversion
int
conversion_rate
float
cost_per_1000_reached
float
cost_per_conversion
float
cost_per_result
float
cost_per_secondary_goal_result
float
cpc
float
cpm
float
ctr
float
follows
int
impressions
int
likes
int
profile_visits
int
profile_visits_rate
float
reach
int
real_time_conversion
int
real_time_conversion_rate
float
real_time_cost_per_result
float
real_time_result
int
real_time_result_rate
float
result
int
result_rate
float
sales_lead
int
secondary_goal_result
int
secondary_goal_result_rate
float
shares
int
spend
float
stat_time_hour
string
total_purchase
int
total_purchase_value
float
total_sales_lead
int
total_sales_lead_value
float
video_play_actions
int
video_views_p25
int
video_views_p50
int
video_views_p75
int
video_views_p100
int
video_watched_2s
int
video_watched_6s
int
_weld_synced
date
campaign
id
string
advertiser_id
string
budget
float
budget_mode
string
campaign_name
string
campaign_type
string
create_time
date
is_new_structure
boolean
budget_optimize_on
boolean
modify_time
date
objective
string
campaign_product_source
string
postback_window_mode
string
app_id
string
rf_campaign_type
string
objective_type
string
opt_status
string
split_test_variable
string
status
string
_weld_synced
date
campaign_country_report
advertiser_id
string
campaign_id
string
clicks
int
conversion
int
conversion_rate
float
cost_per_conversion
float
cost_per_result
float
country_code
string
cpc
float
cpm
float
ctr
float
impressions
int
real_time_conversion
int
real_time_conversion_rate
float
real_time_cost_per_conversion
float
real_time_cost_per_result
float
real_time_result
int
real_time_result_rate
float
result
int
result_rate
float
spend
float
stat_time_day
string
_weld_synced
date
campaign_platform_report
advertiser_id
string
campaign_id
string
clicks
int
conversion
int
conversion_rate
float
cost_per_conversion
float
cost_per_result
float
cpc
float
cpm
float
ctr
float
impressions
int
platform
string
real_time_conversion
int
real_time_conversion_rate
float
real_time_cost_per_conversion
float
real_time_cost_per_result
float
real_time_result
int
real_time_result_rate
float
result
int
result_rate
float
spend
float
stat_time_day
string
_weld_synced
date
campaign_daily_report
advertiser_id
string
campaign_id
string
average_video_play
float
average_video_play_per_user
float
clicks
int
comments
int
conversion
int
conversion_rate
float
cost_per_1000_reached
float
cost_per_conversion
float
cost_per_result
float
cost_per_secondary_goal_result
float
cpc
float
cpm
float
ctr
float
follows
int
impressions
int
likes
int
profile_visits
int
profile_visits_rate
float
reach
int
real_time_conversion
int
real_time_conversion_rate
float
real_time_cost_per_result
float
real_time_result
int
real_time_result_rate
float
result
int
result_rate
float
sales_lead
int
secondary_goal_result
int
secondary_goal_result_rate
float
shares
int
skan_conversion
int
skan_cost_per_conversion
float
skan_sales_lead
int
skan_total_sales_lead
int
skan_total_sales_lead_value
float
spend
float
stat_time_day
string
total_purchase
int
total_purchase_value
float
total_sales_lead
int
total_sales_lead_value
float
video_play_actions
int
video_views_p25
int
video_views_p50
int
video_views_p75
int
video_views_p100
int
video_watched_2s
int
video_watched_6s
int
_weld_synced
date
ad_daily_report
advertiser_id
string
ad_id
string
average_video_play
float
average_video_play_per_user
float
clicks
int
comments
int
conversion
int
conversion_rate
float
cost_per_1000_reached
float
cost_per_conversion
float
cost_per_result
float
cost_per_secondary_goal_result
float
cpc
float
cpm
float
ctr
float
follows
int
impressions
int
likes
int
profile_visits
int
profile_visits_rate
float
reach
int
real_time_conversion
int
real_time_conversion_rate
float
real_time_cost_per_result
float
real_time_result
int
real_time_result_rate
float
result
int
result_rate
float
sales_lead
int
secondary_goal_result
int
secondary_goal_result_rate
float
shares
int
skan_conversion
int
skan_cost_per_conversion
float
skan_sales_lead
int
skan_total_sales_lead
int
skan_total_sales_lead_value
float
spend
float
stat_time_day
string
total_purchase
int
total_purchase_value
float
total_sales_lead
int
total_sales_lead_value
float
video_play_actions
int
video_views_p25
int
video_views_p50
int
video_views_p75
int
video_views_p100
int
video_watched_2s
int
video_watched_6s
int
_weld_synced
date
ad_group_daily_report
advertiser_id
string
ad_group_id
string
average_video_play
float
average_video_play_per_user
float
clicks
int
comments
int
conversion
int
conversion_rate
float
cost_per_1000_reached
float
cost_per_conversion
float
cost_per_result
float
cost_per_secondary_goal_result
float
cpc
float
cpm
float
ctr
float
follows
int
impressions
int
likes
int
profile_visits
int
profile_visits_rate
float
reach
int
real_time_conversion
int
real_time_conversion_rate
float
real_time_cost_per_result
float
real_time_result
int
real_time_result_rate
float
result
int
result_rate
float
sales_lead
int
secondary_goal_result
int
secondary_goal_result_rate
float
shares
int
skan_conversion
int
skan_cost_per_conversion
float
skan_sales_lead
int
skan_total_sales_lead
int
skan_total_sales_lead_value
float
spend
float
stat_time_day
string
total_purchase
int
total_purchase_value
float
total_sales_lead
int
total_sales_lead_value
float
video_play_actions
int
video_views_p25
int
video_views_p50
int
video_views_p75
int
video_views_p100
int
video_watched_2s
int
video_watched_6s
int
_weld_synced
date
ad_hourly_report
advertiser_id
string
ad_id
string
average_video_play
float
average_video_play_per_user
float
clicks
int
comments
int
conversion
int
conversion_rate
float
cost_per_1000_reached
float
cost_per_conversion
float
cost_per_result
float
cost_per_secondary_goal_result
float
cpc
float
cpm
float
ctr
float
follows
int
impressions
int
likes
int
profile_visits
int
profile_visits_rate
float
reach
int
real_time_conversion
int
real_time_conversion_rate
float
real_time_cost_per_result
float
real_time_result
int
real_time_result_rate
float
result
int
result_rate
float
sales_lead
int
secondary_goal_result
int
secondary_goal_result_rate
float
shares
int
spend
float
stat_time_hour
string
total_purchase
int
total_purchase_value
float
total_sales_lead
int
total_sales_lead_value
float
video_play_actions
int
video_views_p25
int
video_views_p50
int
video_views_p75
int
video_views_p100
int
video_watched_2s
int
video_watched_6s
int
_weld_synced
date
campaign_age_gender_report
advertiser_id
string
campaign_id
string
age
string
clicks
int
conversion
int
conversion_rate
float
cost_per_conversion
float
cost_per_result
float
cpc
float
cpm
float
ctr
float
gender
string
impressions
int
real_time_conversion
int
real_time_conversion_rate
float
real_time_cost_per_conversion
float
real_time_cost_per_result
float
real_time_result
int
real_time_result_rate
float
result
int
result_rate
float
spend
float
stat_time_day
string
_weld_synced
date
Table
Sub table
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.