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

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

Syntax description

gorilla refunds count

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

for Gorilla Agency, the syntax is

Gorilla_ASINLIST(sellerID, [marketplace], [filter_sku])

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

marketplace
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 – 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 – Starting date to get sales from when period is custom. To use custom dates, specify the period as “CUSTOM”.

end_date
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:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.

=GORILLA_REFUNDSCOUNT(“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_REFUNDSCOUNT(“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_REFUNDSCOUNT(“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_REFUNDSCOUNT(“2020”, “US”, B7:B27)
=GORILLA_REFUNDSCOUNT(“2020Q1”, “US”, A1:A100)

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

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

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?