Google Sheets Functions

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

GORILLA_RANKING() – Get BSR for products

Sample Usage

🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for 
quicker results and to prevent Google from blocking your account for 
24 hrs due to overloading their resources. 
=GORILLA_RANKING("B00YD545CC", "US", "top", "r_cat")
=GORILLA_RANKING("A2:A10", , "top", "rank")

Syntax Description

gorilla ranking 2 Gorilla ROI

Description:

Get Best Sellers Rank (BSR) for the broadest top level category or deepest child category. Only works for single marketplaces at a time. Not “ALL”.

Syntax

GORILLA_RANKING(sku, [marketplace], [queryType], [returnStyle])

for Gorilla Agency, the syntax is

Gorilla_RANKING(sellerID, sku, [marketplace], [queryType], [returnStyle])

SKU

SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

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.

GORILLA_RANKING Attributes

queryType Attributes:

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

returnStyle Attribute:

rank – rank number onlyr_cat – shows rank number and top level category
r_full – shows the rank and category path 

Examples:

🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for 
quicker results and to prevent Google from blocking your account for 
24 hrs due to overloading their resources. 
=GORILLA_RANKING(“B00YD545CC”, "US", "top", "r_cat")

Returns BSR of the top category as well as the category name for unit B00YD545CC for the US marketplace.

=GORILLA_RANKING("A2:A10", , "top", "rank")

Supports array inputs. Bulk return an array of values by assigning the range of the SKU or ASIN. In this example the SKU or ASIN is listed in A2:A10 and returns all values at once. Default marketplace is used as it is not set.

gorilla ranking

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

=GORILLA_RANKING("SELLER ID", "B00YD545CC", "US", "top", "r_cat")
=GORILLA_RANKING("SELLER ID", "A2:A10", , "top", "r_full")

How can we help?