• Need to be an admin for google analytics
  • Need the appropriate GCP permissions (role ) on BigQuery (roles.bigquery.admin or roles/bigquery.dataOwner)
  1. Sign in to Google Analytics. ...
  2. Click Admin, and navigate to the Analytics 360 property that contains the view you want to link.
  3. In the PROPERTY column, click All Products, then click Link BigQuery.
  4. Enter your BigQuery project number or ID. ...

That's it.

Now, you can run your SQL queries on the analytics data in bigquery