Articles on: Data Warehouse tables & Valid combinations

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.

Data sources group metrics and dimensions into groups. All metrics in the same group will have the same compatibility with metrics in other groups.

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
firat user ggogle 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 table
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 data 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

Updated on: 19/09/2023

Was this article helpful?

Share your feedback

Cancel

Thank you!