Supernova home
Documentation menu

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 _synced_at and _deleted; the column reference below lists source columns only.

Table reference#

campaigns#

titan.facebook_ads.campaigns has 29 source columns.

facebook_ads.campaigns29 columns
idstringpk

Source field id.

account_idstring

Source field account_id.

namestring

Source field name.

statusstring

Source field status.

effective_statusstring

Source field effective_status.

objectivestring

Source field objective.

buying_typestring

Source field buying_type.

bid_strategystring

Source field bid_strategy.

daily_budgetinteger

Source field daily_budget.

lifetime_budgetinteger

Source field lifetime_budget.

budget_remaininginteger

Source field budget_remaining.

spend_capinteger

Source field spend_cap.

special_ad_categoriesjson

Source field special_ad_categories.

special_ad_categorystring

Source field special_ad_category.

start_timedatetime

Source field start_time.

stop_timedatetime

Source field stop_time.

created_timedatetime

Source field created_time.

updated_timedatetime

Source field updated_time.

configured_statusstring

Source field configured_status.

source_campaign_idstring

Source field source_campaign_id.

is_skadnetwork_attributionboolean

Source field is_skadnetwork_attribution.

smart_promotion_typestring

Source field smart_promotion_type.

boosted_object_idstring

Source field boosted_object_id.

budget_rebalance_flagboolean

Source field budget_rebalance_flag.

can_create_brand_lift_studyboolean

Source field can_create_brand_lift_study.

can_use_spend_capboolean

Source field can_use_spend_cap.

special_ad_category_countryjson

Source field special_ad_category_country.

issues_infojson

Source field issues_info.

pacing_typejson

Source field pacing_type.

ad_sets#

titan.facebook_ads.ad_sets has 85 source columns.

facebook_ads.ad_sets85 columns
idstringpk

Source field id.

account_idstring

Source field account_id.

campaign_idstring

Source field campaign_id.

namestring

Source field name.

statusstring

Source field status.

effective_statusstring

Source field effective_status.

bid_strategystring

Source field bid_strategy.

bid_amountinteger

Source field bid_amount.

billing_eventstring

Source field billing_event.

optimization_goalstring

Source field optimization_goal.

daily_budgetinteger

Source field daily_budget.

lifetime_budgetinteger

Source field lifetime_budget.

budget_remaininginteger

Source field budget_remaining.

destination_typestring

Source field destination_type.

start_timedatetime

Source field start_time.

end_timedatetime

Source field end_time.

created_timedatetime

Source field created_time.

updated_timedatetime

Source field updated_time.

attribution_specjson

Source field attribution_spec.

is_dynamic_creativeboolean

Source field is_dynamic_creative.

configured_statusstring

Source field configured_status.

source_adset_idstring

Source field source_adset_id.

learning_stage_infojson

Source field learning_stage_info.

instagram_actor_idstring

Source field instagram_actor_id.

lifetime_impsinteger

Source field lifetime_imps.

rf_prediction_idstring

Source field rf_prediction_id.

use_new_app_clickboolean

Source field use_new_app_click.

bid_infojson

Source field bid_info.

bid_constraintsjson

Source field bid_constraints.

pacing_typejson

Source field pacing_type.

promoted_object_pixel_idstring

Source field promoted_object_pixel_id.

promoted_object_custom_event_typestring

Source field promoted_object_custom_event_type.

promoted_object_smart_pse_enabledboolean

Source field promoted_object_smart_pse_enabled.

promoted_object_page_idstring

Source field promoted_object_page_id.

promoted_object_application_idstring

Source field promoted_object_application_id.

promoted_object_event_idstring

Source field promoted_object_event_id.

promoted_object_object_store_urlstring

Source field promoted_object_object_store_url.

promoted_object_offer_idstring

Source field promoted_object_offer_id.

promoted_object_place_page_set_idstring

Source field promoted_object_place_page_set_id.

promoted_object_product_catalog_idstring

Source field promoted_object_product_catalog_id.

promoted_object_product_set_idstring

Source field promoted_object_product_set_id.

targeting_age_mininteger

Source field targeting_age_min.

targeting_age_maxinteger

Source field targeting_age_max.

targeting_gendersjson

