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
Thank you!