GA4BQ™ - SQL generator for Google Analytics 4 on Google BigQuery, without SQL knowledge using simple visual query builder.

Latest Version

Version
0.4.50
Update
December 4, 2023
Size
3.96MiB
Developer
ga4bq.com
Category
Users
2,000+
Rating
5 ★
Manifest Version
3
Web Store Status
Languages Support
English
See more
Permissions
Storage
Identity
See more

GA4BQ™ - GA4 BigQuery SQL Generator Extension

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.

The Google Analytics 4 BigQuery SQL Generator Extension is a must-have tool for anyone who needs to access their Google Analytics 4 data in BigQuery. It makes it easy to get the insights you need to make data-driven decisions, without the need for any prior knowledge of SQL. So go ahead and download the extension today and start exploring your data!

Release notes for public versions of GA4BQ:
==================================
0.4.50 - Add the ability to choose a Google account instead of using the default Chrome login.
0.4.49 - Added the ability to change order of fields
0.4.48 - Fixing Sort bug for stored queries.
0.4.47 - Adding BigQuery for Google Search Console!
0.4.35 - Adding query builder for funnels!
0.4.32 - Removing auto table name fetch. Users will enter it manually.
0.4.25/6 - Adding items level dimensions and metrics
0.4.24 - Adding quick search on SQL filters
0.4.23 - Changing extension name
0.4.22 - Updating built-in queries module
0.4.20 - Improving date picker.
0.1.01 - Initial version
Read more

Source Manifest.json

{
"update_url": "https://clients2.google.com/service/update2/crx",
"icons":{"16":"icon16.plasmo.58f76cc9.png",
"32":"icon32.plasmo.2e735737.png",
"48":"icon48.plasmo.2ddb44e5.png",
"64":"icon64.plasmo.c29b332a.png",
"128":"icon128.plasmo.822319d6.png"},
"manifest_version":3,
"action":{"default_icon":{"16":"icon16.plasmo.58f76cc9.png",
"32":"icon32.plasmo.2e735737.png",
"48":"icon48.plasmo.2ddb44e5.png",
"64":"icon64.plasmo.c29b332a.png",
"128":"icon128.plasmo.822319d6.png"},
"default_popup":"popup.html"},
"version":"0.4.50",
"author":"ga4bq",
"name":"GA4BQ\u2122 - GA4 BigQuery SQL Generator",
"description":"GA4BQ\u2122 - SQL generator for Google Analytics 4 on Google BigQuery, without SQL knowledge using simple visual query builder.",
"background":{"service_worker":"static/background/index.js"},
"permissions":["storage",
"identity"],
"content_scripts":[{"matches":["https://console.cloud.google.com/bigquery?*",
"https://console.cloud.google.com/*"],
"js":["button-injected.263606a5.js"],
"css":["button-injected.57213085.css"]},{"matches":["https://*/*"],
"js":["all-pages-app.5f91f02e.js"],
"exclude_matches":["https://console.cloud.google.com/bigquery?*",
"https://console.cloud.google.com/*"],
"css":["button-injected.57213085.css"]},{"matches":["https://console.cloud.google.com/bigquery?*",
"https://console.cloud.google.com/*"],
"js":["big-query-page-app.02e97726.js"],
"css":["button-injected.57213085.css"]}],
"key":"MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAi7HHhQt1wKSvc43U+kQjlHkYOjrimy2soRCt0d6Si7L6yRuwVPa/QjBKPq3FcPbJ5g5GST/RgoTaH0a1TuroejerDfktJSFaysEeJf8zpaRh//IILpqc0Al05AUSZtnc7e76vYJSGcmv588IcNkm2QuQWrI5ZbE/X1xAdlEZFIW8ovS6/mnWPwW+rybtuWYN83n/ku93UrDv7/QmBUAFyll8bCO7SgVvC5hXH5mUNU1Nuyj2WQSlPlp65mCrtBZ112UgbYZE1YUKEuoyYlMc9t+eQELVov8YY3rlltehIW2MsuegpwagTGacaf3FhRvjfEyCd7diBC36iTeXtWO/+QIDAQAB",
"host_permissions":["https://*/*"],
"oauth2":{"client_id":"709473009960-k2hpsf7pb6m3ec1f9hm8tihgabdvf374.apps.googleusercontent.com",
"scopes":["https://www.googleapis.com/auth/userinfo.email",
"https://www.googleapis.com/auth/userinfo.profile"]},
"web_accessible_resources":[{"matches":["https://*/*"],
"resources":["all-pages-app.7ca8c454.css",
"all-pages-app.69993fe2.css",
"all-pages-app.487dfb85.css",
"all-pages-app.59b6633d.css",
"all-pages-app.02727e46.css"]},{"matches":["https://console.cloud.google.com/*",
"https://console.cloud.google.com/*"],
"resources":["all-pages-app.7ca8c454.css",
"all-pages-app.69993fe2.css",
"all-pages-app.487dfb85.css",
"all-pages-app.59b6633d.css",
"all-pages-app.02727e46.css"]}]}
Read more

