Facebook Ads Predefined Reports
  • 11 Minutes to read
  • Dark
    Light
  • PDF

Facebook Ads Predefined Reports

  • Dark
    Light
  • PDF

Article summary

Predefined Reports

The Facebook Ads datasource in Rivery comes with the below predefined reports. Each report will have a short description of the data, a list of customizable fields (if any), and the schema mapping. Due to the standardized nature of these reports, there are a number of locked fields that will only be accessible through the custom reporting functionality.

Source-Level Selections

Facebook Ad's one source-level selection is an Ad Accounts filter. Choosing distinct values will filter down each report within the river to only the selected ad accounts' data.

Ad Account

The Ad Account report returns the details on each ad account.

FieldData TypeDimension/Metric
_id system schemaStringDimension
_account_idStringDimension
_account_statusIntegerMetric
_ageFloatMetric
_amount_spentStringDimension
_balanceStringDimension
_businessRecordDimension
_business_cityStringDimension
_business_country_codeStringDimension
_business_nameStringDimension
_business_stateStringDimension
_business_streetStringDimension
_business_street2StringDimension
_business_zipStringDimension
_can_create_brand_lift_studyBooleanDimension
_capabilitiesStringDimension
_created_timeStringDimension
_currencyStringDimension
_disable_reasonIntegerMetric
_end_advertiserStringDimension
_end_advertiser_nameStringDimension
_funding_sourceStringDimension
_funding_source_detailsRecordDimension
_has_migrated_permissionsBooleanDimension
_account_nameStringDimension
_ios_fourteen_campaign_limits_campaign_group_limitIntegerMetric
_ios_fourteen_campaign_limits_campaign_limitIntegerMetric
_is_attribution_spec_system_defaultBooleanDimension
_is_direct_deals_enabledBooleanDimension
_is_in_3ds_authorization_enabled_marketBooleanDimension
_is_notifications_enabledBooleanDimension
_is_personalIntegerMetric
_is_prepay_accountBooleanDimension
_is_tax_id_requiredBooleanDimension
_min_campaign_group_spend_capStringDimension
_min_daily_budgetIntegerMetric
_offsite_pixels_tos_acceptedBooleanDimension
_ownerStringDimension
_spend_capStringDimension
_tax_idStringDimension
_tax_id_statusIntegerDimension
_tax_id_typeStringDimension
_timezone_idIntegerDimension
_timezone_nameStringDimension
_timezone_offset_hours_utcIntegerMetric
_tos_acceptedRecordDimension
_user_tasksStringDimension

Ad Account Activities

The Ad Account Activities report retrieves information on key updates to an ad account and ad objects associated with it. The user can customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
_account_id system schemaStringDimension
_event_timeStringDimension
_actor_nameStringDimension
_application_idStringDimension
_application_nameStringDimension
_categoryStringDimension
_date_time_in_timezoneStringDimension
_actor_idStringDimension
_event_typeStringDimension
_extra_dataStringDimension
_object_idStringDimension
_object_nameStringDimension
_object_typeStringDimension
_translated_event_typeStringDimension

Campaigns

The Campaigns report returns the details on each campaign within the ad account(s). The user can customize the output by using the Campaigns filter option.

FieldData TypeDimension/Metric
_campaign_id system schemaStringDimension
_account_id system schemaStringDimension
_effective_statusStringDimension
_budget_remainingStringDimension
_buying_typeStringDimension
_campagin_nameStringDimension
_budget_rebalance_flagBooleanDimension
_can_create_brand_lift_studyBooleanDimension
_can_use_spend_capBooleanDimension
_configured_statusStringDimension
_created_timeStringDimension
_bid_strategyStringDimension
_is_skadnetwork_attributionBooleanDimension
_lifetime_budgetStringDimension
_objectiveStringDimension
_source_campaignRecordDimension
_source_campaign_idStringDimension
_special_ad_categoryStringDimension
_start_timeStringDimension
_statusStringDimension
_stop_timeStringDimension
_topline_idStringDimension
_updated_timeStringDimension

Adsets

The Adsets report returns the details on each adset within the ad account(s). The user can customize the output by using the Campaigns and/or Adsets filter options.