Source field targeting_genders.

targeting_device_platformsjson

Source field targeting_device_platforms.

targeting_publisher_platformsjson

Source field targeting_publisher_platforms.

targeting_facebook_positionsjson

Source field targeting_facebook_positions.

targeting_instagram_positionsjson

Source field targeting_instagram_positions.

targeting_messenger_positionsjson

Source field targeting_messenger_positions.

targeting_audience_network_positionsjson

Source field targeting_audience_network_positions.

targeting_effective_audience_network_positionsjson

Source field targeting_effective_audience_network_positions.

targeting_flexible_specjson

Source field targeting_flexible_spec.

targeting_exclusionsjson

Source field targeting_exclusions.

targeting_education_schoolsjson

Source field targeting_education_schools.

targeting_education_majorsjson

Source field targeting_education_majors.

targeting_education_statusesjson

Source field targeting_education_statuses.

targeting_college_yearsjson

Source field targeting_college_years.

targeting_work_employersjson

Source field targeting_work_employers.

targeting_work_positionsjson

Source field targeting_work_positions.

targeting_localesjson

Source field targeting_locales.

targeting_user_adclustersjson

Source field targeting_user_adclusters.

targeting_user_devicejson

Source field targeting_user_device.

targeting_user_osjson

Source field targeting_user_os.

targeting_wireless_carrierjson

Source field targeting_wireless_carrier.

targeting_app_install_statejson

Source field targeting_app_install_state.

targeting_connectionsjson

Source field targeting_connections.

targeting_excluded_connectionsjson

Source field targeting_excluded_connections.

targeting_friends_of_connectionsjson

Source field targeting_friends_of_connections.

targeting_excluded_publisher_categoriesjson

Source field targeting_excluded_publisher_categories.

targeting_excluded_publisher_list_idsjson

Source field targeting_excluded_publisher_list_ids.

targeting_excluded_user_devicejson

Source field targeting_excluded_user_device.

targeting_geo_locations_countriesjson

Source field targeting_geo_locations_countries.

targeting_geo_locations_regionsjson

Source field targeting_geo_locations_regions.

targeting_geo_locations_citiesjson

Source field targeting_geo_locations_cities.

targeting_geo_locations_zipsjson

Source field targeting_geo_locations_zips.

targeting_geo_locations_geo_marketsjson

Source field targeting_geo_locations_geo_markets.

targeting_geo_locations_location_typesjson

Source field targeting_geo_locations_location_types.

targeting_geo_locations_custom_locationsjson

Source field targeting_geo_locations_custom_locations.

targeting_excluded_geo_locations_countriesjson

Source field targeting_excluded_geo_locations_countries.

targeting_excluded_geo_locations_regionsjson

Source field targeting_excluded_geo_locations_regions.

targeting_excluded_geo_locations_citiesjson

Source field targeting_excluded_geo_locations_cities.

targeting_excluded_geo_locations_zipsjson

Source field targeting_excluded_geo_locations_zips.

targeting_excluded_geo_locations_geo_marketsjson

Source field targeting_excluded_geo_locations_geo_markets.

targeting_excluded_geo_locations_location_typesjson

Source field targeting_excluded_geo_locations_location_types.

targeting_excluded_geo_locations_custom_locationsjson

Source field targeting_excluded_geo_locations_custom_locations.

ads#

titan.facebook_ads.ads has 21 source columns.

facebook_ads.ads21 columns
idstringpk

Source field id.

account_idstring

Source field account_id.

campaign_idstring

Source field campaign_id.

adset_idstring

Source field adset_id.

namestring

Source field name.

statusstring

Source field status.

effective_statusstring

Source field effective_status.

creative_idstring

Source field creative_id.

created_timedatetime

Source field created_time.

updated_timedatetime

Source field updated_time.

configured_statusstring

Source field configured_status.

source_ad_idstring

Source field source_ad_id.

conversion_domainstring

Source field conversion_domain.

bid_amountinteger

Source field bid_amount.

last_updated_by_app_idstring

Source field last_updated_by_app_id.

tracking_specsjson

Source field tracking_specs.

conversion_specsjson

Source field conversion_specs.

bid_typestring

Source field bid_type.

bid_infojson

