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