Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_REFUNDSTOTAL() – Get total value of units refunded between any time period

GORILLA_REFUNDSTOTAL() – Get total value of units refunded 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_REFUNDSTOTAL(“THIS YEAR”)
=GORILLA_REFUNDSTOTAL(“LAST YEAR”,”US”, A2:A34)
=GORILLA_REFUNDSTOTAL(“CUSTOM”, “FR”, A2:A34, “2020-01-01”, “2020-01-15”)
=GORILLA_REFUNDSTOTAL(“2020”, “US”, B7:B27)
=GORILLA_REFUNDSTOTAL(“2020Q1”, “US”, A1:A100)

Syntax description

gorilla refunds total function 2 Gorilla ROI

Description:

Gets total value in dollars of units refunded for a product between any time period. Only the period is required. Other attributes are optional.

Syntax:

GORILLA_REFUNDSTOTAL(period, [marketplace], [sku], [start_date], [end_date])

for Gorilla AGENCY, the syntax is

GORILLA_REFUNDSTOTAL(sellerID, period, [marketplace], [sku], [start_date], [end_date])

period – REQUIRED

Predefined period to get the refunds value. See full list of predefined periods below.

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

marketplace – OPTIONAL

OPTIONAL – Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

sku – OPTIONAL

OPTIONAL – Any Seller SKU/ASIN to limit results. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string. If no SKUs are specified, it will load the total number across the account.

start_date – OPTIONAL

OPTIONAL – Starting date to get sales from when period is custom. To use custom dates, specify the period as “CUSTOM”.

end_date – OPTIONAL

OPTIONAL – Ending date to get sales from when period is custom. To use custom dates, specify the period as “CUSTOM”.

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_REFUNDSTOTAL(“THIS YEAR”)

Returns the total count of refunded units for this year. No SKUs are specified which will show the count across the entire account. E.g. if the result is 200, then it means that 200 units were refunded for “this year”.

=GORILLA_REFUNDSTOTAL(“LAST YEAR”,”US”, A2:A34)

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:A34 and returns the count of the refunded units for each SKU/ASIN. Can also work for rows and ranges like A1:Z1 or D3:G37.

=GORILLA_REFUNDSTOTAL(“CUSTOM”, “FR”, A2:A34, “2020-01-01”, “2020-01-15”)

Returns the total count of refunded units based on a custom date. The start date is 2020-01-01 and the end date is 2020-01-15. The SKU/ASIN is listed in A2 to A34. The marketplace is defined as France.

=GORILLA_REFUNDSTOTAL(“2020”, “US”, B7:B27)
=GORILLA_REFUNDSTOTAL(“2020Q1”, “US”, A1:A100)

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

=GORILLA_REFUNDSTOTAL(“SELLERID38”, “THIS YEAR”)
=GORILLA_REFUNDSTOTAL(“SELLERID38”, “LAST YEAR”,”US”, A2:A34)
=GORILLA_REFUNDSTOTAL(“SELLERID38”, “CUSTOM”, “FR”, A2:A34, “2020-01-01”, “2020-01-15”)
=GORILLA_REFUNDSTOTAL(“SELLERID38”, “2020”, “US”, B7:B27)
=GORILLA_REFUNDSTOTAL(“SELLERID38”, “2020Q3”, “US”, A1:A100)

How can we help?