Group By Clauses

FreeProEnterprise

Group By clauses, also referred to as Breakouts, allow you to segment data based on event properties, user properties or user segments to better understand its context. A breakout will create multiple data series in the Segmentation, Funnel, and Cohort tools. 

Group By Clauses by Tool

Segmentation Breakout

You may apply a Group By function to each row in your segmentation query. By doing so, you will then categorize your results by each breakout.

[video-to-gif output image]

You may hide a breakout from your visualization by clicking on its name in the field below the visualization area. You may view a single breakout by double clicking on its name in the field below the visualization area.

Funnel Breakout

You may apply a Group By function to categorize users using an event property, user property, or user segment.

You may isolate each group’s conversion rate by clicking on the corresponding slice of the donut in the visualization area. The Total Conversion Rate and Average Conversion Time displayed in the top left corner, and the conversion rate in the webbing between each step will change to reflect only users that are in the selected breakout.

Cohort Breakout

Cohorts are defined by a shared generation or a shared property. A generation is a unit of time, such as a month. A monthly cohort would include all users who entered the cohort during that month. A property is a characteristic or attribute, such as device type. Cohorts defined by device type would include all users with an iPhone, all users with an Android, etc.

Breakout 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.

mceclip0.png

To view more than 50 breakouts, export the data from the tool as a CSV file:

Multiple Group By Clauses

In Segmentation, any query row may be broken out using multiple properties. For example, if "Open App" is broken out by the properties "Browser Name" and "Marketing Channel", the result breakout will include all possible combinations of these values.

[video-to-gif output image]

In this example, the combinations would include:

  • Chrome | Email
  • Chrome | Direct
  • Firefox | Email
  • Firefox | Direct

And so on.

0 users found this helpful