Google Sheets Functions

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

GORILLA_REFUNDSCOUNT() – Get total number 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_REFUNDSCOUNT("TOY STORE", "THIS YEAR")
=GORILLA_REFUNDSCOUNT("TOY STORE", "LAST YEAR","US", A2:A34)
=GORILLA_REFUNDSCOUNT("TOY STORE", "CUSTOM", "FR", A2:A34, "2020-01-01", "2020-01-15")
=GORILLA_REFUNDSCOUNT("TOY STORE", "2020", "US", B7:B27)
=GORILLA_REFUNDSCOUNT("TOY STORE", "2020Q1", "US", A1:A100)

Syntax description

REFUNDSCOUNT Gorilla ROI

Description:

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

Syntax:

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

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

period – REQUIRED
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.

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”.

GORILLA_REFUNDSCOUNT 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

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_REFUNDSCOUNT("TOY STORE", "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("TOY STORE", "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("TOY STORE", "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("TOY STORE", "2020", "US", B7:B27)
=GORILLA_REFUNDSCOUNT("TOY STORE", "2020Q1", "US", A1:A100)
Tags

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.