GA4 and Google Data Studio Quota Limits and How to Avoid Them

GA4 quotas in Looker Studio are proving to be a real pain point for users who are reliant on Looker Studio – here’s how to solve them.

Unless you’ve been living under a rock, you’ve most likely heard about the chaos that the recent Looker Studio release has created for those reporting on Google Analytics 4 properties in Data Studio.

What’s the limitation with GA4 and Looker Studio? 

Put simply, quotas. 

What first seemed to be a temporary bug in Looker Studio turned out to be one of the most controversial GA4 updates Google has ever made, impacting almost every user working with Looker Studio (Google Data Studio).

What are the limitations?

When trying to extract data from GA4, a tool — such as data studio — sends a request to the GA4 API. There are limitations on how often this can happen.

The GA4 API quotas dictate these limitations.

The most important quotas are:

  • Concurrent requests (10)
  • Hourly tokens per Property per Project (1,250)
  • Daily tokens per Property per Project (25,000)

There are different quotas for free vs premium accounts, with the latter usually being 5-10x those of free accounts.

At first glance, these quotas may seem reasonable, but even the most basic Looker Studio report can hit these very quickly. For example, a single report page with 5 charts or scorecards connected to GA4 will hit concurrent request quota immediately for a single view. And that’s before you share it with anyone else.

Once a quota is exceeded, the charts will break, and you’ll need to wait for the quota to refresh before you can send any more requests to the GA4 API.

Depending on the type of quota that is exceeded, it can take up to 24 hours.

How to simplify your Looker Studio Reports

According to Google, there are several workarounds to mitigate quota issues. 

They recommend:

  • Reducing the traffic to the report and, or
  • Reducing the number of charts on each page.

While you can consider sharing the report with fewer people, it’s not always possible. The latter may be more viable. To simplify your data studio reports, consider reducing the number of charts.

Unfortunately, the new quotas are so low that they break even the simplest of dashboards.

Luckily, there are other workarounds, including Google Big Query. 

How to connect Google Analytics 4 (GA4) to Google Big Query

Google BigQuery is a cloud-based data warehouse that enables you to store and analyze large datasets using SQL queries. By exporting your analytics data to BigQuery, then using the BigQuery connector, you can visualise that data in Data Studio, without hitting quotas. 

To connect GA4 to Google Big Query:

  1. Set up a Google Cloud project: To use Google BigQuery, you’ll need to create a Google Cloud project.
  2. Create a BigQuery dataset: In the BigQuery console, create a new dataset where you want to store your GA4 data.
  3. Enable BigQuery export in GA4: Navigate to admin within your GA4 property. Under product links, click on ‘BigQuery Links’ and hit ‘link’. You’ll then be able to select your BigQuery project. You’ll then be able to configure your data stream, events and import frequency. 
  4. Set up permissions: In the IAM & Admin section of your Google Cloud project, add the service account associated with your GA4 data stream as a member with the “BigQuery Data Editor” role.
  5. Verify data: Once you’ve completed these steps, you should start seeing GA4 data in your BigQuery table. You can verify this by running a query in the BigQuery console to retrieve the data.

It’s worth noting that GA4 data is exported to BigQuery in a raw format. 

This means that you can run complex queries on your GA4 data, but only if you understand how to write them.

Resources for writing queries

Luckily, there are a wealth of resources available to help you write queries. Resources for writing queries include:

  • Google Cloud Community: a platform where developers can connect with each other and share their knowledge.The community has a section dedicated to BigQuery, where you can find answers to problems you’re sure to come up against.
  • Google Cloud Training: Google Cloud also offers free and paid training courses that cover BigQuery, including how to write queries. These are designed for both beginners and advanced users, and are always worth trying
  • Molzana can help! and a shameless plug for our wonderful analytics team who have ready to go solutions for all things Looker Studio, GA4 & BigQuery (we recently helped Subway solve issues for their mobile app)

Reporting Consultancy


We provide insights and commentary so you can truly understand website and campaign performance and plan killer optimisations.

App & Mobile Analytics

Digital Analytics Consultancy


Let’s turn your Web Analytics data into insight. Our certified web analytics team have vast expertise across Google Analytics, Google Analytics 360, Adobe Analytics and Tag Management Systems.

Data Strategy


Every business needs a data strategy to understand the needs of their company and make smart technology decisions.

Data Strategy

Business Intelligence


Powerful Business Intelligence solutions that allows for seamless integration of your key data sets, automated and in the hands of your business decision makers.

Business Intelligence

Tag Implementation


With up to 150 tags on some website, Molzana’s tag management and implementation services ensure that your data gets collected while your website remains unaffected.

Report Automation & Dashboards


Elegant and automated, Molzana’s reporting team can create amazing dashboard and report solutions to help your business get to insights and decisions quicker.

Report Automation & Dashboards

Visitor Behaviour


Understanding visitor behavior is vital to understanding how visitors interact with website content and marketing channels.

Visitor Behaviour

Consumer Insight


Consumer Trends & Insight hold the key to understanding your audience. Beyond simple reporting, Molzana can help turn your insight into action.

Consumer Insights

App & Mobile Analytics


We assist in providing powerful insight into iOS, Android & Windows Apps as well as Mobile Websites.

App & Mobile Analytics

Marketing Optimisation


We scrutinise user behaviour, audiences, ad copy and landing pages to improve performance.

Data Strategy

Getting Ready For Google Analytics 4 (GA4)


Get UK based expert support in implementing GA4 tracking for your website and avoid losing valuable data before July…

Solutions for Start-Ups

Conversion Rate Optimisation (CRO) Consultancy


Conversion Rate Optimisation is essential for ensuring your site performs in terms of driving sales, leads or sales development.

Report Automation & Dashboards

Data Science


We take your historic data to look into the future with pinpoint accuracy.

Contact Molzana


Molzana

Digital Analytics, SEO & CRO Agency

London & Manchester.


Get in Touch

Telephone: +44 (0) 20 8938 3136
Email: info@molzana.com

London: 32 Cubitt St, London WC1X 0LR
Manchester:
 5 Piccadilly, Aytoun St, M1 3BR
Edinburgh:
 15-16 Queen Street, EH2 1JE


Molzana Logo Blue

  • This field is for validation purposes and should be left unchanged.