English
See more
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
Extension ID
Languages Support
Permissions
Storage
Identity
See more
Identity
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
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
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
"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"]}]}
Similar Extensions
Adswerve - dataLayer Inspector+ 2,000+ 56 ★ 517KiB
GA4 Fixer 2,000+ 18 ★ 3.3MiB
Datalayer Checker 2,000+ 33 ★ 93.13KiB
GA4 Enhanced DebugView by Luratic 2,000+ 6 ★ 45.79KiB
Analytics Debugger 2,000+ 211 ★ 300KiB
UET Tag Helper (by Microsoft Advertising) 2,000+ 25 ★ 216KiB
GTM Copy Paste 2,000+ 49 ★ 726KiB
Omnibug 2,000+ 50 ★ 1.35MiB
Google Analytics Debugger 2,000+ 533 ★ 28.88KiB
Debugger for Google Analytics 4 (GA4) 2,000+ 28 ★ 102KiB
Da Vinci Tools 2,000+ 34 ★ 1.2MiB
dataslayer 2,000+ 80 ★ 417KiB
WASP.inspector: Analytics Solution Profiler 2,000+ 189 ★ 401KiB
TagHound - Analytics/GTM/Pixel Debugger 2,000+ 63 ★ 1.77MiB
GTM Variable Builder 2,000+ 30 ★ 82.71KiB
GTM Sonar 2,000+ 14 ★ 15.94KiB
Tag Assistant Companion 2,000+ 204 ★ 179KiB
GTMFixer - Google Tag Manager Enhancements 2,000+ 7 ★ 571KiB
Google Analytics Debugger 2,000+ 37 ★ 27.1KiB
Google Analytics UTM Builder 2,000+ 101 ★ 2.94MiB
ObservePoint Debugger 2,000+ 52 ★ 3.6MiB
Consent Mode Inspector by InfoTrust 2,000+ 19 ★ 304KiB
Simple Data Layer Viewer 2,000+ 13 ★ 77.96KiB
Looker Studio Companion 2,000+ 4 ★ 3.02MiB
User reviews
Or Blan (ID: 000000d3c789b3b4) Voted 5 ★ - Updated 09/28/2023
Shuki Mann (ID: 00000043f33dffb3) Voted 5 ★ - Updated 08/28/2023
Idan Daniels (ID: 000000bd451c49ed) Voted 5 ★ - Updated 08/27/2023
