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("TOY STORE", "This Month", "IPHONE13", "US")=GORILLA_OOSRATE("TOY STORE", "Last 30 days", A1:A1320)=GORILLA_OOSRATE("TOY STORE", "CUSTOM", A1:A1032, "UK", "2022-04-02", "2022-06-30")Syntax Description
Description:
Show the number of days out of stock for a list of products during a period.
Syntax:
GORILLA_OOSRATE(Seller ID, period, sku, [marketplace], [start_date], [end_date])
Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account .
SKU – 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
Predefined period to get stock data or use custom to specify a start and end date.
MARKETPLACE – 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.
start_date – OPTIONAL
Starting date for the returning range when the period is “custom”.
end_date – OPTIONAL
Ending date for the returning range when the period is “custom”.
GORILLA_OOS Attributes:
Period attributes:
Today | This month | Last 3 Months |
Yesterday | This quarter | Last 12 Months |
Same day last week | This year | Last 7 Days Week Ago |
Same day last month | This Year-to-Last-Month | Last 7 Days Year Ago |
Same day last year | Last Week | Last 30 Days Month Ago |
Last 7 Days | Last Month | Last 30 Days Year Ago |
Last 14 Days | Last Quarter | Last Week Year Ago |
Last 30 Days | Last Year | Last Month Year Ago |
Last 90 Days | Last 60 Days | YYYY-MM (change format to text) |
This week | YYYY | YYYYQ1… YYYYQ4 |
Custom |
Marketplace attributes:
All | DE | PL | SG |
US | FR | TR | IN |
CA | ES | SA | EG |
MX | IT | AE | EU (only for specific functions) |
BR | NL | JP | EURO (only for specific functions) |
UK | SE | AU |
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("TOY STORE", "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("TOY STORE", "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.
Results for GORILLA_OOSRATE()