⚠️ IMPORTANT NOTICE
Optimize Your Formula Usage
Use ranges (e.g., A2:A1000) in your formula whenever possible to ensure faster results and to prevent Google from blocking your account for 24 hours due to excessive resource usage.
Syntax Description
Description
Daily historical conversions data from business reports.
Syntax
GORILLA_BIZCONVERSIONHIST(sellerId, period, [filter], [marketplace], [b2b], [datapoint], [days], [sort], [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 conversion information or use ‘custom’ to specify a start and end date.
Filter – (OPTIONAL)
SKU or ASIN to filter the results. Can be a range of values like A1:A100 where A1 to A100 consists of values like SKU111, SKU222, SKU333 or ASIN123. Note that some output columns are only available the if SKU filter is empty.
Market Place – (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)
Show or hide B2B datapoints when datapoints filter is ‘ALL’ or not specified.
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)
UnitSessionPercentage
UnitSessionPercentageB2B
OrderItemSessionPercentage
OrderItemSessionPercentageB2B
Days – (OPTIONAL)
Number of days to return starting from the current date. This filter will override any custom start date.
Sort – (OPTIONAL)
Date sorting criteria.
Valid inputs
Valid inputs
Desc (DEFAULT)
Asc
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_BIZCONVERSIONHIST("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", , , "2023-12-01", "2023-12-21")Gets All BIZCONVERSIONHIST datapoints for "TOY STORE" B00YD545CC, including B2B datapoints for the US marketplace between Dec 1, 2023 and Dec 21, 2023.
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", 21)Gets All BIZCONVERSIONHIST datapoints for "TOY STORE" B00YD545CC, including B2B datapoints for the US marketplace within the last 21 days starting from current date.
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "This Week", A2:A10, "US", , "ALL")Gets All BIZCONVERSIONHIST datapoints for "TOY STORE" SKUs/ASINs within A2:A10 range, including B2B datapoints for the US marketplace within this week. Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKUs or ASINs. In this example the SKUs or ASINs are listed in A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "This Month", "IPHN3724", , , "UnitSessionPercentage")Gets BIZCONVERSIONHIST ‘UnitSessionPercentage’ datapoint for "TOY STORE" ‘IPHN3724’ for all Marketplaces within this month.
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "Same Day Last Month", "IPHN3724", "US")Gets All BIZCONVERSIONHIST datapoints for "TOY STORE" ‘IPHN3724’, including B2B datapoints for the US marketplace the same day last month.
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "This Year")Gets All BIZCONVERSIONHIST datapoints for "TOY STORE" all SKUs/ASINs, including B2B datapoints for current 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
