Fivetran documentation

Search the docs

/

Reddit Ads

Explore the interactive ERD

Table & Field Reference

geolocation

Column	Type	Keys
`id`	String	PK
`country`	String
`dma`	Long
`name`	String
`postal_code`	String
`region`	String

targeting_community

Column	Type	Keys
`ad_group_id`	String	PKFK
`community_id`	String	PKFK
`excluded`	Boolean

targeting_interest

Column	Type	Keys
`ad_group_id`	String	PKFK
`interest_id`	String	PKFK
`excluded`	Boolean

community

Column	Type	Keys
`id`	String	PK
`daily_impressions`	Long
`description`	String
`icon_url`	String
`name`	String
`subscriber_count`	Long

ad_group

Column	Type	Keys
`id`	String	PK
`account_id`	String	PKFK
`campaign_id`	String	FK
`bid_strategy`	String
`bid_value`	Long
`configured_status`	String
`effective_status`	String
`end_time`	Instant
`expand_targeting`	Boolean
`goal_type`	String
`goal_value`	Long
`is_processing`	Boolean
`name`	String
`optimization_goal`	String
`start_time`	Instant

third_party_tracker

Column	Type	Keys
`index`	Int	PK
`ad_id`	String	PKFK
`value`	String

targeting_custom_audience

Column	Type	Keys
`ad_group_id`	String	PKFK
`custom_audience_id`	String	PKFK
`excluded`	Boolean

targeting_keyword

Column	Type	Keys
`keyword`	String	PK
`ad_group_id`	String	PKFK
`excluded`	Boolean

targeting_geolocation

Column	Type	Keys
`ad_group_id`	String	PKFK
`geolocation_id`	String	PKFK
`excluded`	Boolean

ad

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`ad_group_id`	String	FK
`campaign_id`	String	FK
`click_url`	String
`configured_status`	String
`effective_status`	String
`is_processing`	Boolean
`name`	String
`post_id`	String
`post_url`	String
`preview_expiry`	String
`preview_url`	String
`rejection_reason`	String
`search_term`	String

targeting_device

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_group_id`	String	FK
`label_map`	Json
`max_version`	String
`min_version`	String
`os`	String
`type`	String

engagement_audience_campaign

Column	Type	Keys
`campaign_id`	String	PKFK
`custom_audience_id`	String	PKFK

time_zone

Column	Type	Keys
`id`	String	PK
`code`	String
`dst_offset`	Long
`is_dst_active`	Boolean
`name`	String
`offset`	Long

business_account

Column	Type	Keys
`id`	String	PK
`business_id`	String	FK
`time_zone_id`	String	FK
`admin_approval`	String
`app_attribution_type`	String
`app_click_attribution_window`	String
`app_view_attribution_window`	String
`attribution_type`	String
`click_attribution_window`	String
`created_at`	Instant
`currency`	String
`modified_at`	Instant
`name`	String
`primary_contact_member_id`	String
`spend_cap_type`	String
`suspension_reason`	String
`type`	String
`view_attribution_window`	String

custom_audience_history

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`created_at`	Instant
`customer_list_config_external_id`	String
`customer_list_config_origin`	String
`engagement_audience_configlookback_window_days`	Long
`lookalike_configsource_audience_id`	String
`name`	String
`pixel_audience_configlookback_window_days`	String
`size_range_lower`	Long
`size_range_upper`	Long
`status`	String
`type`	String
`updated_at`	Instant

schedule

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_group_id`	String	FK
`end_day`	Long
`end_hour`	Long
`start_day`	Long
`start_hour`	Long

click_url_query_parameter

Column	Type	Keys
`index`	Int	PK
`ad_id`	String	PKFK
`name`	String
`value`	String

engagement_audience_tracking_type

Column	Type	Keys
`index`	Int	PK
`custom_audience_id`	String	PKFK
`value`	String

targeting_placement

Column	Type	Keys
`location`	String	PK
`ad_group_id`	String	PKFK

pixel_audience_targeting

Column	Type	Keys
`index`	Int	PK
`custom_audience_id`	String	PKFK
`value`	String

campaign

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`configured_status`	String
`effective_status`	String
`funding_instrument_id`	String
`is_processing`	Boolean
`name`	String
`objective`	String

pixel_partner_reference

Column	Type	Keys
`index`	Int	PK
`account_id`	String	PKFK
`value`	String

interest

Column	Type	Keys
`id`	String	PK
`category`	String
`name`	String

click_tracker

Column	Type	Keys
`index`	Int	PK
`ad_id`	String	PKFK
`value`	String

pixel_audience_custom_targeting

Column	Type	Keys
`index`	Int	PK
`custom_audience_id`	String	PKFK
`value`	String

business

Column	Type	Keys
`id`	String	PK
`agency_affiliated`	Boolean
`country`	String
`created_at`	Instant
`creator_id`	String
`industry`	String
`modified_at`	Instant
`name`	String
`phone`	String
`website_url`	String