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 by Plan

Average Events Per Session by User Type
June 14, 2016 · Refreshed almost 3 years ago
Description
Average events per session based on the User Plan

Collaborators

Run History
SELECT CASE WHEN plan is null THEN 'No Plan' ELSE plan END as plan, ROUND(COUNT(DISTINCT event_id)::DECIMAL / COUNT(DISTINCT session_id), 2) AS "average" FROM heap.all_events join heap.users on heap.all_events.user_id=heap.users.user_id -- modify your date range here with WHERE time >= DATEADD('month', -6, getdate()) GROUP BY 1 LIMIT 100
SELECT CASE WHEN plan is null THEN 'No Plan' ELSE plan END as plan, ROUND(COUNT(DISTINCT event_id)::DECIMAL / COUNT(DISTINCT session_id), 2) AS "average" FROM heap.all_events join heap.users on heap.all_events.user_id=heap.users.user_id -- modify your date range here with WHERE time >= DATEADD('month', -6, getdate()) GROUP BY 1
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> <h5>To use with Heap data, modify your query from heap.table_name to main_production.table_name</h5> </div> <div class="mode-grid container"> <div class="row"> <div class="col-md-12"> <mode-chart id="chart_2319a35345b8" dataset="dataset" options="chart_options"></mode-chart> </div> </div> </div>
{{ 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