Articles on: Data Warehouse tables & Valid combinations
This article is also available in:

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
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 table
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 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 currecy)
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
Pageviews
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 pageviews
Avg. Search Depth
Avg. search duration
Percent of sessions with search
Organic searches within a session



Technology data



This table provides information of client's devices and browser.

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)

Updated on: 23/08/2023

Was this article helpful?

Share your feedback

Cancel

Thank you!