How can a GA4 export stay within its daily BigQuery event limit?

The Citead team, updated

In short. Select only the needed data streams and exclude event names in the GA4 BigQuery link settings when managing the Daily export limit.

Definition: A GA4 BigQuery export can stay within the documented daily event limit by restricting the data streams included in the BigQuery link and excluding event names in its data filtering settings. Google documents a 1 million event limit for Daily exports from Standard properties.

Key facts

  • Google documents a 1 million event limit for Daily, or batch, exports from Standard Google Analytics properties. If a property consistently exceeds it, the daily export is paused and previous days are not reprocessed. Google Analytics Help
  • The BigQuery export details distinguish a complete Daily export of the previous day from Streaming export, which runs continuously during the day. Google's BigQuery export documentation
  • The link setup has a Configure data streams and events step. It lets you choose data streams for export and specify events to exclude.
  • Event exclusions can use existing events selected with Add, or event names entered through Specify event by name, including names not yet collected on the property.
  • After linking, an Editor or higher at the property level can add or remove data streams and add or remove events from the exclusion list.

How does the daily limit work?

Google's BigQuery Export limits documentation states that the 1 million event limit applies to Daily, or batch, exports for Standard properties. The same passage says Streaming export has no limit on the number of events. If the property consistently exceeds the Daily limit, Google says the daily export will be paused and earlier days will not be reprocessed.

Google also says property editors and administrators receive an email each time a property exceeds the daily limit. For a Standard property that significantly exceeds the limit, Analytics may pause Daily exports immediately. The page directs affected properties to data-stream export and event-exclusion settings to decrease the volume exported each day.

During linking, Google's setup instructions identify the Configure data streams and events control. Select the streams that belong in the export, then exclude event names from the export list.

Configure data streams and events
Data streams to export
Events to exclude
Specify event by name

The event picker can select an existing event with Add. Specify event by name also accepts an event name that has not yet been collected on the property. This makes the exclusion list usable before a named event appears in the existing-event list.

The same setup page documents changes after linking: open the BigQuery link, view Data streams and events, select additional streams or remove existing ones, and use the Events to exclude list to add or remove event names. Removing an event uses the minus sign at the end of its row.

Which export should you check against the limit?

Google's BigQuery export details describes Daily export as a once-per-day export of all raw, unsampled event data from the previous day. Its export table lists Standard properties as having up to 1 million events per day, with filtering options to stay under the limit. Streaming export is described separately as a real-time export of the current day's data with no volume limits.

After the link is complete, Google says data should start flowing to the BigQuery project within 24 hours. When Daily export is enabled, 1 file is exported each day and contains the previous day's data. Check the selected streams and the Events to exclude list before relying on that Daily file as the complete export for a reporting day.

FAQ

Does Streaming export use the 1 million event limit?

Google documents the 1 million event limit for Daily exports from Standard properties and describes Streaming export as having no volume limit. The two export types have separate delivery behavior, so identify which one is enabled when reviewing the limit.

Can I change the streams and exclusions after linking?

Yes. Google documents that you can add or remove data streams and add or remove events from the exclusion list after the BigQuery link is configured. The property-level role requirement is Editor or above.

What happens when a Standard property exceeds the limit?

Google says editors and administrators receive an email, and that a Daily export can be paused when the limit is exceeded. A Standard property that significantly exceeds the limit may be paused immediately.

Sources

  1. Google Analytics Help, "Set up BigQuery Export", n.d.
  2. Google Analytics Help, "Exporting Data from Google Analytics 4 Properties to BigQuery", n.d.

Check how a page reads to answer engines. Open the GEO score analyzer

Test a page and see what to fix first

The analysis usually takes less than 10 seconds and needs no account.

400,000+ pages scored in the public benchmark