SQL_GA4 Repository

This repository contains a collection of BigQuery SQL queries for analyzing Google Analytics 4 (GA4) data.

Repository Structure

• GA4_Queries/: Folder containing BigQuery SQL queries for GA4 data analysis

Usage

The SQL queries in this repository are designed to be run in BigQuery against your GA4 dataset. To use these queries:

1. Open Google Cloud Console and navigate to BigQuery
2. Select your GA4 dataset
3. Copy and paste the desired query from the GA4_Queries folder, adapt to your dataset (custom dimensions, table names, etc.)
4. Run the query and analyze the results

Query Examples

The GA4_Queries folder includes various SQL queries for common GA4 analysis tasks, such as:

• Full analysis of page views, conversion rate, progression rate (number of sessions that has gone into the configuration tunnel - panier, etc.), among other things.

Contributing

Feel free to contribute to this repository by adding your own GA4 queries or improving existing ones. Please follow these steps:

1. Fork the repository
2. Create a new branch for your changes
3. Add or modify queries in the GA4_Queries folder
4. Submit a pull request with a clear description of your changes

Contact

Contact me at: kimduy.nguyen@outlook.com