Source field bid_info.

recommendationsjson

Source field recommendations.

targetingjson

Source field targeting.

ad_account#

titan.facebook_ads.ad_account has 45 source columns.

facebook_ads.ad_account45 columns
idstringpk

Source field id.

account_idstring

Source field account_id.

namestring

Source field name.

account_statusinteger

Source field account_status.

currencystring

Source field currency.

timezone_namestring

Source field timezone_name.

timezone_idinteger

Source field timezone_id.

timezone_offset_hours_utcfloat

Source field timezone_offset_hours_utc.

agefloat

Source field age.

amount_spentinteger

Source field amount_spent.

balanceinteger

Source field balance.

spend_capinteger

Source field spend_cap.

min_daily_budgetinteger

Source field min_daily_budget.

min_campaign_group_spend_capinteger

Source field min_campaign_group_spend_cap.

business_namestring

Source field business_name.

business_citystring

Source field business_city.

business_country_codestring

Source field business_country_code.

business_statestring

Source field business_state.

business_streetstring

Source field business_street.

business_street2string

Source field business_street2.

business_zipstring

Source field business_zip.

created_timedatetime

Source field created_time.

disable_reasoninteger

Source field disable_reason.

is_personalboolean

Source field is_personal.

ownerstring

Source field owner.

end_advertiserstring

Source field end_advertiser.

end_advertiser_namestring

Source field end_advertiser_name.

is_prepay_accountboolean

Source field is_prepay_account.

offsite_pixels_tos_acceptedboolean

Source field offsite_pixels_tos_accepted.

tax_idstring

Source field tax_id.

tax_id_statusinteger

Source field tax_id_status.

tax_id_typestring

Source field tax_id_type.

can_create_brand_lift_studyboolean

Source field can_create_brand_lift_study.

has_migrated_permissionsboolean

Source field has_migrated_permissions.

is_direct_deals_enabledboolean

Source field is_direct_deals_enabled.

is_notifications_enabledboolean

Source field is_notifications_enabled.

is_tax_id_requiredboolean

Source field is_tax_id_required.

business_idstring

Source field business_id.

business_manager_namestring

Source field business_manager_name.

media_agencystring

Source field media_agency.

partnerstring

Source field partner.

agency_client_declarationjson

Source field agency_client_declaration.

capabilitiesjson

Source field capabilities.

funding_sourcestring

Source field funding_source.

tos_acceptedjson

Source field tos_accepted.

ad_creatives#

titan.facebook_ads.ad_creatives has 101 source columns.

facebook_ads.ad_creatives101 columns
idstringpk

Source field id.

account_idstring

Source field account_id.

namestring

Source field name.

statusstring

Source field status.

bodystring

Source field body.

titlestring

Source field title.

call_to_action_typestring

Source field call_to_action_type.

image_hashstring

Source field image_hash.

image_urlstring

Source field image_url.

thumbnail_urlstring

Source field thumbnail_url.

url_tagsstring

Source field url_tags.

object_typestring

Source field object_type.

object_story_specjson

Source field object_story_spec.

effective_object_story_idstring

Source field effective_object_story_id.

asset_feed_specjson

Source field asset_feed_spec.

video_idstring

Source field video_id.

object_idstring

Source field object_id.

object_urlstring

Source field object_url.

object_story_idstring

Source field object_story_id.

actor_idstring

Source field actor_id.

product_set_idstring

Source field product_set_id.

source_instagram_media_idstring

Source field source_instagram_media_id.

instagram_user_idstring

Source field instagram_user_id.

effective_instagram_media_idstring

Source field effective_instagram_media_id.

template_urlstring

Source field template_url.

authorization_categorystring

Source field authorization_category.

effective_authorization_categorystring

Source field effective_authorization_category.

enable_direct_installboolean

Source field enable_direct_install.

thumbnail_idstring

Source field thumbnail_id.

bundle_folder_idstring

Source field bundle_folder_id.

categorization_criteriastring

Source field categorization_criteria.

category_media_sourcestring

Source field category_media_source.

destination_set_idstring

Source field destination_set_id.

dynamic_ad_voicestring

Source field dynamic_ad_voice.

messenger_sponsored_messagestring

Source field messenger_sponsored_message.

