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.
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.
Any ideas would be awesome and much appreciated!
