GA4BQ™ - GA4 BigQuery SQL Generator

GA4BQ™ - SQL generator for Google Analytics 4 on Google BigQuery, without SQL knowledge using simple visual query builder.
What is GA4BQ™ - GA4 BigQuery SQL Generator?
GA4BQ™ - GA4 BigQuery SQL Generator is a user-friendly Chrome extension that allows easy generation of SQL queries for Google Analytics 4 data on BigQuery without prior SQL knowledge. It features a visual query builder for defining metrics, dimensions, filters, and time ranges. It also readily includes calculated metrics and dimensions for ease. Ideal for data analysts and marketers, it facilitates easy data-driven decision making.

Extension stats

Users: 2,000+
Rating: 5.00 (5)
Version: 0.4.50 (Last updated: 2023-12-05)
Creation date: 2023-04-23
Risk impact: Moderate risk impact
Risk likelihood: Low risk likelihood
Manifest version: 3
Permissions:
  • storage
  • identity
Host permissions:
  • https://*/*
Size: 4.15M

Other platforms

Not available on Firefox
Not available on Edge
Want to check extension ranking and stats more quickly for other Chrome extensions? Install Chrome-Stats extension to view Chrome-Stats data as you browse the Chrome Web Store.

Extension summary

Introducing GA4BQ™ (BETA): The Google Analytics 4 BigQuery SQL Generator Extension for Chrome. This easy-to-use extension allows you to quickly and easily generate SQL queries for Google Analytics 4 on BigQuery without the need for any prior knowledge of SQL. With just a few clicks, you can access your Google Analytics 4 data in BigQuery and start analyzing it in no time.

Installation instructions

  1. Install the extension
  2. Refresh the BigQuery tab (if it's open, and one time only)
  3. Click the extension icon or open a new query tab and click the GA4BQ button.

The extension is simple to use and requires no special setup. Simply install it on your Chrome browser, go to your Google Analytics 4 table in BigQuery, open a "Query" tab and click on the extension icon. You will be presented with a user-friendly interface where you can select the metrics and dimensions you want to include in your query, as well as any filters or time ranges you want to apply.

To simplify, GA4BQ already includes built-in calculated dimensions and metrics so you won't have to deal with it.

Once you have made your selections, the extension will automatically generate the SQL query for you. You can then copy and paste the query into the BigQuery web UI and run it to retrieve your Google Analytics 4 data.

The extension is perfect for data analysts, marketers, and anyone else who needs to quickly and easily access their Google Analytics 4 data in BigQuery. With its user-friendly interface and powerful functionality, it makes it easy to get the insights you need to make data-driven decisions.

See more

User reviews

It's like having your own mini chat GPT but dedicated for GA4 in BigQuery
by Or Blan, 2023-09-28

Great extension for BigQuery/Google Analytics users. Highly recommended
by Shuki Mann, 2023-08-28

This is THE most needed add-on! I've been using GA4BQ for a few weeks now, and I'm really impressed with how easy it is to use. I've been able to generate complex queries in seconds that would have taken me much longer to write myself.
by Idan Daniels, 2023-08-27
View all user reviews

Extension safety

Risk impact

GA4BQ™ - GA4 BigQuery SQL Generator requires a few sensitive permissions. Exercise caution before installing.

Risk likelihood

GA4BQ™ - GA4 BigQuery SQL Generator has earned a fairly good reputation and likely can be trusted.

Upgrade to see risk analysis details

Similar extensions

Here are some Chrome extensions that are similar to GA4BQ™ - GA4 BigQuery SQL Generator: