Report not found

There was a problem finding this report.
Average Time Between Events
June 29, 2016 · Refreshed over 1 year ago
Description
This shows you the average time between a user visiting a site for the first time and the average time it takes for them to convert.

Collaborators

Run History
SELECT Round(avg(duration)::decimal,2) AS "avg_duration" FROM ( SELECT user_id ,EXTRACT(EPOCH FROM (end_time - start_time))/86400 as duration FROM( SELECT u.user_id ,min(joindate) AS start_time ,min(time) AS end_time FROM heap.dashboard_sidebar_click_publish_site as p JOIN heap.users as u ON p.user_id = u.user_id GROUP BY 1 ) as a ) as b
SELECT Round(avg(duration)::decimal,2) AS "avg_duration" FROM ( SELECT user_id ,EXTRACT(EPOCH FROM (end_time - start_time))/86400 as duration FROM( SELECT u.user_id ,min(joindate) AS start_time ,min(time) AS end_time FROM heap.dashboard_sidebar_click_publish_site as p JOIN heap.users as u ON p.user_id = u.user_id GROUP BY 1 ) as a ) as b
<div class="mode-heade"> <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_duration + " days"; </script> <style> #big_number{ font-size:36px; } </style> <div class="mode-grid container"></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