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.

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
Bidding Strategy Type
Bidding Strategy 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

 

As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!