⚠️ IMPORTANT NOTICE
Optimize Your Formula 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.
Syntax Screenshot
Description
Percentage your offer is featured in the buy box.
Syntax
GORILLA_BIZPERFORMANCE(sellerId, period, [filter], [marketplace], [b2b], [datapoint], [days], [start_date], [end_date], [transpose], [header])
Parameter Descriptions
Seller ID – (REQUIRED)
Seller ID or Nickname found within the Gorilla App to work with.
Period – (REQUIRED)
Predefined period to get performance information or use ‘custom’ to specify a start and end date.
Filter – (OPTIONAL)
SKU or ASIN to filter the results. Can be a string like "SKU111", or "ASIN123", or a range like A1:A100 where A1 to A100 consists of inputs like SKU111, SKU222, SKU333... or ASIN123, ASIN321, ASIN333 etc.
Marketplace – (OPTIONAL)
Marketplace country filter.
If left blank, the Main Marketplace in the Gorilla App will be used.
Amazon Marketplace ID like ‘ATVPDKIKX0DER’ can be used too.
Valid inputs
Valid inputs
ALL (All Marketplaces)
US (USA)
CA (Canada)
MX (Mexico)
BR (Brazil)
BE (Belgium)
UK (United Kingdom)
DE (Germany)
FR (France)
ES (Spain)
IT (Italy)
ZA (South Africa)
NL (Netherlands)
SE (Sweden)
PL (Poland)
TR (Turkey)
SA (Saudi Arabia)
EG (Egypt)
AE (United Arab Emirates)
JP (Japan)
AU (Australia)
SG (Singapore)
IN (India)
IE (Ireland)
EU (includes all European markets except the UK)
EURO (combines countries using the Euro currency)
B2B – (OPTIONAL)
Include or Exclude B2B data.
"INCLUDE", "EXCUDE". Default is set to "INCLUDE".
Valid inputs
Valid inputs
Include (DEFAULT)
Exclude.
Datapoint – (OPTIONAL)
Return data for specific data points. Can be a range of values like A1:E1 where A1 to E1 consists of different datapoint values. Default is empty value for all data points.
Valid inputs
Valid inputs
All (DEFAULT)
BuyBoxPercentage
BuyBoxPercentageB2B
Days – (OPTIONAL)
Number of days to return starting from current date. This filter will override any custom start date.
Start Date – (OPTIONAL)
Starting date for the data when period is custom. (Date is ignored if the days filter has a non-zero value like 5.)
End Date – (OPTIONAL)
Ending date for the data when period is custom. (Date is ignored if the days filter has a non-zero value like 5.)
Transpose – (OPTIONAL)
If empty or no, returns datapoints as header and SKU as a column. If yes, returns SKUs as headers and datapoints as a column.
Header – (OPTIONAL)
Include the header line in the results.
Valid inputs
Valid inputs
TRUE/FALSE.
Default: TRUE
Usage & Examples
=GORILLA_BIZPERFORMANCE("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", , "2023-12-01", "2023-12-21")Retrieve all BIZPERFORMANCE data points for "TOY STORE" ASIN B00YD545CC, including B2B metrics, for the US marketplace between December 1, 2023, and December 21, 2023.
=GORILLA_BIZPERFORMANCE("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", 21)Retrieve all BIZPERFORMANCE data points for "TOY STORE" ASIN B00YD545CC, including B2B metrics, for the US marketplace within the last 21 days from the current date.
=GORILLA_BIZPERFORMANCE("TOY STORE", "This Week", A2:A10, "US", , "ALL")Retrieve all BIZPERFORMANCE data points for "TOY STORE" SKUs or ASINs listed in the range A2:A10, including B2B metrics, for the US marketplace within the current week. Supports two-dimensional ranges and returns bulk results as an array. For example, when SKUs or ASINs are specified in A2:A10, all corresponding data points are returned at once. This function also supports horizontal and multi-cell ranges such as A1:Z1 or D3:G37.
=GORILLA_BIZPERFORMANCE("TOY STORE", "This Month", "IPHN3724", , , "BuyBoxPercentage")Retrieve the BIZPERFORMANCE 'BuyBoxPercentage' data point for "TOY STORE" SKU 'IPHN3724' across all marketplaces for the current month.
=GORILLA_BIZPERFORMANCE("TOY STORE", "Same Day Last Month", "IPHN3724", "US")Retrieve all BIZPERFORMANCE data points for "TOY STORE" SKU 'IPHN3724', including B2B metrics, for the US marketplace on the same day of the previous month.
=GORILLA_BIZPERFORMANCE("TOY STORE", "This Year")Gets All BIZPERFORMANCE datapoints for all "TOY STORE" SKUs/ASINs, including B2B datapoints for offers featured data this year.
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.
Output Screenshot
