Google Sheets Functions

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

GORILLA_RANKING() – Get BSR for products

GORILLA_RANKING( ) Function

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

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.

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_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.

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

GORILLA_RANKING Attributes
queryType Attributes:

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?