Tiktok Ads schema and ERD

41 tables

Loading diagram…

ad_group

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_image

ad_id

string

image_id

string

_weld_synced

date

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

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

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

ad_group

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

adgroup_age

ad_group_id

string

index

int

age

string

_weld_synced

date

ad_group_audience

ad_group_id

string

audience_id

string

_weld_synced

date

ad_group_connection_type

ad_group_id

string

index

int

connection_type

string

_weld_synced

date

ad_group_device_model

ad_group_id

string

device_model_id

string

_weld_synced

date

ad_group_excluded_audience

ad_group_id

string

audience_id

string

_weld_synced

date

ad_group_interest_category

ad_group_id

string

interest_category_id

string

_weld_synced

date

ad_group_interest_keyword

ad_group_id

string

interest_keyword_id

string

_weld_synced

date

ad_group_language

ad_group_id

string

language_id

string

_weld_synced

date

ad_group_location

ad_group_id

string

location_id

string

_weld_synced

date

ad_group_placement

ad_group_id

string

index

int

placement

string

_weld_synced

date

ad_group_split_test

ad_group_id

string

split_test_ad_group_id

string

_weld_synced

date

ad_group_targeting_expansion

ad_group_id

string

audience_id

string

_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

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

ad_group_monthly_report

advertiser_id

string

ad_group_id

string

start_date

string

end_date

string

average_video_play

float

average_video_play_per_user

float

clicks

int

comments

int

conversion

int

conversion_rate

float

ad_group_weekly_report

advertiser_id

string

ad_group_id

string

start_date

string

end_date

string

average_video_play

float

average_video_play_per_user

float

clicks

int

comments

int

conversion

int

conversion_rate

float

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

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

ad_monthly_report

advertiser_id

string

ad_id

string

start_date

string

end_date

string

average_video_play

float

average_video_play_per_user

float

clicks

int

comments

int

conversion

int

conversion_rate

float

ad_weekly_report

advertiser_id

string

ad_id

string

start_date

string

end_date

string

average_video_play

float

average_video_play_per_user

float

clicks

int

comments

int

conversion

int

conversion_rate

float

advertiser

string

address

string

balance

float

company

string

contacter

string

country

string

create_time

date

currency

string

description

string

campaign

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

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

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

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

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

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

campaign_monthly_report

advertiser_id

string

campaign_id

string

start_date

string

end_date

string

average_video_play

float

average_video_play_per_user

float

clicks

int

comments

int

conversion

int

conversion_rate

float

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

campaign_weekly_report

advertiser_id

string

campaign_id

string

start_date

string

end_date

string

average_video_play

float

average_video_play_per_user

float

clicks

int

comments

int

conversion

int

conversion_rate

float

country_report_monthly

advertiser_id

string

country_code

string

start_date

string

end_date

string

currency

string

spend

float

cpc

float

cpm

float

impressions

int

country_report_weekly

advertiser_id

string

country_code

string

start_date

string

end_date

string

currency

string

spend

float

cpc

float

cpm

float

impressions

int

gmv_max_campaign

advertiser_id

string

campaign_id

string

campaign_name

string

operation_status

string

create_time

date

modify_time

date

objective_type

string

secondary_status

string

roi_protection_compensation_status

string

_weld_synced

date

gmv_max_campaign_daily_detailed_report

campaign_id

string

advertiser_id

string

stat_time_day

string

bid_type

string

campaign_name

string

cost

double

cost_per_order

double

gross_revenue

double

max_delivery_budget

double

net_cost

double

gmv_max_creatives_daily_detailed_report

campaign_id

string

advertiser_id

string

item_group_id

string

item_id

string

ad_click_rate

double

ad_conversion_rate

double

ad_video_view_rate_2_s

double

ad_video_view_rate_6_s

double

ad_video_view_rate_p_100

double

ad_video_view_rate_p_25

double