object_store_urlstring

Source field object_store_url.

place_page_set_idstring

Source field place_page_set_id.

playable_asset_idstring

Source field playable_asset_id.

branded_content_sponsor_page_idstring

Source field branded_content_sponsor_page_id.

effective_instagram_story_idstring

Source field effective_instagram_story_id.

instagram_actor_idstring

Source field instagram_actor_id.

instagram_story_idstring

Source field instagram_story_id.

use_page_actor_overrideboolean

Source field use_page_actor_override.

object_story_link_data_captionstring

Source field object_story_link_data_caption.

object_story_link_data_descriptionstring

Source field object_story_link_data_description.

object_story_link_data_linkstring

Source field object_story_link_data_link.

object_story_link_data_messagestring

Source field object_story_link_data_message.

object_story_link_data_child_attachmentsjson

Source field object_story_link_data_child_attachments.

object_story_link_data_app_link_spec_androidjson

Source field object_story_link_data_app_link_spec_android.

object_story_link_data_app_link_spec_iosjson

Source field object_story_link_data_app_link_spec_ios.

object_story_link_data_app_link_spec_ipadjson

Source field object_story_link_data_app_link_spec_ipad.

object_story_link_data_app_link_spec_iphonejson

Source field object_story_link_data_app_link_spec_iphone.

video_video_idstring

Source field video_video_id.

template_captionstring

Source field template_caption.

template_descriptionstring

Source field template_description.

template_messagestring

Source field template_message.

template_child_attachmentsjson

Source field template_child_attachments.

template_url_spec_web_urlstring

Source field template_url_spec_web_url.

template_url_spec_web_should_fallbackboolean

Source field template_url_spec_web_should_fallback.

template_url_spec_ios_urlstring

Source field template_url_spec_ios_url.

template_url_spec_ios_app_namestring

Source field template_url_spec_ios_app_name.

template_url_spec_ios_app_store_idstring

Source field template_url_spec_ios_app_store_id.

template_url_spec_iphone_urlstring

Source field template_url_spec_iphone_url.

template_url_spec_iphone_app_namestring

Source field template_url_spec_iphone_app_name.

template_url_spec_iphone_app_store_idstring

Source field template_url_spec_iphone_app_store_id.

template_url_spec_ipad_urlstring

Source field template_url_spec_ipad_url.

template_url_spec_ipad_app_namestring

Source field template_url_spec_ipad_app_name.

template_url_spec_ipad_app_store_idstring

Source field template_url_spec_ipad_app_store_id.

template_url_spec_android_urlstring

Source field template_url_spec_android_url.

template_url_spec_android_app_namestring

Source field template_url_spec_android_app_name.

template_url_spec_android_packagestring

Source field template_url_spec_android_package.

template_url_spec_windows_phone_urlstring

Source field template_url_spec_windows_phone_url.

template_url_spec_windows_phone_app_namestring

Source field template_url_spec_windows_phone_app_name.

template_url_spec_windows_phone_app_idstring

Source field template_url_spec_windows_phone_app_id.

template_url_spec_config_app_idstring

Source field template_url_spec_config_app_id.

platform_customizations_instagram_image_hashstring

Source field platform_customizations_instagram_image_hash.

platform_customizations_instagram_image_urlstring

Source field platform_customizations_instagram_image_url.

platform_customizations_instagram_video_idstring

Source field platform_customizations_instagram_video_id.

platform_customizations_instagram_caption_idsjson

Source field platform_customizations_instagram_caption_ids.

asset_feed_spec_additional_data_multi_share_end_cardboolean

Source field asset_feed_spec_additional_data_multi_share_end_card.

asset_feed_spec_additional_data_is_click_to_messageboolean

Source field asset_feed_spec_additional_data_is_click_to_message.

asset_feed_spec_additional_data_brand_page_idstring

Source field asset_feed_spec_additional_data_brand_page_id.

asset_feed_spec_app_product_page_idstring

Source field asset_feed_spec_app_product_page_id.

asset_feed_spec_shops_bundlejson

Source field asset_feed_spec_shops_bundle.

asset_feed_spec_additional_data_partner_app_welcome_message_flow_idstring

