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

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

Syntax Description

GORILLA_SALESCOUNTHIST() - Get historical daily number of sales 1

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

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

for Gorilla AGENCY, the syntax is

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

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. 

Examples:

Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google 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, "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, "DE", "Canceled", "EXCLUDE", , "2020-01-01", "2020-03-12")

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?