Fivetran documentation

Search the docs

/

Taboola

Explore the interactive ERD

Table & Field Reference

campaign

Column	Type	Keys
`id`	Long	PK
`account_id`	Long	PKFK
`approval_state`	String
`bid_strategy`	String
`branding_text`	String
`campaign_item_type`	String
`campaign_profile`	String
`cpa_goal`	Double
`cpc`	Double
`daily_ad_delivery_model`	String
`daily_cap`	Double
`end_date`	LocalDate
`end_date_in_utc`	String
`is_active`	Boolean
`is_spend_guard_active`	String
`learning_state`	String
`marketing_objective`	String
`min_expected_conversions_for_cpa_goal`	String
`name`	String
`pricing_model`	String
`roas_goal`	Double
`safety_rating`	String
`spending_limit`	Double
`spending_limit_model`	String
`spent`	Double
`start_date`	LocalDate
`start_date_in_utc`	String
`status`	String
`target_cpa`	Double
`tracking_code`	String
`traffic_allocation_ab_test_end_date`	LocalDate
`traffic_allocation_mode`	String
`type`	String

content_provider_platform_report

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Long	FK
`content_provider_id`	Long	FK
`campaigns_num`	Int
`clicks`	Int
`content_provider`	String
`content_provider_name`	String
`conversions_value`	Double
`cpa`	Double
`cpa_actions_num`	Int
`cpa_actions_num_from_clicks`	Int
`cpa_actions_num_from_views`	Int
`cpa_clicks`	Double
`cpa_conversion_rate`	Double
`cpa_conversion_rate_clicks`	Double
`cpa_conversion_rate_views`	Double
`cpa_views`	Double
`cpc`	Double
`cpm`	Double
`ctr`	Double
`currency`	String
`date`	LocalDate
`impressions`	Long
`platform`	String
`roas`	Double
`spent`	Double
`timezone`	String
`vcpm`	Double
`vctr`	Double
`visible_impressions`	Int

targeting_sub_country

Column	Type	Keys
`index`	Int	PK
`campaign_id`	Long	PKFK
`type`	String
`value`	String

group

Column	Type	Keys
`index`	Int	PK
`account_id`	Long	PKFK
`id`	String

platform_report

Column	Type	Keys
`_fivetran_id`	String	PK
`campaign_id`	Long	FK
`clicks`	Int
`conversions_value`	Double
`cpa`	Double
`cpa_actions_num`	Int
`cpa_actions_num_from_clicks`	Int
`cpa_actions_num_from_views`	Int
`cpa_clicks`	Double
`cpa_conversion_rate`	Double
`cpa_conversion_rate_clicks`	Double
`cpa_conversion_rate_views`	Double
`cpa_views`	Double
`cpc`	Double
`cpm`	Double
`ctr`	Double
`currency`	String
`date`	LocalDate
`impressions`	Long
`platform`	String
`platform_name`	String
`roas`	Double
`spent`	Double
`timezone`	String
`vcpm`	Double
`vctr`	Double
`visible_impressions`	Int

targeting_platform

Column	Type	Keys
`index`	Int	PK
`campaign_id`	Long	PKFK
`type`	String
`value`	String

targeting_publisher

Column	Type	Keys
`index`	Int	PK
`campaign_id`	Long	PKFK
`type`	String
`value`	String

top_campaign_content_report

Column	Type	Keys
`_fivetran_id`	String	PK
`campaign_id`	Long	FK
`item`	Long	FK
`actions`	Double
`actions_num_from_clicks`	Int
`actions_num_from_views`	Int
`clicks`	Int
`conversions_value`	Double
`cpa`	Double
`cpa_clicks`	Double
`cpa_views`	Double
`cpc`	Double
`cpm`	Double
`create_time`	LocalDateTime
`ctr`	Double
`currency`	String
`cvr`	Double
`cvr_clicks`	Double
`cvr_views`	Double
`date`	LocalDate
`description`	String
`impressions`	Long
`item_name`	String
`learning_display_status`	String
`old_item_version_id`	String
`roas`	Double
`spent`	Double
`thumbnail_url`	String
`timezone`	String
`url`	String
`vcpm`	Double
`vctr`	Double
`visible_impressions`	Int

publisher_bid_modifier

Column	Type	Keys
`index`	Int	PK
`campaign_id`	Long	PKFK
`cpc_modification`	Double
`target`	String

