Skip to content

Export Google Analytics data from BigQuery using Standard or Legacy SQL.

Notifications You must be signed in to change notification settings

joaolcorreia/Google-Analytics-BigQuery-Data-Export

Repository files navigation

Google Analytics BigQuery data export

This repository contains SQL code to export data from Google Analytics in BigQuery, using standard or legacy SQL.

Data Extract

Google Analytics Data BigQuery Export

Both SQL queries below transform Google Analytics BigQuery nested data into flat hit level data with a timestamp making data easy to analyze using tools like Tableau, SAS, R, etc.

  • google-analytics-bigquery-legacy-export.sql
  • google-analytics-bigquery-standard-export.sql
Instructions:
  1. Open the SQL and configure the table(s) to export
  2. Output the results to another table and export to Google Storage
  3. Download the CSVs, done!

About

Export Google Analytics data from BigQuery using Standard or Legacy SQL.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published