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 Amazon Business Reports, helping sellers analyze product performance across different periods, marketplaces, and SKUs/ASINs.
Syntax
GORILLA_BIZCONVERSION(sellerId, period, [filter], [marketplace], [b2b], [datapoint], [days], [start_date], [end_date], [transpose], [header], [aggregate])
Parameter Descriptions
Seller ID – (REQUIRED)
Seller ID or Nickname found within the Gorilla App to work with.
Period – (REQUIRED)
Predefined period to get returns or use "CUSTOM" to specify a Start_Date and End_Date.
Valid inputs:
Valid inputs:
Today
Yesterday
This Week
This Month
This Quarter
This Year
This Year-to-Last-Month
Last 7 Days
Last 14 Days
Last 30 Days
Last 60 Days
Last 90 Days
Last Week
Last Month
Last Quarter
Last Year
Last 3 Months
Last 12 Months
Same Day Last Week
Same Day Last Month
Same Day Last Year
Last 7 Days Week Ago
Last 7 Days Year Ago
Last 30 Days Month Ago
Last 30 Days Year Ago
Last Week Year Ago
Last Month Year Ago
YYYY-MM (change format to text)
YYYY
YYYYQ1
YYYYQ2
YYYYQ3
YYYYQ4
Custom
Filter – (OPTIONAL)
SKU or ASIN to filter the results. Can be a string like "ASIN111", or "ASIN123", or a range like A1:A100 where A1 to A100 consists of inputs like ASIN111, ASIN222, ASIN333 etc
Marketplace – (OPTIONAL)
Marketplace country filter.
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)
Include or Exclude B2B data.
If left blank, the default input will be used.
Valid inputs:
Valid inputs:
include (DEFAULT)
exclude.
Datapoint– (OPTIONAL)
Return data for specific data points. Can be a range of inputs like A1:E1 where A1 to E1 consists of different datapoint inputs.
If left blank, the default input will be used.
Valid inputs:
Valid inputs:
all (DEFAULT)
unitsessionpercentage
unitsessionpercentageB2B
Days – (OPTIONAL)
Number of days to return starting from yesterday. It only works when 'Period' is set to Custom. The value in this filter will override any custom input in the 'Start_Date' and 'End_Date' parameters.
Start Date – (OPTIONAL)
Starting date for the data when the 'Period' is set to "CUSTOM". This only applies if the 'Days' filter is left empty.
End Date – (OPTIONAL)
Ending date for the data when the 'Period' is set to "CUSTOM". This only applies if the 'Days' filter is left empty.
Transpose – (OPTIONAL)
Layout of the data.
If "NO" or no input is provided, returns Datapoints as Headers (left to right) and SKUs/ASINs as a Column (top to bottom). If "YES", returns SKUs/ASINs as Headers (left to right) and Datapoints as a Column (top to bottom).
If left blank, the default input will be used.
Valid inputs:
Valid inputs:
no (DEFAULT)
yes
Header – (OPTIONAL)
Include Headers in the results.
If left blank, the default input will be used.
Valid inputs:
Valid inputs:
true (DEFAULT)
false
Aggregate – (OPTIONAL)
Aggregates all the values for the selected datapoints.
If left blank, the default input will be used.
Valid inputs:
Valid inputs:
false (DEFAULT)
true
Usage & Examples
=GORILLA_BIZCONVERSION("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", , "2023-12-01", "2023-12-21")Retrieves business conversion data for ASIN B00YD545CC from the "TOY STORE" US account between Dec 1–21, 2023, including B2B data.
=GORILLA_BIZCONVERSION("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", 21)Retrieves business conversion data for ASIN B00YD545CC from the "TOY STORE" US account for the past 21 days, including B2B data.
=GORILLA_BIZCONVERSION("TOY STORE", "This Week", A2:A10, "US", , "ALL")Retrieves business conversion data for ASINs listed in cells A2 to A10 from the "TOY STORE" US account for the current week, including B2B data.
=GORILLA_BIZCONVERSION("TOY STORE", "This Month", "IPHN3724", , , "UnitSessionPercentage")Retrieves the Unit Session Percentage for ASIN IPHN3724 from the 'TOY STORE' account, based on the current month, the main marketplace used in the Gorilla App, and B2B sales type.
Output Screenshot
