Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. 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()
=GORILLA_SALESCOUNTHIST("B00YD545CC")
=GORILLA_SALESCOUNTHIST(A1:A20)
=GORILLA_SALESCOUNTHIST(A1:A10, "US", "ALL", "EXCLUDE", 60)
=GORILLA_SALESCOUNTHIST(A1:A10, "US", "ALL", "EXCLUDE", 60, , ,"YES")
=GORILLA_SALESCOUNTHIST(A1:A10, "DE", "CANCELED", "EXCLUDE", , "2020-01-01", "2020-03-12")

Syntax Description

gorilla salescount 1 Gorilla ROI

Description:

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

Syntax:

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

for Gorilla AGENCY, the syntax is

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

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. or Amazon Marketplace ID like ATVPDKIKX0DER.

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 is 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()

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

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

=GORILLA_SALESCOUNTHIST(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(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(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(A1:A10, "DE", "Canceled", "EXCLUDE", , "2020-01-01", "2020-03-12")

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.

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

=GORILLA_SALESCOUNTHIST("SELLER37432")
=GORILLA_SALESCOUNTHIST("SELLER37432", "B00YD545CC")
=GORILLA_SALESCOUNTHIST("SELLER37432", A1:A20)
=GORILLA_SALESCOUNTHIST("SELLER37432", A1:A10, "US", "ALL", "EXCLUDE", 60)
=GORILLA_SALESCOUNTHIST("SELLER37432", A1:A10, "US", "ALL", "EXCLUDE", 60, , ,"YES")
=GORILLA_SALESCOUNTHIST("SELLER37432", A1:A10, "DE", "Canceled", "EXCLUDE", , "2020-01-01", "2020-03-12")

How can we help?