How to Export Raw Data from Google Analytics to Google BigQuery

Exporting raw hit-level data out of Google Analytics is very tricky because Google Analytics only makes aggregated data available from the API. Effectively, we end up downloading a Google Analytics report with each request. While we could find out the number of visitors in a particular segment on a particular day on our website and fetch a variety of metrics for those users (such as source/medium, browser, or session duration), we couldn’t get at the underlying, user-level data to follow an individual user’s journey.

Premium version of Google Analytics also known as Google Analytics 360 does give you the option to export Google Analytics Data to Google BigQuery, but it comes at a cost of around $150,000 per year. You can try building your own solution but then you should be an expert in Google Analytics API, Google BigQuery API and this is just the beginning. You must also keep in mind that technologies like Google Analytics and Google BigQuery are always evolving and you might find what was working yesterday might not work today. Trust me, we have been following this space closely.

And so far we have just scratched the surface on how you can extract raw data from Google Analytics. It gets even more complicated when you integrate data from different marketing sources with Google Analytics. So instead of building and maintain your own solution or paying $150,000 for Google Analytics 360.

Try Electrik.AI’s Google Analytics Hit Level Data Extractor, it exports raw un-sampled hit-level data from Google Analytics to Google BigQuery without breaking a sweat.

Here is a sample of hit-level data exported from Google Analytics by Electrik.AI’s Google Analytics Hit-Level Data Extractor.

You can view a list of all dimensions/metrics extracted from Google Analytics here.