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("TOY STORE", “THIS YEAR”)=GORILLA_REFUNDSTOTAL("TOY STORE", “LAST YEAR”,”US”, A2:A34)=GORILLA_REFUNDSTOTAL("TOY STORE", “CUSTOM”, “FR”, A2:A34, “2020-01-01”, “2020-01-15”)=GORILLA_REFUNDSTOTAL("TOY STORE", “2020”, “US”, B7:B27)=GORILLA_REFUNDSTOTAL("TOY STORE", “2020Q1”, “US”, A1:A100)Syntax description
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(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 the refunds value. See full list of predefined periods below.
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 |
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”.
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("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_REFUNDSTOTAL("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_REFUNDSTOTAL("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_REFUNDSTOTAL("TOY STORE", “2020”, “US”, B7:B27)=GORILLA_REFUNDSTOTAL("TOY STORE", "2020Q1", "US", A1:A100