Landing Page for Visit(or)s

SELECT
  fullVisitorId,
  visitId,
  -- Uses the knowledge that hits are stored in chronological order
  FIRST(IF(hits.type = "PAGE", hits.page.pagePath, NULL)) WITHIN RECORD AS landingPagePath
FROM
  [google.com:analytics-bigquery:LondonCycleHelmet.ga_sessions_20130910]