Skip to main content

BigQuery

Purpose: Data warehouse and destination for server-side logging.

Current use​

  • sGTM tag “Write to bigquery” writes event data to pacing-agency-we-1733769538574.SGTMtoBQ1pacing.pacingeventssgtm1.
  • Used for logging/analysis of server-side events.

Dependencies​

  • sGTM event stream; GA4/marketing events.
  • Access via Google Cloud project pacing-agency-we-1733769538574.

TODO​

  • Confirm schema, retention, and access roles.
  • Define ETL/export flows to reporting (Looker Studio, Sheets).
  • Decide on partitioning and cost controls for the logging table.