Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_SALESCOUNT() – Get total number of sales between any time period

GORILLA_SALESCOUNT() – Get total number of sales 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_SALESCOUNT("Custom", "US", "B00YD545CC", "Shipped", "NO", "2021-01-01", "2021-01-21")
=GORILLA_SALESCOUNT("This Week","ALL",A2:A10,"ALL")
=GORILLA_SALESCOUNT("This Month", "ALL", "IPHN3724", "Canceled")
=GORILLA_SALESCOUNT("Same Day Last Month", "ALL", "IPHN3724", "ALL")
=GORILLA_SALESCOUNT("This Year")

Syntax Description:get sales count between any periodDescription:

Gets total number of sales for a product between any time period. Only period is required. Other attributes are optional.

Syntax:

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

for Gorilla Agency, the syntax is

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

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

Gets total number of units sold for B00YD545CC that has been shipped in the US marketplace between Jan 1, 2018 and Jan 21, 2018. Excludes MCF orders.

=GORILLA_SALESCOUNT("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_SALESCOUNT("This Month", "ALL", "IPHN3724", "Canceled")

Gets the total number of units for SKU IPHN3724 from all marketplaces that were canceled this month.

=GORILLA_SALESCOUNT("Same Day Last Month", "ALL", "IPHN3724", "ALL")

Gets the total number of units for SKU IPHN3724 from all marketplaces that are sold and pending.

=GORILLA_SALESCOUNT("This Year")

Gets the total number of units sold for all products, account across all marketplaces.

=GORILLA_SALESCOUNT("2022Q1", "US", "B00YD545CC", "All")
=GORILLA_SALESCOUNT("2022-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.

sales count

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

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

How can we help?