BestSellersProductClusterView

BestSellersProductClusterView

Fields available for query in best_sellers_product_cluster_view table.

Best sellers report with top product clusters. A product cluster is a grouping for different offers and variants that represent the same product, for example, Google Pixel 7.

Values are only set for fields requested explicitly in the request's search query.

Fields
report_date	Date Report date. The value of this field can only be one of the following: The first day of the week (Monday) for weekly reports, The first day of the month for monthly reports. Required in the SELECT clause. If a WHERE condition on report_date is not specified in the query, the latest available weekly or monthly report is returned.
variant_gtins[]	string GTINs of example variants of the product cluster.
report_granularity	ReportGranularityEnum Granularity of the report. The ranking can be done over a week or a month timeframe. Required in the SELECT clause. Condition on report_granularity is required in the WHERE clause.
report_country_code	string Country where the ranking is calculated. Represented in the ISO 3166 format. Required in the SELECT clause. Condition on report_country_code is required in the WHERE clause.
report_category_id	int64 Google product category ID to calculate the ranking for, represented in Google's product taxonomy . Required in the SELECT clause. If a WHERE condition on report_category_id is not specified in the query, rankings for all top-level categories are returned.
title	string Title of the product cluster.
brand	string Brand of the product cluster.
category_l1	string Product category (1st level) of the product cluster, represented in Google's product taxonomy .
category_l2	string Product category (2nd level) of the product cluster, represented in Google's product taxonomy .
category_l3	string Product category (3rd level) of the product cluster, represented in Google's product taxonomy .
category_l4	string Product category (4th level) of the product cluster, represented in Google's product taxonomy .
category_l5	string Product category (5th level) of the product cluster, represented in Google's product taxonomy .
inventory_status	InventoryStatus Whether the product cluster is IN_STOCK in your product data source in at least one of the countries, OUT_OF_STOCK in your product data source in all countries, or NOT_IN_INVENTORY at all. The field doesn't take the Best sellers report country filter into account.
brand_inventory_status	InventoryStatus Whether there is at least one product of the brand currently IN_STOCK in your product data source in at least one of the countries, all products are OUT_OF_STOCK in your product data source in all countries, or NOT_IN_INVENTORY . The field doesn't take the Best sellers report country filter into account.
rank	int64 Popularity of the product cluster on Ads and organic surfaces, in the selected category and country, based on the estimated number of units sold.
previous_rank	int64 Popularity rank in the previous week or month.
relative_demand	RelativeDemandEnum Estimated demand in relation to the product cluster with the highest popularity rank in the same category and country.
previous_relative_demand	RelativeDemandEnum Estimated demand in relation to the product cluster with the highest popularity rank in the same category and country in the previous week or month.
relative_demand_change	RelativeDemandChangeTypeEnum Change in the estimated demand. Whether it rose, sank or remained flat.