Report not found

There was a problem finding this report.

Report

Accounts table

Non-visiting customers

Web events table

Customers who did not visit website in 2016
September 26, 2016 · Refreshed over 2 years ago

Collaborators

Run History
SELECT * FROM demo.web_events
SELECT * FROM demo.web_events
SELECT * FROM demo.accounts
SELECT * FROM demo.accounts
SELECT a.id as customer_id, a.name as customer_name FROM demo.accounts a LEFT JOIN demo.web_events we ON we.account_id = a.id AND we.occurred_at BETWEEN '2016-01-01' AND '2016-12-31 23:59:59' WHERE we.id is NULL
SELECT a.id as customer_id, a.name as customer_name FROM demo.accounts a LEFT JOIN demo.web_events we ON we.account_id = a.id AND we.occurred_at BETWEEN '2016-01-01' AND '2016-12-31 23:59:59' WHERE we.id is NULL
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="mode-grid container"> <div class="row"> <div class="col-md-12"> <mode-table id="table_2d1277b1c85d" 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