Source field asset_feed_spec_additional_data_partner_app_welcome_message_flow_id.

page_linkstring

Source field page_link.

page_messagestring

Source field page_message.

template_page_linkstring

Source field template_page_link.

custom_audiences#

titan.facebook_ads.custom_audiences has 28 source columns.

facebook_ads.custom_audiences28 columns
idstringpk

Source field id.

account_idstring

Source field account_id.

namestring

Source field name.

descriptionstring

Source field description.

subtypestring

Source field subtype.

approximate_count_lower_boundinteger

Source field approximate_count_lower_bound.

approximate_count_upper_boundinteger

Source field approximate_count_upper_bound.

time_createddatetime

Source field time_created.

time_updateddatetime

Source field time_updated.

retention_daysinteger

Source field retention_days.

is_value_basedboolean

Source field is_value_based.

customer_file_sourcestring

Source field customer_file_source.

data_source_typestring

Source field data_source_type.

data_source_sub_typestring

Source field data_source_sub_type.

delivery_status_codeinteger

Source field delivery_status_code.

delivery_status_descriptionstring

Source field delivery_status_description.

operation_status_codeinteger

Source field operation_status_code.

operation_status_descriptionstring

Source field operation_status_description.

rulestring

Source field rule.

lookalike_specjson

Source field lookalike_spec.

pixel_idstring

Source field pixel_id.

sharing_statusstring

Source field sharing_status.

time_content_updateddatetime

Source field time_content_updated.

lookalike_audience_idsjson

Source field lookalike_audience_ids.

permission_for_actionsjson

Source field permission_for_actions.

page_deletion_marked_delete_timeinteger

Source field page_deletion_marked_delete_time.

rule_aggregationstring

Source field rule_aggregation.

custom_conversions#

titan.facebook_ads.custom_conversions has 18 source columns.

facebook_ads.custom_conversions18 columns
idstringpk

Source field id.

account_idstring

Source field account_id.

namestring

Source field name.

descriptionstring

Source field description.

custom_event_typestring

Source field custom_event_type.

default_conversion_valueinteger

Source field default_conversion_value.

is_archivedboolean

Source field is_archived.

is_unavailableboolean

Source field is_unavailable.

rulestring

Source field rule.

retention_daysinteger

Source field retention_days.

creation_timedatetime

Source field creation_time.

first_fired_timedatetime

Source field first_fired_time.

last_fired_timedatetime

Source field last_fired_time.

event_source_typestring

Source field event_source_type.

business_idstring

Source field business_id.

business_namestring

Source field business_name.

data_sourcesjson

Source field data_sources.

offline_conversion_data_setjson

Source field offline_conversion_data_set.

ad_images#

titan.facebook_ads.ad_images has 17 source columns.

facebook_ads.ad_images17 columns
idstringpk

Source field id.

account_idstring

Source field account_id.

hashstring

Source field hash.

namestring

Source field name.

statusstring

Source field status.

urlstring

Source field url.

url_128string

Source field url_128.

heightinteger

Source field height.

widthinteger

Source field width.

original_heightinteger

Source field original_height.

original_widthinteger

Source field original_width.

is_associated_creatives_in_adgroupsboolean

Source field is_associated_creatives_in_adgroups.

created_timedatetime

Source field created_time.

updated_timedatetime

Source field updated_time.

creativesjson

Source field creatives.

hash_2string

Source field hash_2.

ad_videos#

titan.facebook_ads.ad_videos has 33 source columns.

facebook_ads.ad_videos33 columns
idstringpk

Source field id.

titlestring

Source field title.

descriptionstring

Source field description.

lengthfloat

Source field length.

sourcestring

Source field source.

picturestring

Source field picture.

embed_htmlstring

Source field embed_html.

video_statusstring

Source field video_status.

uploading_phase_statusstring

Source field uploading_phase_status.

processing_phase_statusstring

Source field processing_phase_status.

publishing_phase_statusstring

Source field publishing_phase_status.

publishing_phase_publish_statusstring

Source field publishing_phase_publish_status.

publishing_phase_publish_timedatetime

Source field publishing_phase_publish_time.

created_timedatetime

Source field created_time.

updated_timedatetime

Source field updated_time.

viewsinteger

Source field views.

