Taboola → Google BigQuery: data schema – OWOX Help Center

Taboola data is imported to 8 separate Google BigQuery tables.

account

Filed	Type
`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

Filed	Type
`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

Filed	Type
`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

Filed	Type
`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

Filed	Type
`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

Filed	Type
`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

Filed	Type
`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

Filed	Type
`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

account

campaign

campaign_item

motion_ads

campaign_site_day_report

country_report

platform_report

top_campaign_content_report

0 Comments