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.