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

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

account

Название поля Тип поля
account_id STRING
campaign_types ARRAY
currency STRING
default_platform STRING
id INTEGER
is_active INTEGER
name STRING
partner_types ARRAY
time_zone_name STRING
type STRING

 

campaign

Название поля Тип поля
activity_schedule OBJECT
activity_schedule.mode STRING
activity_schedule.rules ARRAY
activity_schedule.time_zone STRING
advertiser_id STRING
approval_state STRING
audience_segments_multi_targeting OBJECT
audience_segments_multi_targeting.href STRING
audience_segments_multi_targeting.state STRING
audience_segments_multi_targeting.value STRING
auto_publisher_targeting OBJECT
auto_publisher_targeting.href STRING
auto_publisher_targeting.type STRING
auto_publisher_targeting.value ARRAY
bid_strategy STRING
bid_type STRING
branding_text STRING
browser_targeting OBJECT
browser_targeting.href STRING
browser_targeting.type STRING
browser_targeting.value ARRAY
campaign_groups STRING
campaign_profile STRING
city_targeting OBJECT
city_targeting.href STRING
city_targeting.type STRING
city_targeting.value ARRAY
comments STRING
connection_type_targeting OBJECT
connection_type_targeting.href STRING
connection_type_targeting.type STRING
connection_type_targeting.value ARRAY
contextual_segments_targeting OBJECT
contextual_segments_targeting.href STRING
contextual_segments_targeting.state STRING
contextual_segments_targeting.value STRING
contextual_targeting OBJECT
contextual_targeting.href STRING
contextual_targeting.type STRING
contextual_targeting.value ARRAY
country_targeting OBJECT
country_targeting.href STRING
country_targeting.type STRING
country_targeting.value ARRAY
cpa_goal NUMBER
cpc NUMBER
custom_audience_targeting OBJECT
custom_audience_targeting.href STRING
custom_audience_targeting.state STRING
custom_audience_targeting.value STRING
daily_ad_delivery_model STRING
daily_cap NUMBER
dma_country_targeting OBJECT
dma_country_targeting.href STRING
dma_country_targeting.type STRING
dma_country_targeting.value ARRAY
end_date STRING
end_date_in_utc STRING
external_brand_safety OBJECT
external_brand_safety.type STRING
external_brand_safety.values ARRAY
id STRING
is_active INTEGER
lookalike_audience_targeting OBJECT
OBJECT STRING
lookalike_audience_targeting.state STRING
lookalike_audience_targeting.value STRING
marketing_objective STRING
marking_label_multi_targeting OBJECT
marking_label_multi_targeting.href STRING
marking_label_multi_targeting.state STRING
marking_label_multi_targeting.value STRING
min_expected_conversions_for_cpa_goal STRING
name STRING
os_targeting OBJECT
os_targeting.href STRING
os_targeting.type STRING
os_targeting.value ARRAY
platform_targeting OBJECT
platform_targeting.href STRING
platform_targeting.type STRING
platform_targeting.value ARRAY
policy_review OBJECT
policy_review.reject_reason STRING
postal_code_targeting OBJECT
postal_code_targeting.href STRING
postal_code_targeting.type STRING
postal_code_targeting.value STRING
pricing_model STRING
publisher_bid_modifier OBJECT
publisher_bid_modifier.values ARRAY
publisher_bid_strategy_modifiers OBJECT
publisher_bid_strategy_modifiers.values ARRAY
publisher_targeting OBJECT
publisher_targeting.href STRING
publisher_targeting.type STRING
publisher_targeting.value ARRAY
region_country_targeting OBJECT
region_country_targeting.href STRING
region_country_targeting.type STRING
region_country_targeting.value ARRAY
safety_rating STRING
spending_limit NUMBER
spending_limit_model STRING
spent NUMBER
start_date STRING
start_date_in_utc STRING
status STRING
sub_country_targeting OBJECT
sub_country_targeting.href STRING
sub_country_targeting.type STRING
sub_country_targeting.value ARRAY
tracking_code STRING
traffic_allocation_ab_test_end_date STRING
traffic_allocation_mode STRING
type STRING
verification_pixel STRING
viewability_tag STRING

 

