This extension allows you to generate SQL queries for Google Analytics 4 on BigQuery without any prior knowledge of SQL.
Features:
- User-friendly interface
- Built-in calculated dimensions and metrics
- Select metrics and dimensions, apply filters and time ranges
- Automatically generates SQL query
- Perfect for data analysts, marketers, and anyone who needs to access their Google Analytics 4 data in BigQuery
To use, simply install the extension on your Chrome browser, go to your Google Analytics 4 table in BigQuery, open a “Query” tab and click on the extension icon.
Once you have made your selections, the extension will automatically generate the SQL query for you.