There is a more recent run of this report. Click here to view it.

Report not found

There was a problem finding this report.

Report

Average Events Per Session

Average Events Per Session
June 14, 2016 · Refreshed about 3 years ago
Description
All time average events per session

Collaborators

Run History
SELECT ROUND(COUNT(DISTINCT event_id)::DECIMAL / COUNT(DISTINCT session_id), 2) AS "avg_events" FROM heap.all_events -- modify your date range here with WHERE time >= DATEADD('day', -30, getdate()) LIMIT 100
SELECT ROUND(COUNT(DISTINCT event_id)::DECIMAL / COUNT(DISTINCT session_id), 2) AS "avg_events" FROM heap.all_events -- modify your date range here with WHERE time >= DATEADD('day', -30, getdate())
<div class="mode-header"> <h1 class="embed-hidden">{{ title }}</h1> <p>{{ description }}</p> <p id="big_number"></p> </div> <script> document.getElementById('big_number').innerHTML=datasets[0].content[0].avg_events; </script> <style> #big_number{ font-size:36px; } </style>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled