SELECT fullVisitorId, hits.page.hostname, hits.page.pagePath, hits.hitNumber, hits.time, nextTime, CASE WHEN hits.isExit IS NOT NULL THEN last_interaction - hit_time ELSE next_pageview - hit_time END AS time_on_page FROM( SELECT fullVisito…
SELECT fullVisitorId, hits.page.hostname, hits.page.pagePath, hits.hitNumber, hits.time, nextTime, CASE WHEN hits.isExit IS NOT NULL THEN last_interaction - hit_time ELSE next_pageview - hit_time END AS time_on_page FROM( SELECT fullVisito…