[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

nguyenkduywork/SQL_GA4

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 

Repository files navigation

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

About

SQL queries for GA4

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published