Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. 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("TOY STORE", "Custom", "US", "B00YD545CC", "5", "2021-01-01", "2021-01-21")
=GORILLA_REVIEWSFILTER("TOY STORE", "This Week","ALL",A2:A10,"ALL")

Syntax Description

REVIEWSFILTER 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(Seller ID, period, [marketplace], [sku], [stars], [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 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.

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("TOY STORE", "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("TOY STORE", "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("TOY STORE", "2019Q1", "US", "B00YD545CC", "1")
=GORILLA_REVIEWSFILTER("TOY STORE", "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("TOY STORE", "This Month", "ALL", "IPHN3724", "5")

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

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

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

=GORILLA_REVIEWSFILTER("TOY STORE", "This Year")

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

How can we help?