Skip to content
  • Home
  • University
  • Developers
  • API
  • Releases
  • Status
  • Home
  • University
  • Developers
  • API
  • Releases
  • Status
Home Heap Connect Sample Analysis Heap Connect: Aggregate Metrics
Getting Started Installation Administration Define & Analyze Analysis Examples Heap Plays Success Guides Integrations Heap Connect Data Privacy FAQs

Table of Contents

Was this article helpful?

Yes No

Thank you for your feedback!

Heap Connect: Aggregate Metrics

This doc is for: Admins Architects
View instructions for: 

Heap Connect is only available for customers on a paid plan. To upgrade, contact your Customer Success Manager or sales@heap.io.

In this section, you’ll find a variety of Heap Connect queries to measure aggregate metrics for your site, including average time, top events, and more. The value of these queries increases as you segment them by user personas, and the same logic can also be applied to calculate more specific statistics.

The visualizations may take a few seconds to load. You can review a complete list of SQL queries in our Common Queries doc. if you have any questions about these queries, please reach out to support@heap.io.

Top N Events

The top N events shed light on how users are interacting with your app. Looking at this list generates a lot of questions: Why are users clicking this button? Why are users viewing this page? Are these two actions correlated? Does the high event count come from users’ success within the product, or is this caused by confusion?

Mode Analytics

You can modify the WHERE statement to adjust the date range. You can include the date in SELECT statement and GROUP BY clause to measure how most frequently performed actions change over time. You can also adjust the number of events you are looking at by modifying the LIMIT.

Average Time on Site

This query is primarily beneficial to you if you have a content site, and there aren’t a lot of user interactions to capture while reading, and avid readers don’t always comment or share. Although this is a proxy for engagement, drastic changes in time on site can cue you in to investigate how users are engaging with your product. You can tweak this query to analyze average time between events, or break it down into different segments of users to get a better understanding of your site’s usage.

Mode Analytics

Average Events Per Session

Likewise, the average events per session metric can give you insight into aggregate behavior. This query can also be modified to analyze behavior across segments and over time, allowing you to answer questions such as: Does this number change with a product launch or tweaks to the onboarding flow? Do different types of users interact differently? Changes in the average can prompt investigation into what is really happening within your app.

Mode Analytics

Average Events per Session Over Time

To modify this query to calculate the average number of events per session over the past year or past six months, simply update the WHERE statement to include the time range and add a GROUP BY clause to address the granularity.

Mode Analytics

Average by User Property

To calculate this, join the all events table on the user table and add a GROUP BY clause based on the User Properties you want to use for segmentation.

Mode Analytics

Average Sessions Per User

The average number of sessions per user can be used in the same way as average events per session and can be modified in the same manner. To find the average number of sessions per user, simply divide the number of unique sessions by the number of unique users across the time period.

Mode Analytics

Was this article helpful?

Yes No

Thank you for your feedback!

Last updated April 13, 2020.

heap connect
  • Blog
  • Partners
  • Security
  • Terms
  • About
  • Careers
  • Privacy
  • Contact Us

© 2021 Heap, Inc.