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

Extract data and interactions of your GA4 items in an easy-to-use format:

Generate queries to simplify the ecommerce 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 global data fields to extract

item_id and item_name aways are extracted.

⁠

date

⁠

device_category + device_operating_system + device browser + geo_country

⁠

item_category (1 - 5)

⁠

item_brand + item_variant

⁠

item affiliation + location id

⁠

item coupon

(creativity and promotion in next updates)

⁠

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. Actions (event_names) to extract

Events/Actions with Items to watch:

add_payment_info,add_shipping_info,add_to_cart,add_to_wishlist,begin_checkout,purchase,refund,remove_from_cart,select_item,select_promotion,view_cart,view_item,view_item_list,view_promotion

⁠

(comma separated)

⁠

6. Item_list_name values to extract

⁠

Extract list group 1:

List name:

⁠

List names to get:

⁠

(comma separated)

⁠

Extract list group 2:

List name:

⁠

List names to get:

⁠

(comma separated)

⁠

Extract list group 3:

List name:

⁠

List names to get:

⁠

(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.