BigQuery Connector

Sync Google Analytics 4 Data to BigQuery

Detrics loads Google Analytics 4 into Google BigQuery on the schedule you set. The tables arrive clean, the history keeps growing, and you can query everything from SQL, Looker Studio, or Claude. We run the pipeline so you don't have to.

Book a Demo

*Free 30-minute consultation

SELECT
  session_source_medium,
  SUM(sessions) AS sessions,
  SUM(ecommerce_purchases) AS ecommerce_purchases,
  SUM(purchase_revenue) AS purchase_revenue
FROM `your_project.marketing_data.ga4_campaign_and_source_details_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY session_source_medium
ORDER BY sessions DESC
LIMIT 10

Why send Google Analytics 4 data to BigQuery?

Unsampled data

Query complete events with SQL, free of the sampling and cardinality limits of the web interface.

History without limits

Platform APIs cap how far back you can query. In BigQuery every Google Analytics 4 sync is stored across its 18 tables, so you accumulate years of your own history.

One warehouse for everything

Join Google Analytics 4 with the rest of your platforms in one place, no copy-pasting between sheets.

Ask Claude about it

With your data in BigQuery, Claude can answer business questions about Google Analytics 4 in plain language.

Google Analytics 4 tables in BigQuery

This is what Detrics creates for Google Analytics 4: 18 preset tables with scheduled syncs, plus any custom one you define.

Audience & Behavior

real_time_activity_hourly

Monitor current user activity in real-time

countrydevice categoryevent nameactive usersscreen page views

user_engagement_daily

User behavior and engagement metrics

account namesessionstotal usersaverage session durationbounce rate

new_vs_returning_users_daily

User acquisition and retention analysis

account namesessionsnew usersactive userstransactions

+3 more tables in this group

E-commerce & Revenue

e_commerce_overview_daily

Website sales and conversion tracking

account nameproperty namesessionstransactionspurchase revenue

revenue_by_campaign_daily

Campaign revenue performance over time

account namesession campaign nametotal revenuetransactions

item_performance_daily

Product and item analytics

account nameitem IDitem categoryitems vieweditems purchaseditem revenue

Traffic & Acquisition

campaign_performance_daily

Track marketing campaign effectiveness with revenue

session source mediumsession campaign namesessionstransactionspurchase revenue

conversion_funnel

Track user journey from session to purchase

session source mediumsessionsadd to cartscheckoutstransactionspurchase revenue

source_medium_analysis_daily

Traffic sources and their performance

session source mediumsessionstransactionspurchase revenue

+6 more tables in this group

HOW IT WORKS

From Google Analytics 4 to your warehouse

Connect your account once. Detrics handles schemas, syncs, and backfills.

First step

Connect your first datasource

Link any of 32+ marketing and ecommerce platforms in a couple of clicks.

Connect a source

Second step

Set up your destination

Point Detrics at your BigQuery project and dataset. We write the SQL and handle the setup for you.

Set up destination

Third step

Create your transfer

Choose what to sync and how often. Detrics builds and runs the pipeline for you.

Create a transfer

And that's it

Real-time data, forever

Your data lands in the warehouse and stays fresh automatically. We handle the syncing, the maintenance, and every API update for you.

Book a demo

In the demo we set everything up for you and save you hours.

Then ask Claude about it

With Google Analytics 4 in BigQuery, the Detrics MCP server lets you run queries in plain language. MCP access is included with every BigQuery plan.

Summarize my Google Analytics 4 data for the last 6 weeks

Traffic dropped this week according to Google Analytics 4. Find out why.

Which pages lost the most visits in Google Analytics 4 this month?

Explore the Google Analytics 4 MCP server

Every Google Analytics 4 field, on demand

Preset tables curated by our team
Custom tables with any field combination
Incremental syncs that only load new data
Automatic backfill of up to 12 months of history

84 metrics

168 dimensions

View Google Analytics 4 Fields

Get Google Analytics 4 into your warehouse this week