post_viewsinteger

Source field post_views.

iconstring

Source field icon.

embeddableboolean

Source field embeddable.

formatjson

Source field format.

content_categorystring

Source field content_category.

content_tagsjson

Source field content_tags.

custom_labelsjson

Source field custom_labels.

ad_breaksjson

Source field ad_breaks.

is_crosspost_videoboolean

Source field is_crosspost_video.

is_crossposting_eligibleboolean

Source field is_crossposting_eligible.

is_episodeboolean

Source field is_episode.

is_instagram_eligibleboolean

Source field is_instagram_eligible.

live_statusstring

Source field live_status.

publishedboolean

Source field published.

universal_video_idstring

Source field universal_video_id.

account_idstring

Source field account_id.

activities#

titan.facebook_ads.activities has 12 source columns.

facebook_ads.activities12 columns
event_timedatetimepk

Source field event_time.

actor_idstringpk

Source field actor_id.

object_idstringpk

Source field object_id.

event_typestringpk

Source field event_type.

actor_namestring

Source field actor_name.

application_idstring

Source field application_id.

application_namestring

Source field application_name.

translated_event_typestring

Source field translated_event_type.

date_time_in_timezonestring

Source field date_time_in_timezone.

object_namestring

Source field object_name.

object_typestring

Source field object_type.

extra_datastring

Source field extra_data.

ad_labels#

titan.facebook_ads.ad_labels has 4 source columns.

facebook_ads.ad_labels4 columns
idstringpk

Source field id.

namestring

Source field name.

created_timedatetime

Source field created_time.

updated_timedatetime

Source field updated_time.

ad_rules#

titan.facebook_ads.ad_rules has 9 source columns.

facebook_ads.ad_rules9 columns
idstringpk

Source field id.

account_idstring

Source field account_id.

namestring

Source field name.

statusstring

Source field status.

created_timedatetime

Source field created_time.

updated_timedatetime

Source field updated_time.

execution_specjson

Source field execution_spec.

evaluation_specjson

Source field evaluation_spec.

schedule_specjson

Source field schedule_spec.

saved_audiences#

titan.facebook_ads.saved_audiences has 11 source columns.

facebook_ads.saved_audiences11 columns
idstringpk

Source field id.

namestring

Source field name.

descriptionstring

Source field description.

approximate_count_lower_boundinteger

Source field approximate_count_lower_bound.

approximate_count_upper_boundinteger

Source field approximate_count_upper_bound.

run_statusstring

Source field run_status.

time_createddatetime

Source field time_created.

time_updateddatetime

Source field time_updated.

targetingjson

Source field targeting.

sentence_linesjson

Source field sentence_lines.

permission_for_actionsjson

Source field permission_for_actions.

ad_label_campaigns#

titan.facebook_ads.ad_label_campaigns has 3 source columns.

facebook_ads.ad_label_campaigns3 columns
campaign_idstringpk

Source field campaign_id.

ad_label_idstringpk

Source field ad_label_id.

ad_label_namestring

Source field ad_label_name.

ad_label_ad_sets#

titan.facebook_ads.ad_label_ad_sets has 3 source columns.

facebook_ads.ad_label_ad_sets3 columns
ad_set_idstringpk

Source field ad_set_id.

ad_label_idstringpk

Source field ad_label_id.

ad_label_namestring

Source field ad_label_name.

ad_label_ads#

titan.facebook_ads.ad_label_ads has 3 source columns.

facebook_ads.ad_label_ads3 columns
ad_idstringpk

Source field ad_id.

ad_label_idstringpk

Source field ad_label_id.

ad_label_namestring

Source field ad_label_name.

campaign_insights#

titan.facebook_ads.campaign_insights has 38 source columns.

facebook_ads.campaign_insights38 columns
campaign_idstringpk

Source field campaign_id.

date_startdatepk

Source field date_start.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

objectivestring

Source field objective.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_set_insights#

titan.facebook_ads.ad_set_insights has 38 source columns.

facebook_ads.ad_set_insights38 columns
adset_idstringpk

Source field adset_id.

date_startdatepk

Source field date_start.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights#

titan.facebook_ads.ad_insights has 41 source columns.

facebook_ads.ad_insights41 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

