Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. GORILLA_SALESCOUNTHIST() – Gets the historical number of orders sold between any period

GORILLA_SALESCOUNTHIST() – Gets the historical number of orders sold between any period

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_SALESCOUNTHIST("TOY STORE")
=GORILLA_SALESCOUNTHIST("TOY STORE", "B00YD545CC")
=GORILLA_SALESCOUNTHIST("TOY STORE", A1:A20)
=GORILLA_SALESCOUNTHIST("TOY STORE", A1:A10, "US", "ALL", "EXCLUDE", 60)
=GORILLA_SALESCOUNTHIST("TOY STORE", A1:A10, "US", "ALL", "EXCLUDE", 60, , ,"YES")
=GORILLA_SALESCOUNTHIST("TOY STORE", A1:A10, "DE", "CANCELED", "EXCLUDE", , "2022-01-01", "2022-03-15")

Syntax Description

SALESCOUNTHIST 1 Gorilla ROI

Description:

Gets the historical number of orders sold between any period.

Syntax:

GORILLA_SALESCOUNTHIST(Seller ID, [sku], [marketplace], [status], [mcf], [days], [start_date], [end_date], [transpose])

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

sku – OPTIONAL
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…

marketplace – OPTIONAL
Marketplace country filter. Country codes are US, CA, MX, BR, BE, UK, DE, ES, IT, FR, NL, PL, TR, IN, SE, AE, AU, SG, JP, EG, SA. Use ‘ALL’ to combine values from a single account, ‘EU’ for all Europe markets EXCEPT UK, ‘EURO’ to combine countries using EURO currency. Amazon Marketplace ID like ‘ATVPDKIKX0DER’ can be used too.

status – OPTIONAL
Order Status. Valid values are:

  • AllButCanceled(default)
  • All
  • PendingAvailability (JP only)
  • Pending
  • Unshipped
  • PartiallyShipped
  • Shipped
  • InvoiceUnconfirmed
  • Canceled
  • Unfulfillable

mcf – OPTIONAL
MCF Orders processing. Valid values are:

  • Exclude (default option – if not specified)
  • Include
  • Only (only displays data for MCF orders. Does not show data for FBA.)

days – OPTIONAL
Number of days to return from current date, defaults to 30 if ommited.

start_date – OPTIONAL
Starting date to get sales from (ignored if days is specified).

end_date – OPTIONAL
Ending date to get sales from (ignored if days is specified).

transpose – OPTIONAL
If ‘no’, show SKUs as column headers, if empty or ‘yes’ return dates as headers.

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_SALESCOUNTHIST("TOY STORE")

When no attributes are entered into the formula, it will create a table of the daily units ordered over the last 30 days of the entire account.

=GORILLA_SALESCOUNTHIST("TOY STORE", "B00YD545CC")

Pulls in the daily units ordered over the last 30 days of ASIN B00YD545CC into a table.

=GORILLA_SALESCOUNTHIST("TOY STORE", A1:A20)

Pulls in the daily units ordered over the last 30 days for the SKUs or ASINs listed in cell A1 to A20.

=GORILLA_SALESCOUNTHIST("TOY STORE", A1:A10, "US", "ALL", "EXCLUDE", 60)

Returns a table of daily historical number of units ordered for all SKUs in cell A1 to A10, in the US marketplace only, the order status includes all, excludes MCF (Merchant Fulfilled) sales for the last 60 days.

=GORILLA_SALESCOUNTHIST("TOY STORE", A1:A10, "US", "ALL", "EXCLUDE", 60, , ,"YES")

This returns the same table as above, but is transposed where the SKU is displayed vertically.

=GORILLA_SALESCOUNTHIST("TOY STORE", A1:A10, "DE", "Canceled", "EXCLUDE", , "2022-01-01", "2022-03-15")

Returns a table of daily historical number of units ordered for all SKUs in cell A1 to A10, in the German marketplace only, the order status is canceled, excludes MCF (Merchant Fulfilled) sales, between the two dates in the formula. The “days” field is blank so that the start and end date will activate. If days value is entered, then the start and end date won’t work.

How can we help?