1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_RANKHIST() – Get historical BSR for products

GORILLA_RANKHIST() – Get historical BSR for products

GORILLA_RANKHIST( ) Function

Description:

Get the daily historical BSR (Best Seller Rank) over any time period for a single or range of sku’s. Only works for single marketplaces at a time. Not “ALL”.

Syntax:
GORILLA_RANKHIST(period, sku, [marketplace], [queryType], [start_date]. [end_date])

period
Predefined periods and any custom date frames to get the rank history. See full list of predefined periods below. 

sku
SKU or ASIN of the product. Can be a range like A2:A100 or an array of strings like {“SKU12345″,”ASIN12345”} or a string like “A734-FBE4-MDUS”.

marketplace
OPTIONAL – Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

queryType
OPTIONAL – What to retrieve (defaults to “top”):

  • top = Top Level category;
  • all = All categories (only 1 SKU/ASIN allowed);
  • child = Child category.

 returnStyle
OPTIONAL – Return style (defaults to “rank”):

  • rank = Rank Only;
  • r_cat = Rank + Category (accepts array input);
  • r_full= Rank + Category Path (accepts array input).

Matrix array inputs like A1:E10 is only accepted for when “rank” is used. Cannot use arrays for r_cat and r_full. 

 Examples:
Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_RANKHIST(“last 30 days”, A2:A100)
Bulk returns the BSR over the preset “last 30 days” for all SKU’s from A2 to A100. No marketplace is specified so the default marketplace for your account is returned.

=GORILLA_RANKHIST(“custom”, A2:A5, “US”, “top”, “2018-06-01”, “2018-06-30”)
Bulk returns BSR from June 1 to June 30 for each SKU from A2 to A5. Also returns the top level category the SKU is located in. USA marketplace is requested. 

=GORILLA_RANKHIST(“this month”, “B00YD545CC”, “JP”, “child”)
Returns the rankings for each day this month for the sku. Requesting Japan marketplace ranking and category will show the top level category as well as the deepest child category.

GORILLA_RANKHIST Attributes
queryType Attributes:

  • all – products are listed under multiple categories. Lists them all.
  • top – the top level category you are used to seeing as a seller
  • child – the lowest level category of the product 

returnStyle Attributes:

  • r_cat – shows rank number and top level category
  • rank – rank number only
  • r_full – shows the rank and category path 

period Attributes:

  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This week
  • This month
  • This quarter
  • This year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last Year
  • Last 60 Days
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago
Was this article helpful to you? Yes No

How can we help?