GA4 and BigQuery Tip for eCommerce Sites

Control Data Volume

During Black Friday and Cyber Monday, retailers will experience a huge surge in traffic on their sites and apps from customers looking for deals.

If you are an eCommerce store using GA4 and sending the data to BigQuery then this post will help you right away. However, even if you are not managing analytics or marketing for an eCommerce and are not worried about Black Friday or Cyber Monday traffic but do use both GA4 and BigQuery then this post will help you as well.

What's the issue with GA4 and BigQuery?

There are two main issues:

  1. BigQuery integration with GA4 has a daily event volume limit of 1 million.  The traffic spike during the holiday season might result in you sending over a million events to BigQuery. If that happens for a few days then your GA4 and BigQuery export will be paused thus causing you to lose all your data.

  2. The cost of data storage can go up. Even though you might be within your storage limit for now, the surge in traffic during the holiday season might push those limits and cause you to start paying for the data storage.

How to optimize GA4/BigQuery Integration?

To make sure that GA4/igQuery integration works without interruption, you must limit the flow of data to BigQuery.  Here is what you should do:

  1. Remove any events that you or your team has created for testing but are being sent to GA4

  2. Remove any old events that don't make sense anymore. I have seen many teams leaving the old events as is. This might be the time to clean those old events and remove them from the GA4/BigQuery export

  3. Remove any events that can be recreated with GA4 using existing data.

If you need the step-by-step instructions then check below.

Step-by-step Instructions for Removing Events

Subscribe to Premium Membership to read the rest.

Become a paying subscriber of Premium Membership to get access to this post and other subscriber-only content.

Already a paying subscriber? Sign In

A subscription gets you:
Advanced Content
Readymade SQL Scripts

Reply

or to participate.