Summing Total Hits

Tags:

February 2, 2015

Legacy SQL

SELECT SUM(totals.hits) AS Hits
FROM   [google.com:analytics-bigquery:LondonCycleHelmet.ga_sessions_20130910]

Standard SQL

SELECT SUM(totals.hits) AS Hits
FROM   'google.com:analytics-bigquery.LondonCycleHelmet.ga_sessions_20130910'