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

Google Ads BigQuery Tables Documentation

When importing Google Ads 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:



Performance Overview data



This table provides a summary of the overall performance of the Google Ads account, giving an overview of the effectiveness and results of the campaigns.

Example:

Performance Overview data table
Dimensions
Date
Campaign
Device
Click Type
Hour
Day of Week
Month
Year
Metrics
Impressions
Clicks
Cost
CPC
Conversions
CTR
Cost per Conversion
Conversion Rate %





Campaign Info data



This table offers specific information about the individual campaigns in Google Ads, providing details about the characteristics and settings of each campaign.

Example:

Campaign Info data table
Dimensions
Date
Account
Account ID
Advertising Channel Type
Advertising Channel Sub-type
Biddin Strategy Type
Bidding Startegy ID
Bidding Strategy Name
Campaign ID
Campaign
Campaign Labels
Campaign State
Currency
Metrics
Clicks
Conversions
Conversion Value
Cost
Engagements
Impressions
Impression share
Interactions
Search Impression Share
Search Top Impression Share
Search Budget Lost Top Impression Share
Search Absolute Top Impression Share
Search Rank Lost Absolute Top Impression Share
Search Budget Lost Absolute Top Impression Share
Search Rank Lost Top Impression Share
Total Budget
Video Impressions
View-through conversions




Keyword Performance data



This table analyzes the performance of the keywords used in Google Ads campaigns, providing insights into how well the keywords are performing in terms of driving traffic or achieving desired outcomes.

Example:

Keyword Performance data table
Dimensions
Date
Campaign
Campaign ID
Ad Group
Ad Group ID
Keyword
Keyword Match Type
Network
Landing Page Experience
Metrics
Impressions
Clicks
Cost
CTR
CPC
Conversions
Conversion Value
Conversion Rate %






Ad Performance Breakdown data



This table breaks down the performance of the individual ads within Google Ads campaigns, providing insights into how well the ads are performing in terms of generating interest or engagement.

Example:

Ad Performance Breakdown data table
Dimensions
Date
Campaign
Campaign ID
Ad Group
Ad Group ID
Ad ID
All Headlines
Description
Display URL
Metrics
Impressions
Clicks
Cost
CTR
CPC
Conversions
Conversion Value
Conversion Rate %
Cost per Conversion







Geographic Performance Breakdown data



This table examines the performance of Google Ads campaigns based on geographic location, providing insights into how different regions or locations contribute to the overall performance of the campaigns.

Example:

Geographic Performance Breakdown data table
Dimensions
Account
Account ID
Ad Group
Campaign
Campaign State
City
Location type
Metro area
Region
Date
Metrics
Clicks
Cost
Conversions
Conversion value
Impressions
Video views
View-through conversions

Updated on: 17/07/2023

Was this article helpful?

Share your feedback

Cancel

Thank you!