Google AdSense data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: BUYER_NETWORK

account_id
Display name Account ID
Description The account ID. Example: ca-pub-088712
Field type dimension
Data type string.text.value
ad_clicks
Display name Ad clicks
Description The number of times a user clicked on a standard content ad
Field type metric
Data type int.number.value
ad_client_id
Display name Client ID
Description The ID of an ad client. Example: ca-feed-pub-088712
Field type dimension
Data type string.text.value
ad_format_code
Display name Format code
Description Ad format code indicating the way an ad is shown to the users on your site. Examples: ON_PAGE, ANCHOR, INTERSTITIAL
Field type dimension
Data type string.text.value
ad_format_name
Display name Format name
Description Localized ad format name indicating the way an ad is shown to the users on your site. Examples: In-page, Anchor, or Vignette
Field type dimension
Data type string.text.value
ad_requests
Display name Ad requests
Description The number of ad units that requested ads (for content ads) or search queries (for search ads)
Field type metric
Data type int.number.value
ad_requests_coverage
Display name Ad requests coverage
Description The ratio of requested ad units or queries to the number returned to the site
Field type metric
Data type float.number.ratio
bid_type_code
Display name Bid type
Description The type of a bid. Examples: cpc, cpm
Field type dimension
Data type string.text.value
bid_type_name
Display name Bid name
Description A bid type name. Examples: CPC bids, CPM bids
Field type dimension
Data type string.text.value
buyer_network_id
Display name Network ID
Description The ID of an ad network that sends ads to your site
Field type dimension
Data type string.text.value
buyer_network_name
Display name Network name
Description The name of an ad network that sends ads to your site. Example: Google Adwords
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
Field type dimension
Data type string.time.date
earnings
Display name Estimated earnings
Description The estimated earnings of the publisher
Field type metric
Data type float.currency.value
individual_ad_impressions
Display name Ad impressions
Description The number of times an individual ad is displayed on your website. Different ad formats will display varying numbers of ads
Field type metric
Data type int.number.value
matched_ad_request
Display name Matched ad request
Description The number of ad units (for content ads) or search queries (for search ads) that showed ads
Field type metric
Data type int.number.value
page_views
Display name Page views
Description The number of page views
Field type metric
Data type int.number.value
platform_type_code
Display name Platform type code
Description The code of a platform type. Examples: HighEndMobile, Desktop
Field type dimension
Data type string.text.value
platform_type_name
Display name Platform type name
Description The name of a platform type. Examples: High-end mobile devices, Desktop
Field type dimension
Data type string.text.value
targeting_type_code
Display name Targeting type code
Description A targeting type code. Examples: Keyword, UserInterest, RunOfNetwork
Field type dimension
Data type string.text.value
targeting_type_name
Display name Targeting type name
Description A targeting type name. Examples: Contextual, Personalized, Run of Network
Field type dimension
Data type string.text.value

Table: AD_UNIT