How to download and manually install GA4BQ™ - GA4 BigQuery SQL Generator extension for Chrome

Looking for a way to install GA4BQ™ - GA4 BigQuery SQL Generator extensions for Chrome, you can search for them in the Chrome Web Store, clicking the "Add to Chrome" button, and following the straightforward process.

However, you may need to install GA4BQ™ - GA4 BigQuery SQL Generator extensions manually, this article outlines two simple methods to effortlessly install GA4BQ™ - GA4 BigQuery SQL Generator extensions, whether they come as unpacked folders in compressed formats like .zip or as .crx files.

Method 1: Download GA4BQ™ - GA4 BigQuery SQL Generator extension and manually install through Drag &Drop

If you ever need to manually install a GA4BQ™ - GA4 BigQuery SQL Generator extension for Chrome, don't worry, it's a simple process. Just follow these easy steps, and you will have your extension ready to use in no time.

Step 1: Download the GA4BQ™ - GA4 BigQuery SQL Generator Extension by clicking the "Download CRX" button on the website.

Look for the GA4BQ™ - GA4 BigQuery SQL Generator extension you wish to install. Go to the website and download the GA4BQ™ - GA4 BigQuery SQL Generator extension package, which is usually a .CRX file and comes in a zipped file. Here ".crx" file is the format for GA4BQ™ - GA4 BigQuery SQL Generator extension that contains all the data.

Step 2: Extract &Arrange Files

Once the file is downloaded, extract that file into its own folder. Similarly, give that extension files a permanent home. In other words, keep it in a folder that you don't accidentally delete it because these files will be needed to make that extension work.

Step 3: Go to the Chrome Extensions Page

Open Google Chrome and in the address bar, type chrome://extensions; it will open the Google Chrome extensions page. Make sure that "My extensions" is selected in the sidebar.

Step 4: Drag and Drop the Extension

Now, go to the folder where you extracted the GA4BQ™ - GA4 BigQuery SQL Generator extension and drag &drop the extension file from there anywhere onto the extension page within Google Chrome.

Step 5: Complete the Installation

Once you drag and drop the extension file, follow the steps that Google Chrome takes you through. Similarly, if the extension file is of .crx file format, you will be required to review the permissions and then add the extension.

Now, you can manage that added extension as you would like to with any other Chrome extension that you added through Chrome Webstore. Its icon will also appear in the Google Chrome Menu on the right side of the address bar once you activate it.

Method 2: Download GA4BQ™ - GA4 BigQuery SQL Generator extension for Chrome and install in Developer Mode

This is another method to install GA4BQ™ - GA4 BigQuery SQL Generator extension manually, but the twist is that here, you install by enabling the developer mode option provided in Google Chrome. This mode is commonly used for testing extensions or running unpublished tools.

Step 1: Download the GA4BQ™ - GA4 BigQuery SQL Generator extension file

Select and download the GA4BQ™ - GA4 BigQuery SQL Generator extension by clicking the 'Download CRX' button on the website.

Step 2: Extract the downloaded contents

Convert the file to a ZIP file if it is in CRX format then extract the GA4BQ™ - GA4 BigQuery SQL Generator extension zip file or folder that you downloaded. Make sure you extract it using the same folder name and keep it safely in another folder, so you don't delete it by mistake. The extracted folder will be needed to keep your GA4BQ™ - GA4 BigQuery SQL Generator extension running.

