Facebook Ads predefined reports
Predefined reports
The Facebook Ads data source in Data Integration comes with the following predefined reports. Each report includes a short description of the data, a list of customizable fields (if any), and the schema mapping.
Since these reports follow a standardized format, a few fields are locked, and you can only access them through the Custom reports feature.
Source-level selections
Source-level selection is an Ad Accounts filter. Choosing distinct values filters down each report within the river for the selected ad accounts.
Ad account
The Ad account report returns the details on each ad account.
| Field | Data Type | Dimension/Metric |
|---|---|---|
_id  | String | Dimension |
| _account_id | String | Dimension |
| _account_status | Integer | Metric |
| _age | Float | Metric |
| _amount_spent | String | Dimension |
| _balance | String | Dimension |
| _business | Record | Dimension |
| _business_city | String | Dimension |
| _business_country_code | String | Dimension |
| _business_name | String | Dimension |
| _business_state | String | Dimension |
| _business_street | String | Dimension |
| _business_street2 | String | Dimension |
| _business_zip | String | Dimension |
| _can_create_brand_lift_study | Boolean | Dimension |
| _capabilities | String | Dimension |
| _created_time | String | Dimension |
| _currency | String | Dimension |
| _disable_reason | Integer | Metric |
| _end_advertiser | String | Dimension |
| _end_advertiser_name | String | Dimension |
| _funding_source | String | Dimension |
| _funding_source_details | Record | Dimension |
| _has_migrated_permissions | Boolean | Dimension |
| _account_name | String | Dimension |
| _ios_fourteen_campaign_limits_campaign_group_limit | Integer | Metric |
| _ios_fourteen_campaign_limits_campaign_limit | Integer | Metric |
| _is_attribution_spec_system_default | Boolean | Dimension |
| _is_direct_deals_enabled | Boolean | Dimension |
| _is_in_3ds_authorization_enabled_market | Boolean | Dimension |
| _is_notifications_enabled | Boolean | Dimension |
| _is_personal | Integer | Metric |
| _is_prepay_account | Boolean | Dimension |
| _is_tax_id_required | Boolean | Dimension |
| _min_campaign_group_spend_cap | String | Dimension |
| _min_daily_budget | Integer | Metric |
| _offsite_pixels_tos_accepted | Boolean | Dimension |
| _owner | String | Dimension |
| _spend_cap | String | Dimension |
| _tax_id | String | Dimension |
| _tax_id_status | Integer | Dimension |
| _tax_id_type | String | Dimension |
| _timezone_id | Integer | Dimension |
| _timezone_name | String | Dimension |
| _timezone_offset_hours_utc | Integer | Metric |
| _tos_accepted | Record | Dimension |
| _user_tasks | String | Dimension |
Ad account activities
The Ad Account Activities report retrieves information on key updates to an Ad account and its associated objects. You can customize the type of incremental load related to this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _account_id | String | Dimension |
| _event_time | String | Dimension |
| _actor_name | String | Dimension |
| _application_id | String | Dimension |
| _application_name | String | Dimension |
| _category | String | Dimension |
| _date_time_in_timezone | String | Dimension |
| _actor_id | String | Dimension |
| _event_type | String | Dimension |
| _extra_data | String | Dimension |
| _object_id | String | Dimension |
| _object_name | String | Dimension |
| _object_type | String | Dimension |
| _translated_event_type | String | Dimension |
Campaigns
The Campaigns report returns details on each campaign within the ad account(s). The Campaigns filter option lets you customize the output.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _campaign_id | String | Dimension |
| _account_id | String | Dimension |
| _effective_status | String | Dimension |
| _budget_remaining | String | Dimension |
| _buying_type | String | Dimension |
| _campagin_name | String | Dimension |
| _budget_rebalance_flag | Boolean | Dimension |
| _can_create_brand_lift_study | Boolean | Dimension |
| _can_use_spend_cap | Boolean | Dimension |
| _configured_status | String | Dimension |
| _created_time | String | Dimension |
| _bid_strategy | String | Dimension |
| _is_skadnetwork_attribution | Boolean | Dimension |
| _lifetime_budget | String | Dimension |
| _objective | String | Dimension |
| _source_campaign | Record | Dimension |
| _source_campaign_id | String | Dimension |
| _special_ad_category | String | Dimension |
| _start_time | String | Dimension |
| _status | String | Dimension |
| _stop_time | String | Dimension |
| _topline_id | String | Dimension |
| _updated_time | String | Dimension |
Adsets
The Adsets report returns the details on each Adset within the Ad account(s). You can customize the output using the Campaigns and/or Adsets filter options.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _account_id | String | Dimension |
| _adset_id | String | Dimension |
| _campaign_id | String | Dimension |
| _behaviors_full_details_string | String | Dimension |
| _age_max | Integer | Metric |
| _age_min | Integer | Metric |
| _attribution_spec | Record | Dimension |
| _behaviors_full_details | Record | Dimension |
| _adset_schedule | Record | Dimension |
| _behaviors_ids | String | Dimension |
| _behaviors_ids_string | String | Dimension |
| _behaviors_names | String | Dimension |
| _behaviors_names_string | String | Dimension |
| _bid_amount | Integer | Metric |
| _bid_info | Record | Dimension |
| _bid_strategy | String | Dimension |
| _billing_event | String | Dimension |
| _budget_remaining | String | Dimension |
| _campaign | Record | Dimension |
| _adset_name | String | Dimension |
| _configured_status | String | Dimension |
| _created_time | String | Dimension |
| _custom_audience_full_details | Record | Dimension |
| _custom_audience_full_details_string | String | Dimension |
| _custom_audience_ids | String | Dimension |
| _custom_audience_ids_string | String | Dimension |
| _custom_audience_names | String | Dimension |
| _custom_audience_names_string | String | Dimension |
| _daily_budget | String | Dimension |
| _destination_type | String | Dimension |
| _device | String | Dimension |
| _effective_status | String | Dimension |
| _end_time | String | Dimension |
| _excluded_custom_audiences_full_details | String | Dimension |
| _excluded_custom_audiences_full_details_string | String | Dimension |
| _excluded_custom_audiences_ids | String | Dimension |
| _excluded_custom_audiences_ids_string | String | Dimension |
| _excluded_custom_audiences_names | String | Dimension |
| _excluded_custom_audiences_string | String | Dimension |
| _excluded_geo_countries | String | Dimension |
| _frequency_control_specs | Record | Dimension |
| _genders | String | Dimension |
| _geo_countries | String | Dimension |
| _interests_full_details | Record | Dimension |
| _interests_full_details_string | String | Dimension |
| _interests_ids | String | Dimension |
| _interests_ids_string | String | Dimension |
| _interests_names | String | Dimension |
| _interests_names_string | String | Dimension |
| _is_dynamic_creative | Boolean | Dimension |
| _lal_percentage | String | Dimension |
| _lal_percentage_string | String | Dimension |
| _lifetime_budget | String | Dimension |
| _lifetime_imps | Integer | Metric |
| _optimization_goal | String | Dimension |
| _optimization_sub_event | String | Dimension |
| _pacing_type | String | Dimension |
| _promoted_object | Record | Dimension |
| _recommendations | Record | Dimension |
| _recurring_budget_semantics | Boolean | Dimension |
| _seed_audience | String | Dimension |
| _source_adset | Record | Dimension |
| _source_adset_id | String | Dimension |
| _start_time | String | Dimension |
| _status | String | Dimension |
| _updated_time | String | Dimension |
| _use_new_app_click | Boolean | Dimension |
| _user_os | String | Dimension |
| _user_os_string | String | Dimension |
Ads
The Ads report returns the details on each ad within the ad account(s). You can customize the output using the Campaigns, Adsets, and/or Ads filter options. The type of incremental load associated with this report is also customizable.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _adset_id | String | Dimension |
| _ad_id | String | Dimension |
| _account_id | String | Dimension |
| _campaign_id | String | Dimension |
| _created_time | String | Dimension |
| _bid_type | String | Dimension |
| _campaign | Record | Dimension |
| _adset | Record | Dimension |
| _configured_status | String | Dimension |
| _conversion_specs | Record | Dimension |
| _ad_name | String | Dimension |
| _creative | Record | Dimension |
| _creative_id | String | Dimension |
| _display_sequence | Integer | Metric |
| _effective_status | String | Dimension |
| _last_updated_by_app_id | String | Dimension |
| _recommendations | Record | Dimension |
| _source_ad_id | String | Dimension |
| _status | String | Dimension |
| _tracking_specs | Record | Dimension |
| _updated_time | String | Dimension |
Ad creatives
The Ad creatives report returns the details on each creative within the ad account(s). You can customize the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _creative_id | String | Dimension |
| _account_id | String | Dimension |
| _portrait_customizations | Record | Dimension |
| _body | String | Dimension |
| _call_to_action_type | String | Dimension |
| _authorization_category | String | Dimension |
| _creative_name | String | Dimension |
| _effective_authorization_category | String | Dimension |
| _effective_instagram_media_id | String | Dimension |
| _effective_instagram_story_id | String | Dimension |
| _effective_object_story_id | String | Dimension |
| _image_hash | String | Dimension |
| _image_url | String | Dimension |
| _instagram_actor_id | String | Dimension |
| _instagram_permalink_url | String | Dimension |
| _instagram_user_id | String | Dimension |
| _link | String | Dimension |
| _object_story_spec | Record | Dimension |
| _object_type | String | Dimension |
| _asset_feed_spec | Record | Dimension |
| _status | String | Dimension |
| _thumbnail_url | String | Dimension |
| _title | String | Dimension |
| _use_page_actor_override | Boolean | Dimension |
| _video_id | String | Dimension |
| post_attachments | Record | Dimension |
| post_call_to_action | Record | Dimension |
| post_created_time | String | Dimension |
| post_from | Record | Dimension |
| post_full_picture | String | Dimension |
| post_icon | String | Dimension |
| post_id | String | Dimension |
| post_instagram_eligibility | String | Dimension |
| post_object_id | String | Dimension |
| post_type | String | Dimension |
| video_content_category | String | Dimension |
| video_created_time | String | Dimension |
| video_description | String | Dimension |
| video_id | String | Dimension |
Ads pixels
The Ads pixels report returns a list of the pixels within the ad account(s) and their details. You can customize the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _account_id | String | Dimension |
| _id | String | Dimension |
| _first_party_cookie_status | String | Dimension |
| _can_proxy | Boolean | Dimension |
| _code | String | Dimension |
| _creation_time | String | Dimension |
| _creator | Record | Dimension |
| _data_use_setting | String | Dimension |
| _enable_automatic_matching | Boolean | Dimension |
| _automatic_matching_fields | String | Dimension |
| _aggregation | String | Dimension |
| _is_created_by_business | Boolean | Dimension |
| _is_unavailable | Boolean | Dimension |
| _last_fired_time | String | Dimension |
| _name | String | Dimension |
| _owner_ad_account | Record | Dimension |
| _owner_business | Record | Dimension |
| _start_time | String | Dimension |
| _stats | Record | Dimension |
Ad Leads
The Ad leads reports returns a list of leads captured with Ads from the Ad account. You can customize the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _account_id | String | Dimension |
| _lead_id | String | Dimension |
| _form_page_name | String | Dimension |
| _form_locale | String | Dimension |
| _form_name | String | Dimension |
| _form_page_id | String | Dimension |
| _form_id | String | Dimension |
| _form_status | String | Dimension |
| _is_organic | Boolean | Dimension |
| _lead_form_field_name | String | Dimension |
| _lead_form_field_value | String | Dimension |
| _created_time | String | Dimension |
| _platform | String | Dimension |
Ad leads forms
The Ad leads forms report returns details on each Lead form created within the account. You can customize the type of incremental load associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | String | Dimension |
| _account_id | String | Dimension |
| locale | String | Dimension |
| context_card | Record | Dimension |
| created_time | String | Dimension |
| expired_leads_count | Integer | Metric |
| follow_up_action_url | String | Dimension |
| block_display_for_non_targeted_viewer | Boolean | Dimension |
| is_optimized_for_quality | Boolean | Dimension |
| leads_count | Integer | Metric |
| legal_content | Record | Dimension |
| allow_organic_lead | Boolean | Dimension |
| name | String | Dimension |
| organic_leads_count | Integer | Metric |
| page | Record | Dimension |
| page_id | String | Dimension |
| page_name | String | Dimension |
| privacy_policy_url | String | Dimension |
| question_page_custom_headline | String | Dimension |
| questions | Record | Dimension |
| status | String | Dimension |
| thank_you_page | Record | Dimension |
Insight report basic
The Insight report basic report returns daily metrics on each Ad within the Ad account. You can customize the output using the Campaigns, Adsets, and/or Ads filter options. You can also customize the type of incremental load associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _adset_id | String | Dimension |
| _account_id | String | Dimension |
| _date_start | String | Dimension |
| _ad_id | String | Dimension |
| _campaign_id | String | Dimension |
| _impressions | String | Dimension |
| _adset_name | String | Dimension |
| _ad_name | String | Dimension |
| _campaign_name | String | Dimension |
| _clicks | String | Dimension |
| _conversions | Record | Dimension |
| _cost_per_action_type | Record | Dimension |
| _cost_per_conversion | Record | Dimension |
| _cpc | String | Dimension |
| _cpm | String | Dimension |
| _cpp | String | Dimension |
| _ctr | String | Dimension |
| _currency | String | Dimension |
| _actions | Record | Dimension |
| _date_stop | String | Dimension |
| _frequency | String | Dimension |
| _account_name | String | Dimension |
| _inline_link_clicks | String | Dimension |
| _outbound_clicks | Record | Dimension |
| _outbound_clicks_ctr | Record | Dimension |
| _reach | String | Dimension |
| _social_spend | String | Dimension |
| _spend | String | Dimension |
| _unique_actions | Record | Dimension |
| _unique_clicks | String | Dimension |
| _unique_ctr | String | Dimension |
| _unique_inline_link_click_ctr | String | Dimension |
| _unique_inline_link_clicks | String | Dimension |
| _unique_link_clicks_ctr | String | Dimension |
| _unique_outbound_clicks | Record | Dimension |
| _unique_outbound_clicks_ctr | Record | Dimension |
| _video_avg_time_watched_actions | Record | Dimension |
| _video_p100_watched_actions | Record | Dimension |
| _video_p25_watched_actions | Record | Dimension |
| _video_p50_watched_actions | Record | Dimension |
| _video_p75_watched_actions | Record | Dimension |
| _video_p95_watched_actions | Record | Dimension |
Insight report platform
The Insight report platform report returns daily metrics on each Ad within the ad account, grouped by the platform. You can customize the output using the Campaigns, Adsets, and/or Ads filter options. You can also customize the type of incremental load associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _campaign_id | String | Dimension |
| _publisher_platform | String | Dimension |
| _platform_position | String | Dimension |
| _date_start | String | Dimension |
| _ad_id | String | Dimension |
| _account_id | String | Dimension |
| _adset_id | String | Dimension |
| _ad_name | String | Dimension |
| _adset_name | String | Dimension |
| _campaign_name | String | Dimension |
| _clicks | String | Dimension |
| _cost_per_action_type | Record | Dimension |
| _cpc | String | Dimension |
| _cpm | String | Dimension |
| _cpp | String | Dimension |
| _ctr | String | Dimension |
| _currency | String | Dimension |
| _actions | Record | Dimension |
| _date_stop | String | Dimension |
| _frequency | String | Dimension |
| _impressions | String | Dimension |
| _inline_link_clicks | String | Dimension |
| _outbound_clicks | Record | Dimension |
| _outbound_clicks_ctr | Record | Dimension |
| _action_values | Record | Dimension |
| _account_name | String | Dimension |
| _reach | String | Dimension |
| _spend | Integer | Metric |
| _unique_actions | Record | Dimension |
| _unique_clicks | String | Dimension |
| _unique_ctr | String | Dimension |
| _unique_inline_link_click_ctr | String | Dimension |
| _unique_inline_link_clicks | String | Dimension |
| _unique_link_clicks_ctr | String | Dimension |
| _unique_outbound_clicks | Record | Dimension |
| _unique_outbound_clicks_ctr | Record | Dimension |
| _video_avg_time_watched_actions | Record | Dimension |
| _video_p100_watched_actions | Record | Dimension |
| _video_p25_watched_actions | Record | Dimension |
| _video_p50_watched_actions | Record | Dimension |
| _video_p75_watched_actions | Record | Dimension |
| _video_p95_watched_actions | Record | Dimension |
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. You can customize the output using the Campaigns, Adsets, and/or Ads filter options. You can also customize the type of incremental load associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _age | String | Dimension |
| _gender | String | Dimension |
| _date_start | String | Dimension |
| _campaign_id | String | Dimension |
| _ad_id | String | Dimension |
| _account_id | String | Dimension |
| _adset_id | String | Dimension |
| _ad_name | String | Dimension |
| _adset_name | String | Dimension |
| _actions | Record | Dimension |
| _campaign_name | String | Dimension |
| _clicks | String | Dimension |
| _conversions | Record | Dimension |
| _cost_per_action_type | Record | Dimension |
| _cpc | String | Dimension |
| _cpm | String | Dimension |
| _cpp | String | Dimension |
| _ctr | String | Dimension |
| _currency | String | Dimension |
| _action_values | Record | Dimension |
| _date_stop | String | Dimension |
| _frequency | String | Dimension |
| _account_name | String | Dimension |
| _impressions | String | Dimension |
| _inline_link_clicks | String | Dimension |
| _outbound_clicks | Record | Dimension |
| _outbound_clicks_ctr | Record | Dimension |
| _reach | String | Dimension |
| _spend | String | Dimension |
| _unique_actions | Record | Dimension |
| _unique_clicks | String | Dimension |
| _unique_ctr | String | Dimension |
| _unique_inline_link_click_ctr | String | Dimension |
| _unique_inline_link_clicks | String | Dimension |
| _unique_link_clicks_ctr | String | Dimension |
| _unique_outbound_clicks | Record | Dimension |
| _unique_outbound_clicks_ctr | Record | Dimension |
| _video_avg_time_watched_actions | Record | Dimension |
| _video_p100_watched_actions | Record | Dimension |
| _video_p25_watched_actions | Record | Dimension |
| _video_p50_watched_actions | Record | Dimension |
| _video_p75_watched_actions | Record | Dimension |
| _video_p95_watched_actions | Record | Dimension |
Insight report country
The Insight report country report returns daily metrics on each Ad within the ad account, grouped by the country. You can customize the output using the Campaigns, Adsets, and/or Ads filter options. You can also customize the type of incremental load associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _adset_id | String | Dimension |
| _date_start | String | Dimension |
| _country | String | Dimension |
| _campaign_id | String | Dimension |
| _ad_id | String | Dimension |
| _account_id | String | Dimension |
| _ad_name | String | Dimension |
| _adset_name | String | Dimension |
| _actions | Record | Dimension |
| _campaign_name | String | Dimension |
| _clicks | String | Dimension |
| _cost_per_action_type | Record | Dimension |
| _action_values | Record | Dimension |
| _cpc | String | Dimension |
| _cpm | String | Dimension |
| _cpp | String | Dimension |
| _ctr | String | Dimension |
| _currency | String | Dimension |
| _account_name | String | Dimension |
| _date_stop | String | Dimension |
| _frequency | String | Dimension |
| _impressions | String | Dimension |
| _inline_link_clicks | String | Dimension |
| _outbound_clicks | Record | Dimension |
| _outbound_clicks_ctr | Record | Dimension |
| _reach | String | Dimension |
| _spend | String | Dimension |
| _unique_actions | Record | Dimension |
| _unique_clicks | String | Dimension |
| _unique_ctr | String | Dimension |
| _unique_inline_link_click_ctr | String | Dimension |
| _unique_inline_link_clicks | String | Dimension |
| _unique_link_clicks_ctr | String | Dimension |
| _unique_outbound_clicks | Record | Dimension |
| _unique_outbound_clicks_ctr | Record | Dimension |
| _video_avg_time_watched_actions | Record | Dimension |
| _video_continuous_2_sec_watched_actions | Record | Dimension |
| _video_p100_watched_actions | Record | Dimension |
| _video_p25_watched_actions | Record | Dimension |
| _video_p50_watched_actions | Record | Dimension |
| _video_p75_watched_actions | Record | Dimension |
| _video_p95_watched_actions | Record | Dimension |
Insight report product
The Insight report product report returns daily metrics on each Ad within the ad account, grouped by the product. You can customize the output using the Campaigns, Adsets, and/or Ads filter options. You can also customize the type of incremental load associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _campaign_id | String | Dimension |
| _product_id | String | Dimension |
| _date_start | String | Dimension |
| _ad_id | String | Dimension |
| _account_id | String | Dimension |
| _adset_id | String | Dimension |
| _cpc | String | Dimension |
| _adset_name | String | Dimension |
| _campaign_name | String | Dimension |
| _clicks | String | Dimension |
| _cost_per_action_type | Record | Dimension |
| _ad_name | String | Dimension |
| _cpm | String | Dimension |
| _ctr | String | Dimension |
| _currency | String | Dimension |
| _actions | Record | Dimension |
| _date_stop | String | Dimension |
| _impressions | String | Dimension |
| _inline_link_clicks | String | Dimension |
| _outbound_clicks | Record | Dimension |
| _outbound_clicks_ctr | Record | Dimension |
| _account_name | String | Dimension |
| _spend | String | Dimension |
Custom conversions
The Custom conversions report lists the ad accounts' conversion objects which measure events you want to track to optimize ads delivery.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _id | String | Dimension |
| _account_id | String | Dimension |
| _custom_event_type | String | Dimension |
| _data_sources | String | Dimension |
| _default_conversion_value | Integer | Metric |
| _event_source_type | String | Dimension |
| _first_fired_time | String | Dimension |
| _creation_time | String | Dimension |
| _is_archived | Boolean | Dimension |
| _is_unavailable | Boolean | Dimension |
| _last_fired_time | String | Dimension |
| _name | String | Dimension |
| _pixel | Record | Dimension |
| _retention_days | Integer | Metric |
| _rule | String | Dimension |
Saved audiences
The Saved audiences report returns a list of audiences saved and unused for an ad target.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _id | String | Dimension |
| _account | Record | Dimension |
| _approximate_count_lower_bound | Integer | Metric |
| _approximate_count_upper_bound | Integer | Metric |
| _name | String | Dimension |
| _permission_for_actions | Record | Dimension |
| _run_status | String | Dimension |
| _sentence_lines | Record | Dimension |
| _targeting | Record | Dimension |
| _time_created | String | Dimension |
| _time_updated | String | Dimension |
Custom audiences
The Custom audiences report returns a list of custom-created audiences within the Ad account that can be used for Ad targeting.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| _id | String | Dimension |
| _account_id | String | Dimension |
| _lookalike_spec | Record | Dimension |
| _customer_file_source | String | Dimension |
| _data_source | Record | Dimension |
| _delivery_status | Record | Dimension |
| _description | String | Dimension |
| _external_event_source | Record | Dimension |
| _approximate_count_upper_bound | Integer | Metric |
| _is_value_based | Boolean | Dimension |
| _lookalike_audience_ids | String | Dimension |
| _approximate_count_lower_bound | Integer | Metric |
| _name | String | Dimension |
| _operation_status | Record | Dimension |
| _permission_for_actions | Record | Dimension |
| _pixel_id | String | Dimension |
| _retention_days | Integer | Metric |
| _rule | String | Dimension |
| _subtype | String | Dimension |
| _time_content_updated | Integer | Metric |
| _time_created | Integer | Metric |
| _time_updated | Integer | Metric |
