Session ID
February 2, 2015
|
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'