You should query events_YYYYMMDD rather than events_intraday_YYYYMMDD so you're querying a stable dataset for the day. events_YYYYMMDD: The full daily export of events.If you select the daily option when you set up BigQuery Export, then the following table is also created each day. This table can include records of a session when that session spans multiple export operations.This table is deleted when events_YYYYMMDD is complete. Data is exported continuously throughout the day. Streaming export is a best-effort operation and may not include all data for reasons such as the processing of late events and/or failed uploads.

events_intraday_YYYYMMDD: An internal staging table that includes records of session activity that took place during the day.When you use this export option, BigQuery has more recent information you can analyze about your users and their traffic on your property.įor each day, streaming export creates one new table: You can choose the streaming export option when you link your Google Analytics 4 property to BigQuery.īigQuery streaming export makes data for the current day available within a few minutes via BigQuery Export. To understand the differences between BigQuery event export and the Google Analytics interface, and explore ways to mitigate these differences when possible, see Bridging the gap between Google Analytics UI and BigQuery export. For this reason, the data from BigQuery event export might differ from the data in the Google Analytics interface. The BigQuery event export provides access to raw event and user-level data, excluding any value additions that Google Analytics makes to the data found in standard reports and explorations.

Learn more about other BigQuery Export limits Differences between the Google Analytics interface and BigQuery Export Standard properties have a daily BigQuery Export limit of 1 million events. You can export to a free instance of BigQuery ( BigQuery sandbox), but exports that exceed the sandbox limits incur charges.

Data is also exported continuously throughout the day (see Streaming export below). Note: Once you export data from Analytics to BigQuery, you cannot re-export it.Ī full export of data takes place once a day.

Export google analytics data to excel