Percent of New Sessions with Mediums

Tags:

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