[UA] BigQuery Export for Analytics [Legacy] - Analytics Help Skip to main content Analytics Help Sign in Google Help Help Center Get started with Analytics Collect and manage data Report and explore Advertising and attribution Audiences and remarketing Manage accounts, properties, and users Google Analytics 360 Policies and data privacy Community Analytics Privacy Policy Terms of Service Submit feedback Send feedback on... This help content & information General Help Center experience Next Help Center Community Announcements Analytics Contact us Get started with Analytics Introduction to AnalyticsSet up AnalyticsGuides and videosTroubleshootGlossary Collect and manage data Events and key eventsImport data from external systemsIntegrationsMeasure ecommerceMeasure lead generationFirst-party dataTroubleshoot data issues Report and explore ReportsExplorationsDimensions and metricsAnalytics IntelligenceThe Analytics appHow data is stored and displayed Advertising and attribution Understand advertisingUnderstand attributionManage and configure attributioniOS conversion measurement Audiences and remarketing Set up audiencesUse audiences for advertising and remarketing Audiences for common marketing objectivesTroubleshoot audiences Manage accounts, properties, and users [GA4] SubpropertiesRoll-up properties Google Analytics 360 [GA4] SubpropertiesRoll-up propertiesHow data is stored and displayed Policies and data privacy Data privacy and security [UA] BigQuery Export for Analytics [Legacy] Use BigQuery to quickly query all of your Analytics data. You are viewing a legacy article about Universal Analytics. Learn more about Google Analytics 4 replacing Universal Analytics. In light of the previous announcements for Universal Analytics 360 customers regarding the GA4 migration, Big Query (BQ) export for App views has been experiencing instability since May 14, 2024 and may not function as expected. This article is about using BigQuery Export in Universal Analytics. For information about using BigQuery Export in Google Analytics 4, go to [GA4] Set up BigQuery Export. This feature is only available in Analytics 360, part of Google Marketing Platform. Learn more about Google Marketing Platform. BigQuery is a cloud data warehouse that lets you run super-fast queries of large datasets. You can export session and hit data from a Google Analytics 360 account to BigQuery, and then use a SQL-like syntax to query all of your Analytics data. When you export data to BigQuery, you own that data, and you can use BigQuery ACLs to manage permissions on projects and datasets.   Compare BigQuery Export in Google Analytics 4 and Universal Analytics Google Analytics 4 Universal Analytics Available to Standard (free) and 360 (paid) Standard limit: 1M events per day 360 limit: Billions of events per day Available to 360 (paid) Cost Free export to BigQuery Sandbox within Sandbox limits Exported data that exceeds Sandbox limits incurs charges per contract terms Cost Free export to BigQuery Sandbox within Sandbox limits Exported data that exceeds Sandbox limits incurs charges per contract terms Setup Can include specific data streams and exclude specific events for each property (lets you control export volume and cost) Setup Can link 1 view per property (exports all data in that view) Streaming export $0.05 per GB (learn more about BigQuery pricing) Table created: events_intraday_YYYYMMDD Table is deleted each day: if you also use the daily-export option in addition to streaming when the daily table is complete Does not include User campaign, User source, or User medium data for new users Streaming export $0.05 per GB (learn more about BigQuery pricing) Table created: ga_realtime_sessions_YYYYMMDD BigQuery view created: ga_realtime_sessions_view_YYYYMMDD Daily export Table created: events_YYYYMMDD Daily export Tables created ga_sessions_intraday_YYYYMMDD Updated at least 3 times per day Each updated overwrites previous data Deleted when full import from next day is complete ga_sessions_YYYYMMDD Full daily import Fresh Daily export Available on “Normal” and “Large” 360 properties Learn more about processing differences between daily export and fresh daily. Not applicable Export, general Backfill: no backfill Dataset: for each linked property, 1 dataset named analytics_<property id> If you've implemented consent mode, export includes: cookieless pings customer-provided data (user_id, custom dimensions) Export, general Backfill: upon linking, backfill of 13 months of data or 10B hits, whichever is smaller (Backfill to BigQuery Sandbox can fail) Dataset: for each linked view, 1 dataset named the same as the view Export schema GA4 only exports the traffic source that first acquired the user Does not support UA data exported to BigQuery Each row in a BigQuery table represents an event Event data that is unique to Google Analytics 4 While there are some Google Analytics 4 fields that are essentially the same as Universal Analytics fields (e.g., device.category and device.deviceCategory), there are more differences than similarities between GA4 event data and UA hit data Export schema Session-level attribution across multiple touch points Each row in a BigQuery table represents a session Hit data that is unique to Universal Analytics While there are some Universal Analytics fields that are essentially the same as Google Analytics 4 fields (e.g., device.deviceCategory and device.category), there are more differences than similarities between UA hit data and GA4 event data. Next step Set up BigQuery Export. Related resources Visit the following guides to learn more about: Google BigQuery BigQuery ACLs BigQuery syntax Build BigQuery recommendation system BigQuery design patterns If you already have BigQuery set up, you can get acquainted with it by using our sample dataset. Was this helpful? How can we improve it? Submit Need more help? Try these next steps: Post to the help community Get answers from community members Contact us Tell us more and we’ll help you get there false BigQuery Export 1 of 3 [UA] Set up BigQuery Export [Legacy] 2 of 3 [UA] Localize your BigQuery Export in the EU [Legacy] 3 of 3 [UA] Export error messages [Legacy] Choose your own learning path Check out google.com/analytics/learn, a new resource to help you get the most out of Google Analytics 4. The new website includes videos, articles, and guided flows, and provides links to the Google Analytics Discord, Blog, YouTube channel, and GitHub repository. Start learning today! ©2026 Google Privacy Policy Terms of Service Language català‎dansk‎Deutsch‎español‎español (Latinoamérica)‎Filipino‎français‎hrvatski‎Indonesia‎italiano‎latviešu‎lietuvių‎magyar‎Nederlands‎norsk‎polski‎português‎português (Brasil)‎română‎slovenčina‎slovenščina‎suomi‎svenska‎Tiếng Việt‎Türkçe‎čeština‎Ελληνικά‎български‎русский‎српски‎українська‎‏עברית‏العربيةहिन्दी‎ไทย‎中文（简体）‎中文（繁體）‎日本語‎한국어‎ English‎ Enable Dark Mode Send feedback on... This help content & information General Help Center experience Search Clear search Close search Google apps Main menu 187687235988144351 true Search Help Center false true true true true true 69256 false false false false false