campaign_item

Название поля Тип поля
approval_state STRING
campaign_id STRING
creative_focus OBJECT
creative_focus.coordinates OBJECT
creative_focus.coordinates.x INTEGER
creative_focus.coordinates.y INTEGER
creative_focus.type STRING
cta OBJECT
cta.cta_type STRING
description STRING
id STRING
is_active BOOLEAN
policy_review OBJECT
policy_review.reject_reason STRING
policy_review.status_reason STRING
status STRING
thumbnail_url STRING
title STRING
type STRING
url STRING
verification_pixel STRING
viewability_tag STRING

 

motion_ads

Название поля Тип поля
approval_state STRING
campaign_id STRING
fallback_url STRING
gif_url STRING
id STRING
is_active BOOLEAN
policy_review OBJECT
policy_review.reject_reason STRING
status STRING
title STRING
url STRING
video_url STRING

 

campaign_site_day_report

Название поля Тип поля
campaign STRING
campaign_name STRING
campaigns_num INTEGER
clicks INTEGER
conversions_value NUMBER
cpa NUMBER
cpa_actions_num INTEGER
cpa_actions_num_from_clicks INTEGER
cpa_actions_num_from_views INTEGER
cpa_clicks NUMBER
cpa_conversion_rate NUMBER
cpa_conversion_rate_clicks NUMBER
cpa_conversion_rate_views NUMBER
cpa_views NUMBER
cpc NUMBER
cpm NUMBER
ctr NUMBER
currency STRING
date STRING
impressions INTEGER
roas NUMBER
spent NUMBER
vcpm NUMBER
vctr NUMBER
visible_impressions INTEGER

 

country_report

Название поля Тип поля
campaign_id STRING
campaigns_num INTEGER
clicks INTEGER
conversions_value NUMBER
country STRING
country_name STRING
cpa NUMBER
cpa_actions_num INTEGER
cpa_actions_num_from_clicks INTEGER
cpa_actions_num_from_views INTEGER
cpa_clicks NUMBER
cpa_conversion_rate NUMBER
cpa_conversion_rate_clicks NUMBER
cpa_conversion_rate_views NUMBER
cpa_views NUMBER
cpc NUMBER
cpm NUMBER
ctr NUMBER
currency STRING
date STRING
impressions INTEGER
roas NUMBER
spent NUMBER
vcpm NUMBER
vctr NUMBER
visible_impressions INTEGER

 

platform_report

Название поля Тип поля
campaign_id STRING
campaigns_num INTEGER
clicks INTEGER
conversions_value NUMBER
cpa NUMBER
cpa_actions_num INTEGER
cpa_actions_num_from_clicks INTEGER
cpa_actions_num_from_views INTEGER
cpa_clicks NUMBER
cpa_conversion_rate NUMBER
cpa_conversion_rate_clicks NUMBER
cpa_conversion_rate_views NUMBER
cpa_views NUMBER
cpc NUMBER
cpm NUMBER
ctr NUMBER
currency STRING
date STRING
impressions INTEGER
platform STRING
platform_name STRING
roas NUMBER
spent NUMBER
vcpm NUMBER
vctr NUMBER
visible_impressions INTEGER

 

top_campaign_content_report

Название поля Тип поля
actions INTEGER
actions_num_from_clicks INTEGER
actions_num_from_views INTEGER
campaign STRING
campaign_name STRING
clicks INTEGER
content_provider STRING
content_provider_name STRING
conversions_value NUMBER
cpa NUMBER
cpa_clicks NUMBER
cpa_views NUMBER
cpc NUMBER
cpm NUMBER
create_time STRING
ctr NUMBER
currency STRING
cvr NUMBER
cvr_clicks NUMBER
cvr_views NUMBER
description STRING
impressions INTEGER
item STRING
item_name STRING
learning_display_status STRING
old_item_version_id STRING
roas NUMBER
spent NUMBER
thumbnail_url STRING
url STRING
vcpm NUMBER
vctr NUMBER
visible_impressions INTEGER

 

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

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

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