Skip to content
  • Home
  • Developers
  • API
  • Releases
  • Community
  • University
  • Status
  • Home
  • Developers
  • API
  • Releases
  • Community
  • University
  • Status
Home Charts Chart Features Group By
Session Replay Getting Started Administration Data Management Definitions Charts Analysis Examples Heap Plays Integrations Heap Connect Data Privacy

Table of Contents

Was this article helpful?

Yes No

Thank you for your feedback!

Group By

In this article you'll learn:

  • How the group by clause works and what it can be used for
  • Examples of how to group by event level properties

The group by clause allows you to break down Heap queries even further by creating up to 4 groups within reports based on user and event-level properties.

Group by User-Level Properties

How does it work?

Heap automatically captures certain user properties, such as date first seen and other initial properties. A full list of all properties which are automatically captured is available in Autocaptured Data. You can also define additional properties, such as account type, LTV, and more using our addUserProperties API.

To segment your analysis by one or more of these user-level properties, simply click the + Add Group By button and select your property.

A graph in Heap grouped by 'Initial Marketing Channel'

Why is this powerful?

Grouping by a user-level property allows you to get an in-depth picture of who is using your product.

As an example, within Heap, there are six analysis tools. Using a multigraph, we can compare how frequently each of these features is used, which helps our product team prioritize which features to work on.

A multigraph by the graph, funnel, users, retention, influence, and paths 'execute query' events

When we group this multigraph by job title, we are not only comparing which features are being used most frequently, but also comparing who is using them. A marketer needs a different feature set than someone in sales or design.

A group by 'Lead Job title' property

This provides actionable insight into how we should prioritize our features and who we need to build features for.

Graph results for the execute query multigraph

You can also use a multigraph + a group by to compare the effectiveness of different campaigns, landing pages, blog posts, and more across different groups of users.

In this example, we can compare three blog posts and their conversion rate for signups based on the region. Looking at the results, it’s clear that some posts are more effective than others in different regions. This enables our outbound team to adjust their strategy when getting prospects to sign up for Heap.

A graph comparing the conversion rate between views of three different blog posts grouped by initial city

Group by Event-Level Properties

When using funnels, conversion rate over time, and average time between, you can segment your data by grouping by an event-level property.

How is the conversion rate calculated?

When you group by the property of the first event in a funnel (or any intermediate event), we calculate the conversion rate by bucketing the user into the instance of the event immediately before a conversion.

If the user has not completed the rest of the funnel, we use the most recent value of the event’s property. Each user will only be included in one bucket, and if a user completes a funnel multiple times, we will use the data from their first conversion.

For example, in an A→ B→ C funnel:

  • Bob does event A with path /home, event A with path /blog > event B > event C
  • Tammy does event A with path /home
  • Beth does event A with path /home > event B > event C

The results will be as follows:

ABCTotal Conversion
/home21150%
/blog111100%

When you group by the properties of the last event in the funnel, users will be bucketed into categories based on the first instance of the last event (the first conversion). As above, each user will only be included in one bucket, and if a user completes a funnel multiple times, we will use the data from their first conversion.

For example, in the funnel A → B:

  • Bob does event A > event A > event B with Referrer Google, B with Referrer Facebook
  • Tammy does event A > event B with Referrer Facebook
  • Beth does event A

The results will be as follows:

ABTotal Conversion
Google11100%
Facebook11100%
None10%

Where can I group by event-level properties?

You can group by event-level properties in the graph (including average time between and conversion rate between queries) and in the funnel modules.

How do I use grouping by event-level properties to find actionable insights?

Grouping by the first or intermediate step of a funnel provides insight into what was happening immediately before the conversion. In this example, we compare the effectiveness of different marketing pages by grouping by the marketing page immediately preceding the Sign Up event.

A funnel 'View any marketing page' -> 'sign up' grouped by 'path - view any marketing page' for past 7 days

This example can be adapted to see which collection was viewed before checking out, or which product was viewed before adding to the cart.

Was this article helpful?

Yes No

Thank you for your feedback!

Last updated October 19, 2022.

event-level propertiesgroup byuser-level properties
  • Blog
  • Partners
  • Legal
  • Security
  • Terms
  • About
  • Careers
  • Privacy
  • Contact Us

© 2023 Heap, Inc.