Google Sheets Functions

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

GORILLA_REFUNDSCOUNT() – Get total number 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)

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)

Syntax description

gorilla refunds count
Gets total number of units refunded for a product between any time period. Only the period is required. Other attributes are optional.

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

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)

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)

GORILLA_REFUNDSCOUNT Attributes
Period Attributes:

  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This Week
  • This Month
  • This Quarter
  • This Year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last YearLast 60 DaysYYYY
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago
  • YYYY-MM (change format to text)
  • YYYYQ1… YYYYQ4

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?