Export Google Analytics data from BigQuery using Standard or Legacy SQL.
Clone or download
Latest commit 388e16b Jan 26, 2017
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
README.md Standard and Legacy Jan 26, 2017
google-analytics-bigquery-legacy-export.sql Standard and Legacy Jan 26, 2017
google-analytics-bigquery-standard-export.sql Standard and Legacy Jan 26, 2017

README.md

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!