Step 3: Open Chrome Extension Setting Page

In the address bar of Google Chrome, type chrome://extensions and open the Chrome Extension Page.

Step 4: Enable Developer Mode

After opening the Chrome Extension page, look at the top right side, and you will find the toggle option of "Developer mode."Simply enable that developer mode option.

Step 5: Load the Unpacked Extension

Once you enable the developer mode option, you will see the menu of Load Unpacked, Pack Extensions and Update. From that, select the option "Load unpacked."

Step 6: Select the Extension Folder

Once the pop-up opens upon clicking Load unpacked, select the GA4BQ™ - GA4 BigQuery SQL Generator extension directory and click on the "Select Folder "button.

Step 7: Confirm and Install

After you select an extension folder of a Google Chrome extension you're installing manually, confirm its installation for the final time and let the installation complete.

Conclusion

Here we've made a step-by-step guide on How to manually install GA4BQ™ - GA4 BigQuery SQL Generator extension in 2 ways. We hope this guide proves helpful.

Similar Extensions

icon

Adswerve - dataLayer Inspector+ Extension · Developer Tools 2,000+ 56 ★ 517KiB

icon

GA4 Fixer Extension · Developer Tools 2,000+ 18 ★ 3.3MiB

icon

Datalayer Checker Extension · Developer Tools 2,000+ 33 ★ 93.13KiB

icon

GA4 Enhanced DebugView by Luratic Extension · Developer Tools 2,000+ 6 ★ 45.79KiB

icon

Analytics Debugger Extension · Developer Tools 2,000+ 211 ★ 300KiB

icon

UET Tag Helper (by Microsoft Advertising) Extension · Developer Tools 2,000+ 25 ★ 216KiB

icon

GTM Copy Paste Extension · Productivity 2,000+ 49 ★ 726KiB

icon

Omnibug Extension · Developer Tools 2,000+ 50 ★ 1.35MiB

icon

Google Analytics Debugger Extension · Developer Tools 2,000+ 533 ★ 28.88KiB

icon

Debugger for Google Analytics 4 (GA4) Extension · Developer Tools 2,000+ 28 ★ 102KiB

icon

Da Vinci Tools Extension · Developer Tools 2,000+ 34 ★ 1.2MiB

icon

dataslayer Extension · Developer Tools 2,000+ 80 ★ 417KiB

icon

WASP.inspector: Analytics Solution Profiler Extension · Developer Tools 2,000+ 189 ★ 401KiB

icon

TagHound - Analytics/GTM/Pixel Debugger Extension · Developer Tools 2,000+ 63 ★ 1.77MiB

icon

GTM Variable Builder Extension · Developer Tools 2,000+ 30 ★ 82.71KiB

icon

GTM Sonar Extension · Developer Tools 2,000+ 14 ★ 15.94KiB

icon

Tag Assistant Companion Extension · Developer Tools 2,000+ 204 ★ 179KiB

icon

GTMFixer - Google Tag Manager Enhancements Extension · Developer Tools 2,000+ 7 ★ 571KiB

icon

Google Analytics Debugger Extension · Developer Tools 2,000+ 37 ★ 27.1KiB

icon

Google Analytics UTM Builder Extension · Productivity 2,000+ 101 ★ 2.94MiB

icon

ObservePoint Debugger Extension · Developer Tools 2,000+ 52 ★ 3.6MiB

icon

Consent Mode Inspector by InfoTrust Extension · Productivity 2,000+ 19 ★ 304KiB

icon

Simple Data Layer Viewer Extension · Developer Tools 2,000+ 13 ★ 77.96KiB

icon

Looker Studio Companion Extension · Developer Tools 2,000+ 4 ★ 3.02MiB

User reviews

icon

Or Blan (ID: 000000d3c789b3b4) Voted 5 ★ - Updated 09/28/2023 It's like having your own mini chat GPT but dedicated for GA4 in BigQuery

icon

Shuki Mann (ID: 00000043f33dffb3) Voted 5 ★ - Updated 08/28/2023 Great extension for BigQuery/Google Analytics users. Highly recommended

icon

Idan Daniels (ID: 000000bd451c49ed) Voted 5 ★ - Updated 08/27/2023 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.