Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_OOSRATE() – Show Out Of Stock days as a percentage

GORILLA_OOSRATE() – Show Out Of Stock days as a percentage

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_OOSRATE("This Month", "IPHONE13", "US")
=GORILLA_OOSRATE("Last 30 days", A1:A1320)
=GORILLA_OOSRATE("CUSTOM", A1:A1032, "UK", "2022-04-02", "2022-06-30")

Syntax Description

gorilla oosrate function Gorilla ROI

Description:

Show the number of days out of stock for a list of products during a period.

Syntax:

GORILLA_OOSRATE(period, sku, [marketplace], [start_date], [end_date])

for Gorilla Agency, the syntax is

=GORILLA_OOSRATE("TOYS USA", "This Month", "IPHONE13", "US")
=GORILLA_OOSRATE("KITCHEN DE", "Last 30 days", A1:A1320)
=GORILLA_OOSRATE("SELLERID", "CUSTOM", A1:A1032, "UK", "2022-04-02", "2022-06-30")

SKU – REQUIRED
REQUIRED – SKU or ASIN to filter the results. Can be a range of values like A1:A100 where A1 to A100 consists of values like SKU111, SKU222, SKU333 or ASIN123.

PERIOD – REQUIRED
REQUIRED – Predefined period to get stock data or use custom to specify a start and end date.

MARKETPLACE – OPTIONAL
OPTIONAL – Marketplace country filter. Country codes are US, CA, MX, BR, UK, DE, ES, IT, FR, NL, PL, TR, IN, SE, AE, AU, SG, JP, EG, SA. Use DEFAULT for seller default. Amazon Marketplace ID like ATVPDKIKX0DER can be used too.

start_date – OPTIONAL
OPTIONAL – Starting date for the returning range when the period is “custom”.

end_date – OPTIONAL
OPTIONAL – Ending date for the returning range when the period is “custom”.

GORILLA_OOS Attributes:

Period attributes:

TodayThis monthLast 3 Months
YesterdayThis quarterLast 12 Months
Same day last weekThis yearLast 7 Days Week Ago
Same day last monthThis Year-to-Last-MonthLast 7 Days Year Ago
Same day last yearLast WeekLast 30 Days Month Ago
Last 7 DaysLast MonthLast 30 Days Year Ago
Last 14 DaysLast QuarterLast Week Year Ago
Last 30 DaysLast YearLast Month Year Ago
Last 90 DaysLast 60 DaysYYYY-MM (change format to text)
 This weekYYYY YYYYQ1… YYYYQ4
Custom

Marketplace attributes:

AllDEPLSG
USFRTRIN
CAESSAEG
MXITAEEU (only for specific functions)
BRNLJPEURO (only for specific functions)
UKSEAU

start_date & end_date attributes:

Enter full date period in USA date format YYYY-MM-DD such as 2022-12-23

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_OOSRATE("This Month", "IPHONE13", "US")

This formula will display the number of days out of stock for this month for the US market and product SKU IPHONE13.

=GORILLA_OOSRATE("Last 3 months", A1:A1320)

Displays the number of days out of stock during the last 3 months for all the per SKU listed from A1:A1320.

This is the output for a formula as shown below.

OOSRATE formula results Gorilla ROI
Results for GORILLA_OOSRATE()

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

=GORILLA_OOSRATE("TOYS USA", "This Month", "IPHONE13", "US")
=GORILLA_OOSRATE("KITCHEN DE", "Last 30 days", A1:A1320)
=GORILLA_OOSRATE("SELLERID", "CUSTOM", A1:A1032, "UK", "2022-04-02", "2022-06-30")

How can we help?