targeting_os

Column	Type	Keys
`index`	Int	PK
`campaign_id`	Long	PKFK
`os_family`	String
`sub_categories`	String
`type`	String

targeting_contextual

Column	Type	Keys
`index`	Int	PK
`campaign_id`	Long	PKFK
`type`	String
`value`	String

campaign_item

Column	Type	Keys
`id`	Long	PK
`campaign_id`	Long	FK
`approval_state`	String
`cta_type`	String
`is_active`	Boolean
`status`	String
`thumbnail_url`	String
`title`	String
`type`	String
`url`	String

campaign_site_day_report

Column	Type	Keys
`_fivetran_id`	String	PK
`campaign_id`	Long	FK
`blocking_level`	String
`campaign_name`	String
`clicks`	Int
`conversions_value`	Double
`cpa`	Double
`cpa_actions_num`	Int
`cpa_actions_num_from_clicks`	Int
`cpa_actions_num_from_views`	Int
`cpa_clicks`	Double
`cpa_conversion_rate`	Double
`cpa_conversion_rate_clicks`	Double
`cpa_conversion_rate_views`	Double
`cpa_views`	Double
`cpc`	Double
`cpm`	Double
`ctr`	Double
`currency`	String
`date_time`	Instant
`impressions`	Long
`roas`	Double
`site`	String
`site_name`	String
`spent`	Double
`timezone`	String
`vcpm`	Double
`vctr`	Double
`visible_impressions`	Int

country_report

Column	Type	Keys
`_fivetran_id`	String	PK
`campaign_id`	Long	FK
`clicks`	Int
`conversions_value`	Double
`country`	String
`country_name`	String
`cpa`	Double
`cpa_actions_num`	Int
`cpa_actions_num_from_clicks`	Int
`cpa_actions_num_from_views`	Int
`cpa_clicks`	Double
`cpa_conversion_rate`	Double
`cpa_conversion_rate_clicks`	Double
`cpa_conversion_rate_views`	Double
`cpa_views`	Double
`cpc`	Double
`cpm`	Double
`ctr`	Double
`currency`	String
`date`	LocalDate
`impressions`	Long
`roas`	Double
`spent`	Double
`timezone`	String
`vcpm`	Double
`vctr`	Double
`visible_impressions`	Int

campaign_type

Column	Type	Keys
`index`	Int	PK
`account_id`	Long	PKFK
`type`	String

account

Column	Type	Keys
`id`	Long	PK
`account_id`	String
`country`	String
`currency`	String
`default_platform`	String
`is_active`	Boolean
`language`	String
`name`	String
`parent_network`	String
`timezone`	String
`type`	String

comment

Column	Type	Keys
`campaign_id`	Long	PK
`index`	Int	PK
`account_id`	Long	PKFK
`comment`	String

contained_account

Column	Type	Keys
`index`	Int	PK
`account_id`	Long	PKFK
`id`	String

targeting_postal_code

Column	Type	Keys
`index`	Int	PK
`campaign_id`	Long	PKFK
`type`	String
`value`	String

partner_type

Column	Type	Keys
`index`	Int	PK
`account_id`	Long	PKFK
`type`	String

content_provider_country_report

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Long	FK
`content_provider_id`	Long	FK
`campaigns_num`	Int
`clicks`	Int
`content_provider`	String
`content_provider_name`	String
`conversions_value`	Double
`country_name`	String
`country_value`	String
`cpa`	Double
`cpa_actions_num`	Int
`cpa_actions_num_from_clicks`	Int
`cpa_actions_num_from_views`	Int
`cpa_clicks`	Double
`cpa_conversion_rate`	Double
`cpa_conversion_rate_clicks`	Double
`cpa_conversion_rate_views`	Double
`cpa_views`	Double
`cpc`	Double
`cpm`	Double
`ctr`	Double
`currency`	String
`date`	LocalDate
`impressions`	Long
`roas`	Double
`spent`	Double
`timezone`	String
`vcpm`	Double
`vctr`	Double
`visible_impressions`	Int

targeting_country

Column	Type	Keys
`index`	Int	PK
`campaign_id`	Long	PKFK
`type`	String
`value`	String

targeting_audience_segment

Column	Type	Keys
`index`	Int	PK
`campaign_id`	Long	PKFK
`state`	String
`value`	String