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.

Attributes

• brand (type: String.t, default: nil) - Brand of the product cluster.
• brandInventoryStatus (type: String.t, default: nil) - 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.
• categoryL1 (type: String.t, default: nil) - Product category (1st level) of the product cluster, represented in Google's product taxonomy.
• categoryL2 (type: String.t, default: nil) - Product category (2nd level) of the product cluster, represented in Google's product taxonomy.
• categoryL3 (type: String.t, default: nil) - Product category (3rd level) of the product cluster, represented in Google's product taxonomy.
• categoryL4 (type: String.t, default: nil) - Product category (4th level) of the product cluster, represented in Google's product taxonomy.
• categoryL5 (type: String.t, default: nil) - Product category (5th level) of the product cluster, represented in Google's product taxonomy.
• inventoryStatus (type: String.t, default: nil) - 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.
• previousRank (type: String.t, default: nil) - Popularity rank in the previous week or month.
• previousRelativeDemand (type: String.t, default: nil) - 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.
• rank (type: String.t, default: nil) - Popularity of the product cluster on Ads and organic surfaces, in the selected category and country, based on the estimated number of units sold.
• relativeDemand (type: String.t, default: nil) - Estimated demand in relation to the product cluster with the highest popularity rank in the same category and country.
• relativeDemandChange (type: String.t, default: nil) - Change in the estimated demand. Whether it rose, sank or remained flat.
• reportCategoryId (type: String.t, default: nil) - 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.
• reportCountryCode (type: String.t, default: nil) - 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.
• reportDate (type: GoogleApi.MerchantAPI.Reports_v1beta.Model.Date.t, default: nil) - 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.
• reportGranularity (type: String.t, default: nil) - 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.
• title (type: String.t, default: nil) - Title of the product cluster.
• variantGtins (type: list(String.t), default: nil) - GTINs of example variants of the product cluster.