You've successfully subscribed to GA4BigQuery
Success! Your account is fully activated, you now have access to all content.
Success! Your billing info is updated.
Billing info update failed.

How to filter events in your GA4 BigQuery export to avoid exceeding daily 1 million event limit

How to filter events in your GA4 BigQuery export to avoid exceeding daily 1 million event limit

Join 3,200+ other professionals and receive a monthly newsletter packed with GA4 & BigQuery news, tips & tricks

Great! Check your inbox and click the link to confirm your subscription
Please enter a valid email address!
Already have an account? Sign in

Data filtering is a powerful solution that can help you ensure you're only exporting the GA4 data you need in BigQuery. It can be especially useful for those who are working with a standard GA4 property that has a daily export limit of 1 million events.

When you're working with a standard property, it's important to keep in mind that if your property consistently exceeds the export limit, the daily BigQuery export will be paused and previous days' exports will not be reprocessed. This can be a real headache for property editors and administrators, who will receive an email notification each time a property they manage exceeds the daily limit.

That notification will indicate when their export will be paused if action is not taken. Additionally, if a standard property significantly exceeds the one-million-event daily limit, Analytics may pause daily exports immediately.

Event filtering

This is where data filtering comes in. By using the data-filtering options available to you, such as data-stream export and event-exclusion, you can decrease the volume of events exported each day and ensure that the daily export continues to operate smoothly. This can help you avoid those pesky email notifications and ensure that your exports are always running smoothly.

So, whether you're looking to limit the size of your exports or just make sure you're exporting the data you need, data filtering can be a valuable tool.

The desired filtering can be configured in the linking process.

Filtering in an existing BigQuery connection

But what if you've already configured the link and want to make changes? No problem! You can add or remove data streams and events to or from the exclusion list after you've configured the BigQuery link. Here's how:

Note: When signing in, use an email address that has owner access to the BigQuery project and also has the Editor role for the Analytics property that includes the data stream you want to link.
  1. In your GA4 property, click Admin > BigQuery Links.
  2. Click the row for the project whose link you want to modify.
  3. Under Data streams and events, click  Configure data streams and events.
  4. Under Data streams to export, you can select additional data streams to export or remove existing data streams from the list.
  5. On the Events to exclude list, you can click Add to select from a list of existing events or click Specify event by name to choose existing events by name or to specify event names that have yet to be collected on the property.
  6. To remove an event from the list, click the minus sign at the end of that row.

And that's it! With these simple steps, you can easily exclude data streams and events from your export in BigQuery, giving you more control over the data you're working with.

Now it's your turn!

I hope you've enjoyed this and feel a bit more confident to utilise your own Google Analytics data in BigQuery. Drop a line in the comments if you have any questions, feedback or suggestions related to this article.