GA4 BigQuery export verified streaming + daily.
BigQuery export is GA4's most powerful feature — raw event-level SQL access, no sampling, no 14-month retention cliff. Half the properties we audit either don't have it on, or have it on the wrong way. The audit confirms both.
BigQuery export is the difference between "the GA4 UI told us X" and "we ran SQL against the actual events and the answer is Y." Properties without it run into three failure modes within the first year: (1) reports start sampling above 10M events and your numbers stop being trustworthy, (2) data older than 14 months silently disappears so year-over-year comparisons break, (3) anything you want to join to internal data — orders, CRM, ad spend — has to be hand-exported through CSV downloads. Properties that DO have it on are still split between streaming (real-time, recommended) and daily-only (cheap but lagged 12+ hours). Marketing leaders rarely know which mode their property is in until a data-engineering hire asks. The audit names the dataset, the project, and which mode is active.
- Reports whether BigQuery export is enabled at all — if not, surfaces the WARNING with the exact GA4 Admin → BigQuery Links menu path and the free-tier eligibility note.
- When it is enabled, names the GCP project + dataset receiving the data so the data team can connect Looker / Hex / dbt without hunting through GA4 admin tabs.
- Distinguishes streaming export (real-time, ~$0.05/GB stream cost) from daily-only export (free but 12+ hour lag) so you know whether your dashboards can run on near-realtime data.
- Cross-checks against your event volume — if you exceed the 1M events/day free-tier sampling threshold and you DON'T have BigQuery export, the GA4 UI numbers are likely sampled and the warning gets escalated.
- Reports the export status in plain English, no SQL required to verify. Marketing leaders sign off in seconds, the data team gets the project name to start querying.
BigQuery export not enabled — your data has a 14-month expiration
Without BigQuery export, every event GA4 collects today disappears 14 months from now. Year-over-year campaign analysis becomes impossible after that window. Custom funnels, cohort analysis, and joining to your CRM or ad-spend data all require either CSV exports (slow, manual, sampled) or a live SQL-grade data store. Free-tier BigQuery covers most properties under 1M events/day at zero cost — the gap is configuration time, not budget.
In GA4 Admin → Product Links → BigQuery Links → Link, pick (or create) a GCP project, choose your data location (match your Firestore region for low latency), select streaming export (not just daily) so dashboards stay near-realtime, then confirm. The first export populates within ~24 hours. Re-run the audit to confirm the check turns green and the dataset name shows up in the finding.
Hire a web analyst. Or install one.
GA4 BigQuery export is one of 10 high-stakes chores the agent covers end-to-end. Your first audit is free — and the agent keeps watching every night, so the next time ga4 bigquery export drifts, you hear it from us before it costs you.