Google Merchant Center data warehouse table groups

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

Table: PERFORMANCE

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
merchant_performance_view__account_id
Display name Account ID
Description Account ID
Field type dimension
Data type string.text.value
merchant_performance_view__account_name
Display name Account name
Description Account name
Field type dimension
Data type string.text.value
merchant_performance_view__brand
Display name Brand
Description Brand of the product
Field type dimension
Data type string.text.value
merchant_performance_view__clicks
Display name Clicks
Description The total number of clicks on your product on Google that led to visits to your product detail pages
Field type metric
Data type int.number.value
merchant_performance_view__conversions
Display name Conversions
Description Conversion are when customer completed a desired action on your website or app, such as buying your product
Field type metric
Data type int.number.value
merchant_performance_view__currency_code
Display name Currency code
Description Currency in which price metrics are represented
Field type dimension
Data type string.currency.code
merchant_performance_view__custom_label_four
Display name Custom label 4
Description The label that you assigned to the product
Field type dimension
Data type string.text.value
merchant_performance_view__custom_label_one
Display name Custom label 1
Description The label that you assigned to the product
Field type dimension
Data type string.text.value
merchant_performance_view__custom_label_three
Display name Custom label 3
Description The label that you assigned to the product
Field type dimension
Data type string.text.value
merchant_performance_view__custom_label_two
Display name Custom label 2
Description The label that you assigned to the product
Field type dimension
Data type string.text.value
merchant_performance_view__custom_label_zero
Display name Custom label 0
Description The label that you assigned to the product
Field type dimension
Data type string.text.value
merchant_performance_view__customer_country_code
Display name Customer country code
Description Country where the customer is located at the time of the action
Field type dimension
Data type string.geo.country.twolettercode
merchant_performance_view__date
Display name Date
Field type dimension
Data type string.time.date
merchant_performance_view__impressions
Display name Impressions
Description How often your product was shows on Google
Field type metric
Data type int.number.value
merchant_performance_view__product_category_five
Display name Product category (5th level)
Description The product category defined by Google and assigned to your product
Field type dimension
Data type string.text.value
merchant_performance_view__product_category_four
Display name Product category (4th level)
Description The product category defined by Google and assigned to your product
Field type dimension
Data type string.text.value
merchant_performance_view__product_category_one
Display name Product category (1st level)
Description The product category defined by Google and assigned to your product
Field type dimension
Data type string.text.value
merchant_performance_view__product_category_three
Display name Product category (3rd level)
Description The product category defined by Google and assigned to your product
Field type dimension
Data type string.text.value
merchant_performance_view__product_category_two
Display name Product category (2nd level)
Description The product category defined by Google and assigned to your product
Field type dimension
Data type string.text.value
merchant_performance_view__product_id
Display name Product ID
Description A unique identifier of your product
Field type dimension
Data type string.text.value
merchant_performance_view__product_type_five
Display name Product type (5th level)
Description The category that you defined for your product
Field type dimension
Data type string.text.value
merchant_performance_view__product_type_four
Display name Product type (4th level)
Description The category that you defined for your product
Field type dimension
Data type string.text.value
merchant_performance_view__product_type_one
Display name Product type (1st level)
Description The category that you defined for your product
Field type dimension
Data type string.text.value
merchant_performance_view__product_type_three
Display name Product type (3rd level)
Description The category that you defined for your product
Field type dimension
Data type string.text.value
merchant_performance_view__product_type_two
Display name Product type (2nd level)
Description The category that you defined for your product
Field type dimension
Data type string.text.value
merchant_performance_view__program
Display name Program
Description Program to which metrics apply, for example, Free Product Listing
Field type dimension
Data type string.text.value
merchant_performance_view__title
Display name Title
Description The name that describes your product
Field type dimension
Data type string.text.value

