Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. 1.Seller Central Data/Fun...
  8. /
  9. GORILLA_SALESTOTALHIST() ...

GORILLA_SALESTOTALHIST() – Get local currency amount of sales history for a given 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_SALESTOTALHIST("TOY STORE")
=GORILLA_SALESTOTALHIST("TOY STORE", "B00YD545CC")
=GORILLA_SALESTOTALHIST("TOY STORE", A1:A20)
=GORILLA_SALESTOTALHIST("TOY STORE", A1:A10, "US", "ALL", "EXCLUDE", 60)
=GORILLA_SALESTOTALHIST("TOY STORE", A1:A10, "US", "ALL", "EXCLUDE", 60, , ,"Yes")
=GORILLA_SALESTOTALHIST("TOY STORE", A1:A10, "DE", "Canceled", "EXCLUDE", , "2020-01-01", "2020-03-12")

Syntax Description

SALESTOTALHIST 1 Gorilla ROI

Description:

Get local currency amount of sales history for a given period

GORILLA_SALESTOTALHIST(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. Can be a range of values. Valid values are:

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

mcf – OPTIONAL
MCF Orders processing. Valid values are

  • Exclude (default option is 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_SALESTOTALHIST("TOY STORE")

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

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

=GORILLA_SALESTOTALHIST("TOY STORE", 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("TOY STORE", 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("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_SALESTOTALHIST("TOY STORE", 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.

GET YOUR SPREADSHEETS

Enter your email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.