FieldData TypeDimension/Metric
_account_id system schemaStringDimension
_adset_id system schemaStringDimension
_campaign_id system schemaStringDimension
_behaviors_full_details_stringStringDimension
_age_maxIntegerMetric
_age_minIntegerMetric
_attribution_specRecordDimension
_behaviors_full_detailsRecordDimension
_adset_scheduleRecordDimension
_behaviors_idsStringDimension
_behaviors_ids_stringStringDimension
_behaviors_namesStringDimension
_behaviors_names_stringStringDimension
_bid_amountIntegerMetric
_bid_infoRecordDimension
_bid_strategyStringDimension
_billing_eventStringDimension
_budget_remainingStringDimension
_campaignRecordDimension
_adset_nameStringDimension
_configured_statusStringDimension
_created_timeStringDimension
_custom_audience_full_detailsRecordDimension
_custom_audience_full_details_stringStringDimension
_custom_audience_idsStringDimension
_custom_audience_ids_stringStringDimension
_custom_audience_namesStringDimension
_custom_audience_names_stringStringDimension
_daily_budgetStringDimension
_destination_typeStringDimension
_deviceStringDimension
_effective_statusStringDimension
_end_timeStringDimension
_excluded_custom_audiences_full_detailsStringDimension
_excluded_custom_audiences_full_details_stringStringDimension
_excluded_custom_audiences_idsStringDimension
_excluded_custom_audiences_ids_stringStringDimension
_excluded_custom_audiences_namesStringDimension
_excluded_custom_audiences_stringStringDimension
_excluded_geo_countriesStringDimension
_frequency_control_specsRecordDimension
_gendersStringDimension
_geo_countriesStringDimension
_interests_full_detailsRecordDimension
_interests_full_details_stringStringDimension
_interests_idsStringDimension
_interests_ids_stringStringDimension
_interests_namesStringDimension
_interests_names_stringStringDimension
_is_dynamic_creativeBooleanDimension
_lal_percentageStringDimension
_lal_percentage_stringStringDimension
_lifetime_budgetStringDimension
_lifetime_impsIntegerMetric
_optimization_goalStringDimension
_optimization_sub_eventStringDimension
_pacing_typeStringDimension
_promoted_objectRecordDimension
_recommendationsRecordDimension
_recurring_budget_semanticsBooleanDimension
_seed_audienceStringDimension
_source_adsetRecordDimension
_source_adset_idStringDimension
_start_timeStringDimension
_statusStringDimension
_updated_timeStringDimension
_use_new_app_clickBooleanDimension
_user_osStringDimension
_user_os_stringStringDimension

Ads

The Ads report returns the details on each ad within the ad account(s). The user can customize the output by using the Campaigns, Adsets, and/or Ads filter options. The type of incremental load associated with this report is also customizable.

FieldData TypeDimension/Metric
_adset_id system schemaStringDimension
_ad_id system schemaStringDimension
_account_id system schemaStringDimension
_campaign_id system schemaStringDimension
_created_timeStringDimension
_bid_typeStringDimension
_campaignRecordDimension
_adsetRecordDimension
_configured_statusStringDimension
_conversion_specsRecordDimension
_ad_nameStringDimension
_creativeRecordDimension
_creative_idStringDimension
_display_sequenceIntegerMetric
_effective_statusStringDimension
_last_updated_by_app_idStringDimension
_recommendationsRecordDimension
_source_ad_idStringDimension
_statusStringDimension
_tracking_specsRecordDimension
_updated_timeStringDimension

Ad Creatives

The Ad Creatives report returns the details on each creative within the ad account(s). The user can customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
_creative_id system schemaStringDimension
_account_id system schemaStringDimension
_portrait_customizationsRecordDimension
_bodyStringDimension
_call_to_action_typeStringDimension
_authorization_categoryStringDimension
_creative_nameStringDimension
_effective_authorization_categoryStringDimension
_effective_instagram_media_idStringDimension
_effective_instagram_story_idStringDimension
_effective_object_story_idStringDimension
_image_hashStringDimension
_image_urlStringDimension
_instagram_actor_idStringDimension
_instagram_permalink_urlStringDimension
_instagram_user_idStringDimension
_linkStringDimension
_object_story_specRecordDimension
_object_typeStringDimension
_asset_feed_specRecordDimension
_statusStringDimension
_thumbnail_urlStringDimension
_titleStringDimension
_use_page_actor_overrideBooleanDimension
_video_idStringDimension
post_attachmentsRecordDimension
post_call_to_actionRecordDimension
post_created_timeStringDimension
post_fromRecordDimension
post_full_pictureStringDimension
post_iconStringDimension
post_idStringDimension
post_instagram_eligibilityStringDimension
post_object_idStringDimension
post_typeStringDimension
video_content_categoryStringDimension
video_created_timeStringDimension
video_descriptionStringDimension
video_idStringDimension

