Session ID

Tags:

February 2, 2015 | Bounteous x Accolite

Legacy SQL

SELECT CONCAT(fullVisitorId, ".", STRING(visitId)) AS Session_ID
FROM   [google.com:analytics-bigquery:LondonCycleHelmet.ga_sessions_20130910]

Standard SQL

SELECT CONCAT(fullVisitorId, ".", CAST(visitId AS STRING)) AS Session_ID
FROM   'google.com:analytics-bigquery.LondonCycleHelmet.ga_sessions_20130910'