Google Search Ads 360 data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

account_id
Display name Account ID
Description The ID of the customer
Field type dimension
Data type string.text.value
account_type
Display name Account type
Description Engine account type, for example, Google Ads, Microsoft Advertising, Yahoo Japan, Baidu, Facebook, Engine Track, etc
Field type dimension
Data type string.text.value
all_conversions
Display name All conversions
Description The total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric
Field type metric
Data type float.number.value
all_conversions_value
Display name All conversions value
Description The value of all conversions
Field type metric
Data type float.currency.value
budget_period
Display name Budget Period
Description Period over which to spend the budget. Defaults to DAILY if not specified
Field type dimension
Data type string.text.value
campaign
Display name Campaign
Description The name of the campaign. This field is required and should not be empty when creating new campaigns. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters
Field type dimension
Data type string.text.value
campaign_budget
Display name Campaign budget
Description The budget of the campaign
Field type dimension
Data type float.currency.value
campaign_end_date
Display name Campaign end date
Description The last day of the campaign in serving customer's timezone in YYYY-MM-DD format. On create, defaults to 2037-12-30, which means the campaign will run indefinitely. To set an existing campaign to run indefinitely, set this field to 2037-12-30
Field type dimension
Data type string.time.date
campaign_id
Display name Campaign ID
Description The ID of the campaign
Field type dimension
Data type string.text.value
campaign_start_date
Display name Campaign start date
Description The date when campaign started in serving customer's timezone in YYYY-MM-DD format
Field type dimension
Data type string.time.date
campaign_state
Display name Campaign state
Description The status of the campaign. When a new campaign is added, the status defaults to ENABLED
Field type dimension
Data type string.text.value
campaign_type
Display name Campaign type
Description The primary serving target for ads within the campaign. The targeting options can be refined in network_settings. This field is required and should not be empty when creating new campaigns. Can be set only when creating campaigns. After the campaign is created, the field can not be changed
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
client_account_conversions
Display name Client account conversions
Description The number of client account conversions. This only includes conversion actions which include_in_client_account_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions
Field type metric
Data type float.number.value
client_account_conversions_value
Display name Client account conversions value
Description The value of client account conversions. This only includes conversion actions which include_in_client_account_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions
Field type metric
Data type float.currency.value
client_account_view_through_conversions
Display name Client account view-through conversions
Description The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (for example, clicking on) another ad
Field type metric
Data type int.number.value
content_budget_lost_impression_share
Display name Content budget lost impression share
Description The estimated percent of times that your ad was eligible to show on the Display Network but didn't because your budget was too low. Note: Content budget lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001
Field type metric
Data type float.number.percentage
content_impression_share
Display name Content impression share
Description The impressions you've received on the Display Network divided by the estimated number of impressions you were eligible to receive. Note: Content impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999
Field type metric
Data type float.number.percentage
content_rank_lost_impression_share
Display name Content rank lost impression share
Description The estimated percentage of impressions on the Display Network that your ads didn't receive due to poor Ad Rank. Note: Content rank lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001
Field type metric
Data type float.number.percentage
cost
Display name Cost
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause
Field type metric
Data type float.currency.value
customer_name
Display name Account
Description Optional, non-unique descriptive name of the customer
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
delivery_method
Display name Delivery method
Description The delivery method that determines the rate at which the campaign budget is spent. Defaults to STANDARD if unspecified in a create operation
Field type dimension
Data type string.text.value
engine_id
Display name Engine ID
Description ID of the account in the external engine account
Field type dimension
Data type string.text.value
impressions
Display name Impressions
Description Count of how often your ad has appeared on a search results page or website on the Google Network
Field type metric
Data type int.number.value
search_budget_lost_impression_share
Display name Search budget lost impression share
Description The estimated percent of times that your ad was eligible to show on the Search Network but didn't because your budget was too low. Note: Search budget lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001
Field type metric
Data type float.number.percentage
search_impression_share
Display name Search impression share
Description The impressions you've received on the Search Network divided by the estimated number of impressions you were eligible to receive. Note: Search impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999
Field type metric
Data type float.number.percentage
search_rank_lost_impression_share
Display name Search rank lost impression share
Description The estimated percentage of impressions on the Search Network that your ads didn't receive due to poor Ad Rank. Note: Search rank lost impression share is reported in the range of 0 to 0.9. Any value above 0.9 is reported as 0.9001
Field type metric
Data type float.number.percentage
visits
Display name Visits
Description Clicks that Search Ads 360 has successfully recorded and forwarded to an advertiser's landing page
Field type metric
Data type int.number.value

