Periodically, you may wish to analyze the average number of times users trigger a given event 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 > Browse All > Graph and set up a graph for the count of your event, then use the + Add Ratio button to add a ratio for count unique of that same event.
For our example, we have an event called View Dashboard, and we want to check whether the per user count of dashboard views is going up, or down.
2. Click Run Query. This will generate a graph like this:
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 Export button in the top-right corner and open up the file 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 Graph.