Percent of New Sessions with Mediums

June 23, 2016
By Bounteous
SELECT trafficSource.medium, 
       SUM(totals.newVisits) / SUM(totals.visits) AS percentNewSessions
FROM [google.com:analytics-bigquery:LondonCycleHelmet.ga_sessions_20130910]
GROUP BY trafficSource.medium