Connectors / Google Analytics 4 / BigQuery
Google Analytics 4 → BigQuery
Sessions, users, engagement and conversions by source/medium — the reporting backbone next to ad spend. Load jobs into your project (your billing) or a Yoker-managed dataset — date-partitioned, source-clustered, restatement-safe upserts.
How the sync works
- Point Yoker at your GCP project (or use a managed dataset).
- Choose sources; tables are created per connector with documented schemas.
- Syncs upsert on (source, date, dimensions) so restated ad metrics overwrite cleanly.
What lands in BigQuery
2 dimensions: date, session_source_medium
7 metrics: sessions, total_users, new_users, engaged_sessions, conversions, event_count, total_revenue
Restatement-aware: every sync re-pulls the trailing 3 days, so revised conversions overwrite cleanly in BigQuery — no duplicate rows, no stale numbers.
Why teams pick Yoker for this
- Hourly on every paid plan — most tools gate hourly refresh behind $99–199/mo tiers; here it starts at $29.
- Backfills are free and unlimited — pull years of Google Analytics 4 history without it counting against anything.
- The guarantees: price-lock, one-click cancel, 30-day refunds, and a 99% sync SLA with automatic credit.
- Unified schema: blend Google Analytics 4 with every other platform without renaming columns by hand.