---
title: Google Universal Analytics BigQuery Tables Documentation
description: When importing Google Universal Analytics data into BigQuery via Dataslayer, you may get an &quot;invalid parameters combination&quot; error if you select certain dimensions and metrics that cannot be used toge
---

[Skip to content](https://support.dataslayer.ai/google-universal-analytics-bigquery-tables-documentation#main-content)

- [English](https://support.dataslayer.ai/google-universal-analytics-bigquery-tables-documentation)
- [Español](https://support.dataslayer.ai/es/documentación-de-tablas-de-google-universal-analytics-en-bigquery)

English

Show submenu for translations

[![Dataslayer](https://support.dataslayer.ai/hs-fs/hubfs/Dataslayer_New_Logo.png?height=35&name=Dataslayer_New_Logo.png)](https://www.dataslayer.ai/)

Open main navigation

Close main navigation

- - [English](https://support.dataslayer.ai/google-universal-analytics-bigquery-tables-documentation)
    - [Español](https://support.dataslayer.ai/es/documentación-de-tablas-de-google-universal-analytics-en-bigquery)

  English
  
  Show submenu for translations

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge base](https://support.dataslayer.ai/?hsLang=en)
2. [Data Sources](https://support.dataslayer.ai/data-sources?hsLang=en)

May 6, 2024

# 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) |

 

- [General](https://support.dataslayer.ai/general?hsLang=en)
- [Billing & Pricing](https://support.dataslayer.ai/billing-pricing?hsLang=en)
- [Data Sources](https://support.dataslayer.ai/data-sources?hsLang=en)
- [Blended Connectors](https://support.dataslayer.ai/blended-connectors?hsLang=en)
- [Google Sheets](https://support.dataslayer.ai/google-sheets?hsLang=en)
- [Microsoft Excel](https://support.dataslayer.ai/microsoft-excel?hsLang=en)
- [Spreadsheets](https://support.dataslayer.ai/spreadsheets?hsLang=en)
- [Looker Studio](https://support.dataslayer.ai/looker-studio?hsLang=en)
- [Big Query](https://support.dataslayer.ai/big-query?hsLang=en)
- [API Query Manager](https://support.dataslayer.ai/api-query-manager?hsLang=en)
- [Power BI](https://support.dataslayer.ai/power-bi?hsLang=en)
- [Amazon S3](https://support.dataslayer.ai/amazon-s3?hsLang=en)
- [Amazon Redshift](https://support.dataslayer.ai/amazon-redshift?hsLang=en)
- [Snowflake](https://support.dataslayer.ai/snowflake?hsLang=en#main-content)

    - [Marketplace](https://support.dataslayer.ai/snowflake?hsLang=en#marketplace)
- [Google Cloud Storage](https://support.dataslayer.ai/google-cloud-storage?hsLang=en)
- [Database](https://support.dataslayer.ai/database?hsLang=en)
- [Azure SQL](https://support.dataslayer.ai/azure-sql?hsLang=en)
- [Azure Storage](https://support.dataslayer.ai/azure-storage?hsLang=en)
- [Dataslayer Atlas](https://support.dataslayer.ai/dataslayer-atlas?hsLang=en)
- [Morpheus](https://support.dataslayer.ai/morpheus?hsLang=en)
- [AI Looker Studio Analyzer](https://support.dataslayer.ai/ai-looker-studio-analyzer?hsLang=en)
- [Dataslayer MCP](https://support.dataslayer.ai/dataslayer-mcp?hsLang=en)
- [Dataslayer GPT](https://support.dataslayer.ai/dataslayer-gpt?hsLang=en)
- [Dataslayer AI Chat](https://support.dataslayer.ai/dataslayer-ai-chat?hsLang=en)

[![Chill listening crop-3](https://support.dataslayer.ai/hs-fs/hubfs/Dataslayer_New_Logo.png?width=142&height=24&name=Dataslayer_New_Logo.png "Chill listening crop-3")](https://dataslayer.ai/)

Dataslayer.ai: Digital Marketing Reporting Made Easy

<https://www.linkedin.com/company/dataslayer/> <https://www.youtube.com/@dataslayers>

Copyright © 2026, DATASLAYER SL