campaign_insights_actions#

titan.facebook_ads.campaign_insights_actions has 8 source columns.

facebook_ads.campaign_insights_actions8 columns
campaign_idstringpk

Source field campaign_id.

date_startdatepk

Source field date_start.

action_typestringpk

Source field action_type.

valueinteger

Source field value.

_1d_clickinteger

Source field _1d_click.

_7d_clickinteger

Source field _7d_click.

_28d_clickinteger

Source field _28d_click.

_1d_viewinteger

Source field _1d_view.

campaign_insights_action_values#

titan.facebook_ads.campaign_insights_action_values has 8 source columns.

facebook_ads.campaign_insights_action_values8 columns
campaign_idstringpk

Source field campaign_id.

date_startdatepk

Source field date_start.

action_typestringpk

Source field action_type.

valuedecimal(28,2)

Source field value.

_1d_clickdecimal(28,2)

Source field _1d_click.

_7d_clickdecimal(28,2)

Source field _7d_click.

_28d_clickdecimal(28,2)

Source field _28d_click.

_1d_viewdecimal(28,2)

Source field _1d_view.

ad_set_insights_actions#

titan.facebook_ads.ad_set_insights_actions has 8 source columns.

facebook_ads.ad_set_insights_actions8 columns
adset_idstringpk

Source field adset_id.

date_startdatepk

Source field date_start.

action_typestringpk

Source field action_type.

valueinteger

Source field value.

_1d_clickinteger

Source field _1d_click.

_7d_clickinteger

Source field _7d_click.

_28d_clickinteger

Source field _28d_click.

_1d_viewinteger

Source field _1d_view.

ad_set_insights_action_values#

titan.facebook_ads.ad_set_insights_action_values has 8 source columns.

facebook_ads.ad_set_insights_action_values8 columns
adset_idstringpk

Source field adset_id.

date_startdatepk

Source field date_start.

action_typestringpk

Source field action_type.

valuedecimal(28,2)

Source field value.

_1d_clickdecimal(28,2)

Source field _1d_click.

_7d_clickdecimal(28,2)

Source field _7d_click.

_28d_clickdecimal(28,2)

Source field _28d_click.

_1d_viewdecimal(28,2)

Source field _1d_view.

ad_insights_actions#

titan.facebook_ads.ad_insights_actions has 8 source columns.

facebook_ads.ad_insights_actions8 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

action_typestringpk

Source field action_type.

valueinteger

Source field value.

_1d_clickinteger

Source field _1d_click.

_7d_clickinteger

Source field _7d_click.

_28d_clickinteger

Source field _28d_click.

_1d_viewinteger

Source field _1d_view.

ad_insights_action_values#

titan.facebook_ads.ad_insights_action_values has 8 source columns.

facebook_ads.ad_insights_action_values8 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

action_typestringpk

Source field action_type.

valuedecimal(28,2)

Source field value.

_1d_clickdecimal(28,2)

Source field _1d_click.

_7d_clickdecimal(28,2)

Source field _7d_click.

_28d_clickdecimal(28,2)

Source field _28d_click.

_1d_viewdecimal(28,2)

Source field _1d_view.

ad_insights_age_and_gender#

titan.facebook_ads.ad_insights_age_and_gender has 43 source columns.

facebook_ads.ad_insights_age_and_gender43 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

agestringpk

Source field age.

genderstringpk

Source field gender.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights_country#

titan.facebook_ads.ad_insights_country has 42 source columns.

facebook_ads.ad_insights_country42 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

countrystringpk

Source field country.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights_region#

titan.facebook_ads.ad_insights_region has 42 source columns.

facebook_ads.ad_insights_region42 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

regionstringpk

Source field region.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights_dma#

titan.facebook_ads.ad_insights_dma has 42 source columns.

facebook_ads.ad_insights_dma42 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

dmastringpk

Source field dma.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights_platform_and_device#

titan.facebook_ads.ad_insights_platform_and_device has 44 source columns.

facebook_ads.ad_insights_platform_and_device44 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

publisher_platformstringpk

Source field publisher_platform.

platform_positionstringpk

Source field platform_position.

impression_devicestringpk

Source field impression_device.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights_action_type#

