title: Get visitor Latitude and Longitude from Google analytics through BigQuery
body: <p>I've been using BigQuery (SQL)for a bit but now need to get some more specific location data. At the moment, our Google analytics table schema has the usual:
  geonetwork.Metro, geoNetwork.region etc etc - but the geoNetwork.city data is pretty hit and miss.</p>
  
  <p>So I'm wondering if anyone knows how I can grab Latitude and Longitude from the Google analytics that feeds into BigQuery. I've read that lat and long is available in the Google analytics real-time reporting API - but wondering if there's a way to get it into bigquery. </p>
  
  <p>Any ideas would be awesome and much appreciated!</p>