--- title: Facebook Ads description: Connect Facebook Ads, understand its sync behavior, and query every table and column it writes. species: reference --- # Facebook Ads Connect Facebook Ads with a system-user token and ad account. The source writes 42 fixed tables under `titan.facebook_ads`. ```sql select id, account_id, name from titan.facebook_ads.campaigns limit 10 ``` ## Connect Facebook Ads 1. Open **Apps**, choose **Connect app**, and select **Facebook Ads**. 2. Enter a system-user token and ad account. 3. Review the tables, then save the source. 4. Watch **Sync history** until the first run completes. Credentials are stored as secrets. They never become lake columns or appear in query results. ## Sync behavior Configure history months and attribution lookback. Report tables keep the selected attribution window consistent across runs. A new source syncs when you connect it and then follows its schedule. The default recurring interval is 4 hours. An interrupted run keeps its completed progress and retries safely. Every lake table also has the [system columns](/v2/docs/concepts/your-lake#the-system-columns) `_synced_at` and `_deleted`; the column reference below lists source columns only. ## Table reference ### `campaigns` `titan.facebook_ads.campaigns` has 29 source columns. ```columns table=facebook_ads.campaigns id string pk Source field `id`. account_id string Source field `account_id`. name string Source field `name`. status string Source field `status`. effective_status string Source field `effective_status`. objective string Source field `objective`. buying_type string Source field `buying_type`. bid_strategy string Source field `bid_strategy`. daily_budget integer Source field `daily_budget`. lifetime_budget integer Source field `lifetime_budget`. budget_remaining integer Source field `budget_remaining`. spend_cap integer Source field `spend_cap`. special_ad_categories json Source field `special_ad_categories`. special_ad_category string Source field `special_ad_category`. start_time datetime Source field `start_time`. stop_time datetime Source field `stop_time`. created_time datetime Source field `created_time`. updated_time datetime Source field `updated_time`. configured_status string Source field `configured_status`. source_campaign_id string Source field `source_campaign_id`. is_skadnetwork_attribution boolean Source field `is_skadnetwork_attribution`. smart_promotion_type string Source field `smart_promotion_type`. boosted_object_id string Source field `boosted_object_id`. budget_rebalance_flag boolean Source field `budget_rebalance_flag`. can_create_brand_lift_study boolean Source field `can_create_brand_lift_study`. can_use_spend_cap boolean Source field `can_use_spend_cap`. special_ad_category_country json Source field `special_ad_category_country`. issues_info json Source field `issues_info`. pacing_type json Source field `pacing_type`. ``` ### `ad_sets` `titan.facebook_ads.ad_sets` has 85 source columns. ```columns table=facebook_ads.ad_sets id string pk Source field `id`. account_id string Source field `account_id`. campaign_id string Source field `campaign_id`. name string Source field `name`. status string Source field `status`. effective_status string Source field `effective_status`. bid_strategy string Source field `bid_strategy`. bid_amount integer Source field `bid_amount`. billing_event string Source field `billing_event`. optimization_goal string Source field `optimization_goal`. daily_budget integer Source field `daily_budget`. lifetime_budget integer Source field `lifetime_budget`. budget_remaining integer Source field `budget_remaining`. destination_type string Source field `destination_type`. start_time datetime Source field `start_time`. end_time datetime Source field `end_time`. created_time datetime Source field `created_time`. updated_time datetime Source field `updated_time`. attribution_spec json Source field `attribution_spec`. is_dynamic_creative boolean Source field `is_dynamic_creative`. configured_status string Source field `configured_status`. source_adset_id string Source field `source_adset_id`. learning_stage_info json Source field `learning_stage_info`. instagram_actor_id string Source field `instagram_actor_id`. lifetime_imps integer Source field `lifetime_imps`. rf_prediction_id string Source field `rf_prediction_id`. use_new_app_click boolean Source field `use_new_app_click`. bid_info json Source field `bid_info`. bid_constraints json Source field `bid_constraints`. pacing_type json Source field `pacing_type`. promoted_object_pixel_id string Source field `promoted_object_pixel_id`. promoted_object_custom_event_type string Source field `promoted_object_custom_event_type`. promoted_object_smart_pse_enabled boolean Source field `promoted_object_smart_pse_enabled`. promoted_object_page_id string Source field `promoted_object_page_id`. promoted_object_application_id string Source field `promoted_object_application_id`. promoted_object_event_id string Source field `promoted_object_event_id`. promoted_object_object_store_url string Source field `promoted_object_object_store_url`. promoted_object_offer_id string Source field `promoted_object_offer_id`. promoted_object_place_page_set_id string Source field `promoted_object_place_page_set_id`. promoted_object_product_catalog_id string Source field `promoted_object_product_catalog_id`. promoted_object_product_set_id string Source field `promoted_object_product_set_id`. targeting_age_min integer Source field `targeting_age_min`. targeting_age_max integer Source field `targeting_age_max`. targeting_genders json Source field `targeting_genders`. targeting_device_platforms json Source field `targeting_device_platforms`. targeting_publisher_platforms json Source field `targeting_publisher_platforms`. targeting_facebook_positions json Source field `targeting_facebook_positions`. targeting_instagram_positions json Source field `targeting_instagram_positions`. targeting_messenger_positions json Source field `targeting_messenger_positions`. targeting_audience_network_positions json Source field `targeting_audience_network_positions`. targeting_effective_audience_network_positions json Source field `targeting_effective_audience_network_positions`. targeting_flexible_spec json Source field `targeting_flexible_spec`. targeting_exclusions json Source field `targeting_exclusions`. targeting_education_schools json Source field `targeting_education_schools`. targeting_education_majors json Source field `targeting_education_majors`. targeting_education_statuses json Source field `targeting_education_statuses`. targeting_college_years json Source field `targeting_college_years`. targeting_work_employers json Source field `targeting_work_employers`. targeting_work_positions json Source field `targeting_work_positions`. targeting_locales json Source field `targeting_locales`. targeting_user_adclusters json Source field `targeting_user_adclusters`. targeting_user_device json Source field `targeting_user_device`. targeting_user_os json Source field `targeting_user_os`. targeting_wireless_carrier json Source field `targeting_wireless_carrier`. targeting_app_install_state json Source field `targeting_app_install_state`. targeting_connections json Source field `targeting_connections`. targeting_excluded_connections json Source field `targeting_excluded_connections`. targeting_friends_of_connections json Source field `targeting_friends_of_connections`. targeting_excluded_publisher_categories json Source field `targeting_excluded_publisher_categories`. targeting_excluded_publisher_list_ids json Source field `targeting_excluded_publisher_list_ids`. targeting_excluded_user_device json Source field `targeting_excluded_user_device`. targeting_geo_locations_countries json Source field `targeting_geo_locations_countries`. targeting_geo_locations_regions json Source field `targeting_geo_locations_regions`. targeting_geo_locations_cities json Source field `targeting_geo_locations_cities`. targeting_geo_locations_zips json Source field `targeting_geo_locations_zips`. targeting_geo_locations_geo_markets json Source field `targeting_geo_locations_geo_markets`. targeting_geo_locations_location_types json Source field `targeting_geo_locations_location_types`. targeting_geo_locations_custom_locations json Source field `targeting_geo_locations_custom_locations`. targeting_excluded_geo_locations_countries json Source field `targeting_excluded_geo_locations_countries`. targeting_excluded_geo_locations_regions json Source field `targeting_excluded_geo_locations_regions`. targeting_excluded_geo_locations_cities json Source field `targeting_excluded_geo_locations_cities`. targeting_excluded_geo_locations_zips json Source field `targeting_excluded_geo_locations_zips`. targeting_excluded_geo_locations_geo_markets json Source field `targeting_excluded_geo_locations_geo_markets`. targeting_excluded_geo_locations_location_types json Source field `targeting_excluded_geo_locations_location_types`. targeting_excluded_geo_locations_custom_locations json Source field `targeting_excluded_geo_locations_custom_locations`. ``` ### `ads` `titan.facebook_ads.ads` has 21 source columns. ```columns table=facebook_ads.ads id string pk Source field `id`. account_id string Source field `account_id`. campaign_id string Source field `campaign_id`. adset_id string Source field `adset_id`. name string Source field `name`. status string Source field `status`. effective_status string Source field `effective_status`. creative_id string Source field `creative_id`. created_time datetime Source field `created_time`. updated_time datetime Source field `updated_time`. configured_status string Source field `configured_status`. source_ad_id string Source field `source_ad_id`. conversion_domain string Source field `conversion_domain`. bid_amount integer Source field `bid_amount`. last_updated_by_app_id string Source field `last_updated_by_app_id`. tracking_specs json Source field `tracking_specs`. conversion_specs json Source field `conversion_specs`. bid_type string Source field `bid_type`. bid_info json Source field `bid_info`. recommendations json Source field `recommendations`. targeting json Source field `targeting`. ``` ### `ad_account` `titan.facebook_ads.ad_account` has 45 source columns. ```columns table=facebook_ads.ad_account id string pk Source field `id`. account_id string Source field `account_id`. name string Source field `name`. account_status integer Source field `account_status`. currency string Source field `currency`. timezone_name string Source field `timezone_name`. timezone_id integer Source field `timezone_id`. timezone_offset_hours_utc float Source field `timezone_offset_hours_utc`. age float Source field `age`. amount_spent integer Source field `amount_spent`. balance integer Source field `balance`. spend_cap integer Source field `spend_cap`. min_daily_budget integer Source field `min_daily_budget`. min_campaign_group_spend_cap integer Source field `min_campaign_group_spend_cap`. business_name string Source field `business_name`. business_city string Source field `business_city`. business_country_code string Source field `business_country_code`. business_state string Source field `business_state`. business_street string Source field `business_street`. business_street2 string Source field `business_street2`. business_zip string Source field `business_zip`. created_time datetime Source field `created_time`. disable_reason integer Source field `disable_reason`. is_personal boolean Source field `is_personal`. owner string Source field `owner`. end_advertiser string Source field `end_advertiser`. end_advertiser_name string Source field `end_advertiser_name`. is_prepay_account boolean Source field `is_prepay_account`. offsite_pixels_tos_accepted boolean Source field `offsite_pixels_tos_accepted`. tax_id string Source field `tax_id`. tax_id_status integer Source field `tax_id_status`. tax_id_type string Source field `tax_id_type`. can_create_brand_lift_study boolean Source field `can_create_brand_lift_study`. has_migrated_permissions boolean Source field `has_migrated_permissions`. is_direct_deals_enabled boolean Source field `is_direct_deals_enabled`. is_notifications_enabled boolean Source field `is_notifications_enabled`. is_tax_id_required boolean Source field `is_tax_id_required`. business_id string Source field `business_id`. business_manager_name string Source field `business_manager_name`. media_agency string Source field `media_agency`. partner string Source field `partner`. agency_client_declaration json Source field `agency_client_declaration`. capabilities json Source field `capabilities`. funding_source string Source field `funding_source`. tos_accepted json Source field `tos_accepted`. ``` ### `ad_creatives` `titan.facebook_ads.ad_creatives` has 101 source columns. ```columns table=facebook_ads.ad_creatives id string pk Source field `id`. account_id string Source field `account_id`. name string Source field `name`. status string Source field `status`. body string Source field `body`. title string Source field `title`. call_to_action_type string Source field `call_to_action_type`. image_hash string Source field `image_hash`. image_url string Source field `image_url`. thumbnail_url string Source field `thumbnail_url`. link_url string Source field `link_url`. url_tags string Source field `url_tags`. object_type string Source field `object_type`. object_story_spec json Source field `object_story_spec`. effective_object_story_id string Source field `effective_object_story_id`. asset_feed_spec json Source field `asset_feed_spec`. instagram_permalink_url string Source field `instagram_permalink_url`. video_id string Source field `video_id`. object_id string Source field `object_id`. object_url string Source field `object_url`. object_story_id string Source field `object_story_id`. actor_id string Source field `actor_id`. link_og_id string Source field `link_og_id`. product_set_id string Source field `product_set_id`. applink_treatment string Source field `applink_treatment`. source_instagram_media_id string Source field `source_instagram_media_id`. instagram_user_id string Source field `instagram_user_id`. effective_instagram_media_id string Source field `effective_instagram_media_id`. template_url string Source field `template_url`. authorization_category string Source field `authorization_category`. effective_authorization_category string Source field `effective_authorization_category`. enable_direct_install boolean Source field `enable_direct_install`. thumbnail_id string Source field `thumbnail_id`. bundle_folder_id string Source field `bundle_folder_id`. categorization_criteria string Source field `categorization_criteria`. category_media_source string Source field `category_media_source`. destination_set_id string Source field `destination_set_id`. dynamic_ad_voice string Source field `dynamic_ad_voice`. link_destination_display_url string Source field `link_destination_display_url`. messenger_sponsored_message string Source field `messenger_sponsored_message`. object_store_url string Source field `object_store_url`. place_page_set_id string Source field `place_page_set_id`. playable_asset_id string Source field `playable_asset_id`. branded_content_sponsor_page_id string Source field `branded_content_sponsor_page_id`. effective_instagram_story_id string Source field `effective_instagram_story_id`. instagram_actor_id string Source field `instagram_actor_id`. instagram_story_id string Source field `instagram_story_id`. use_page_actor_override boolean Source field `use_page_actor_override`. object_story_link_data_caption string Source field `object_story_link_data_caption`. object_story_link_data_description string Source field `object_story_link_data_description`. object_story_link_data_link string Source field `object_story_link_data_link`. object_story_link_data_message string Source field `object_story_link_data_message`. object_story_link_data_child_attachments json Source field `object_story_link_data_child_attachments`. object_story_link_data_app_link_spec_android json Source field `object_story_link_data_app_link_spec_android`. object_story_link_data_app_link_spec_ios json Source field `object_story_link_data_app_link_spec_ios`. object_story_link_data_app_link_spec_ipad json Source field `object_story_link_data_app_link_spec_ipad`. object_story_link_data_app_link_spec_iphone json Source field `object_story_link_data_app_link_spec_iphone`. video_video_id string Source field `video_video_id`. video_call_to_action_value_link string Source field `video_call_to_action_value_link`. template_caption string Source field `template_caption`. template_description string Source field `template_description`. template_link string Source field `template_link`. template_message string Source field `template_message`. template_child_attachments json Source field `template_child_attachments`. template_app_link_spec_android json Source field `template_app_link_spec_android`. template_app_link_spec_ios json Source field `template_app_link_spec_ios`. template_app_link_spec_ipad json Source field `template_app_link_spec_ipad`. template_app_link_spec_iphone json Source field `template_app_link_spec_iphone`. template_url_spec_web_url string Source field `template_url_spec_web_url`. template_url_spec_web_should_fallback boolean Source field `template_url_spec_web_should_fallback`. template_url_spec_ios_url string Source field `template_url_spec_ios_url`. template_url_spec_ios_app_name string Source field `template_url_spec_ios_app_name`. template_url_spec_ios_app_store_id string Source field `template_url_spec_ios_app_store_id`. template_url_spec_iphone_url string Source field `template_url_spec_iphone_url`. template_url_spec_iphone_app_name string Source field `template_url_spec_iphone_app_name`. template_url_spec_iphone_app_store_id string Source field `template_url_spec_iphone_app_store_id`. template_url_spec_ipad_url string Source field `template_url_spec_ipad_url`. template_url_spec_ipad_app_name string Source field `template_url_spec_ipad_app_name`. template_url_spec_ipad_app_store_id string Source field `template_url_spec_ipad_app_store_id`. template_url_spec_android_url string Source field `template_url_spec_android_url`. template_url_spec_android_app_name string Source field `template_url_spec_android_app_name`. template_url_spec_android_package string Source field `template_url_spec_android_package`. template_url_spec_windows_phone_url string Source field `template_url_spec_windows_phone_url`. template_url_spec_windows_phone_app_name string Source field `template_url_spec_windows_phone_app_name`. template_url_spec_windows_phone_app_id string Source field `template_url_spec_windows_phone_app_id`. template_url_spec_config_app_id string Source field `template_url_spec_config_app_id`. platform_customizations_instagram_image_hash string Source field `platform_customizations_instagram_image_hash`. platform_customizations_instagram_image_url string Source field `platform_customizations_instagram_image_url`. platform_customizations_instagram_video_id string Source field `platform_customizations_instagram_video_id`. platform_customizations_instagram_caption_ids json Source field `platform_customizations_instagram_caption_ids`. asset_feed_spec_link_urls json Source field `asset_feed_spec_link_urls`. asset_feed_spec_additional_data_multi_share_end_card boolean Source field `asset_feed_spec_additional_data_multi_share_end_card`. asset_feed_spec_additional_data_is_click_to_message boolean Source field `asset_feed_spec_additional_data_is_click_to_message`. asset_feed_spec_additional_data_brand_page_id string Source field `asset_feed_spec_additional_data_brand_page_id`. asset_feed_spec_app_product_page_id string Source field `asset_feed_spec_app_product_page_id`. asset_feed_spec_shops_bundle json Source field `asset_feed_spec_shops_bundle`. asset_feed_spec_additional_data_partner_app_welcome_message_flow_id string Source field `asset_feed_spec_additional_data_partner_app_welcome_message_flow_id`. page_link string Source field `page_link`. page_message string Source field `page_message`. carousel_ad_link string Source field `carousel_ad_link`. template_page_link string Source field `template_page_link`. ``` ### `custom_audiences` `titan.facebook_ads.custom_audiences` has 28 source columns. ```columns table=facebook_ads.custom_audiences id string pk Source field `id`. account_id string Source field `account_id`. name string Source field `name`. description string Source field `description`. subtype string Source field `subtype`. approximate_count_lower_bound integer Source field `approximate_count_lower_bound`. approximate_count_upper_bound integer Source field `approximate_count_upper_bound`. time_created datetime Source field `time_created`. time_updated datetime Source field `time_updated`. retention_days integer Source field `retention_days`. is_value_based boolean Source field `is_value_based`. customer_file_source string Source field `customer_file_source`. data_source_type string Source field `data_source_type`. data_source_sub_type string Source field `data_source_sub_type`. delivery_status_code integer Source field `delivery_status_code`. delivery_status_description string Source field `delivery_status_description`. operation_status_code integer Source field `operation_status_code`. operation_status_description string Source field `operation_status_description`. rule string Source field `rule`. lookalike_spec json Source field `lookalike_spec`. pixel_id string Source field `pixel_id`. sharing_status string Source field `sharing_status`. time_content_updated datetime Source field `time_content_updated`. lookalike_audience_ids json Source field `lookalike_audience_ids`. opt_out_link string Source field `opt_out_link`. permission_for_actions json Source field `permission_for_actions`. page_deletion_marked_delete_time integer Source field `page_deletion_marked_delete_time`. rule_aggregation string Source field `rule_aggregation`. ``` ### `custom_conversions` `titan.facebook_ads.custom_conversions` has 18 source columns. ```columns table=facebook_ads.custom_conversions id string pk Source field `id`. account_id string Source field `account_id`. name string Source field `name`. description string Source field `description`. custom_event_type string Source field `custom_event_type`. default_conversion_value integer Source field `default_conversion_value`. is_archived boolean Source field `is_archived`. is_unavailable boolean Source field `is_unavailable`. rule string Source field `rule`. retention_days integer Source field `retention_days`. creation_time datetime Source field `creation_time`. first_fired_time datetime Source field `first_fired_time`. last_fired_time datetime Source field `last_fired_time`. event_source_type string Source field `event_source_type`. business_id string Source field `business_id`. business_name string Source field `business_name`. data_sources json Source field `data_sources`. offline_conversion_data_set json Source field `offline_conversion_data_set`. ``` ### `ad_images` `titan.facebook_ads.ad_images` has 17 source columns. ```columns table=facebook_ads.ad_images id string pk Source field `id`. account_id string Source field `account_id`. hash string Source field `hash`. name string Source field `name`. status string Source field `status`. url string Source field `url`. url_128 string Source field `url_128`. permalink_url string Source field `permalink_url`. height integer Source field `height`. width integer Source field `width`. original_height integer Source field `original_height`. original_width integer Source field `original_width`. is_associated_creatives_in_adgroups boolean Source field `is_associated_creatives_in_adgroups`. created_time datetime Source field `created_time`. updated_time datetime Source field `updated_time`. creatives json Source field `creatives`. hash_2 string Source field `hash_2`. ``` ### `ad_videos` `titan.facebook_ads.ad_videos` has 33 source columns. ```columns table=facebook_ads.ad_videos id string pk Source field `id`. title string Source field `title`. description string Source field `description`. length float Source field `length`. source string Source field `source`. picture string Source field `picture`. permalink_url string Source field `permalink_url`. embed_html string Source field `embed_html`. video_status string Source field `video_status`. uploading_phase_status string Source field `uploading_phase_status`. processing_phase_status string Source field `processing_phase_status`. publishing_phase_status string Source field `publishing_phase_status`. publishing_phase_publish_status string Source field `publishing_phase_publish_status`. publishing_phase_publish_time datetime Source field `publishing_phase_publish_time`. created_time datetime Source field `created_time`. updated_time datetime Source field `updated_time`. views integer Source field `views`. post_views integer Source field `post_views`. icon string Source field `icon`. embeddable boolean Source field `embeddable`. format json Source field `format`. content_category string Source field `content_category`. content_tags json Source field `content_tags`. custom_labels json Source field `custom_labels`. ad_breaks json Source field `ad_breaks`. is_crosspost_video boolean Source field `is_crosspost_video`. is_crossposting_eligible boolean Source field `is_crossposting_eligible`. is_episode boolean Source field `is_episode`. is_instagram_eligible boolean Source field `is_instagram_eligible`. live_status string Source field `live_status`. published boolean Source field `published`. universal_video_id string Source field `universal_video_id`. account_id string Source field `account_id`. ``` ### `activities` `titan.facebook_ads.activities` has 12 source columns. ```columns table=facebook_ads.activities event_time datetime pk Source field `event_time`. actor_id string pk Source field `actor_id`. object_id string pk Source field `object_id`. event_type string pk Source field `event_type`. actor_name string Source field `actor_name`. application_id string Source field `application_id`. application_name string Source field `application_name`. translated_event_type string Source field `translated_event_type`. date_time_in_timezone string Source field `date_time_in_timezone`. object_name string Source field `object_name`. object_type string Source field `object_type`. extra_data string Source field `extra_data`. ``` ### `ad_labels` `titan.facebook_ads.ad_labels` has 4 source columns. ```columns table=facebook_ads.ad_labels id string pk Source field `id`. name string Source field `name`. created_time datetime Source field `created_time`. updated_time datetime Source field `updated_time`. ``` ### `ad_rules` `titan.facebook_ads.ad_rules` has 9 source columns. ```columns table=facebook_ads.ad_rules id string pk Source field `id`. account_id string Source field `account_id`. name string Source field `name`. status string Source field `status`. created_time datetime Source field `created_time`. updated_time datetime Source field `updated_time`. execution_spec json Source field `execution_spec`. evaluation_spec json Source field `evaluation_spec`. schedule_spec json Source field `schedule_spec`. ``` ### `saved_audiences` `titan.facebook_ads.saved_audiences` has 11 source columns. ```columns table=facebook_ads.saved_audiences id string pk Source field `id`. name string Source field `name`. description string Source field `description`. approximate_count_lower_bound integer Source field `approximate_count_lower_bound`. approximate_count_upper_bound integer Source field `approximate_count_upper_bound`. run_status string Source field `run_status`. time_created datetime Source field `time_created`. time_updated datetime Source field `time_updated`. targeting json Source field `targeting`. sentence_lines json Source field `sentence_lines`. permission_for_actions json Source field `permission_for_actions`. ``` ### `ad_label_campaigns` `titan.facebook_ads.ad_label_campaigns` has 3 source columns. ```columns table=facebook_ads.ad_label_campaigns campaign_id string pk Source field `campaign_id`. ad_label_id string pk Source field `ad_label_id`. ad_label_name string Source field `ad_label_name`. ``` ### `ad_label_ad_sets` `titan.facebook_ads.ad_label_ad_sets` has 3 source columns. ```columns table=facebook_ads.ad_label_ad_sets ad_set_id string pk Source field `ad_set_id`. ad_label_id string pk Source field `ad_label_id`. ad_label_name string Source field `ad_label_name`. ``` ### `ad_label_ads` `titan.facebook_ads.ad_label_ads` has 3 source columns. ```columns table=facebook_ads.ad_label_ads ad_id string pk Source field `ad_id`. ad_label_id string pk Source field `ad_label_id`. ad_label_name string Source field `ad_label_name`. ``` ### `campaign_insights` `titan.facebook_ads.campaign_insights` has 38 source columns. ```columns table=facebook_ads.campaign_insights campaign_id string pk Source field `campaign_id`. date_start date pk Source field `date_start`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. objective string Source field `objective`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_set_insights` `titan.facebook_ads.ad_set_insights` has 38 source columns. ```columns table=facebook_ads.ad_set_insights adset_id string pk Source field `adset_id`. date_start date pk Source field `date_start`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights` `titan.facebook_ads.ad_insights` has 41 source columns. ```columns table=facebook_ads.ad_insights ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `campaign_insights_actions` `titan.facebook_ads.campaign_insights_actions` has 8 source columns. ```columns table=facebook_ads.campaign_insights_actions campaign_id string pk Source field `campaign_id`. date_start date pk Source field `date_start`. action_type string pk Source field `action_type`. value integer Source field `value`. _1d_click integer Source field `_1d_click`. _7d_click integer Source field `_7d_click`. _28d_click integer Source field `_28d_click`. _1d_view integer Source field `_1d_view`. ``` ### `campaign_insights_action_values` `titan.facebook_ads.campaign_insights_action_values` has 8 source columns. ```columns table=facebook_ads.campaign_insights_action_values campaign_id string pk Source field `campaign_id`. date_start date pk Source field `date_start`. action_type string pk Source field `action_type`. value decimal(28,2) Source field `value`. _1d_click decimal(28,2) Source field `_1d_click`. _7d_click decimal(28,2) Source field `_7d_click`. _28d_click decimal(28,2) Source field `_28d_click`. _1d_view decimal(28,2) Source field `_1d_view`. ``` ### `ad_set_insights_actions` `titan.facebook_ads.ad_set_insights_actions` has 8 source columns. ```columns table=facebook_ads.ad_set_insights_actions adset_id string pk Source field `adset_id`. date_start date pk Source field `date_start`. action_type string pk Source field `action_type`. value integer Source field `value`. _1d_click integer Source field `_1d_click`. _7d_click integer Source field `_7d_click`. _28d_click integer Source field `_28d_click`. _1d_view integer Source field `_1d_view`. ``` ### `ad_set_insights_action_values` `titan.facebook_ads.ad_set_insights_action_values` has 8 source columns. ```columns table=facebook_ads.ad_set_insights_action_values adset_id string pk Source field `adset_id`. date_start date pk Source field `date_start`. action_type string pk Source field `action_type`. value decimal(28,2) Source field `value`. _1d_click decimal(28,2) Source field `_1d_click`. _7d_click decimal(28,2) Source field `_7d_click`. _28d_click decimal(28,2) Source field `_28d_click`. _1d_view decimal(28,2) Source field `_1d_view`. ``` ### `ad_insights_actions` `titan.facebook_ads.ad_insights_actions` has 8 source columns. ```columns table=facebook_ads.ad_insights_actions ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. action_type string pk Source field `action_type`. value integer Source field `value`. _1d_click integer Source field `_1d_click`. _7d_click integer Source field `_7d_click`. _28d_click integer Source field `_28d_click`. _1d_view integer Source field `_1d_view`. ``` ### `ad_insights_action_values` `titan.facebook_ads.ad_insights_action_values` has 8 source columns. ```columns table=facebook_ads.ad_insights_action_values ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. action_type string pk Source field `action_type`. value decimal(28,2) Source field `value`. _1d_click decimal(28,2) Source field `_1d_click`. _7d_click decimal(28,2) Source field `_7d_click`. _28d_click decimal(28,2) Source field `_28d_click`. _1d_view decimal(28,2) Source field `_1d_view`. ``` ### `ad_insights_age_and_gender` `titan.facebook_ads.ad_insights_age_and_gender` has 43 source columns. ```columns table=facebook_ads.ad_insights_age_and_gender ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. age string pk Source field `age`. gender string pk Source field `gender`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_country` `titan.facebook_ads.ad_insights_country` has 42 source columns. ```columns table=facebook_ads.ad_insights_country ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. country string pk Source field `country`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_region` `titan.facebook_ads.ad_insights_region` has 42 source columns. ```columns table=facebook_ads.ad_insights_region ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. region string pk Source field `region`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_dma` `titan.facebook_ads.ad_insights_dma` has 42 source columns. ```columns table=facebook_ads.ad_insights_dma ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. dma string pk Source field `dma`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_platform_and_device` `titan.facebook_ads.ad_insights_platform_and_device` has 44 source columns. ```columns table=facebook_ads.ad_insights_platform_and_device ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. publisher_platform string pk Source field `publisher_platform`. platform_position string pk Source field `platform_position`. impression_device string pk Source field `impression_device`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_action_type` `titan.facebook_ads.ad_insights_action_type` has 41 source columns. ```columns table=facebook_ads.ad_insights_action_type ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_action_carousel_card` `titan.facebook_ads.ad_insights_action_carousel_card` has 41 source columns. ```columns table=facebook_ads.ad_insights_action_carousel_card ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_action_product_id` `titan.facebook_ads.ad_insights_action_product_id` has 42 source columns. ```columns table=facebook_ads.ad_insights_action_product_id ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. product_id string pk Source field `product_id`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_action_reaction` `titan.facebook_ads.ad_insights_action_reaction` has 41 source columns. ```columns table=facebook_ads.ad_insights_action_reaction ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_action_video_sound` `titan.facebook_ads.ad_insights_action_video_sound` has 41 source columns. ```columns table=facebook_ads.ad_insights_action_video_sound ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_action_video_type` `titan.facebook_ads.ad_insights_action_video_type` has 41 source columns. ```columns table=facebook_ads.ad_insights_action_video_type ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_delivery_device` `titan.facebook_ads.ad_insights_delivery_device` has 42 source columns. ```columns table=facebook_ads.ad_insights_delivery_device ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. device_platform string pk Source field `device_platform`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_delivery_platform` `titan.facebook_ads.ad_insights_delivery_platform` has 42 source columns. ```columns table=facebook_ads.ad_insights_delivery_platform ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. publisher_platform string pk Source field `publisher_platform`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_delivery_platform_and_device_platform` `titan.facebook_ads.ad_insights_delivery_platform_and_device_platform` has 43 source columns. ```columns table=facebook_ads.ad_insights_delivery_platform_and_device_platform ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. publisher_platform string pk Source field `publisher_platform`. device_platform string pk Source field `device_platform`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_demographics_age` `titan.facebook_ads.ad_insights_demographics_age` has 42 source columns. ```columns table=facebook_ads.ad_insights_demographics_age ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. age string pk Source field `age`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_demographics_country` `titan.facebook_ads.ad_insights_demographics_country` has 42 source columns. ```columns table=facebook_ads.ad_insights_demographics_country ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. country string pk Source field `country`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ### `ad_insights_demographics_dma_region` `titan.facebook_ads.ad_insights_demographics_dma_region` has 42 source columns. ```columns table=facebook_ads.ad_insights_demographics_dma_region ad_id string pk Source field `ad_id`. date_start date pk Source field `date_start`. dma string pk Source field `dma`. ad_name string Source field `ad_name`. adset_id string Source field `adset_id`. adset_name string Source field `adset_name`. campaign_id string Source field `campaign_id`. campaign_name string Source field `campaign_name`. account_id string Source field `account_id`. date_stop date Source field `date_stop`. impressions integer Source field `impressions`. clicks integer Source field `clicks`. spend decimal(28,2) Source field `spend`. reach integer Source field `reach`. frequency float Source field `frequency`. cpc decimal(28,6) Source field `cpc`. cpm decimal(28,6) Source field `cpm`. cpp decimal(28,6) Source field `cpp`. ctr decimal(28,6) Source field `ctr`. inline_link_clicks integer Source field `inline_link_clicks`. inline_link_click_ctr decimal(28,6) Source field `inline_link_click_ctr`. cost_per_inline_link_click decimal(28,6) Source field `cost_per_inline_link_click`. cost_per_unique_click decimal(28,6) Source field `cost_per_unique_click`. unique_clicks integer Source field `unique_clicks`. unique_ctr decimal(28,6) Source field `unique_ctr`. social_spend decimal(28,2) Source field `social_spend`. quality_ranking string Source field `quality_ranking`. engagement_rate_ranking string Source field `engagement_rate_ranking`. conversion_rate_ranking string Source field `conversion_rate_ranking`. actions json Source field `actions`. action_values json Source field `action_values`. conversions json Source field `conversions`. conversion_values json Source field `conversion_values`. cost_per_action_type json Source field `cost_per_action_type`. outbound_clicks json Source field `outbound_clicks`. cost_per_outbound_click json Source field `cost_per_outbound_click`. purchase_roas json Source field `purchase_roas`. video_p25_watched_actions json Source field `video_p25_watched_actions`. video_p50_watched_actions json Source field `video_p50_watched_actions`. video_p75_watched_actions json Source field `video_p75_watched_actions`. video_p100_watched_actions json Source field `video_p100_watched_actions`. video_avg_time_watched_actions json Source field `video_avg_time_watched_actions`. ``` ## Deletes and history Rows are merged by their source key. When the source can prove that a row was deleted, Supernova keeps the row and sets `_deleted` so queries can choose whether to include history. Filter current-state queries with `where not _deleted`.