Report not found

There was a problem finding this report.
Daily Conversion Rate
June 15, 2016 · Refreshed about 3 years ago
Description
This shows the percent of users who have converted (completed the flow) each day over the time period 6/1 -6/14 . Users had to complete the funnel each calendar day to be included.

Collaborators

Run History
With e1 as ( select distinct user_id, 1 as step_1, min(time) as step_1_time, time::date as day from heap.dashboard_galleries_view_gallery as e1 WHERE time BETWEEN '2016-06-01' AND '2016-06-15' group by 1, 4 ), e2 as ( select e1.user_id, 1 as step_2, min(time) as step_2_time, e2.time::date as day from heap.dashboard_galleries_click_add_new_files as e2 join e1 on e1.user_id=e2.user_id and e1.day = e2.time::date where time BETWEEN step_1_time and '2016-06-15' group by 1, 4 ), e3 as ( select e3.user_id, 1 as step_3, min(time) as step_3_time, e3.time::date as day from heap.dashboard_sidebar_click_publish_site as e3 join e2 on e2.user_id=e3.user_id and e2.day=e3.time::date where time BETWEEN step_2_time and '2016-06-15' group by 1, 4 ) select day, round(sum(step_3)/sum(step_1)::decimal, 4) as "Conversion Rate" from( select e1.user_id, step_1, step_1_time, step_3, step_3_time, e1.day From e1 left join e2 on e1.user_id = e2.user_id and e1.day=e2.day left join e3 on e2.user_id= e3.user_id and e2.day=e3.day ) as counts group by 1 order by 1 LIMIT 100
With e1 as ( select distinct user_id, 1 as step_1, min(time) as step_1_time, time::date as day from heap.dashboard_galleries_view_gallery as e1 WHERE time BETWEEN '2016-06-01' AND '2016-06-15' group by 1, 4 ), e2 as ( select e1.user_id, 1 as step_2, min(time) as step_2_time, e2.time::date as day from heap.dashboard_galleries_click_add_new_files as e2 join e1 on e1.user_id=e2.user_id and e1.day = e2.time::date where time BETWEEN step_1_time and '2016-06-15' group by 1, 4 ), e3 as ( select e3.user_id, 1 as step_3, min(time) as step_3_time, e3.time::date as day from heap.dashboard_sidebar_click_publish_site as e3 join e2 on e2.user_id=e3.user_id and e2.day=e3.time::date where time BETWEEN step_2_time and '2016-06-15' group by 1, 4 ) select day, round(sum(step_3)/sum(step_1)::decimal, 4) as "Conversion Rate" from( select e1.user_id, step_1, step_1_time, step_3, step_3_time, e1.day From e1 left join e2 on e1.user_id = e2.user_id and e1.day=e2.day left join e3 on e2.user_id= e3.user_id and e2.day=e3.day ) as counts group by 1 order 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_d1c4f7b66050" 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