Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_SALESTOTALHIST() – Get daily historical sales figures

GORILLA_SALESTOTALHIST() – Get daily historical sales figures

Sample Usage

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

Syntax Description

sales total history

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

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

for Gorilla AGENCY, the syntax is

GORILLA_SALESTOTALHIST(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.

sku

OPTIONAL – Any Seller SKU/ASIN to limit results. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

status

OPTIONAL – Order Status. Valid values are:

  • AllButCanceled (default)
  • AllPendingAvailability (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 – Starting date to get sales from when period is custom. 

end_date

OPTIONAL – Ending date to get sales from when period is custom.  

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

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

=GORILLA_SALESTOTALHIST("B00YD545CC")

Pulls in the daily sales figures over the last 30 days of ASIN B00YD545CC into a table. 

=GORILLA_SALESTOTALHIST(A1:A20)

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

=GORILLA_SALESTOTALHIST(A1:A10, “US”, “ALL”, “EXCLUDE”, 60)

Returns a table of daily historical sales figures 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_SALESTOTALHIST(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_SALESTOTALHIST(“SELLER37432”)
=GORILLA_SALESTOTALHIST(“SELLER37432”, “B00YD545CC”)
=GORILLA_SALESTOTALHIST(“SELLER37432”, A1:A20)
=GORILLA_SALESTOTALHIST(“SELLER37432”, A1:A10, “US”, “ALL”, “EXCLUDE”, 60)
=GORILLA_SALESTOTALHIST(“SELLER37432”, A1:A10, “DE”, “Canceled”, “EXCLUDE”, , “2020-01-01”, “2020-03-12”)

GORILLA_SALESTOTALHIST Attributes

Status Attributes:

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

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?