“By" clauses, also referred to as “breakouts,” allow you to segment data based on event properties and people properties to better understand its context. A breakout will create multiple data series in the Segmentation, Funnel, and Cohort tools.
Breakouts by Tool
To find the Marketing Channel breakout of users who performed an event or events, drag the property "Marketing Channel" into the "By" clause drop zone. The tool will break out the results by all possible values of the property "Marketing Channel". Below, see what this looks like in each tool.
Results Display Options
Queries with a breakout are limited to display a maximum of 50 breakout results. Use the selector in the query builder to show the top or bottom 5 - 50 results. If there are less than 5 breakout results, the menu will not appear. To view more than 50 breakouts, export the data from the tool as a CSV file:
Multiple "By" Clauses
In Segmentation, any query row may be broken out using multiple properties. For example, if "View Content" is broken out by the properties "Gender" and "AB Testing", the the result breakout will include all possible combinations of these values. In this case, the combinations would be:
- Males in Group A
- Males in Group B
- Females in Group A
- Females in Group B