Skip to main content
Support Articles
Feature Requests Documentation Status Dashboard

Breakdowns Combinations

  • 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

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