Report not found

There was a problem finding this report.
Example - New Signup Analysis
July 31, 2016 · Refreshed 29 days ago
Description
Signup funnel performance, by month

Collaborators

Run History
SELECT month, created_user AS "New users", enter_email/created_user::FLOAT AS "% entering email", enter_info/created_user::FLOAT AS "% entering user info", complete_signup/created_user::FLOAT AS "% completing signup" FROM ( SELECT DATE_TRUNC('month',occurred_at) AS month, COUNT(DISTINCT CASE WHEN event_name = 'create_user' THEN user_id ELSE NULL END) AS created_user, COUNT(DISTINCT CASE WHEN event_name = 'enter_email' THEN user_id ELSE NULL END) AS enter_email, COUNT(DISTINCT CASE WHEN event_name = 'enter_info' THEN user_id ELSE NULL END) AS enter_info, COUNT(DISTINCT CASE WHEN event_name = 'complete_signup' THEN user_id ELSE NULL END) AS complete_signup FROM benn.fake_fact_signup_events WHERE event_type = 'signup_flow' GROUP BY 1 ) totals ORDER BY 1
SELECT month, created_user AS "New users", enter_email/created_user::FLOAT AS "% entering email", enter_info/created_user::FLOAT AS "% entering user info", complete_signup/created_user::FLOAT AS "% completing signup" FROM ( SELECT DATE_TRUNC('month',occurred_at) AS month, COUNT(DISTINCT CASE WHEN event_name = 'create_user' THEN user_id ELSE NULL END) AS created_user, COUNT(DISTINCT CASE WHEN event_name = 'enter_email' THEN user_id ELSE NULL END) AS enter_email, COUNT(DISTINCT CASE WHEN event_name = 'enter_info' THEN user_id ELSE NULL END) AS enter_info, COUNT(DISTINCT CASE WHEN event_name = 'complete_signup' THEN user_id ELSE NULL END) AS complete_signup FROM benn.fake_fact_signup_events WHERE event_type = 'signup_flow' GROUP BY 1 ) totals ORDER BY 1
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="container mode-grid"> <div class="row" data-row-height="small"> <div class="col-md-6"> <mode-chart id="chart_dec91346b36c" dataset="dataset" options="chart_options"></mode-chart> </div> <div class="col-md-6"> <mode-chart id="chart_9b1c9f8206d2" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-4"> <mode-chart id="chart_bfc69fecef63" dataset="dataset" options="chart_options"></mode-chart> </div> <div class="col-md-8"> <mode-chart id="chart_12b5fc30d803" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-12"> <mode-table id="table_f5920bec8965" dataset="dataset" options="table_options"></mode-table> </div> </div> </div> <script> var chartHeight = 200; $("mode-chart").css("margin","500px") $(".chart").css("height",200) $(".chart-svg").css("height",200) $(".editor-chart").css("border","none")</script>
{{ 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