Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_SALESTOTAL() – Get total sales dollar amount between any time period

GORILLA_SALESTOTAL() – Get total sales dollar amount between any time 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_SALESTOTAL("Custom", "US", "B00YD545CC", "EXCLUDE", "Shipped", "NO", "2021-01-01", "2021-01-21")
=GORILLA_SALESTOTAL("This Week","ALL",A2:A10),"ALL")
=GORILLA_SALESTOTAL("This Month", "ALL", "IPHN3724", "Canceled")
=GORILLA_SALESTOTAL("Same Day Last Month", "ALL", "IPHN3724", "pending")
=GORILLA_SALESTOTAL("This Year")

Syntax Description

gorilla salestotal Gorilla ROI

Description:

Get total sales dollar amount for any product for any specified time period. Only the period attribute is required. Other attributes are optional.

Syntax:

GORILLA_SALESTOTAL(period, [marketplace], [sku], [status], [mcf], [start_date], [end_date])

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

Gorilla_SALESTOTAL(sellerID, period, [marketplace], [sku], [status], [mcf], [start_date], [end_date])

period

Predefined period to get sales. See full list of predefined periods below.

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 below.

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.)

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.

GORILLA_SALESTOTAL Attributes

Period Attributes:

TodayThis monthLast 3 Months
YesterdayThis quarterLast 12 Months
Same day last weekThis yearLast 7 Days Week Ago
Same day last monthThis Year-to-Last-MonthLast 7 Days Year Ago
Same day last yearLast WeekLast 30 Days Month Ago
Last 7 DaysLast MonthLast 30 Days Year Ago
Last 14 DaysLast QuarterLast Week Year Ago
Last 30 DaysLast YearLast Month Year Ago
Last 90 DaysLast 60 DaysYYYY-MM (change format to text)
 This weekYYYY YYYYQ1… YYYYQ4
Custom

Status Attribute:

AllPendingAvailability (JP marketplace only)
PendingUnshipped
PartiallyShippedShipped
InvoiceUnconfirmedCanceled
Unfulfillable 

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_SALESTOTAL("Custom", "US", "B00YD545CC", "Exclude", "Shipped", "2018-01-01", "2018-01-21")

Returns total dollar in sales for unit B00YD545CC that has been shipped in the US marketplace between Jan 1, 2018 and Jan 21, 2018. Excludes MCF orders from the data.

=GORILLA_SALESTOTAL("This Week","ALL",A2:A10),"ALL")

Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKU or ASIN. In this example the SKU or ASIN is listed in A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.

=GORILLA_SALESTOTAL("This Month", "ALL", "IPHN3724", "Canceled")

Gets the total dollar amount for SKU IPHN3724 from all marketplaces that were canceled this month.

=GORILLA_SALESTOTAL("Same Day Last Month", "ALL", "IPHN3724", "pending")

Gets the total dollar in sales for SKU IPHN3724 from all marketplaces that are sold and pending.

=GORILLA_SALESTOTAL("This Year")

Gets the total dollar in sales for all products, across all marketplaces, so far year to date.

sales total
=GORILLA_SALESTOTAL("2019Q1", "US", "B00YD545CC", "All")
=GORILLA_SALESTOTAL("2019-05", "US", "B00YD545CC", "All")

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

To get monthly data, use the format YYYY-MM as the preset period.

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

=GORILLA_SALESTOTAL("SELLER ID", "Custom", "US", "B00YD545CC", "Shipped", "Exclude", "2018-01-01", "2018-01-21")
=GORILLA_SALESTOTAL("SELLER ID", "This Week","ALL",A2:A10,"ALL")
=GORILLA_SALESTOTAL("SELLER ID", "This Month", "ALL", "IPHN3724", "Canceled")
=GORILLA_SALESTOTAL("SELLER ID", "Same Day Last Month", "ALL", "IPHN3724", "ALL")
=GORILLA_SALESTOTAL("SELLER ID", "This Year")
=GORILLA_SALESTOTAL("SELLER37432", "2019Q1", "US", "B00YD545CC", "All")
=GORILLA_SALESTOTAL("SELLER37432", "2019-05", "US", "B00YD545CC", "All")

How can we help?