Video Tutorial
⚠️ 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 Screenshot
Description
Display conversion related data from business reports.
Syntax
GORILLA_BIZCONVERSION(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 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
Marketplace – (OPTIONAL)
Marketplace country filter. Amazon Marketplace ID like ‘ATVPDKIKX0DER’ can be used too.
If left blank, the Main Marketplace in the Gorilla App will be used.
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.
Data Points – (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
Days – (OPTIONAL)
Number of days to return starting from the 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_BIZCONVERSION("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", , "2023-12-01", "2023-12-21")Gets All BIZCONVERSION datapoints for "TOY STORE" B00YD545CC, including B2B datapoints for the US marketplace between Dec 1, 2023 and Dec 21, 2023.
=GORILLA_BIZCONVERSION("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", 21)Gets All BIZCONVERSION datapoints for "TOY STORE" B00YD545CC, including B2B datapoints for the US marketplace within the last 21 days starting from current date.
=GORILLA_BIZCONVERSION("TOY STORE", "This Week", A2:A10, "US", , "ALL")Gets All BIZCONVERSION 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_BIZCONVERSION("TOY STORE", "This Month", "IPHN3724", , , "UnitSessionPercentage")Gets BIZCONVERSION ‘UnitSessionPercentage’ datapoint for "TOY STORE" ‘IPHN3724’ for all Marketplaces within this month.
=GORILLA_BIZCONVERSION("TOY STORE", "Same Day Last Month", "IPHN3724", "US")Gets All BIZCONVERSION datapoints for "TOY STORE" ‘IPHN3724’, including B2B datapoints for the US marketplace the same day last month.
=GORILLA_BIZCONVERSION("TOY STORE", "This Year")Gets All BIZCONVERSION datapoints for "TOY STORE" all SKUs/ASINs, including B2B datapoints for conversions 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