account_id
Display name Account ID
Description The account ID. Example: ca-pub-088712
Field type dimension
Data type string.text.value
ad_clicks
Display name Ad clicks
Description The number of times a user clicked on a standard content ad
Field type metric
Data type int.number.value
ad_client_id
Display name Client ID
Description The ID of an ad client. Example: ca-feed-pub-088712
Field type dimension
Data type string.text.value
ad_format_code
Display name Format code
Description Ad format code indicating the way an ad is shown to the users on your site. Examples: ON_PAGE, ANCHOR, INTERSTITIAL
Field type dimension
Data type string.text.value
ad_format_name
Display name Format name
Description Localized ad format name indicating the way an ad is shown to the users on your site. Examples: In-page, Anchor, or Vignette
Field type dimension
Data type string.text.value
ad_requests
Display name Ad requests
Description The number of ad units that requested ads (for content ads) or search queries (for search ads)
Field type metric
Data type int.number.value
ad_requests_coverage
Display name Ad requests coverage
Description The ratio of requested ad units or queries to the number returned to the site
Field type metric
Data type float.number.ratio
ad_unit_code
Display name Unit code
Description The code of an ad unit. This value is not necessarily unique across ad clients. Example: 837572. Please note that this field will be removed on 2021-08-01
Field type dimension
Data type int.number.value
ad_unit_id
Display name Unit ID
Description The unique ID of an ad unit. Example: ca-pub-088712:837572
Field type dimension
Data type string.text.value
ad_unit_name
Display name Unit name
Description The name of an ad unit
Field type dimension
Data type string.text.value
ad_unit_size_code
Display name Unit size code
Description The size code of an ad unit. Examples: 720x42 or mobile_single
Field type dimension
Data type string.text.value
ad_unit_size_name
Display name Unit size name
Description The size name of an ad unit. Examples: 720x42 or Single (Mobile)
Field type dimension
Data type string.text.value
bid_type_code
Display name Bid type
Description The type of a bid. Examples: cpc, cpm
Field type dimension
Data type string.text.value
bid_type_name
Display name Bid name
Description A bid type name. Examples: CPC bids, CPM bids
Field type dimension
Data type string.text.value
country_code
Display name Country code
Description The CLDR Region Code. Examples: US, FR
Field type dimension
Data type string.geo.country.twolettercode
country_name
Display name Country name
Description Region name. Examples: United States, France
Field type dimension
Data type string.geo.country
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
Field type dimension
Data type string.time.date
earnings
Display name Estimated earnings
Description The estimated earnings of the publisher
Field type metric
Data type float.currency.value
individual_ad_impressions
Display name Ad impressions
Description The number of times an individual ad is displayed on your website. Different ad formats will display varying numbers of ads
Field type metric
Data type int.number.value
matched_ad_request
Display name Matched ad request
Description The number of ad units (for content ads) or search queries (for search ads) that showed ads
Field type metric
Data type int.number.value
page_views
Display name Page views
Description The number of page views
Field type metric
Data type int.number.value
platform_type_code
Display name Platform type code
Description The code of a platform type. Examples: HighEndMobile, Desktop
Field type dimension
Data type string.text.value
platform_type_name
Display name Platform type name
Description The name of a platform type. Examples: High-end mobile devices, Desktop
Field type dimension
Data type string.text.value
targeting_type_code
Display name Targeting type code
Description A targeting type code. Examples: Keyword, UserInterest, RunOfNetwork
Field type dimension
Data type string.text.value
targeting_type_name
Display name Targeting type name
Description A targeting type name. Examples: Contextual, Personalized, Run of Network
Field type dimension
Data type string.text.value

Table: CUSTOM_CHANNEL

account_id
Display name Account ID
Description The account ID. Example: ca-pub-088712
Field type dimension
Data type string.text.value
ad_clicks
Display name Ad clicks
Description The number of times a user clicked on a standard content ad
Field type metric
Data type int.number.value
ad_client_id
Display name Client ID
Description The ID of an ad client. Example: ca-feed-pub-088712
Field type dimension
Data type string.text.value
ad_format_code
Display name Format code
Description Ad format code indicating the way an ad is shown to the users on your site. Examples: ON_PAGE, ANCHOR, INTERSTITIAL
Field type dimension
Data type string.text.value
ad_format_name
Display name Format name
Description Localized ad format name indicating the way an ad is shown to the users on your site. Examples: In-page, Anchor, or Vignette
Field type dimension
Data type string.text.value
ad_requests
Display name Ad requests
Description The number of ad units that requested ads (for content ads) or search queries (for search ads)
Field type metric
Data type int.number.value
ad_requests_coverage
Display name Ad requests coverage
Description The ratio of requested ad units or queries to the number returned to the site
Field type metric
Data type float.number.ratio
bid_type_code
Display name Bid type
Description The type of a bid. Examples: cpc, cpm
Field type dimension
Data type string.text.value
bid_type_name
Display name Bid name
Description A bid type name. Examples: CPC bids, CPM bids
Field type dimension
Data type string.text.value
cstm_channel_code
Display name Channel code
Description The code of a custom channel. Please note that this field will be removed on 2021-08-01
Field type dimension
Data type string.text.value
cstm_channel_id
Display name Channel ID
Description The ID of a custom channel
Field type dimension
Data type string.text.value
cstm_channel_name
Display name Channel name
Description The name of a custom channel
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
Field type dimension
Data type string.time.date
earnings
Display name Estimated earnings
Description The estimated earnings of the publisher
Field type metric
Data type float.currency.value
individual_ad_impressions
Display name Ad impressions
Description The number of times an individual ad is displayed on your website. Different ad formats will display varying numbers of ads
Field type metric
Data type int.number.value
matched_ad_request
Display name Matched ad request
Description The number of ad units (for content ads) or search queries (for search ads) that showed ads
Field type metric
Data type int.number.value
page_views
Display name Page views
Description The number of page views
Field type metric
Data type int.number.value
platform_type_code
Display name Platform type code
Description The code of a platform type. Examples: HighEndMobile, Desktop
Field type dimension
Data type string.text.value
platform_type_name
Display name Platform type name
Description The name of a platform type. Examples: High-end mobile devices, Desktop
Field type dimension
Data type string.text.value
targeting_type_code
Display name Targeting type code
Description A targeting type code. Examples: Keyword, UserInterest, RunOfNetwork
Field type dimension
Data type string.text.value
targeting_type_name
Display name Targeting type name
Description A targeting type name. Examples: Contextual, Personalized, Run of Network
Field type dimension
Data type string.text.value

