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). When you export data to BigQuery, you own that data, and you can use BigQuery ACLs to manage permissions on projects and datasets.Ī full export of data takes place once a day. In BigQuery, you can choose to export your data to external storage or import external data for the purposes of combining it with your Analytics data. You can export all of your raw events from Google Analytics 4 properties (including subproperties and roll-up properties) to BigQuery, and then use an SQL-like syntax to query that data. Exporting Data from Google Analytics 4 Properties to BigQueryīigQuery is a cloud data warehouse that lets you run highly performant queries of large datasets.

Sandboxie v4