Articles on: Google BigQuery

Google Universal Analytics BigQuery Tables Documentation

When importing Universal Analytics 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:



User-level data



This table contains user-level data such as the number of users, new users, and user retention.

Example:

User-level data table
Dimensions
City
Continent
Country
Region
Language
Date
View
View ID
Metrics
Users
New users
Sessions
Pageviews
Bounces
Total time on site (seconds)


Traffic sources data



This table provides insights into the various sources of website traffic.

Example:

Traffic sources data table
Dimensions
Date
Source
Medium
Campaign
Keyword
Ad content (utm_content)
Ad destination URL
User type
Metrics
Sessions
Users
Bounces
Pageviews
Session duration
Goal completions
Goal conversion rate
Avg. revenue per session


Content



This table focuses on the performance of individual pages or content pieces on the website.

Example:

Content table
Dimensions
Data Source
Date
Exit Page
Landing Page
Page Path
Page Title
Previous Page Path
View Name
View ID
Metrics
Entrances
Exits
Avg. Page Download Time (sec)
Page Load Sample
Avg. Page Load Time (sec)
Page Value
Pageviews
Avg. Redirection Time (sec)
Avg. Server Connection time (sec)
Avg. Server Response Time (sec)
Sample Size used for calculating speed metrics
Avg. Time on Page (seconds)


Acquisition channels and campaigns



This table gives an overview of the different channels and campaigns driving traffic to the website.

Example:

Acquisition channels and campaigns table
Dimensions
Date
Campaign
Campaign ID
Medium
Source
Ad Content (utm content)
Keyword
Metrics
Sessions
New Users
Bounce Rate
Pages/Session
Session Duration
Goal Completions
Transaction revenue
Ad Cost


Marketing Channel Performance Data



This table analyzes the effectiveness of marketing channels in driving website traffic and conversions.

Example:

Marketing Channel Performance Data Table
Dimensions
Source/Medium
Campaign
Date
Device category
Landing page
User type
City
Region
Country
Metrics
Sessions
Bounce rate
Session duration
Goal completions
Goal conversion rate
Revenue

Updated on: 18/05/2023

Was this article helpful?

Share your feedback

Cancel

Thank you!