Google Universal Analytics BigQuery Tables Documentation

When importing Google Universal Analytics data into BigQuery via Dataslayer, you may get an "invalid parameters combination" error if you select certain dimensions and metrics that cannot be used together.

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


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
Date
Data source
City
Continent
Country
Country ISO Code
Region
Region ISO Code
Language
View name
View ID
Metrics
Users
New users
Sessions
Session Duration
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
Dimensions
Date
Source
Medium
Channel group
Campaign
Keyword
Ad content (utm_content)
User type
View name
View ID
Referral Path
Metrics
Sessions
Session Duration
Total Time on site (seconds)
Users
Bounces
Pageviews
Goal completions
Goal Starts
Goal Value
Goal conversion rate
Total Value
Avg. revenue per session value
Transactions revenue
Transactions

Paid Traffic Data

This table provides insights of the paid traffic.

Example:

Paid traffic data table
Dimensions
Date
Ad Content (utm_content)
Ad Group
Ad Group ID
Search Query
Query Match Type
Campaign
Campaign ID
Creative ID
View name
View ID
Metrics
Ad Clicks
Ad cost
Ad impressions
Bounces
Goal Completions
Goal Starts
Goal Value
Pageviews
Sessions
Session Duration
Total Time on site (seconds)
Users
Total Value

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
Page Download Time (ms)
Avg. Page Download Time (sec)
Page Load Sample
Page load time (ms)
Avg. Page Load Time (sec)
Page Value
Pageviews
Redirection Time (ms)
Avg. Redirection Time (sec)
Server connection time (ms)
Avg. Server Connection time (sec)
Server response time (ms)
Avg. Server Response Time (sec)
Sample Size used for calculating speed metrics
Total time on site (seconds)
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
Transaction Revenue

E-commerce

This table shows details about online transactions.

E-commerce Data Table

Dimensions
Data Source
Product Brand
Product Catergory (Enhanced Ecommerce)
Product List Name
Product List Position
Product Name
Product SKU
View name
View ID
Date
Metrics
Item Quantity
Item Revenue
Item revenue (local currency)
Local product refund amount
Product adds to cart
Product Checkouts
Product Detail views
Product list clicks
Product list views
Product List CTR
Product refund amount
Product refunds
Product removes from cart
Product revenue per purchase
Quantity added to cart
Quantity checked out
Quantity refunded
Quantity removed from cart
Unique purchases

Social

This table provides an analysis of social media interactions and engagement metrics.

Social Data Table
Dimensions
Date
Data source
Has social source referral
View name
View ID
Social Engagement Type
Social interaction target
Social network
Social Interaction Network
Social Action
Social action network
Metrics
Page views
Sessions
Social actions (onsite)
Unique social actions (onsite)
Users

Events

This table offers insights into user interactions and engagement through tracked events on the website.

Events Data Table
Dimensions
Data source
Event action
Event category
event label
view name
view id
Date
Metrics
Event value
Pageviews
Sessions
Total events
Users

Search

This table shows details about search results.

Example:

Search Data Table
Dimensions
Data source
Date
View Name
View ID
Search Category
Search Destination Page
Search Keyword
Search Start Page
Search used
Metrics
Search Exits
Search exit rate
Search Refinements
Search result views
Search sessions
Search uniques
Avg. search page views
Avg. Search Depth
Avg. search duration
Percent of sessions with search
Organic searches within a session

Technology data

This table provides information on the client's devices and browsers.

Example:

Technology data table
Dimensions
Date
Browser
Browser Version
Device category
Screen Resolution
Operating System
Operating System Version
Service Location
Hostname
View name
View ID
Metrics
Bounces
Bounce Rate
Users
New users
Pageviews
Sessions
Session Duration
Total time on site (seconds)
Total time on site (hours)