anuj GCP BigQuery

Google Analytics Data in BigQuery

  • 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

anuj

I am passionate about getting cloud solutions right the first time. I help customers transition to the public cloud with the appropriate security controls and guardrails. GCP, AWS and Azure Security Specialist. <a href="https://calendly.com/anujvarma/google-cloud-architect-initial-consultation">Initial Consultation</a>

Leave a reply

Your email address will not be published. Required fields are marked *