REPORT PARAMETERS

There is a more recent run of this report. Click here to view it.

Report not found

There was a problem finding this report.
Measuring Feature Use
November 1, 2014 · Refreshed almost 5 years ago
Description
Feature use over time, by the number of times the feature has been used and by how many people.

Collaborators

Run History
-- For details on how to use this report, visit -- https://modeanalytics.zendesk.com/hc/en-us/articles/203326184 WITH users AS ( SELECT user_id, activated_at FROM tutorial.playbook_users ), events AS ( SELECT user_id, event_name, occurred_at FROM tutorial.playbook_events ) SELECT time_id, home_page_visits_users AS home_page_visits, searches_users AS searches, messages_users AS messages, like_message_users AS like_messages, view_inbox_users AS view_inbox FROM ( SELECT DATE_TRUNC('day',e.occurred_at) AS time_id, COUNT(DISTINCT CASE WHEN e.event_name = 'home_page' THEN e.user_id ELSE NULL END) AS home_page_visits_users, COUNT(DISTINCT CASE WHEN e.event_name = 'search_run' THEN e.user_id ELSE NULL END) AS searches_users, COUNT(DISTINCT CASE WHEN e.event_name = 'send_message' THEN e.user_id ELSE NULL END) AS messages_users, COUNT(DISTINCT CASE WHEN e.event_name = 'like_message' THEN e.user_id ELSE NULL END) AS like_message_users, COUNT(DISTINCT CASE WHEN e.event_name = 'view_inbox' THEN e.user_id ELSE NULL END) AS view_inbox_users, COUNT(CASE WHEN e.event_name = 'home_page' THEN e.user_id ELSE NULL END) AS home_page_visits, COUNT(CASE WHEN e.event_name = 'search_run' THEN e.user_id ELSE NULL END) AS searches, COUNT(CASE WHEN e.event_name = 'send_message' THEN e.user_id ELSE NULL END) AS messages, COUNT(CASE WHEN e.event_name = 'like_message' THEN e.user_id ELSE NULL END) AS like_message, COUNT(CASE WHEN e.event_name = 'view_inbox' THEN e.user_id ELSE NULL END) AS view_inbox FROM users u JOIN events e ON e.user_id = u.user_id AND e.occurred_at >= '2014-01-01' AND e.occurred_at <= '2014-10-31' GROUP BY 1 ORDER BY 1 ) z
-- For details on how to use this report, visit -- https://modeanalytics.zendesk.com/hc/en-us/articles/203326184 WITH users AS ( SELECT user_id, activated_at FROM tutorial.playbook_users ), events AS ( SELECT user_id, event_name, occurred_at FROM tutorial.playbook_events ) SELECT time_id, {% if metric == 'number of users' %} home_page_visits_users AS home_page_visits, searches_users AS searches, messages_users AS messages, like_message_users AS like_messages, view_inbox_users AS view_inbox {% elsif metric == 'number of events' %} home_page_visits, searches, messages, like_messages, view_inbox {% elsif metric == 'average times used per user' %} home_page_visits/CASE WHEN home_page_visits_users = 0 THEN 1 ELSE home_page_visits_users END::FLOAT AS home_page_visits, searches/CASE WHEN searches_users = 0 THEN 1 ELSE searches_users END::FLOAT AS searches, messages/CASE WHEN messages_users = 0 THEN 1 ELSE messages_users END::FLOAT AS messages, like_message/CASE WHEN like_message_users = 0 THEN 1 ELSE like_message_users END::FLOAT AS like_messages, view_inbox/CASE WHEN view_inbox_users = 0 THEN 1 ELSE view_inbox_users END::FLOAT AS view_inbox {% endif %} FROM ( SELECT DATE_TRUNC('{{time_interval}}',e.occurred_at) AS time_id, COUNT(DISTINCT CASE WHEN e.event_name = 'home_page' THEN e.user_id ELSE NULL END) AS home_page_visits_users, COUNT(DISTINCT CASE WHEN e.event_name = 'search_run' THEN e.user_id ELSE NULL END) AS searches_users, COUNT(DISTINCT CASE WHEN e.event_name = 'send_message' THEN e.user_id ELSE NULL END) AS messages_users, COUNT(DISTINCT CASE WHEN e.event_name = 'like_message' THEN e.user_id ELSE NULL END) AS like_message_users, COUNT(DISTINCT CASE WHEN e.event_name = 'view_inbox' THEN e.user_id ELSE NULL END) AS view_inbox_users, COUNT(CASE WHEN e.event_name = 'home_page' THEN e.user_id ELSE NULL END) AS home_page_visits, COUNT(CASE WHEN e.event_name = 'search_run' THEN e.user_id ELSE NULL END) AS searches, COUNT(CASE WHEN e.event_name = 'send_message' THEN e.user_id ELSE NULL END) AS messages, COUNT(CASE WHEN e.event_name = 'like_message' THEN e.user_id ELSE NULL END) AS like_message, COUNT(CASE WHEN e.event_name = 'view_inbox' THEN e.user_id ELSE NULL END) AS view_inbox FROM users u JOIN events e ON e.user_id = u.user_id AND e.occurred_at >= '{{start_date}}' AND e.occurred_at <= '{{end_date}}' GROUP BY 1 ORDER BY 1 ) z {% form %} start_date: type: text default: 2014-01-01 end_date: type: text default: 2014-10-31 time_interval: type: select options: [['day','day'], ['week','week'], ['month','month']] default: day metric: type: select options: [['number of users','number of users'], ['number of events','number of events'], ['average times used per user','average times used per user']] default: 'number of users' {% endform %}
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="container mode-grid"> <div class="row"> <div class="col-md-12"> <mode-chart id="chart_d35deb24e9a0" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row" data-row-height="medium"> <div class="col-md-12"> <mode-table id="table_b0e6872d6112" 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