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

Query 2

Monthly Average Events Per Session
June 14, 2016 · Refreshed about 3 years ago
Description
Average events per session each Month

Collaborators

Run History
--in Redshift you can also use TO_CHAR(time, 'YYYY-MM') SELECT SUBSTRING(time::date||'', 0, 8) as month, ROUND(COUNT(DISTINCT event_id)::DECIMAL / COUNT(DISTINCT session_id), 2) AS "average" FROM heap.all_events -- modify your date range here with WHERE time >= DATEADD('month', -6, getdate()) GROUP BY 1 LIMIT 100
--in Redshift you can also use TO_CHAR(time, 'YYYY-MM') SELECT SUBSTRING(time::date||'', 0, 8) as month, ROUND(COUNT(DISTINCT event_id)::DECIMAL / COUNT(DISTINCT session_id), 2) AS "average" FROM heap.all_events -- modify your date range here with WHERE time >= DATEADD('month', -6, getdate()) GROUP BY 1
select * from heap.all_events order by time desc
select * from heap.all_events order by time desc
<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_2758e1aefc7c" 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