Ads Pixels

The Ads Pixels report returns a list of the pixels within the ad account(s) and the details associated with each. The user can customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
_account_id system schemaStringDimension
_id system schemaStringDimension
_first_party_cookie_statusStringDimension
_can_proxyBooleanDimension
_codeStringDimension
_creation_timeStringDimension
_creatorRecordDimension
_data_use_settingStringDimension
_enable_automatic_matchingBooleanDimension
_automatic_matching_fieldsStringDimension
_aggregationStringDimension
_is_created_by_businessBooleanDimension
_is_unavailableBooleanDimension
_last_fired_timeStringDimension
_nameStringDimension
_owner_ad_accountRecordDimension
_owner_businessRecordDimension
_start_timeStringDimension
_statsRecordDimension

Ad Leads

The Ad Leads reports returns a list of leads captured with ads from the ad account. The user can customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
_account_id system schemaStringDimension
_lead_id system schemaStringDimension
_form_page_nameStringDimension
_form_localeStringDimension
_form_nameStringDimension
_form_page_idStringDimension
_form_idStringDimension
_form_statusStringDimension
_is_organicBooleanDimension
_lead_form_field_nameStringDimension
_lead_form_field_valueStringDimension
_created_timeStringDimension
_platformStringDimension

Ad Leads Forms

The Ad Leads Forms report returns details on each of the Lead forms created within the account. The user can customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
id system schemaStringDimension
_account_id system schemaStringDimension
localeStringDimension
context_cardRecordDimension
created_timeStringDimension
expired_leads_countIntegerMetric
follow_up_action_urlStringDimension
block_display_for_non_targeted_viewerBooleanDimension
is_optimized_for_qualityBooleanDimension
leads_countIntegerMetric
legal_contentRecordDimension
allow_organic_leadBooleanDimension
nameStringDimension
organic_leads_countIntegerMetric
pageRecordDimension
page_idStringDimension
page_nameStringDimension
privacy_policy_urlStringDimension
question_page_custom_headlineStringDimension
questionsRecordDimension
statusStringDimension
thank_you_pageRecordDimension

Insight Report Basic

The Insight Report Basic report returns daily metrics on each Ad within the ad account. The user can customize the output by using the Campaigns, Adsets, and/or Ads filter options. The type of incremental load associated with this report is also customizable.

FieldData TypeDimension/Metric
_adset_id system schemaStringDimension
_account_id system schemaStringDimension
_date_start system schemaStringDimension
_ad_id system schemaStringDimension
_campaign_id system schemaStringDimension
_impressionsStringDimension
_adset_nameStringDimension
_ad_nameStringDimension
_campaign_nameStringDimension
_clicksStringDimension
_conversionsRecordDimension
_cost_per_action_typeRecordDimension
_cost_per_conversionRecordDimension
_cpcStringDimension
_cpmStringDimension
_cppStringDimension
_ctrStringDimension
_currencyStringDimension
_actionsRecordDimension
_date_stopStringDimension
_frequencyStringDimension
_account_nameStringDimension
_inline_link_clicksStringDimension
_outbound_clicksRecordDimension
_outbound_clicks_ctrRecordDimension
_reachStringDimension
_social_spendStringDimension
_spendStringDimension
_unique_actionsRecordDimension
_unique_clicksStringDimension
_unique_ctrStringDimension
_unique_inline_link_click_ctrStringDimension
_unique_inline_link_clicksStringDimension
_unique_link_clicks_ctrStringDimension
_unique_outbound_clicksRecordDimension
_unique_outbound_clicks_ctrRecordDimension
_video_avg_time_watched_actionsRecordDimension
_video_p100_watched_actionsRecordDimension
_video_p25_watched_actionsRecordDimension
_video_p50_watched_actionsRecordDimension
_video_p75_watched_actionsRecordDimension
_video_p95_watched_actionsRecordDimension