Table: ITEM_ISSUE

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
diagnostics__account_id
Display name Account ID
Description Account ID
Field type dimension
Data type string.text.value
diagnostics__account_name
Display name Account name
Description Account name
Field type dimension
Data type string.text.value
diagnostics__approved_countries
Display name Approved countries
Description List of country codes (ISO 3166-1 alpha-2) where the offer is approved
Field type dimension
Data type string.text.value
diagnostics__creation_date
Display name Creation date
Description Date on which the item has been created, in ISO 8601 format
Field type dimension
Data type string.time.datetime
diagnostics__disapproved_countries
Display name Disapproved countries
Description List of country codes (ISO 3166-1 alpha-2) where the offer is disapproved
Field type dimension
Data type string.text.value
diagnostics__google_expiration_date
Display name Google expiration date
Description Date on which the item expires in Google Shopping, in ISO 8601 format
Field type dimension
Data type string.time.datetime
diagnostics__id
Display name Product ID
Description The ID of the product for which status is reported
Field type dimension
Data type string.text.value
diagnostics__issue_applicable_countries
Display name Issue applicable countries
Description List of country codes (ISO 3166-1 alpha-2) where issue applies to the offer
Field type dimension
Data type string.text.value
diagnostics__issue_attribute_name
Display name Issue attribute name
Description The attribute's name, if the issue is caused by a single attribute
Field type dimension
Data type string.text.value
diagnostics__issue_code
Display name Issue code
Description The error code of the issue
Field type dimension
Data type string.text.value
diagnostics__issue_description
Display name Issue description
Description A short issue description in English
Field type dimension
Data type string.text.value
diagnostics__issue_destination
Display name Issue destination
Description The destination the issue applies to
Field type dimension
Data type string.text.value
diagnostics__issue_detail
Display name Issue detail
Description A detailed issue description in English
Field type dimension
Data type string.text.value
diagnostics__issue_documentation
Display name Issue documentation
Description The URL of a web page to help with resolving this issue
Field type dimension
Data type string.text.url
diagnostics__issue_resolution
Display name Issue resolution
Description Whether the issue can be resolved by the merchant
Field type dimension
Data type string.text.value
diagnostics__issue_servability
Display name Issue servability
Description How this issue affects serving of the offer
Field type dimension
Data type string.text.value
diagnostics__last_update_date
Display name Last update date
Description Date on which the item has been last updated, in ISO 8601 format
Field type dimension
Data type string.time.datetime
diagnostics__pending_countries
Display name Pending countries
Description List of country codes (ISO 3166-1 alpha-2) where the offer is pending approval
Field type dimension
Data type string.text.value
diagnostics__product_destination
Display name Destination
Description The name of the destination
Field type dimension
Data type string.text.value
diagnostics__status
Display name Status
Description Destination approval status
Field type dimension
Data type string.text.value
diagnostics__title
Display name Title
Description The title of the product
Field type dimension
Data type string.text.value
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date

Table: PRODUCT

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
product__account_id
Display name Account ID
Description Account ID
Field type dimension
Data type string.text.value
product__account_name
Display name Account name
Description Account name
Field type dimension
Data type string.text.value
product__availability
Display name Availability
Description Availability status of the item
Field type dimension
Data type string.text.value
product__brand
Display name Brand
Description The publicly recognized name of the company that makes your product
Field type dimension
Data type string.text.value
product__channel
Display name Channel
Description The item's channel (online or local)
Field type dimension
Data type string.text.value
product__condition
Display name Condition
Description Condition or state of the item
Field type dimension
Data type string.text.value
product__currency
Display name Currency
Description The currency of the price
Field type dimension
Data type string.currency.code
product__custom_label_four
Display name Custom label 4
Description Custom label 4 for custom grouping of items in a Shopping campaign
Field type dimension
Data type string.text.value
product__custom_label_one
Display name Custom label 1
Description Custom label 1 for custom grouping of items in a Shopping campaign
Field type dimension
Data type string.text.value
product__custom_label_three
Display name Custom label 3
Description Custom label 3 for custom grouping of items in a Shopping campaign
Field type dimension
Data type string.text.value
product__custom_label_two
Display name Custom label 2
Description Custom label 2 for custom grouping of items in a Shopping campaign
Field type dimension
Data type string.text.value
product__custom_label_zero
Display name Custom label 0
Description Custom label 0 for custom grouping of items in a Shopping campaign
Field type dimension
Data type string.text.value
product__description
Display name Description
Description Description of the item
Field type dimension
Data type string.text.value
product__feed_label
Display name Feed label
Description Feed label for the item
Field type dimension
Data type string.text.value
product__google_product_category
Display name Google product category
Description Google's category of the item (see Google product taxonomy)
Field type dimension
Data type string.text.value
product__gtin
Display name GTIN
Description Global Trade Item Number (GTIN) of the item
Field type dimension
Data type string.text.value
product__item_group_id
Display name Item group ID
Description Shared identifier for all variants of the same product
Field type dimension
Data type string.text.value
product__item_id
Display name Item ID
Description A unique identifier for the item
Field type dimension
Data type string.text.value
product__language
Display name Language
Description The two-letter ISO 639-1 language code for the item
Field type dimension
Data type string.text.value
product__mpn
Display name MPN (Manufacturer Partner Number)
Description Manufacturer Part Number (MPN) of the item
Field type dimension
Data type string.text.value
product__price
Display name Price
Description The price represented as a number
Field type dimension
Data type string.text.value
product__product_id
Display name Product ID
Description The REST ID of the product
Field type dimension
Data type string.text.value
product__product_type
Display name Product type
Description Categories of the item
Field type dimension
Data type string.text.value
product__shipping_label
Display name Shipping label
Description The shipping label of the product, used to group product in account-level shipping rules
Field type dimension
Data type string.text.value
product__source
Display name Source
Description Currency in which price metrics are represented
Field type dimension
Data type string.text.value
product__target_country
Display name Target country
Description The CLDR territory code for the item's country of sale
Field type dimension
Data type string.geo.country.twolettercode
product__tax_category
Display name Tax category
Description The tax category of the product, used to configure detailed tax nexus in account-level tax settings
Field type dimension
Data type string.text.value
product__title
Display name Title
Description Title of the item
Field type dimension
Data type string.text.value
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date