Erstellung des Ereignis-Seiten-Berichtes in Big Query mit Universal Analytics Daten

select
  hits.page.pagepath as page,
  -- hits.page.pagetitle as page_title,
  count(*) as total_events,
  count(distinct concat(cast(fullvisitorid as string), cast(visitstarttime as string))) as unique_events,
  ifnull(sum(hits.eventinfo.eventvalue),0) as event_value,
  ifnull(sum(hits.eventinfo.eventvalue) / count(*),0) as avg_value
from
  `bigquery-public-data.google_analytics_sample.ga_sessions_20160801`,
  unnest(hits) as hits
where
  totals.visits = 1
  and hits.type = 'EVENT'
group by
  hits.page.pagepath
  -- ,hits.page.pagetitle
order by total_events desc