Google Merchant Center Connector Reference
The Google Merchant Center connector exposes 150 fields (33 metrics, 117 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available actions
Insert Product Add a product to an API data source of the connected Merchant Center account. If the data source already has an entry with the same product_id, content_language and feed_label, the new entry replaces it. data_source is the data_source_id or data_source_name of an API data source (Data Sources table, or create one with create_data_source). In a primary data source, give the attributes that Google needs to show the product, for example title, link, image_link, price, currency and availability. Merchant Center shows the change after a few minutes. Remove the product with delete_product.
Add a product to an API data source of the connected Merchant Center account. If the data source already has an entry with the same product_id, content_language and feed_label, the new entry replaces it. data_source is the data_source_id or data_source_name of an API data source (Data Sources table, or create one with create_data_source). In a primary data source, give the attributes that Google needs to show the product, for example title, link, image_link, price, currency and availability. Merchant Center shows the change after a few minutes. Remove the product with delete_product.
Update Product Change the given attributes of a product in an API data source of the connected Merchant Center account. Attributes that are not given keep their values. product_id, content_language and feed_label come from the product_id, product_content_language and product_feed_label fields. data_source is the data_source_id or data_source_name of an API data source: the product's primary data source (product_data_source) if its input is API, otherwise a supplemental API data source that is linked to that primary data source (create one with create_data_source and link_to_primary_data_source). Values of a supplemental data source that comes before the feed in the feed's default rule (as create_data_source links it) override the feed values until delete_product removes them from the supplemental data source. clear_attributes deletes attributes from the product in data_source: in a supplemental data source the product then shows the feed value again. pause ADS or ALL pauses the product, NONE ends the pause. Merchant Center shows the change after a few minutes.
Change the given attributes of a product in an API data source of the connected Merchant Center account. Attributes that are not given keep their values. product_id, content_language and feed_label come from the product_id, product_content_language and product_feed_label fields. data_source is the data_source_id or data_source_name of an API data source: the product's primary data source (product_data_source) if its input is API, otherwise a supplemental API data source that is linked to that primary data source (create one with create_data_source and link_to_primary_data_source). Values of a supplemental data source that comes before the feed in the feed's default rule (as create_data_source links it) override the feed values until delete_product removes them from the supplemental data source. clear_attributes deletes attributes from the product in data_source: in a supplemental data source the product then shows the feed value again. pause ADS or ALL pauses the product, NONE ends the pause. Merchant Center shows the change after a few minutes.
Delete Product Delete a product from an API data source of the connected Merchant Center account. From a primary data source this removes the whole product, including its supplemental values: only insert_product with all attributes adds it again. From a supplemental data source this removes only the values of that data source, and the product keeps its primary values. data_source is the data_source_id or data_source_name of the API data source.
Delete a product from an API data source of the connected Merchant Center account. From a primary data source this removes the whole product, including its supplemental values: only insert_product with all attributes adds it again. From a supplemental data source this removes only the values of that data source, and the product keeps its primary values. data_source is the data_source_id or data_source_name of the API data source.
Create Data Source Create an API product data source in the connected Merchant Center account. A primary data source holds products that insert_product adds. A supplemental data source holds values that update_product writes for products from a file feed, an app or the Merchant Center UI. Merchant Center applies them only to products of the primary data sources that the supplemental data source is linked to. link_to_primary_data_source (data_source_id or data_source_name) puts the new supplemental data source first in the default rule of that primary data source, so its values override the feed, and keeps the sources the rule already uses. The user removes the link in Merchant Center (the Attribute rules of the primary data source). Give content_language and feed_label together to accept only products with them, or leave both out to accept every product. countries is for a primary data source only. Each call creates a new data source: list the existing ones in the Data Sources table first.
Create an API product data source in the connected Merchant Center account. A primary data source holds products that insert_product adds. A supplemental data source holds values that update_product writes for products from a file feed, an app or the Merchant Center UI. Merchant Center applies them only to products of the primary data sources that the supplemental data source is linked to. link_to_primary_data_source (data_source_id or data_source_name) puts the new supplemental data source first in the default rule of that primary data source, so its values override the feed, and keeps the sources the rule already uses. The user removes the link in Merchant Center (the Attribute rules of the primary data source). Give content_language and feed_label together to accept only products with them, or leave both out to accept every product. countries is for a primary data source only. Each call creates a new data source: list the existing ones in the Data Sources table first.
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 Data Sources fields
The Data Sources report of the Google Merchant Center connector includes 9 fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_source_content_language | TEXT | Data Source Content Language | The language of the products that the data source accepts. Empty when it accepts every language. | dataSources |
| data_source_countries | TEXT | Data Source Countries | The target countries of a primary product data source. | dataSources |
| data_source_display_name | TEXT | Data Source Display Name | The data source name shown in Merchant Center. | dataSources |
| data_source_feed_label | TEXT | Data Source Feed Label | The feed label of the products that the data source accepts. Empty when it accepts every feed label. | dataSources |
| data_source_id | TEXT | Data Source ID | The ID of the data source. | dataSources |
| data_source_input | TEXT | Data Source Input | How the data source gets its data: API, FILE, UI or AUTOFEED. Write actions change products only in API data sources. | dataSources |
| data_source_linked_primary_sources | TEXT | Data Source Linked Primary Sources | The primary data sources that a supplemental data source is linked to. Its values change only the products of these data sources. | dataSources |
| data_source_name | TEXT | Data Source Name | The resource name of the data source, as in product_data_source. Format: accounts/{account}/dataSources/{data_source_id}. | dataSources |
| data_source_type | TEXT | Data Source Type | The data source type, for example primaryProductDataSource or supplementalProductDataSource. | dataSources |
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 | 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 | 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 | 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 |
