GA4 BigQuery Tables Documentation

When importing GA4 data into BigQuery using Dataslayer, you may encounter an "invalid parameters combination" error if you select certain dimensions and metrics that cannot be queried together.

The "invalid parameters combination" error comes from the native data source API, not from Dataslayer.


To avoid this error, you can import the following tables:

Engagement data

Example:

Engagement data table
Dimensions
content group
event name
hostname
property name
stream name
page path and screen class
date
Metrics
active users
add-to-carts
checkouts
conversions
ecommerce purchases
engaged sessions
event count
event value
first time purchasers
item promotion click through rate
item view events
new users
sessions
total ad revenue
total revenue
total purchasers
total users
transactions
user engagement

Acquisition data

Example:

Acquisition data table
Dimensions
first user campaign id
first user campaign
first user google ads ad group id
first user google ads ad group name
first user google ads network type
first user medium
date
Metrics
active users
add-to-carts
checkouts
conversions
ecommerce purchases
event value
first time purchasers
item list click through rate
item promotion click through rate
item view events
new users
sessions
total ad revenue
total revenue
total purchasers
total users
transactions
user engagement

Device data

Example:

Device data table
Dimensions
browser
device category
language
platform
property name
stream name
date
Metrics
28-day active users
7-day active users
1-day active users
active users
add-to-carts
conversions
ecommerce purchases
engaged sessions
event count
first time purchasers
item list click through rate
item promotion click through rate
new users
sessions
total ad revenue
total purchasers
total revenue
total users
transactions
user engagement

Traffic Acquisition data

Example:

Traffic Acquisition data
Dimensions
session campaign
session default channel grouping
session google ads ad group name
session google ads keyword text
session medium
session source
date
Metrics
active users
add-to-carts
checkouts
conversions
ecommerce purchases
engaged sessions
event value
first time purchasers
item list click through rate
item view events
item promotion click through rate
new users
transactions
user engagement
total users
total revenue
total purchasers
total ad revenue

Publishing data

Example:

Publishing data table
Dimensions
device category
language
platform
property name
session medium
session source
date
Metrics
1-day active users
28-day active users
7-day active users
active users
add-to-carts
ad unit exposure
checkouts
conversions
ecommerce purchasers
engaged sessions
event value
first time purchasers
item list click through rate
new users
publisher ad clicks
publisher ad impressions
sessions
total ad revenue
total purchasers
total revenue
total users
transactions
user engagement

User Acquisition

Example:

User Acquisition table
Dimensions
first user campaign ID
first user campaign
first user google ads group id
first user google ads group name
first user google ads network type
first user medium
date
Metrics
active users
add-to-carts
checkouts
conversions
ecommerce purchases
engaged sessions
event value
first time purchasers
item list click through rate
item view events
new users
sessions
total ad revenue
total purchasers
total revenue
total users
transactions
user engagement

User Data

Example:

User Data table
Dimensions
city
country
language
region
age
gender
date
Metrics
active users
add-to-carts
checkouts
conversions
ecommerce purchases
engaged sessions
event count
event value
first time purchasers
item list click through rate
item view events
item promotion click through rate
new users
sessions
total ad revenue
total purchasers
total revenue
total users
transactions
user engagement

Ecommerce Data

Example:

Ecommerce data table
Dimensions
item brand
item category
item list name
item name
property name
date
Metrics
active users
engaged sessions
first time purchasers
sessions
total purchasers
total users


Do you have any questions? Don't hesitate to write us through our website chat or through our email.