Skip to content

IKAUE GA4 Public Tools

IKAUE GA4 Tools and Resources

GAU/GA3 Resources

About IKAUE

More

Share

Explore

IKAUE GA4 Tools and Resources

Get your GA4 tables exported much easier with this query generator:

Generate queries to simplify the data that GA4 exports to your Google BigQuery. Create a new version of your tables with that data so you can query easier and cheaper.

In addition, these tables can be connected to Google Sheets, Looker Studio or the tool of your choice as they are flattened and do not use RECORD or ARRAY data.

⁠

1. Google Analytics 4 Google BigQuery (GBQ) table location

GBQ Project:

⁠

(required)

GBQ dataset:

⁠

(required)

GBQ table:

events_YYYYMMDD

⁠

2. Select Date Range

Start date:

2024-08-04

⁠

End date:

2024-08-04

⁠

Do not use dates, create a parameter (@run_date) for scheduled queries

(More info)⁠

⁠

0

2

⁠

Days to be subtracted from the scheduled day

⁠

3. Select groups of data fields to extract

⁠

Web Pages data (page title, page location, referrer, ...)

⁠

App Screens data (screen name, screen class, ...)

⁠

Device & system data (device brand, browser, etc.) - device_category allways is extracted.

⁠

Geo data (country, city, etc.) - geo_country allways is extracted.

⁠

App data (app version, install source, etc.)

⁠

Campaign user first interaction data (campaign, medium & source)

⁠

Campaign event data (campaign, medium, source, content, ...)

⁠

Ecommerce global data

⁠

Ecommerce first item data

⁠

Consent Data (analytics_storage, ...)

⁠

LTV (Life time value) Metrics

⁠

4. Create Data Filters

⁠

Exclude

⁠

no-consent data (pings with no granted analytics_storage)

⁠

No filter

⁠

this data stream ID’s :

⁠

(comma separated)

⁠

Exclude

⁠

this event names :

session_start,user_engagement

⁠

(comma separated)

⁠

5. Extract Conversions based on Event Names

Events to be posted

⁠

System Events:

first_visit,page_view

⁠

(comma separated)

⁠

Ecommerce Events:

view_item,add_to_cart,begin_checkout,purchase

⁠

(comma separated)

⁠

Recommended Events:

sing_up,login,select_content

⁠

(comma separated)

⁠

Custom Events:

⁠

(comma separated)

⁠

6. Extract Conversions based on event+param+regex values (not real GA4 conversions)

⁠

Extract Custom Conversion 1:

Conversion name:

⁠

(e.g. “thanks”)

Event names to watch:

⁠

(e.g. “page_view")

Params to watch:

⁠

(e.g. “page_location”)

Regex to match in params:

⁠

(e.g. “^.*/thanks.html$”)

⁠

Extract Custom Conversion 2:

Conversion name:

⁠

Event names to watch:

⁠

Params to watch:

⁠

Regex to match in params:

⁠

Extract Custom Conversion 3:

Conversion name:

⁠

Event names to watch:

⁠

Params to watch:

⁠

Regex to match in params:

⁠

7. Extract Custom User Properties

⁠

(comma separated)

Leave the field blank if you do not want to extract any user property

⁠

8. Extract Event Custom Params/Dimensions

⁠

(comma separated)

Leave the field blank if you do not want to extract any user property

⁠

9. Extract Session Scope (Landing/Exit) params/dimensions

⁠

Extract Collection 1 (by default: landing_view/exit_view/prev_view web & app mixed)

Collection name:

view

⁠

Events to watch:

page_view,screen_view

⁠

(comma separated)

Params to extract:

page_location,screen_name

⁠

(comma separated)

⁠

Extract Collection 2

Collection name:

⁠

Events to watch:

⁠

(comma separated)

Params to extract:

⁠

(comma separated)

⁠

Extract Collection 3

Collection name:

⁠

Events to watch:

⁠

(comma separated)

Params to extract:

⁠

(comma separated)

⁠

Your Google BigQuery query to model

GA default extraction tables

⁠

Set as subquery using “WITH”

1. Copy query to clipboard

⁠

2. Go to GBQ

⁠

Your SQL Code:

⁠
ERROR: set GBQ project an dataset fields
⁠
⁠

Want more GA4 Tools and Resources

⁠

⁠

USE IT

⁠

⁠

USE IT

⁠

⁠

GET IT

⁠

⁠

GO FOR IT

⁠

⁠

GET IT

⁠

Developed by

⁠

This website includes content that is the intellectual property of IKAUE MARKETING ONLINE S.L. Any user that access this website can use the resources and tools available, but that does not grant any ownership rights over them.

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.

Get your GA4 tables exported much easier with this query generator:

1. Google Analytics 4 Google BigQuery (GBQ) table location

2. Select Date Range

3. Select groups of data fields to extract

4. Create Data Filters

5. Extract Conversions based on Event Names

Events to be posted

6. Extract Conversions based on event+param+regex values ​(not real GA4 conversions)

7. Extract Custom User Properties

8. Extract Event Custom Params/Dimensions

9. Extract Session Scope (Landing/Exit) params/dimensions

Your Google BigQuery query to model

GA default extraction tables

Your SQL Code:

Want more GA4 Tools and Resources

6. Extract Conversions based on event+param+regex values (not real GA4 conversions)