Report not found

There was a problem finding this report.

Report

ARPU by Has Done Event

ARPU by Has Done Event
July 6, 2016 · Refreshed over 2 years ago
Description
ARPU based on whether or not a user has uploaded files within their account.

Collaborators

Run History
WITH user_info AS (SELECT identity, users.user_id, SUM(order_total) AS total_revenue, Count(event_id) AS event_count FROM heap.users AS users join heap.TRANSACTION ON identity = customer_id left join heap.dashboard_galleries_click_add_new_files AS event ON users.user_id = event.user_id GROUP BY 1, 2) SELECT CASE WHEN event_count = 0 THEN 'has not uploaded files' ELSE 'has uploaded files' END, Round(SUM(total_revenue) :: DECIMAL / Count(DISTINCT user_id), 2) AS avg_revenue_per_user FROM user_info GROUP BY 1 LIMIT 100
WITH user_info AS (SELECT identity, users.user_id, SUM(order_total) AS total_revenue, Count(event_id) AS event_count FROM heap.users AS users join heap.TRANSACTION ON identity = customer_id left join heap.dashboard_galleries_click_add_new_files AS event ON users.user_id = event.user_id GROUP BY 1, 2) SELECT CASE WHEN event_count = 0 THEN 'has not uploaded files' ELSE 'has uploaded files' END, Round(SUM(total_revenue) :: DECIMAL / Count(DISTINCT user_id), 2) AS avg_revenue_per_user FROM user_info GROUP BY 1
<div class="mode-header"> <h1 class='embed-hidden'>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="mode-grid container"> <div class="row"> <div class="col-md-12"> <mode-chart id="chart_21a9c053dc4a" 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