CODEWITHSUNDEEP
sqlgoogle-mapsgoogle-analyticsgeolocationgoogle-bigquery
Dows
Dows

Reputation: 11

Get visitor Latitude and Longitude from Google analytics through BigQuery

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!

Upvotes: 0

Views: 1702

Answers (1)

Pentium10
Pentium10

Reputation: 207838

BigQuery Export Schema is documented here and now contains lat/long columns.

Upvotes: 2

Related Questions