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

🚨 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_REVIEWSFILTER("Custom", "US", "B00YD545CC", "5", "2021-01-01", "2021-01-21")
=GORILLA_REVIEWSFILTER("This Week","ALL",A2:A10,"ALL")

Syntax Description

gorilla reviewsfilter function popup 1 Gorilla ROI

Description:

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.

Syntax:

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: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_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")

How can we help?