Table: AD_GROUP

account_id
Display name Account ID
Description The ID of the customer
Field type dimension
Data type string.text.value
account_type
Display name Account type
Description Engine account type, for example, Google Ads, Microsoft Advertising, Yahoo Japan, Baidu, Facebook, Engine Track, etc
Field type dimension
Data type string.text.value
ad_group
Display name Ad group
Description The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters
Field type dimension
Data type string.text.value
ad_group_cpc_bid
Display name Ad group CPC bid
Description The maximum CPC (cost-per-click) bid
Field type dimension
Data type float.currency.value
ad_group_id
Display name Ad group ID
Description The ID of the ad group
Field type dimension
Data type string.text.value
ad_group_state
Display name Ad group state
Description The status of the ad group
Field type dimension
Data type string.text.value
campaign
Display name Campaign
Description The name of the campaign. This field is required and should not be empty when creating new campaigns. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters
Field type dimension
Data type string.text.value
campaign_end_date
Display name Campaign end date
Description The last day of the campaign in serving customer's timezone in YYYY-MM-DD format. On create, defaults to 2037-12-30, which means the campaign will run indefinitely. To set an existing campaign to run indefinitely, set this field to 2037-12-30
Field type dimension
Data type string.time.date
campaign_id
Display name Campaign ID
Description The ID of the campaign
Field type dimension
Data type string.text.value
campaign_start_date
Display name Campaign start date
Description The date when campaign started in serving customer's timezone in YYYY-MM-DD format
Field type dimension
Data type string.time.date
clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
client_account_conversions
Display name Client account conversions
Description The number of client account conversions. This only includes conversion actions which include_in_client_account_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions
Field type metric
Data type float.number.value
client_account_conversions_value
Display name Client account conversions value
Description The value of client account conversions. This only includes conversion actions which include_in_client_account_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions
Field type metric
Data type float.currency.value
client_account_view_through_conversions
Display name Client account view-through conversions
Description The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (for example, clicking on) another ad
Field type metric
Data type int.number.value
cost
Display name Cost
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause
Field type metric
Data type float.currency.value
customer_name
Display name Account
Description Optional, non-unique descriptive name of the customer
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
engine_id
Display name Engine ID
Description ID of the account in the external engine account
Field type dimension
Data type string.text.value
impressions
Display name Impressions
Description Count of how often your ad has appeared on a search results page or website on the Google Network
Field type metric
Data type int.number.value
visits
Display name Visits
Description Clicks that Search Ads 360 has successfully recorded and forwarded to an advertiser's landing page
Field type metric
Data type int.number.value

Table: AD

