Periodically, you may wish to analyze the average number of times users take a specific action over time. The value of this kind of insight is to understand whether it’s your per-user engagement that’s increasing or just your overall count of users.
To set this up in Heap, complete the following steps:
1. Navigate to Analyze > Usage over time
2. Select More > Ratio
3. In the top field (A), to the right of total events, select the event you’d like to see this count for. For example, if you run an online shop, you may want to see a count of the users who viewed a product page.
4. In the bottom field (B) select Unique users from the left drop-down.
5. In the field next to Unique users, select the same event that you selected for the top row (A). In this example, it would be View – Product Details Page (PDP) (Any).
6. Click View results. This will generate a graph like this:
When you hover over the line graph, the count is the total number of times this event was triggered; the count unique is the total number of users who triggered the event at least once.
3. To figure out the per-user average, we’ll need to do some math. Click the Actions button in the top-right corner, then select Export result to CSV. Once the file downloads, open it in Excel or another spreadsheet software. Please note that this .csv file will show up to 100,000 rows of data.
You should see something like this:
4. Below that table, create a row to calculate the average, add a function that divides the Count by the Count Unique for each row, and copy it across all columns.
5. Select the series and Average rows, then graph it.
Because this graph adjusts for average count per user, it tells us more about per-user engagement, and whether it’s going up, then a total count of the events or users alone.
For more information about our graph module, see our Graph analysis overview.