Fivetran documentation

Search the docs

/

Snapchat Ads

Explore the interactive ERD

Table & Field Reference

funding_source_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`organization_id`	String	FK
`available_credit_micro`	Long
`budget_spent_micro`	Long
`card_type`	String
`created_at`	Instant
`currency`	String
`daily_spend_limit_currency`	String
`daily_spend_limit_micro`	Long
`email`	String
`end_date`	LocalDate
`expiration_month`	Short
`expiration_year`	Short
`last_4_digits_of_card`	Short
`name`	String
`start_date`	LocalDate
`status`	String
`total_budget_micro`	Long
`type`	String
`value_micro`	Long

ad_squad_segment_history

Column	Type	Keys
`ad_squad_id`	String	PKFK
`ad_squad_updated_at`	Instant	PKFK
`audience_segment_id`	String	PKFK
`operation`	String

campaign_delivery_status

Column	Type	Keys
`status`	String	PK
`campaign_id`	String	PKFK
`campaign_updated_at`	Instant	PKFK

ad_squad_placement_v_2_snapchat_position

Column	Type	Keys
`snapchat_position`	String	PK
`ad_squad_id`	String	PKFK
`ad_squad_updated_at`	Instant	PKFK

ad_delivery_status

Column	Type	Keys
`status`	String	PK
`ad_id`	String	PKFK
`ad_updated_at`	Instant	PKFK

targeting_interest_history

Column	Type	Keys
`index`	Long	PK
`ad_squad_id`	String	PKFK
`ad_squad_updated_at`	Instant	PKFK
`category_id`	Json

targeting_demographic_history

Column	Type	Keys
`index`	Long	PK
`ad_squad_id`	String	PKFK
`ad_squad_updated_at`	Instant	PKFK
`advanced_demographics`	Json
`age_groups`	Json
`gender`	String
`languages`	Json
`min_age`	String
`operation`	String

targeting_device_history

Column	Type	Keys
`index`	Long	PK
`ad_squad_id`	String	PKFK
`ad_squad_updated_at`	Instant	PKFK
`connection_type`	String
`os_type`	String

ad_account_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`organization_id`	String	FK
`advertiser`	String
`agency_representing_client`	Boolean
`billing_type`	String
`client_paying_invoices`	Boolean
`created_at`	Instant
`currency`	String
`lifetime_spend_cap_micro`	Long
`name`	String
`regulations_restricted_delivery_signals`	Boolean
`status`	String
`timezone`	String
`type`	String
`agency_client_metadata_`

campaign_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`ad_account_id`	String	FK
`buy_model`	String
`created_at`	Instant
`daily_budget_micro`	Long
`end_time`	Instant
`lifetime_spend_cap_micro`	Long
`name`	String
`objective`	String
`objective_v_2_type`	String
`promotion_type`	String
`start_time`	Instant
`status`	String

organization_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`address_line_1`	String
`administrative_district_level_1`	String
`country`	String
`created_at`	Instant
`locality`	String
`name`	String
`postal_code`	String
`type`	String

ad_squad_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`campaign_id`	String	FK
`audience_size_maximum`	Long
`audience_size_minimum`	Long
`auto_bid`	Boolean
`bid_estimate_maximum`	Long
`bid_estimate_minimum`	Long
`bid_micro`	Long
`bid_strategy`	String
`billing_event`	String
`created_at`	Instant
`daily_budget_micro`	Long
`delivery_constraint`	String
`end_time`	Instant
`event_sources`	Json
`lifetime_budget_micro`	Long
`lifetime_spend_micro`	Long
`name`	String
`optimization_goal`	String
`pacing_type`	String
`placement`	String
`placement_v_2_config`	String
`start_time`	Instant
`status`	String
`target_bid`	Boolean
`targeting_regulated_content`	Boolean
`type`	String

media_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`ad_account_id`	String	FK
`created_at`	Instant
`download_link`	String
`file_name`	String
`media_status`	String
`name`	String
`type`	String

snap_pixel_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`ad_account_id`	String	FK
`created_at`	Instant
`effective_status`	String
`name`	String
`pixel_javascript`	String
`status`	String

creative_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`ad_account_id`	String	FK
`app_install_icon_media_id`	String	FK
`deep_link_icon_media_id`	String	FK
`longform_video_media_id`	String	FK
`top_snap_media_id`	String	FK
`ad_product`	String
`app_install_android_app_url`	String
`app_install_app_name`	String
`app_install_ios_app_id`	String
`attachment_type`	String
`brand_name`	String
`call_to_action`	String
`created_at`	Instant
`deep_link_android_app_url`	String
`deep_link_app_name`	String
`deep_link_ios_app_id`	String
`deep_link_uri`	String
`headline`	String
`name`	String
`packaging_status`	String
`playback_type`	String
`preview_creative_id`	String
`review_status`	String
`shareable`	Boolean
`top_snap_crop_position`	String
`type`	String
`url_macro_parameters`	String
`web_view_`

ad_account_funding_source

Column	Type	Keys
`ad_account_id`	String	PKFK
`funding_source_id`	String	PKFK

ad_squad_delivery_status

Column	Type	Keys
`status`	String	PK
`ad_squad_id`	String	PKFK
`ad_squad_updated_at`	Instant	PKFK

targeting_geolocation_history

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_squad_id`	String	FK
`ad_squad_updated_at`	Instant	FK
`country_code`	String
`geo_type`	String
`geo_value`	String
`operation`	String

ad_squad_placement_v_2_platform

Column	Type	Keys
`platform`	String	PK
`ad_squad_id`	String	PKFK
`ad_squad_updated_at`	Instant	PKFK

audience_segment_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`ad_account_id`	String	FK
`approximate_number_users`	Long
`created_at`	Instant
`description`	String
`name`	String
`retention_in_days`	Int
`source_type`	String
`status`	String
`targetable_status`	String
`upload_status`	String

creative_url_tag_history

Column	Type	Keys
`key`	String	PK
`value`	String	PK
`creative_id`	String	PKFK
`updated_at`	Instant	PKFK

ad_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`ad_squad_id`	String	FK
`creative_id`	String	FK
`created_at`	Instant
`deleted`	Boolean
`name`	String
`render_type`	String
`review_status`	String
`review_status_reason`	String
`status`	String
`type`	String