Insight Report Platform

The Insight Report Platform report returns daily metrics on each Ad within the ad account grouped by the platform. The user can customize the output by using the Campaigns, Adsets, and/or Ads filter options. The type of incremental load associated with this report is also customizable.

FieldData TypeDimension/Metric
_campaign_id system schemaStringDimension
_publisher_platform system schemaStringDimension
_platform_position system schemaStringDimension
_date_start system schemaStringDimension
_ad_id system schemaStringDimension
_account_id system schemaStringDimension
_adset_id system schemaStringDimension
_ad_nameStringDimension
_adset_nameStringDimension
_campaign_nameStringDimension
_clicksStringDimension
_cost_per_action_typeRecordDimension
_cpcStringDimension
_cpmStringDimension
_cppStringDimension
_ctrStringDimension
_currencyStringDimension
_actionsRecordDimension
_date_stopStringDimension
_frequencyStringDimension
_impressionsStringDimension
_inline_link_clicksStringDimension
_outbound_clicksRecordDimension
_outbound_clicks_ctrRecordDimension
_action_valuesRecordDimension
_account_nameStringDimension
_reachStringDimension
_spendIntegerMetric
_unique_actionsRecordDimension
_unique_clicksStringDimension
_unique_ctrStringDimension
_unique_inline_link_click_ctrStringDimension
_unique_inline_link_clicksStringDimension
_unique_link_clicks_ctrStringDimension
_unique_outbound_clicksRecordDimension
_unique_outbound_clicks_ctrRecordDimension
_video_avg_time_watched_actionsRecordDimension
_video_p100_watched_actionsRecordDimension
_video_p25_watched_actionsRecordDimension
_video_p50_watched_actionsRecordDimension
_video_p75_watched_actionsRecordDimension
_video_p95_watched_actionsRecordDimension

Insight Report Age Gender

The Insight Report Age Gender report returns daily metrics on each Ad within the ad account grouped by the Age and Gender buckets. The user can customize the output by using the Campaigns, Adsets, and/or Ads filter options. The type of incremental load associated with this report is also customizable.

FieldData TypeDimension/Metric
_age system schemaStringDimension
_gender system schemaStringDimension
_date_start system schemaStringDimension
_campaign_id system schemaStringDimension
_ad_id system schemaStringDimension
_account_id system schemaStringDimension
_adset_id system schemaStringDimension
_ad_nameStringDimension
_adset_nameStringDimension
_actionsRecordDimension
_campaign_nameStringDimension
_clicksStringDimension
_conversionsRecordDimension
_cost_per_action_typeRecordDimension
_cpcStringDimension
_cpmStringDimension
_cppStringDimension
_ctrStringDimension
_currencyStringDimension
_action_valuesRecordDimension
_date_stopStringDimension
_frequencyStringDimension
_account_nameStringDimension
_impressionsStringDimension
_inline_link_clicksStringDimension
_outbound_clicksRecordDimension
_outbound_clicks_ctrRecordDimension
_reachStringDimension
_spendStringDimension
_unique_actionsRecordDimension
_unique_clicksStringDimension
_unique_ctrStringDimension
_unique_inline_link_click_ctrStringDimension
_unique_inline_link_clicksStringDimension
_unique_link_clicks_ctrStringDimension
_unique_outbound_clicksRecordDimension
_unique_outbound_clicks_ctrRecordDimension
_video_avg_time_watched_actionsRecordDimension
_video_p100_watched_actionsRecordDimension
_video_p25_watched_actionsRecordDimension
_video_p50_watched_actionsRecordDimension
_video_p75_watched_actionsRecordDimension
_video_p95_watched_actionsRecordDimension

Insight Report Country

The Insight Report Country report returns daily metrics on each Ad within the ad account grouped by the country. The user can customize the output by using the Campaigns, Adsets, and/or Ads filter options. The type of incremental load associated with this report is also customizable.

