Google Sheets Functions

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

GORILLA_RANKHIST() – Get historical BSR for products

Sample Usage

=GORILLA_RANKHIST("last 30 days", A2:A100)
=GORILLA_RANKHIST("custom", A2:A5, "US", "top", "2021-06-01", "2021-06-30")
=GORILLA_RANKHIST("this month", "B00YD545CC", "JP", "child")

Syntax Description

show bsr category

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])

for Gorilla Agency, the syntax is

GORILLA_RANKHIST(sellerID, period, sku, [marketplace], [queryType], [start_date], [end_date])

period – REQUIRED

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

  • 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
  • YYYY
  • 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
  • YYYY-MM (change format to text)
  • YYYYQ1… YYYYQ4

    sku – REQUIRED

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.

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.

rankhist

=GORILLA_RANKHIST("2021Q1", "US", "B00YD545CC", "All")
=GORILLA_RANKHIST("2021-05", "US", "B00YD545CC", "All")

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

To get monthly data, use the format YYYY-MM as the preset period.

For Gorilla Agency, the formulas will start with the seller ID:

=GORILLA_RANKHIST("SELLER ID", "last 30 days", A2:A100)
=GORILLA_RANKHIST("SELLER ID", "custom", A2:A5, "US", "top", "2021-06-01", "2021-06-30")
=GORILLA_RANKHIST("SELLER ID", "this month", "B00YD545CC", "JP", "child")
=GORILLA_RANKHIST("SELLER37432", "2021Q1", "US", "B00YD545CC", "All")
=GORILLA_RANKHIST("SELLER37432", "2021-05", "US", "B00YD545CC", "All")

How can we help?