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
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:
Today | This month | Last 3 Months |
Yesterday | This quarter | Last 12 Months |
Same day last week | This year | Last 7 Days Week Ago |
Same day last month | This Year-to-Last-Month | Last 7 Days Year Ago |
Same day last year | Last Week | Last 30 Days Month Ago |
Last 7 Days | Last Month | Last 30 Days Year Ago |
Last 14 Days | Last Quarter | Last Week Year Ago |
Last 30 Days | Last Year | Last Month Year Ago |
Last 90 Days | Last 60 Days | YYYY-MM (change format to text) |
This week | YYYY | YYYYQ1… YYYYQ4 |
Custom |
Screenshot:
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.