BestSellersBrandView

BestSellersBrandView

Fields available for query in best_sellers_brand_view table.

Best sellers report with top brands.

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.
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.
brand	string Name of the brand.
rank	int64 Popularity of the brand 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 brand with the highest popularity rank in the same category and country.
previous_relative_demand	RelativeDemandEnum Estimated demand in relation to the brand 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.