Report not found

There was a problem finding this report.

Report

Funnel with Conversion Rates

Onboarding Funnel Group by Event Level Property
June 15, 2016 · Refreshed 11 months ago
Description
This funnel allows you to compare conversion rates based on an event level property. This query has event level properties based on the first event in the session.

Collaborators

Run History
With e1 as ( select distinct e1.user_id, 1 as step_1, min(time) as step_1_time, case when utm_source is null then 'None' else utm_source end from heap.dashboard_galleries_view_gallery as e1 inner join( select user_id, min(time) as mintime from heap.dashboard_galleries_view_gallery WHERE DATE(time) BETWEEN '2016-04-13' AND '2016-04-20' group by 1 ) as min_value on e1.user_id=min_value.user_id and e1.time=min_value.mintime WHERE DATE(time) BETWEEN '2016-04-13' AND '2016-04-20' group by 1, 4 ), e2 as ( select e1.user_id, 1 as step_2, min(time) as step_2_time from heap.dashboard_galleries_click_add_new_files as e2 join e1 on e1.user_id=e2.user_id where time BETWEEN step_1_time AND '2016-04-21' group by 1 ), e3 as ( select e3.user_id, 1 as step_3, min(time) as step_3_time from heap.dashboard_sidebar_click_publish_site as e3 join e2 on e2.user_id=e3.user_id where time BETWEEN step_2_time AND '2016-04-21' group by 1 ) select utm_source, CASE WHEN SUM(step_1) is NULL then 0 ELSE SUM(step_1) END AS "Step 1", CASE WHEN SUM(step_2) is NULL then 0 ELSE SUM(step_2) END AS "Step 2", CASE WHEN SUM(step_3) is NULL then 0 ELSE SUM(step_3) END AS "Step 3", CASE WHEN sum(step_3) is Null then 0 else ROUND(sum(step_3)/sum(step_1)::decimal, 4) END as total_conversion from( select e1.user_id, step_1, step_1_time, step_2, step_2_time, step_3, step_3_time, utm_source From e1 left join e2 on e1.user_id = e2.user_id left join e3 on e2.user_id= e3.user_id ) as user_counts group by 1
With e1 as ( select distinct e1.user_id, 1 as step_1, min(time) as step_1_time, case when utm_source is null then 'None' else utm_source end from heap.dashboard_galleries_view_gallery as e1 inner join( select user_id, min(time) as mintime from heap.dashboard_galleries_view_gallery WHERE DATE(time) BETWEEN '2016-04-13' AND '2016-04-20' group by 1 ) as min_value on e1.user_id=min_value.user_id and e1.time=min_value.mintime WHERE DATE(time) BETWEEN '2016-04-13' AND '2016-04-20' group by 1, 4 ), e2 as ( select e1.user_id, 1 as step_2, min(time) as step_2_time from heap.dashboard_galleries_click_add_new_files as e2 join e1 on e1.user_id=e2.user_id where time BETWEEN step_1_time AND '2016-04-21' group by 1 ), e3 as ( select e3.user_id, 1 as step_3, min(time) as step_3_time from heap.dashboard_sidebar_click_publish_site as e3 join e2 on e2.user_id=e3.user_id where time BETWEEN step_2_time AND '2016-04-21' group by 1 ) select utm_source, CASE WHEN SUM(step_1) is NULL then 0 ELSE SUM(step_1) END AS "Step 1", CASE WHEN SUM(step_2) is NULL then 0 ELSE SUM(step_2) END AS "Step 2", CASE WHEN SUM(step_3) is NULL then 0 ELSE SUM(step_3) END AS "Step 3", CASE WHEN sum(step_3) is Null then 0 else ROUND(sum(step_3)/sum(step_1)::decimal, 4) END as total_conversion from( select e1.user_id, step_1, step_1_time, step_2, step_2_time, step_3, step_3_time, utm_source From e1 left join e2 on e1.user_id = e2.user_id left join e3 on e2.user_id= e3.user_id ) as user_counts 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-table id="table_cb56cd363b34" 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