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