Skip to content

Instantly share code, notes, and snippets.

@JustinCarmony

JustinCarmony/visits-and-hits.sql

Last active May 9, 2018 16:39
Show Gist options
  • Save JustinCarmony/a4f6b82bbbd254f4c8511281eaef0673 to your computer and use it in GitHub Desktop.
Save JustinCarmony/a4f6b82bbbd254f4c8511281eaef0673 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
visits-and-hits.sql
SELECT
VISIT.visitId,
VISIT.device.operatingSystem,
HIT.type,
HIT.page.pageTitle,
SUBSTR(HIT.page.pagePath, 0, 20) AS pagePath
FROM `141567708.ga_sessions_20180501` VISIT,
UNNEST(VISIT.hits) HIT
ORDER BY VISIT.visitStartTime ASC,
HIT.hitNumber ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment