Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. 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", "2018-06-01", "2018-06-30")
=GORILLA_RANKHIST("this month", "B00YD545CC", "JP", "child")

Syntax 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”.

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

Gorilla Agency, the syntax is

GORILLA_RANKHIST(sellerID, 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.

rankhist

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", "2018-06-01", "2018-06-30")
=GORILLA_RANKHIST("SELLER ID", "this month", "B00YD545CC", "JP", "child")

GORILLA_RANKHIST Attributes
queryType Attributes:

GORILLA_RANKHIST Attributes
Period Attribute:

Today This month Last 12 Months
Yesterday This quarter Last 7 Days Week Ago
Same day last week This year Last 7 Days Year Ago
Same day last month This Year-to-Last-Month Last 30 Days Month Ago
Same day last year Last Week Last 30 Days Year Ago
Last 7 Days Last Month Last Week Year Ago
Last 14 Days Last Quarter Last Month Year Ago
Last 30 Days Last Year YYYY-MM (change format to text)
This week Last 60 Days YYYYQ1… YYYYQ4

queryType Attribute:

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

returnStyle Attribute:

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

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?