Loading.
Loading.
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.
GA4-INT-01BigQuery export not enabledGA4-INT-02BigQuery export streaming vs daily modeGA4-INT-03BigQuery dataset destination + projectGA4-DQ-01Sampling threshold approaching (10M events/property/day)GA4-DR-01Data retention < 14 months without BQ backupWithout 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.
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.