Report not found

There was a problem finding this report.

Report

Herald articles popular with Tribune readers

Tribune articles popular with Herald readers

Visitors

Cross-domain dashboard: Publisher
June 1, 2017 · Refreshed 14 days ago

Collaborators

Run History
SELECT tribune.week AS time_period, 'week' AS interval, tribune.viewers - crossdomain.viewers AS tribune, herald.viewers - crossdomain.viewers AS herald, crossdomain.viewers AS cross_domain, crossdomain.viewers / ( (tribune.viewers - crossdomain.viewers) + (herald.viewers - crossdomain.viewers) )::numeric AS cross_domain_rate FROM ( SELECT DATE_TRUNC('week',t.sent_at) AS week, COUNT(DISTINCT t.anonymous_id) AS viewers FROM demo.tribune_pages t GROUP BY 1 ) AS tribune JOIN ( SELECT DATE_TRUNC('week',h.sent_at) AS week, COUNT(DISTINCT h.anonymous_id) AS viewers FROM demo.herald_pages AS h GROUP BY 1 ) AS herald ON tribune.week = herald.week JOIN ( SELECT DATE_TRUNC('week',t.sent_at) AS week, COUNT(DISTINCT t.anonymous_id) AS viewers FROM demo.tribune_pages t JOIN demo.herald_pages AS h ON t.context_traits_cross_domain_id = h.context_traits_cross_domain_id AND DATE_TRUNC('week',t.sent_at) = DATE_TRUNC('week',h.sent_at) GROUP BY 1 ) AS crossdomain ON tribune.week = crossdomain.week UNION ALL SELECT tribune.month AS time_period, 'month' AS interval, tribune.viewers - crossdomain.viewers AS tribune, herald.viewers - crossdomain.viewers AS herald, crossdomain.viewers AS cross_domain, crossdomain.viewers / ( (tribune.viewers - crossdomain.viewers) + (herald.viewers - crossdomain.viewers) )::numeric AS cross_domain_rate FROM ( SELECT DATE_TRUNC('month',t.sent_at) AS month, COUNT(DISTINCT t.anonymous_id) AS viewers FROM demo.tribune_pages t GROUP BY 1 ) AS tribune JOIN ( SELECT DATE_TRUNC('month',h.sent_at) AS month, COUNT(DISTINCT h.anonymous_id) AS viewers FROM demo.herald_pages AS h GROUP BY 1 ) AS herald ON tribune.month = herald.month JOIN ( SELECT DATE_TRUNC('month',t.sent_at) AS month, COUNT(DISTINCT t.anonymous_id) AS viewers FROM demo.tribune_pages t JOIN demo.herald_pages AS h ON t.context_traits_cross_domain_id = h.context_traits_cross_domain_id AND DATE_TRUNC('month',t.sent_at) = DATE_TRUNC('month',h.sent_at) GROUP BY 1 ) AS crossdomain ON tribune.month = crossdomain.month ORDER BY 2,1
SELECT tribune.week AS time_period, 'week' AS interval, tribune.viewers - crossdomain.viewers AS tribune, herald.viewers - crossdomain.viewers AS herald, crossdomain.viewers AS cross_domain, crossdomain.viewers / ( (tribune.viewers - crossdomain.viewers) + (herald.viewers - crossdomain.viewers) )::numeric AS cross_domain_rate FROM ( SELECT DATE_TRUNC('week',t.sent_at) AS week, COUNT(DISTINCT t.anonymous_id) AS viewers FROM demo.tribune_pages t GROUP BY 1 ) AS tribune JOIN ( SELECT DATE_TRUNC('week',h.sent_at) AS week, COUNT(DISTINCT h.anonymous_id) AS viewers FROM demo.herald_pages AS h GROUP BY 1 ) AS herald ON tribune.week = herald.week JOIN ( SELECT DATE_TRUNC('week',t.sent_at) AS week, COUNT(DISTINCT t.anonymous_id) AS viewers FROM demo.tribune_pages t JOIN demo.herald_pages AS h ON t.context_traits_cross_domain_id = h.context_traits_cross_domain_id AND DATE_TRUNC('week',t.sent_at) = DATE_TRUNC('week',h.sent_at) GROUP BY 1 ) AS crossdomain ON tribune.week = crossdomain.week UNION ALL SELECT tribune.month AS time_period, 'month' AS interval, tribune.viewers - crossdomain.viewers AS tribune, herald.viewers - crossdomain.viewers AS herald, crossdomain.viewers AS cross_domain, crossdomain.viewers / ( (tribune.viewers - crossdomain.viewers) + (herald.viewers - crossdomain.viewers) )::numeric AS cross_domain_rate FROM ( SELECT DATE_TRUNC('month',t.sent_at) AS month, COUNT(DISTINCT t.anonymous_id) AS viewers FROM demo.tribune_pages t GROUP BY 1 ) AS tribune JOIN ( SELECT DATE_TRUNC('month',h.sent_at) AS month, COUNT(DISTINCT h.anonymous_id) AS viewers FROM demo.herald_pages AS h GROUP BY 1 ) AS herald ON tribune.month = herald.month JOIN ( SELECT DATE_TRUNC('month',t.sent_at) AS month, COUNT(DISTINCT t.anonymous_id) AS viewers FROM demo.tribune_pages t JOIN demo.herald_pages AS h ON t.context_traits_cross_domain_id = h.context_traits_cross_domain_id AND DATE_TRUNC('month',t.sent_at) = DATE_TRUNC('month',h.sent_at) GROUP BY 1 ) AS crossdomain ON tribune.month = crossdomain.month ORDER BY 2,1
SELECT CASE WHEN LENGTH(t.title) > 46 THEN LEFT(t.title,46)||'...' ELSE t.title END AS title, COUNT(DISTINCT herald_viewers.context_traits_cross_domain_id) AS herald_viewers FROM demo.tribune_pages t JOIN ( SELECT DISTINCT h.context_traits_cross_domain_id FROM demo.herald_pages h ) AS herald_viewers ON t.context_traits_cross_domain_id = herald_viewers.context_traits_cross_domain_id GROUP BY 1 ORDER BY 2 DESC LIMIT 12
SELECT CASE WHEN LENGTH(t.title) > 46 THEN LEFT(t.title,46)||'...' ELSE t.title END AS title, COUNT(DISTINCT herald_viewers.context_traits_cross_domain_id) AS herald_viewers FROM demo.tribune_pages t JOIN ( SELECT DISTINCT h.context_traits_cross_domain_id FROM demo.herald_pages h ) AS herald_viewers ON t.context_traits_cross_domain_id = herald_viewers.context_traits_cross_domain_id GROUP BY 1 ORDER BY 2 DESC LIMIT 12
SELECT CASE WHEN LENGTH(h.title) > 46 THEN LEFT(h.title,46)||'...' ELSE h.title END AS title, COUNT(DISTINCT tribune_viewers.context_traits_cross_domain_id) AS tribune_viewers FROM demo.herald_pages h JOIN ( SELECT DISTINCT t.context_traits_cross_domain_id FROM demo.tribune_pages t ) AS tribune_viewers ON h.context_traits_cross_domain_id = tribune_viewers.context_traits_cross_domain_id GROUP BY 1 ORDER BY 2 DESC LIMIT 12
SELECT CASE WHEN LENGTH(h.title) > 46 THEN LEFT(h.title,46)||'...' ELSE h.title END AS title, COUNT(DISTINCT tribune_viewers.context_traits_cross_domain_id) AS tribune_viewers FROM demo.herald_pages h JOIN ( SELECT DISTINCT t.context_traits_cross_domain_id FROM demo.tribune_pages t ) AS tribune_viewers ON h.context_traits_cross_domain_id = tribune_viewers.context_traits_cross_domain_id GROUP BY 1 ORDER BY 2 DESC LIMIT 12
<style> /* Chart text */ text { fill: #63656E !important; } .mode-filters { position: fixed; top: 0px; } </style> <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-6"> <mode-chart id="chart_fdbafdcd8e06" dataset="dataset" options="chart_options"></mode-chart> </div> <div class="col-md-6"> <mode-chart id="chart_25d4a538740c" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-6"> <mode-chart id="chart_02f7621fdd70" dataset="dataset" options="chart_options"></mode-chart> </div> <div class="col-md-6"> <mode-chart id="chart_99eee3e47652" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row" data-row-height="medium"> <div class="col-md-6"> <mode-table id="table_c268f1e5ea9e" dataset="dataset" options="table_options"></mode-table> </div> <div class="col-md-6"> <mode-table id="table_bc6f457fcd87" 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