FieldData TypeDimension/Metric
_adset_id system schemaStringDimension
_date_start system schemaStringDimension
_country system schemaStringDimension
_campaign_id system schemaStringDimension
_ad_id system schemaStringDimension
_account_id system schemaStringDimension
_ad_nameStringDimension
_adset_nameStringDimension
_actionsRecordDimension
_campaign_nameStringDimension
_clicksStringDimension
_cost_per_action_typeRecordDimension
_action_valuesRecordDimension
_cpcStringDimension
_cpmStringDimension
_cppStringDimension
_ctrStringDimension
_currencyStringDimension
_account_nameStringDimension
_date_stopStringDimension
_frequencyStringDimension
_impressionsStringDimension
_inline_link_clicksStringDimension
_outbound_clicksRecordDimension
_outbound_clicks_ctrRecordDimension
_reachStringDimension
_spendStringDimension
_unique_actionsRecordDimension
_unique_clicksStringDimension
_unique_ctrStringDimension
_unique_inline_link_click_ctrStringDimension
_unique_inline_link_clicksStringDimension
_unique_link_clicks_ctrStringDimension
_unique_outbound_clicksRecordDimension
_unique_outbound_clicks_ctrRecordDimension
_video_avg_time_watched_actionsRecordDimension
_video_continuous_2_sec_watched_actionsRecordDimension
_video_p100_watched_actionsRecordDimension
_video_p25_watched_actionsRecordDimension
_video_p50_watched_actionsRecordDimension
_video_p75_watched_actionsRecordDimension
_video_p95_watched_actionsRecordDimension

Insight Report Product

The Insight Report Product report returns daily metrics on each Ad within the ad account grouped by the product. The user can customize the output by using the Campaigns, Adsets, and/or Ads filter options. The type of incremental load associated with this report is also customizable.

FieldData TypeDimension/Metric
_campaign_id system schemaStringDimension
_product_id system schemaStringDimension
_date_start system schemaStringDimension
_ad_id system schemaStringDimension
_account_id system schemaStringDimension
_adset_id system schemaStringDimension
_cpcStringDimension
_adset_nameStringDimension
_campaign_nameStringDimension
_clicksStringDimension
_cost_per_action_typeRecordDimension
_ad_nameStringDimension
_cpmStringDimension
_ctrStringDimension
_currencyStringDimension
_actionsRecordDimension
_date_stopStringDimension
_impressionsStringDimension
_inline_link_clicksStringDimension
_outbound_clicksRecordDimension
_outbound_clicks_ctrRecordDimension
_account_nameStringDimension
_spendStringDimension

Custom Conversions

The Custom Conversions report lists the ad accounts' conversion objects which measure events you want to track to optimize ads delivery.

FieldData TypeDimension/Metric
_id system schemaStringDimension
_account_id system schemaStringDimension
_custom_event_typeStringDimension
_data_sourcesStringDimension
_default_conversion_valueIntegerMetric
_event_source_typeStringDimension
_first_fired_timeStringDimension
_creation_timeStringDimension
_is_archivedBooleanDimension
_is_unavailableBooleanDimension
_last_fired_timeStringDimension
_nameStringDimension
_pixelRecordDimension
_retention_daysIntegerMetric
_ruleStringDimension

Saved Audiences

The Saved Audiences report returns a list of audiences that have been saved and not used for an ad target.

FieldData TypeDimension/Metric
_id system schemaStringDimension
_accountRecordDimension
_approximate_count_lower_boundIntegerMetric
_approximate_count_upper_boundIntegerMetric
_nameStringDimension
_permission_for_actionsRecordDimension
_run_statusStringDimension
_sentence_linesRecordDimension
_targetingRecordDimension
_time_createdStringDimension
_time_updatedStringDimension

Custom Audiences

The Custom Audiences report returns a list of custom created audiences within the ad account that can be used for ad targeting.

FieldData TypeDimension/Metric
_id system schemaStringDimension
_account_id system schemaStringDimension
_lookalike_specRecordDimension
_customer_file_sourceStringDimension
_data_sourceRecordDimension
_delivery_statusRecordDimension
_descriptionStringDimension
_external_event_sourceRecordDimension
_approximate_count_upper_boundIntegerMetric
_is_value_basedBooleanDimension
_lookalike_audience_idsStringDimension
_approximate_count_lower_boundIntegerMetric
_nameStringDimension
_operation_statusRecordDimension
_permission_for_actionsRecordDimension
_pixel_idStringDimension
_retention_daysIntegerMetric
_ruleStringDimension
_subtypeStringDimension
_time_content_updatedIntegerMetric
_time_createdIntegerMetric
_time_updatedIntegerMetric

Was this article helpful?