account_id
Display name Account ID
Description The ID of the customer
Field type dimension
Data type string.text.value
account_type
Display name Account type
Description Engine account type, for example, Google Ads, Microsoft Advertising, Yahoo Japan, Baidu, Facebook, Engine Track, etc
Field type dimension
Data type string.text.value
ad
Display name Ad
Description The name of the ad. This is only used to be able to identify the ad. It does not need to be unique and does not affect the served ad. The name field is currently only supported for DisplayUploadAd, ImageAd, ShoppingComparisonListingAd and VideoAd
Field type dimension
Data type string.text.value
ad_description_1
Display name Ad description 1
Description Text ad description 1
Field type dimension
Data type string.text.value
ad_description_2
Display name Ad description 2
Description Text ad description 2
Field type dimension
Data type string.text.value
ad_display_url
Display name Ad display URL
Description The URL that appears in the ad description for some ad formats
Field type dimension
Data type string.text.url
ad_engine_id
Display name Ad engine ID
Description ID of the ad in the external engine account. This field is for SearchAds 360 account only, for example, Yahoo Japan, Microsoft, Baidu etc. For non-SearchAds 360 entity, use "ad_group_ad.ad.id" instead
Field type dimension
Data type string.text.value
ad_final_url
Display name Ad final URL
Description The list of possible final URLs after all cross-domain redirects for the ad
Field type dimension
Data type string.text.url
ad_group
Display name Ad group
Description The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters
Field type dimension
Data type string.text.value
ad_group_id
Display name Ad group ID
Description The ID of the ad group
Field type dimension
Data type string.text.value
ad_headline
Display name Ad headline
Description The headline of the ad
Field type dimension
Data type string.text.value
ad_headline_2
Display name Ad headline 2
Description The second headline of the ad
Field type dimension
Data type string.text.value
ad_id
Display name Ad ID
Description The ID of the ad
Field type dimension
Data type string.text.value
ad_path_1
Display name Ad path 1
Description Text appended to the auto-generated visible URL with a delimiter
Field type dimension
Data type string.text.value
ad_path_2
Display name Ad path 2
Description Text appended to path1 with a delimiter
Field type dimension
Data type string.text.value
ad_type
Display name Ad type
Description The type of ad
Field type dimension
Data type string.text.value
campaign
Display name Campaign
Description The name of the campaign. This field is required and should not be empty when creating new campaigns. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description The ID of the campaign
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
client_account_conversions
Display name Client account conversions
Description The number of client account conversions. This only includes conversion actions which include_in_client_account_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions
Field type metric
Data type float.number.value
client_account_conversions_value
Display name Client account conversions value
Description The value of client account conversions. This only includes conversion actions which include_in_client_account_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions
Field type metric
Data type float.currency.value
client_account_view_through_conversions
Display name Client account view-through conversions
Description The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (for example, clicking on) another ad
Field type metric
Data type int.number.value
cost
Display name Cost
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause
Field type metric
Data type float.currency.value
customer_name
Display name Account
Description Optional, non-unique descriptive name of the customer
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description Count of how often your ad has appeared on a search results page or website on the Google Network
Field type metric
Data type int.number.value
visits
Display name Visits
Description Clicks that Search Ads 360 has successfully recorded and forwarded to an advertiser's landing page
Field type metric
Data type int.number.value

Table: KEYWORD

account_id
Display name Account ID
Description The ID of the customer
Field type dimension
Data type string.text.value
account_type
Display name Account type
Description Engine account type, for example, Google Ads, Microsoft Advertising, Yahoo Japan, Baidu, Facebook, Engine Track, etc
Field type dimension
Data type string.text.value
ad_group
Display name Ad group
Description The name of the ad group. This field is required and should not be empty when creating new ad groups. It must contain fewer than 255 UTF-8 full-width characters. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters
Field type dimension
Data type string.text.value
ad_group_id
Display name Ad group ID
Description The ID of the ad group
Field type dimension
Data type string.text.value
bid_cpc
Display name Bid CPC
Description The CPC (cost-per-click) bid
Field type dimension
Data type float.currency.value
campaign
Display name Campaign
Description The name of the campaign. This field is required and should not be empty when creating new campaigns. It must not contain any null (code point 0x0), NL line feed (code point 0xA) or carriage return (code point 0xD) characters
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description The ID of the campaign
Field type dimension
Data type string.text.value
click_server_url
Display name Click server URL
Description The URL template for constructing a tracking URL
Field type dimension
Data type string.text.url
clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
cost
Display name Cost
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause
Field type metric
Data type float.currency.value
customer_name
Display name Account
Description Optional, non-unique descriptive name of the customer
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
effective_max_cpc
Display name Effective max CPC
Description The effective CPC (cost-per-click) bid
Field type dimension
Data type float.currency.value
external_keyword_id
Display name External keyword ID
Description ID of the ad group criterion in the external engine account. This field is for non-Google Ads account only, for example, Yahoo Japan, Microsoft, Baidu etc. For Google Ads entity, use "ad_group_criterion.criterion_id" instead
Field type dimension
Data type string.text.value
impressions
Display name Impressions
Description Count of how often your ad has appeared on a search results page or website on the Google Network
Field type metric
Data type int.number.value
keyword
Display name Keyword
Description The text of the keyword (at most 80 characters and 10 words)
Field type dimension
Data type string.text.value
keyword_final_url
Display name Keyword final URL
Description The list of possible final URLs after all cross-domain redirects for the ad
Field type dimension
Data type string.text.url
keyword_id
Display name Keyword ID
Description The ID of the criterion
Field type dimension
Data type string.text.value
keyword_match_type
Display name Keyword match type
Description The match type of the keyword
Field type dimension
Data type string.text.value
visits
Display name Visits
Description Clicks that Search Ads 360 has successfully recorded and forwarded to an advertiser's landing page
Field type metric
Data type int.number.value