Report not found

There was a problem finding this report.

Report

Users Per UTM Source

Users Per UTM Source
June 14, 2016 · Refreshed over 2 years ago
Description
This query returns the number of users who fall into each category

Collaborators

Run History
SELECT utm_source, COUNT(distinct all_sessions.user_id) FROM heap.sessions AS all_sessions INNER JOIN ( SELECT user_id ,MIN(time) AS first_time FROM heap.sessions GROUP BY user_id ) AS first_session ON all_sessions.user_id = first_session.user_id AND all_sessions.time = first_session.first_time INNER JOIN heap.users AS users ON all_sessions.user_id = users.user_id --only include users with a UTM source defined WHERE utm_source is not null GROUP BY 1 LIMIT 100
SELECT utm_source, COUNT(distinct all_sessions.user_id) FROM heap.sessions AS all_sessions INNER JOIN ( SELECT user_id ,MIN(time) AS first_time FROM heap.sessions GROUP BY user_id ) AS first_session ON all_sessions.user_id = first_session.user_id AND all_sessions.time = first_session.first_time INNER JOIN heap.users AS users ON all_sessions.user_id = users.user_id --only include users with a UTM source defined WHERE utm_source is not null 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_099e214ef8a8" 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