Fivetran documentation

Search the docs

/

OpenAI Ads

Explore the interactive ERD

Table & Field Reference

ad_group_product_set_filter_value

Column	Type	Keys
`index`	Int	PK
`ad_group_id`	String	PKFK
`filter_index`	Int	PKFK
`product_feed_id`	String
`value`	String

ad_group_context_hint

Column	Type	Keys
`index`	Int	PK
`ad_group_id`	String	PKFK
`hint`	String

campaign_targeting_country

Column	Type	Keys
`index`	Int	PK
`campaign_id`	String	PKFK
`country_name`	String

ad_group

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`bidding_config_billing_event_type`	String
`bidding_config_max_bid_micros`	Long
`created_at`	Long
`description`	String
`name`	String
`product_set_product_feed_id`	String
`status`	String
`updated_at`	Long

ad_group_custom_audience_bid_multiplier

Column	Type	Keys
`index`	Int	PK
`ad_group_id`	String	PKFK
`bid_multiplier_micros`	Long
`custom_audience_id`	String

ad

Column	Type	Keys
`id`	String	PK
`ad_group_id`	String	FK
`created_at`	Long
`creative_body`	String
`creative_file_id`	String
`creative_image_url`	String
`creative_price`	String
`creative_target_url`	String
`creative_title`	String
`creative_type`	String
`name`	String
`review_body_reason`	String
`review_body_status`	String
`review_status`	String
`status`	String
`updated_at`	Long

campaign_custom_audience

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	PKFK
`is_excluded`	Boolean

campaign

Column	Type	Keys
`id`	String	PK
`ad_account_id`	String	FK
`bidding_type`	String
`budget_daily_spend_limit_micros`	Long
`budget_lifetime_spend_limit_micros`	Long
`created_at`	Long
`description`	String
`end_time`	Long
`mode`	String
`name`	String
`start_time`	Long
`status`	String
`updated_at`	Long

campaign_conversion_event_setting

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	PKFK

ad_group_product_set_filter

Column	Type	Keys
`index`	Int	PK
`ad_group_id`	String	PKFK
`field`	String
`operator`	String
`product_feed_id`	String

campaign_targeting_geo_location

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	PKFK
`country_code`	String
`name`	String
`region_code`	String
`type`	String

ad_report_daily

Column	Type	Keys
`date`	String	PK
`ad_id`	String	PKFK
`ad_account_id`	String	FK
`ad_group_id`	String	FK
`campaign_id`	String	FK
`clicks`	Long
`cpc`	Double
`cpm`	Double
`ctr`	Double
`end_time`	Long
`impressions`	Long
`spend`	Double
`start_time`	Long

ad_account

Column	Type	Keys
`id`	String	PK
`account_integrity_decision`	String
`account_integrity_reason`	String
`account_integrity_review_reason`	String
`account_integrity_review_status`	String
`account_integrity_status_updated_at`	String
`currency_code`	String
`name`	String
`preview_url`	String
`review_reason`	String
`review_status`	String
`status`	String
`timezone`	String
`url`	String