Google Merchant Center Connector Reference

The Google Merchant Center connector exposes 141 fields (33 metrics, 108 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Google Merchant Center Fields

Google Merchant Center Competitive Visibility Benchmark fields

The Competitive Visibility Benchmark report of the Google Merchant Center connector includes 6 fields.

ID	Type	Name	Description	Report
cv_benchmark_category_id	TEXT	Competitive Visibility Benchmark Category ID	The Google product taxonomy category ID the benchmark applies to.	reports
cv_benchmark_category_visibility_trend	NUMERIC	Category Benchmark Visibility Trend	Change in the category average visibility relative to the first day of the requested range, as a fraction.	reports
cv_benchmark_country	COUNTRY	Competitive Visibility Benchmark Country	The CLDR territory code of the country the benchmark applies to.	reports
cv_benchmark_date	DATE	Competitive Visibility Benchmark Date	Date in the merchant timezone to which the benchmark applies.	reports
cv_benchmark_traffic_source	TEXT	Competitive Visibility Benchmark Traffic Source	Traffic source of the impressions: ADS, ORGANIC or ALL.	reports
cv_benchmark_your_domain_visibility_trend	NUMERIC	Your Domain Visibility Trend	Change in your visibility relative to the first day of the requested range, as a fraction.	reports

Google Merchant Center Competitive Visibility Competitors fields

The Competitive Visibility Competitors report of the Google Merchant Center connector includes 10 fields.

ID	Type	Name	Description	Report
cv_competitor_ads_organic_ratio	NUMERIC	Competitive Visibility Competitor Ads Organic Ratio	Ratio of ads impressions to organic impressions for the domain.	reports
cv_competitor_category_id	TEXT	Competitive Visibility Competitor Category ID	The Google product taxonomy category ID the ranking applies to.	reports
cv_competitor_country	COUNTRY	Competitive Visibility Competitor Country	The CLDR territory code of the country the ranking applies to.	reports
cv_competitor_domain	TEXT	Competitive Visibility Competitor Domain	Domain of one of the businesses with similar visibility to yours.	reports
cv_competitor_higher_position_rate	NUMERIC	Competitive Visibility Competitor Higher Position Rate	Fraction of impressions where the domain was shown in a higher position than your domain on the same page.	reports
cv_competitor_is_your_domain	BOOLEAN	Competitive Visibility Competitor Is Your Domain	True if the domain is your own domain.	reports
cv_competitor_page_overlap_rate	NUMERIC	Competitive Visibility Competitor Page Overlap Rate	Fraction of impressions where your domain and the domain both appeared on the same page.	reports
cv_competitor_rank	NUMERIC	Competitive Visibility Competitor Rank	Position of the domain in the competitor ranking by impressions, where 1 is the highest.	reports
cv_competitor_relative_visibility	NUMERIC	Competitive Visibility Competitor Relative Visibility	Visibility of the domain relative to your own, as a fraction (negative means less visible than you).	reports
cv_competitor_traffic_source	TEXT	Competitive Visibility Competitor Traffic Source	Traffic source of the impressions: ADS, ORGANIC or ALL.	reports

Google Merchant Center Competitive Visibility Top Merchants fields

The Competitive Visibility Top Merchants report of the Google Merchant Center connector includes 9 fields.

ID	Type	Name	Description	Report
cv_top_merchant_ads_organic_ratio	NUMERIC	Competitive Visibility Top Merchant Ads Organic Ratio	Ratio of ads impressions to organic impressions for the domain.	reports
cv_top_merchant_category_id	TEXT	Competitive Visibility Top Merchant Category ID	The Google product taxonomy category ID the ranking applies to.	reports
cv_top_merchant_country	COUNTRY	Competitive Visibility Top Merchant Country	The CLDR territory code of the country the ranking applies to.	reports
cv_top_merchant_domain	TEXT	Competitive Visibility Top Merchant Domain	Domain of one of the businesses with the highest visibility.	reports
cv_top_merchant_higher_position_rate	NUMERIC	Competitive Visibility Top Merchant Higher Position Rate	Fraction of impressions where the domain was shown in a higher position than your domain on the same page.	reports
cv_top_merchant_is_your_domain	BOOLEAN	Competitive Visibility Top Merchant Is Your Domain	True if the domain is your own domain.	reports
cv_top_merchant_page_overlap_rate	NUMERIC	Competitive Visibility Top Merchant Page Overlap Rate	Fraction of impressions where your domain and the domain both appeared on the same page.	reports
cv_top_merchant_rank	NUMERIC	Competitive Visibility Top Merchant Rank	Position of the domain in the top merchants ranking by impressions, where 1 is the highest.	reports
cv_top_merchant_traffic_source	TEXT	Competitive Visibility Top Merchant Traffic Source	Traffic source of the impressions: ADS, ORGANIC or ALL.	reports

Google Merchant Center Product Statuses fields

The Product Statuses report of the Google Merchant Center connector includes 6 fields.

ID	Type	Name	Description	Report
product_status_active_count	NUMERIC	Active Product Count	Number of active products for the reporting context and country.	aggregateProductStatuses
product_status_country	COUNTRY	Product Status Country	The CLDR territory code of the country the aggregate product status applies to.	aggregateProductStatuses
product_status_disapproved_count	NUMERIC	Disapproved Product Count	Number of disapproved products for the reporting context and country.	aggregateProductStatuses
product_status_expiring_count	NUMERIC	Expiring Product Count	Number of expiring products for the reporting context and country.	aggregateProductStatuses
product_status_pending_count	NUMERIC	Pending Product Count	Number of products pending review for the reporting context and country.	aggregateProductStatuses
product_status_reporting_context	TEXT	Product Status Reporting Context	The destination (reporting context) the aggregate product status applies to, for example SHOPPING_ADS or FREE_LISTINGS.	aggregateProductStatuses

Google Merchant Center other fields

The Google Merchant Center connector has 110 fields that do not belong to a named report, or belong to a report with only one or two fields.

Google Merchant Center other fields (account_id to product_custom_label_2)

ID	Type	Name	Description	Report
account_id	TEXT	Account ID	The Google Merchant account ID.	accounts
account_name	TEXT	Account Name	The Google Merchant account name.	accounts
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Date	Universal date field, for product performance contains value of product_performance_date field, for other product related queries contains date part of product_creation_time field, and if only account data (like account_name) queried, contains date when the quiery is being made.
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
product_ads_grouping	TEXT	Product Ads Grouping	Used to group items in an arbitrary way. Only for CPA%, discouraged otherwise.	products
product_ads_redirect	TEXT	Product Ads Redirect	Allows advertisers to override the item URL when the product is shown within the context of Product ads.	products
product_adult	BOOLEAN	Product Adult	Set to true if the item is targeted towards adults.	products
product_age_group	TEXT	Product Age Group	Target age group of the item.	products
product_availability	TEXT	Product Availability	Availability status of the item. For example, "inStock" or "out_of_stock".	products
product_availability_date	DATE	Product Availability Date	The day a pre-ordered product becomes available for delivery, in ISO 8601 format.	products
product_benchmark_price	NUMERIC	Product Benchmark Price	Latest available price benchmark for the product's catalog in the benchmark country.	reports
product_benchmark_price_currency_code	TEXT	Product Benchmark Price Currency Code	Currency Code for latest available price benchmark for the product's catalog in the benchmark country. Product Benchmark Price should be requested for the field to be available.	reports
product_brand	TEXT	Product Brand	Brand of the item. For example, "Google".	products
product_canonical_link	TEXT	Product Canonical Link	URL for the canonical version of your item's landing page.	products
product_category_l1	TEXT	Product Category Level 1	Product category (1st level) in Google's product taxonomy.	reports
product_category_l2	TEXT	Product Category Level 2	Product category (2nd level) in Google's product taxonomy.	reports
product_category_l3	TEXT	Product Category Level 3	Product category (3rd level) in Google's product taxonomy.	reports
product_category_l4	TEXT	Product Category Level 4	Product category (4th level) in Google's product taxonomy.	reports
product_category_l5	TEXT	Product Category Level 5	Product category (5th level) in Google's product taxonomy.	reports
product_channel	TEXT	Product Channel	Channel of the product. Can be ONLINE or LOCAL.	reports
product_click_potential	TEXT	Product Click Potential	Estimated performance potential compared to highest performing products of the merchant.	reports
product_click_potential_rank	NUMERIC	Product Click Potrential Rank	Rank of the product based on its click potential. A product with clickPotentialRank1 has the highest click potential among the merchant's products that fulfill the search query conditions.	reports
product_click_uplift	PERCENT	Product Click Uplift	Predicted change in clicks as a fraction afterintroducing the suggested price compared to current active price.For example, 5 is a 5% predicted increase in clicks.	reports
product_clicks	NUMERIC	Product Clicks	Number of clicks.	reports
product_color	TEXT	Product Color	Color of the item. For example, "red".	products
product_condition	TEXT	Product Condition	Condition or state of the item. For example, "new" or "used".	products
product_content_language	TEXT	Product Content Language	The two-letter ISO 639-1 language code for the product.	products
product_conversion_rate	PERCENT	Product Conversion Rate	Number of conversions divided by the number of clicks, reported on the impression date. Available only for the FREE traffic source.	reports
product_conversion_uplift	PERCENT	Product Conversion Uplift	Predicted change in conversions as a fraction afterintroducing the suggested price compared to current active price.For example, 5 is a 5% predicted increase in conversions.	reports
product_conversions	NUMERIC	Product Conversions	Number of conversions attributed to the product, reported on the conversion date. Depending on the attribution model, a conversion might be distributed across multiple clicks, where each click gets its own credit assigned. This metric is a sum of all such credits. Available only for the FREE traffic source.	reports
product_creation_date	DATE	Product Creation Date	The date the merchant created the product.	products
product_creation_time	TIMESTAMP	Product Creation Time	The time the merchant created the product in timestamp seconds.	reports
product_ctr	PERCENT	Product CTR	Click-through rate - the number of clicks merchant's products receive (clicks) divided by the number of times the products are shown (impressions).
product_custom_label_0	TEXT	Product Custom Label 0	Custom label 0 for custom grouping of items in a Shopping campaign.	products
product_custom_label_1	TEXT	Product Custom Label 1	Custom label 1 for custom grouping of items in a Shopping campaign.	products
product_custom_label_2	TEXT	Product Custom Label 2	Custom label 2 for custom grouping of items in a Shopping campaign.	products

Google Merchant Center other fields (product_custom_label_3 to product_sale_price_currency_code)

ID	Type	Name	Description	Report
product_custom_label_3	TEXT	Product Custom Label 3	Custom label 3 for custom grouping of items in a Shopping campaign.	products
product_custom_label_4	TEXT	Product Custom Label 4	Custom label 4 for custom grouping of items in a Shopping campaign.	products
product_data_source	TEXT	Product Data Source	The primary data source of the product.	products
product_description	TEXT	Product Description	Description of the item.	products
product_display_ads_id	TEXT	Product Display Ads ID	An identifier for an item for dynamic remarketing campaigns.	products
product_display_ads_link	TEXT	Product Display Ads Link	URL directly to your item's landing page for dynamic remarketing campaigns.	products
product_display_ads_title	TEXT	Product Display Ads Title	Title of an item for dynamic remarketing campaigns.	products
product_display_ads_value	NUMERIC	Product Display Ads Value	Offer margin for dynamic remarketing campaigns.	products
product_effectiveness	TEXT	Product Effectiveness	The predicted effectiveness of applying the price suggestion, bucketed.	reports
product_energy_efficiency_class	TEXT	Product Energy Efficiency Class	The energy efficiency class as defined in EU directive 2010/30/EU.	products
product_expiration_date	DATE	Product Expiration Date	Date on which the item expires, in ISO 8601 format.	reports
product_external_seller_id	TEXT	Product External Seller ID	Required for multi-seller accounts. Use this attribute if you're a marketplace uploading products for various sellers to your multi-seller account.	products
product_feed_label	TEXT	Product Feed Label	Feed label of the product.	reports
product_gender	TEXT	Product Gender	Target gender of the item. For example, "male" or "female".	products
product_google_category	TEXT	Product Google Category	Google's category of the item (see Google product taxonomy).When querying products, this field will contain the user provided value.There is currently no way to get back the auto assigned google product categories through the API.	products
product_gtin	TEXT	Product GTIN	Global Trade Item Numbers (GTIN) of the item. You can provide up to 10 GTINs. This field includes all provided ones.	reports
product_id	TEXT	Product ID	Your unique identifier for the product.	reports
product_image_link	IMAGE_URL	Product Image Link	URL of an image of the item.	products
product_impression_uplift	PERCENT	Product Impression Uplift	Predicted change in impressions as a fraction afterintroducing the suggested price compared to current active price.For example, 5 is a 5% predicted increase in impressions.	reports
product_impressions	NUMERIC	Product Impressions	Number of times merchant's products are shown.	reports
product_item_group_id	TEXT	Product Item Group ID	Shared identifier for all variants of the same product.	products
product_language_code	TEXT	Product Language Code	Language code of the product in BCP 47 format.	reports
product_last_update_date	DATE	Product Last Update Date	Date on which the item has been last updated, in ISO 8601 format.	products
product_link	TEXT	Product Link	URL directly linking to your item's page on your online store.	products
product_material	TEXT	Product Material	The material of which the item is made. For example, "Leather" or "Cotton".	products
product_max_energy_efficiency_class	TEXT	Product Maximal Energy Efficiency Class	The energy efficiency class as defined in EU directive 2010/30/EU.	products
product_min_energy_efficiency_class	TEXT	Product Minimal Energy Efficiency Class	The energy efficiency class as defined in EU directive 2010/30/EU.	products
product_mobile_link	TEXT	Product Mobile Link	URL for the mobile-optimized version of your item's landing page.	products
product_mpn	TEXT	Product MPN	Manufacturer Part Number (MPN) of the item.	products
product_multipack	NUMERIC	Product Multipack	The number of identical products in a business-defined multipack.	products
product_name	TEXT	Product Name	The name of the product. Format: accounts/{account}/products/{product}where the last section product consists of 4 parts:channel~contentLanguage~feedLabel~offerId example for product name isaccounts/123/products/online~en~US~sku123	products
product_pattern	TEXT	Product Pattern	The item's pattern. For example, polka dots.	products
product_performance_date	DATE	Product Performance Date	Date in the merchant timezone to which metrics apply.	reports
product_pickup_method	TEXT	Product Pickup Method	The pickup option for the item.	products
product_pickup_sla	TEXT	Product Pickup SLA	Item store pickup timeline.	products
product_price	NUMERIC	Product Price	Product price.	reports
product_price_currency_code	TEXT	Product Price Currency Code	Product price currency code. Product Price should be requested for the field to be available.	reports
product_price_gap	PERCENT	Product Price Gap	Percentage difference between your price and the benchmark price for a product.
product_sale_price	NUMERIC	Product Sale Price	Price of the item.	products
product_sale_price_currency_code	TEXT	Product Sale Price Currency Code	Currency code of the price of the item.	products

Google Merchant Center other fields (product_sale_price_effective_end_date to year_week_iso)

ID	Type	Name	Description	Report
product_sale_price_effective_end_date	DATE	Product Sale Price Effective End Date	End of date range during which the item is on sale.	products
product_sale_price_effective_start_date	DATE	Product Sale Price Effective Start Date	Start of date range during which the item is on sale.	products
product_sale_price_micros	NUMERIC	Product Sale Price in Micros.	Price of the item in micros.	products
product_sell_on_google_quantity	NUMERIC	Product Sell on Google Quantity	The quantity of the product that is available for selling on Google.Supported only for online products.	products
product_shipping_label	TEXT	Product Shipping Label	The shipping label of the product,used to group product in account-level shipping rules.	products
product_size	TEXT	Product Size	Size of the item. Only one value is allowed. For variants with different sizes, insert a separate product for each size with the same itemGroupId value.	products
product_size_system	TEXT	Product Size System	System in which the size is specified. Recommended for apparel items. For example, "US", "UK", "DE".	products
product_suggested_price	NUMERIC	Product Suggested Price	Latest suggested price for the product.	reports
product_suggested_price_currency_code	TEXT	Product Suggested Price Currency Code	Currency code of latest suggested price for the product. Product Suggested Price should be requested for the field to be available.	reports
product_thumbnail_link	IMAGE_URL	Product Thumbnail Link	Link to the processed image of the product, hosted on the Google infrastructure.	reports
product_title	TEXT	Product Title	Title of the item.	reports
product_type_l1	TEXT	Product Type Level 1	Product type (1st level) in merchant's own product taxonomy.	reports
product_type_l2	TEXT	Product Type Level 2	Product type (2nd level) in merchant's own product taxonomy.	reports
product_type_l3	TEXT	Product Type Level 3	Product type (3rd level) in merchant's own product taxonomy.	reports
product_type_l4	TEXT	Product Type Level 4	Product type (4th level) in merchant's own product taxonomy.	reports
product_type_l5	TEXT	Product Type Level 5	Product type (5th level) in merchant's own product taxonomy.	reports
product_virtual_model_link	TEXT	Product Virtual Model Link	URL of the 3D image of the item.	products
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024|20