titan.facebook_ads.ad_insights_action_type has 41 source columns.

facebook_ads.ad_insights_action_type41 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights_action_carousel_card#

titan.facebook_ads.ad_insights_action_carousel_card has 41 source columns.

facebook_ads.ad_insights_action_carousel_card41 columns

ad_insights_action_product_id#

titan.facebook_ads.ad_insights_action_product_id has 42 source columns.

facebook_ads.ad_insights_action_product_id42 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

product_idstringpk

Source field product_id.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights_action_reaction#

titan.facebook_ads.ad_insights_action_reaction has 41 source columns.

facebook_ads.ad_insights_action_reaction41 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights_action_video_sound#

titan.facebook_ads.ad_insights_action_video_sound has 41 source columns.

facebook_ads.ad_insights_action_video_sound41 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights_action_video_type#

titan.facebook_ads.ad_insights_action_video_type has 41 source columns.

facebook_ads.ad_insights_action_video_type41 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights_delivery_device#

titan.facebook_ads.ad_insights_delivery_device has 42 source columns.

facebook_ads.ad_insights_delivery_device42 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

device_platformstringpk

Source field device_platform.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights_delivery_platform#

titan.facebook_ads.ad_insights_delivery_platform has 42 source columns.

facebook_ads.ad_insights_delivery_platform42 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

publisher_platformstringpk

Source field publisher_platform.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

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.

facebook_ads.ad_insights_delivery_platform_and_device_platform43 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

publisher_platformstringpk

Source field publisher_platform.

device_platformstringpk

Source field device_platform.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights_demographics_age#

titan.facebook_ads.ad_insights_demographics_age has 42 source columns.

facebook_ads.ad_insights_demographics_age42 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

agestringpk

Source field age.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights_demographics_country#

titan.facebook_ads.ad_insights_demographics_country has 42 source columns.

facebook_ads.ad_insights_demographics_country42 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

countrystringpk

Source field country.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

Source field video_avg_time_watched_actions.

ad_insights_demographics_dma_region#

titan.facebook_ads.ad_insights_demographics_dma_region has 42 source columns.

facebook_ads.ad_insights_demographics_dma_region42 columns
ad_idstringpk

Source field ad_id.

date_startdatepk

Source field date_start.

dmastringpk

Source field dma.

ad_namestring

Source field ad_name.

adset_idstring

Source field adset_id.

adset_namestring

Source field adset_name.

campaign_idstring

Source field campaign_id.

campaign_namestring

Source field campaign_name.

account_idstring

Source field account_id.

date_stopdate

Source field date_stop.

impressionsinteger

Source field impressions.

clicksinteger

Source field clicks.

spenddecimal(28,2)

Source field spend.

reachinteger

Source field reach.

frequencyfloat

Source field frequency.

cpcdecimal(28,6)

Source field cpc.

cpmdecimal(28,6)

Source field cpm.

cppdecimal(28,6)

Source field cpp.

ctrdecimal(28,6)

Source field ctr.

cost_per_unique_clickdecimal(28,6)

Source field cost_per_unique_click.

unique_clicksinteger

Source field unique_clicks.

unique_ctrdecimal(28,6)

Source field unique_ctr.

social_spenddecimal(28,2)

Source field social_spend.

quality_rankingstring

Source field quality_ranking.

engagement_rate_rankingstring

Source field engagement_rate_ranking.

conversion_rate_rankingstring

Source field conversion_rate_ranking.

actionsjson

Source field actions.

action_valuesjson

Source field action_values.

conversionsjson

Source field conversions.

conversion_valuesjson

Source field conversion_values.

cost_per_action_typejson

Source field cost_per_action_type.

outbound_clicksjson

Source field outbound_clicks.

cost_per_outbound_clickjson

Source field cost_per_outbound_click.

purchase_roasjson

Source field purchase_roas.

video_p25_watched_actionsjson

Source field video_p25_watched_actions.

video_p50_watched_actionsjson

Source field video_p50_watched_actions.

video_p75_watched_actionsjson

Source field video_p75_watched_actions.

video_p100_watched_actionsjson

Source field video_p100_watched_actions.

video_avg_time_watched_actionsjson

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.