Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_REVIEWSFILTER() – Get number of reviews between any time period

GORILLA_REVIEWSFILTER() – Get number of reviews between any time period

Sample Usage

=GORILLA_REVIEWSFILTER("Custom", "US", "B00YD545CC", "5", "2021-01-01", "2021-01-21")
=GORILLA_REVIEWSFILTER("This Week","ALL",A2:A10,"ALL")

Syntax:

GORILLA_REVIEWSFILTER() - Get number of reviews between any time period 1

Gets total number of 1,2,3,4,5 or all reviews for a product between any time period. Only the time period is required. Other attributes are optional.

GORILLA_REVIEWSFILTER(period, [marketplace], [sku], [stars], [start_date], [end_date])

for Gorilla Agency, the syntax is

GORILLA_REVIEWSFILTER(sellerID, period, [marketplace], [sku], [status], [start_date], [end_date])

period

Predefined period to get the number of reviews. See full list of predefined periods below.

marketplace

OPTIONAL – Marketplace filter. Use All for all marketplaces and 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.

stars

OPTIONAL – The review star rating to filter for

  • All (default)
  • 1
  • 2
  • 3
  • 4
  • 5

start_date

OPTIONAL – Starting date to get number of reviews from when period is custom.

end_date

OPTIONAL – Ending date to get number of reviews from when period is 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_REVIEWSFILTER("Custom", "US", "B00YD545CC", "5", "2021-01-01", "2021-01-21")

Gets total number of 5 star reviews for B00YD545CC in the US marketplace between Jan 1, 2021 and Jan 21, 2021.

=GORILLA_REVIEWSFILTER("This Week","ALL",A2:A10,"ALL")

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:A10 and returns the count of all reviews 1-5. Can also work for rows and ranges like A1:Z1 or D3:G37. 

=GORILLA_REVIEWSFILTER("2019Q1", "US", "B00YD545CC", "1")
=GORILLA_REVIEWSFILTER("2019-05", "US", "B00YD545CC", "3")

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

To get monthly data, use the format YYYY-MM as the preset period.

=GORILLA_REVIEWSFILTER("This Month", "ALL", "IPHN3724", "5")

Gets the total number of 5 star reviews for SKU IPHN3724 from all marketplaces. 

=GORILLA_REVIEWSFILTER("Same Day Last Month", "ALL", “IPHN3724”, "1")

Gets the total number of 1 star reviews for SKU IPHN3724 from all marketplaces. 

=GORILLA_REVIEWSFILTER("This Year")

Gets the total number of reviews all products, account across all marketplaces.

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

=GORILLA_REVIEWSFILTER("SELLERID83", "Custom", "US", "B00YD545CC", "5", "2021-01-01", "2021-01-21")
=GORILLA_REVIEWSFILTER("SELLERID83", "This Week","ALL",A2:A10,"ALL")
=GORILLA_REVIEWSFILTER("SELLERID83", "2019Q1", "US", "B00YD545CC", "1")
=GORILLA_REVIEWSFILTER("SELLERID83", "2019-05", "US", "B00YD545CC", "3")
=GORILLA_REVIEWSFILTER("SELLERID83", "This Month", "ALL", "IPHN3724", "5")
=GORILLA_REVIEWSFILTER("SELLERID83", "Same Day Last Month", "ALL", “IPHN3724”, "1")

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?