Table: URL_CHANNEL

account_id
Display name Account ID
Description The account ID. Example: ca-pub-088712
Field type dimension
Data type string.text.value
ad_clicks
Display name Ad clicks
Description The number of times a user clicked on a standard content ad
Field type metric
Data type int.number.value
ad_client_id
Display name Client ID
Description The ID of an ad client. Example: ca-feed-pub-088712
Field type dimension
Data type string.text.value
ad_format_code
Display name Format code
Description Ad format code indicating the way an ad is shown to the users on your site. Examples: ON_PAGE, ANCHOR, INTERSTITIAL
Field type dimension
Data type string.text.value
ad_format_name
Display name Format name
Description Localized ad format name indicating the way an ad is shown to the users on your site. Examples: In-page, Anchor, or Vignette
Field type dimension
Data type string.text.value
ad_requests
Display name Ad requests
Description The number of ad units that requested ads (for content ads) or search queries (for search ads)
Field type metric
Data type int.number.value
ad_requests_coverage
Display name Ad requests coverage
Description The ratio of requested ad units or queries to the number returned to the site
Field type metric
Data type float.number.ratio
bid_type_code
Display name Bid type
Description The type of a bid. Examples: cpc, cpm
Field type dimension
Data type string.text.value
bid_type_name
Display name Bid name
Description A bid type name. Examples: CPC bids, CPM bids
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
Field type dimension
Data type string.time.date
earnings
Display name Estimated earnings
Description The estimated earnings of the publisher
Field type metric
Data type float.currency.value
individual_ad_impressions
Display name Ad impressions
Description The number of times an individual ad is displayed on your website. Different ad formats will display varying numbers of ads
Field type metric
Data type int.number.value
matched_ad_request
Display name Matched ad request
Description The number of ad units (for content ads) or search queries (for search ads) that showed ads
Field type metric
Data type int.number.value
page_views
Display name Page views
Description The number of page views
Field type metric
Data type int.number.value
platform_type_code
Display name Platform type code
Description The code of a platform type. Examples: HighEndMobile, Desktop
Field type dimension
Data type string.text.value
platform_type_name
Display name Platform type name
Description The name of a platform type. Examples: High-end mobile devices, Desktop
Field type dimension
Data type string.text.value
product_code
Display name Product code
Description The code of a product. Examples: AFC, AFS
Field type dimension
Data type string.text.value
product_name
Display name Product name
Description The name of a product. Examples: AdSense for Content, AdSense for Search
Field type dimension
Data type string.text.value
targeting_type_code
Display name Targeting type code
Description A targeting type code. Examples: Keyword, UserInterest, RunOfNetwork
Field type dimension
Data type string.text.value
targeting_type_name
Display name Targeting type name
Description A targeting type name. Examples: Contextual, Personalized, Run of Network
Field type dimension
Data type string.text.value
url_channel_id
Display name URL channel ID
Description The ID of a URL channel
Field type dimension
Data type string.text.value
url_channel_name
Display name URL channel name
Description The domain name
Field type dimension
Data type string.text.value