Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. GORILLA_SALESCOUNTHIST() – Get historical daily number of sales

GORILLA_SALESCOUNTHIST() – Get historical daily number of sales

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 Gorilla ROI

Description:

The fastest way to get a daily count of historical sales between any two dates.

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. Select or enter a range of values.

marketplace – OPTIONAL
Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc.

status – OPTIONAL
Order Status. Valid values are:

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

mcf – OPTIONAL
Whether to display, include or exclude MCF orders.

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

days – OPTIONAL
By default, the last 30 days is pulled. Enter the number of days to display in the results.

start_date – OPTIONAL
Only works if “days” is left blank. Starting date to get sales between any two periods. Date format should be in YYYY-MM-DD.

end_date – OPTIONAL
Only works if “days” is left blank. End date to get sales between any two periods. Date format should be in YYYY-MM-DD.

transpose – OPTIONAL
Default is set to “YES”. It will display the SKUs on the left side and the dates horizontally.
“NO” will display the SKUs in a horizontal row at the time. Dates vertically down.

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 sold over the last 30 days of the entire account.

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

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

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

Pulls in the daily units sold 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 sales 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 sales 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?