Google Sheets Functions

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

GORILLA_GROSSPROFIT() – Get gross profit of unit solds for any set of periods

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_GROSSPROFIT("TOY STORE", "2023")
=GORILLA_GROSSPROFIT("TOY STORE", "2023", , ,"US")
=GORILLA_GROSSPROFIT("TOY STORE", "2023", A2:A1000 , "DUMP" ,"US")
=GORILLA_GROSSPROFIT("TOY STORE", "2023", A2:A1000 , "DUMP" , "US", "50", "SKU_Asc")

Syntax description

GROSSPROFIT Gorilla ROI

Description:

Get gross profit of units sold for any set of periods.

Syntax:

GORILLA_GROSSPROFIT(sellerId, period, [sku], [output], [marketplace], [count], [sort], [start_date], [end_date], [status], [mcf])

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

period – REQUIRED
Predefined periods and any custom date frames to get the rank history. See full list of predefined periods below.

sku – OPTIONAL
SKU or ASIN to filter the results. Only empty (for seller’s total) or 1 SKU or ASIN can be provided when details is set to “YES” or “NO”.
A range (vertical or horizontal array) can be used when details are ‘totals_only’ to generate a matrix of data.

OUTPUT – OPTIONAL
Data output for the gross profit. Use ‘TOTAL’ to get the precalculated Gross profit (Total sold – Total COGS). Valid values: ‘TOTAL’ or ‘DUMP’ (default is ‘DUMP’). Dump will display all Gross profit in a table format, entered in your account.

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.

COUNT – OPTIONAL
Number of data rows to display when using ‘DUMP’ mode (not ‘TOTAL’). This is recommended for sellers with tens of thousands of SKUs.

SORT – OPTIONAL
Sorting criteria for ‘DUMP’ output. Sort by SKU or by date. Valid values: ‘SKU_Asc’ (DEFAULT), ‘Date_Asc’, ‘SKU_Desc’, ‘Date_Desc’.

START_DATE – OPTIONAL
Starting date for the returning range when period is ‘CUSTOM’ (Mandatory if custom).

END_DATE – OPTIONAL
Ending date for the returning range when period is ‘CUSTOM’.

STATUS – OPTIONAL
Order Status. Can be a range of values. Valid values are: ‘AllButCanceled’ (default), ‘All’, ‘PendingAvailability’ (JP only), ‘Pending’, ‘Unshipped’, ‘PartiallyShipped’, ‘Shipped’, ‘Shipping’, ‘InvoiceUnconfirmed’, ‘Canceled’, ‘Unfulfillable’.

MCF – OPTIONAL
MCF Orders processing. Valid values are: ‘Exclude’ (default), ‘Include’, ‘Only’ (Include only MCF orders)

GORILLA_GROSSPROFIT 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

Screenshot:

GROSSPROFIT SAMPLE Gorilla ROI

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

Will automatically generate DUMP of the GROSS PROFIT for the year 2023.

=GORILLA_GROSSPROFIT("TOY STORE", "2023", , ,"US")

Will automatically generate DUMP of the GROSS PROFIT for the year 2023 with US as the marketplace.

=GORILLA_GROSSPROFIT("TOY STORE", "2023", A2:A1000 , "DUMP" ,"US")

Will automatically generate DUMP of the GROSS PROFIT for the year 2023 with US as the marketplace for SKUs A2:A1000.

=GORILLA_GROSSPROFIT("TOY STORE", "2023", A2:A1000 , "DUMP" , "US", "50", "SKU_Asc" )

Will automatically generate DUMP of the GROSS PROFIT for the year 2023 with US as the marketplace for SKUs A2:A1000. DUMP will be limited to 50 rows which will be sorted via SKU on an ascending manner.

EBOOKS tO HELP unleash your amazon success

Enter your name and email for the full download package now.

Want SPREADSHEETS CREATED BY 7-Figure AMAZON Sellers?

Enter your name & email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.

GET YOUR SPREADSHEETS

Enter your email for the full download package now.