GA4BQ™ - GA4 BigQuery SQL Generator
Item logo image for GA4BQ™ - GA4 BigQuery SQL Generator

GA4BQ™ - GA4 BigQuery SQL Generator

ga4bq.com
5.0(

5 ratings

)
Item media 2 screenshot
Item media 1 screenshot
Item media 2 screenshot
Item media 1 screenshot
Item media 1 screenshot
Item media 2 screenshot

Overview

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

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

5 out of 55 ratings

Google doesn't verify reviews. Learn more about results and reviews.

Review's profile picture

Or BlanSep 28, 2023

It's like having your own mini chat GPT but dedicated for GA4 in BigQuery

1 person found this review to be helpful
Review's profile picture

Shuki MannAug 28, 2023

Great extension for BigQuery/Google Analytics users. Highly recommended

1 person found this review to be helpful
Review's profile picture

Idan DanielsAug 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.

2 out of 2 people found this helpful

Details

  • Version
    0.4.50
  • Updated
    December 5, 2023
  • Size
    3.96MiB
  • Languages
    English
  • Developer
    Website
    Email
    info@quickwin.co.il
  • Non-trader
    This developer has not identified itself as a trader. For consumers in the European Union, please note that consumer rights do not apply to contracts between you and this developer.

Privacy

GA4BQ™ - GA4 BigQuery SQL Generator has disclosed the following information regarding the collection and usage of your data. More detailed information can be found in the developer's privacy policy.

GA4BQ™ - GA4 BigQuery SQL Generator handles the following:

Personally identifiable information

This developer declares that your data is

  • Not being sold to third parties, outside of the approved use cases
  • Not being used or transferred for purposes that are unrelated to the item's core functionality
  • Not being used or transferred to determine creditworthiness or for lending purposes

Support

For help with questions, suggestions, or problems, visit the developer's support site

Related

dataslayer

4.6(80)

Debug and test tag management (Google Tag Manager, DTM, Tealium) and analytics implementations.

Tag Assistant Companion

2.7(116)

The Tag Assistant Companion extension works with Tag Assistant to help troubleshoot installation of gtag.js and Google Tag Manager.

WASP.inspector: Analytics Solution Profiler

4.6(189)

Digital analytics quality made easy

TagHound - Analytics/GTM/Pixel Debugger

4.9(41)

Debug Google Tag Manager dataLayer, Google Analytics, Google Ads, Facebook Ads and 18+ ad networks pixels - Twitter, TikTok and more

Adswerve - dataLayer Inspector+

4.5(42)

DataLayer Tools for Digital Analysts

Datalayer Checker

4.7(29)

The easiest way to debug and check the dataLayer implementations without having to use the browser console!

GA4 Enhanced DebugView by Luratic

5.0(6)

Prints on console all the params and their values when clicking over an event logged into the GA4/Firebase DebugView/Usersnapshot.

Analytics Debugger

4.6(181)

Your Single Source of Truth (SSOT) for debugging analytics implementations

GTM Copy Paste

4.3(41)

Copy your Tags, Triggers and Variables and Paste them into any other account

Omnibug

4.1(50)

Omnibug is a browser extension to decode and display outgoing digital marketing tool requests.

Google Analytics Debugger

4.2(534)

Prints useful information to the JavaScript console by enabling the debug version of the Google Analytics Javascript.

Da Vinci Tools

4.8(32)

The Supermetrics Google Marketing Platform power tools for smart digital marketers and analysts.

dataslayer

4.6(80)

Debug and test tag management (Google Tag Manager, DTM, Tealium) and analytics implementations.

Tag Assistant Companion

2.7(116)

The Tag Assistant Companion extension works with Tag Assistant to help troubleshoot installation of gtag.js and Google Tag Manager.

WASP.inspector: Analytics Solution Profiler

4.6(189)

Digital analytics quality made easy

TagHound - Analytics/GTM/Pixel Debugger

4.9(41)

Debug Google Tag Manager dataLayer, Google Analytics, Google Ads, Facebook Ads and 18+ ad networks pixels - Twitter, TikTok and more

Adswerve - dataLayer Inspector+

4.5(42)

DataLayer Tools for Digital Analysts

Datalayer Checker

4.7(29)

The easiest way to debug and check the dataLayer implementations without having to use the browser console!

GA4 Enhanced DebugView by Luratic

5.0(6)

Prints on console all the params and their values when clicking over an event logged into the GA4/Firebase DebugView/Usersnapshot.

Analytics Debugger

4.6(181)

Your Single Source of Truth (SSOT) for debugging analytics implementations

Google apps