Report not found

There was a problem finding this report.

Report

First Touch Properties

First Touch Properties
June 14, 2016 · Refreshed 11 months ago
Description
This query gives you the user id, date the user was first seen, and referrer, UTM parameters, and device type of the first session.

Collaborators

Run History
SELECT all_sessions.user_id ,identity ,first_session.first_time AS first_seen ,referrer ,utm_source ,utm_campaign ,device_type --add any user level properties or session level properties here 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 ORDER BY 2 ASC LIMIT 10
SELECT all_sessions.user_id ,identity ,first_session.first_time AS first_seen ,referrer ,utm_source ,utm_campaign ,device_type --add any user level properties or session level properties here 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 ORDER BY 2 ASC LIMIT 10
<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-table id="table_e581b48ac7de" dataset="dataset" options="table_options"></mode-table> </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