⚠️ 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
Returns daily historical conversions data from Amazon Business Reports using a variety of filters
Syntax
GORILLA_BIZCONVERSIONHIST(sellerId, period, [filter], [marketplace], [b2b], [datapoint], [days], [sort], [start_date], [end_date], [transpose], [header], [grouping])
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.
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
orderItemsessionpercentage
orderItemsessionpercentageB2B
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.
Sort – (OPTIONAL)
Date sorting criteria.
Valid inputs:
Valid inputs:
desc (DEFAULT)
asc
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 the header line in the results.
If left blank, the default input will be used.
Valid inputs:
Valid inputs:
true (DEFAULT)
false
Grouping – (OPTIONAL)
Specifies how the output data should be grouped by date.
If left blank, the default input will be used.
Valid inputs:
Valid inputs:
daily (DEFAULT)
weekly
monthly
yearly
Usage & Examples
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", , , "2023-12-01", "2023-12-21")It will retrieves daily conversion data from Amazon Business Reports for the seller "TOY STORE", filtered by ASIN B00YD545CC in the US marketplace. It includes B2B data and returns all available datapoints for the custom date range December 1 to December 21, 2023.
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", 21)It will retrieve daily conversion data from Amazon Business Reports for the seller "TOY STORE", filtered by ASIN B00YD545CC in the US marketplace. It includes B2B data and returns all available datapoints for the past 21 days from yesterday.
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "This Week", A2:A10, "US", , "ALL")It will retrieve daily conversion data from Amazon Business Reports for the seller "TOY STORE", using a list of ASINs or SKUs from cells A2 to A10, filtered by the US marketplace. It returns all available datapoints for the current week ("This Week").
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "This Month", "IPHN3724", , , "UnitSessionPercentage")It will retrieve daily conversion data from Amazon Business Reports for the seller "TOY STORE", filtered by ASIN IPHN3724. It returns only the UnitSessionPercentage datapoint for the current month ("This Month").
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "Same Day Last Month", "IPHN3724", "US")It will retrieve daily conversion data from Amazon Business Reports for the seller "TOY STORE", filtered by ASIN IPHN3724 in the US marketplace. It returns data for the same calendar day from the previous month.
Output Screenshot
