Skip to main content
Documentation
Troubleshooting
Feature Requests Status

Breakdowns Combinations

Edit on GitHub
  • Updated
Fivetran System User Fivetranner

Generic Breakdownslink

Breakdowns are estimated metrics. They are used to group data. You can select any of these breakdowns while creating your connector.

  • age
  • country
  • dma
  • gender
  • frequency_value
  • reach
  • impression_device
  • place_page_id
  • publisher_platform
  • platform_position
  • device_platform
  • product_id
  • region
  • ad_format_asset
  • body_asset
  • call_to_action_asset
  • description_asset
  • image_asset
  • link_url_asset
  • title_asset
  • video_asset

Restrictions

  • reach and frequency_value breakdowns are related and must be selected together.

  • The following fields cannot be grouped so they can’t be requested if you are specifying a breakdown:

    • app_store_clicks
    • newsfeed_avg_position
    • newsfeed_clicks
    • relevance_score
    • newsfeed_impressions

NOTE: When Facebook introduced changes related to Apple’s iOS 14 updates, some metrics became unavailable with certain breakdowns selected. For example, delivery and action breakdowns are not supported for offsite conversion events. This includes demographic breakdowns such as age, gender, and region. See Apple’s iOS 14 changes in Facebook API for more information.

Hourly Breakdowns (Hourly statistics)link

  • hourly_stats_aggregated_by_advertiser_time_zone
  • hourly_stats_aggregated_by_audience_time_zone

Restrictions

  • video_* fields cannot be requested with any hourly breakdowns.
  • Hourly breakdowns do not support unique fields, which are any fields prepended with unique_*, reach or frequency.
  • reach and frequency fields will return 0 when hourly breakdowns are in use.

Action Breakdownslink

Action breakdowns group results in action fields.

Note: Permutations marked with an asterisk (*) can be joined with action_type, action_target_id and action_destination which is the name for action_target_id.

  • action_canvas_component_name
  • action_destination
  • action_device
  • action_reaction
  • action_target_id
  • action_type
  • action_video_sound
  • action_video_type

Restrictions

You can’t select the following fields along with the action_device breakdown:

  • instant_experience_clicks_to_open
  • instant_experience_clicks_to_start
  • instant_experience_outbound_clicks

Combined Breakdownslink

You can select multiple combinations of breakdowns:

  • action_type *
  • action_target_id *
  • action_device *
  • action_device, impression_device *
  • action_device, publisher_platform *
  • action_device, publisher_platform, impression_device *
  • action_device, publisher_platform, platform_position *
  • action_device, publisher_platform, platform_position, impression_device *
  • action_reaction
  • action_type, action_reaction
  • age *
  • gender *
  • age, gender *
  • country *
  • region *
  • frequency_value, reach
  • publisher_platform *
  • publisher_platform, impression_device *
  • publisher_platform, platform_position *
  • publisher_platform, platform_position, impression_device *
  • product_id *
  • hourly_stats_aggregated_by_advertiser_time_zone *
  • hourly_stats_aggregated_by_audience_time_zone *

Related articles

Didn’t find what you need?

Contact support