Skip to main content

BigQuery

📦Website
đź’°

Costs

Monthly:Free
Annual:Free
🔑

Access

INTERNAL
ℹ️

Live database used as destination for google analytics raw data. Leads tables also created for website submissions

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.