ole-boss ole-boss
ole-boss
/ Big Query Google Analytics sessions export including site speed metrics.sql
Last active
June 13, 2020 14:41
This script helps you creating sessions from Google Analytics raw data on hit level in Google Big Query. The export will also include some metrics related to site speed based on Google's Latency Tracking KPIs.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| first_sessions.sid AS sessionId, | |
| visitorId, | |
| first_transactions.transactionId AS transactionId, | |
| timestamp, | |
| deviceCategory, | |
| landingPage, | |
| pageviews, | |
| timeOnSite, | |
| channel, |