GORILLA_BIZSALESHIST() – Daily historical values of the sales data from business reports
Sample 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.
=GORILLA_BIZSALESHIST("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", , , "2023-12-01", "2023-12-21")=GORILLA_BIZSALESHIST("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", 21)=GORILLA_BIZSALESHIST("TOY STORE", "This Week", A2:A10, "US", , "ALL")=GORILLA_BIZSALESHIST("TOY STORE", "This Month", "IPHN3724", , , "UnitsOrdered")=GORILLA_BIZSALESHIST("TOY STORE", "Same Day Last Month", "IPHN3724", "US")=GORILLA_BIZSALESHIST("TOY STORE", "This Year")Example output screenshot
Syntax Description:
Description:
Daily historical values of the sales data from business reports.
Syntax:
GORILLA_BIZSALESHIST(sellerId, period, [filter], [marketplace], [b2b], [datapoint], [days], [sort], [start_date], [end_date], [transpose], [header])
Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.
PERIOD – REQUIRED
Predefined period to get sales 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 if the SKU filter is empty.
MARKETPLACE – OPTIONAL
Marketplace country filter. Country codes are US, CA, MX, BR, BE, UK, DE, ES, IT, FR, NL, PL, TR, IN, SE, AE, AU, SG, JP, EG, SA. Use DEFAULT for your default market. Amazon Marketplace ID like ATVPDKIKX0DER can be used too.
B2B – OPTIONAL
Show or hide B2B datapoints when datapoints filter is ‘ALL’ or not specified. Valid values are:
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. Other Valid values are:
All (DEFAULT)
OrderedProductSales
OrderedProductSalesCurrencyCode
OrderedProductSalesB2B
OrderedProductSalesB2BCurrencyCode
UnitsOrdered
UnitsOrderedB2B
TotalOrderItems
TotalOrderItemsB2B
AverageSalesPerOrderItem
AverageSalesPerOrderItemCurrencyCode
AverageSalesPerOrderItemB2B
AverageSalesPerOrderItemB2BCurrencyCode
AverageUnitsPerOrderItem
AverageUnitsPerOrderItemB2B
AverageSellingPrice
AverageSellingPriceCurrencyCode
AverageSellingPriceB2B
AverageSellingPriceB2BCurrencyCode
ShippedProductSales
ShippedProductSalesCurrencyCode
UnitsShipped
OrdersShipped
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 values:
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. Possible values: TRUE/FALSE. Default: TRUE
GORILLA_BIZSALESHIST Attributes
Period Attributes:
Today | This month | Last 3 Months |
Yesterday | This quarter | Last 12 Months |
Same day last week | This year | Last 7 Days Week Ago |
Same day last month | This Year-to-Last-Month | Last 7 Days Year Ago |
Same day last year | Last Week | Last 30 Days Month Ago |
Last 7 Days | Last Month | Last 30 Days Year Ago |
Last 14 Days | Last Quarter | Last Week Year Ago |
Last 30 Days | Last Year | Last Month Year Ago |
Last 90 Days | Last 60 Days | YYYY-MM (change format to text) |
This week | YYYY | YYYYQ1… YYYYQ4 |
Custom |
Datapoint Attributes:
All | OrderedProductSales |
OrderedProductSalesCurrencyCode | OrderedProductSalesB2B |
OrderedProductSalesB2BCurrencyCode | UnitsOrdered |
UnitsOrderedB2B | TotalOrderItems |
TotalOrderItemsB2B | AverageSalesPerOrderItem |
AverageSalesPerOrderItemCurrencyCode | AverageSalesPerOrderItemB2B |
AverageSalesPerOrderItemB2BCurrencyCode | AverageUnitsPerOrderItem |
AverageUnitsPerOrderItemB2B | AverageSellingPrice |
AverageSellingPriceCurrencyCode | AverageSellingPriceB2B |
AverageSellingPriceB2BCurrencyCode | ShippedProductSales |
ShippedProductSalesCurrencyCode | UnitsShipped |
OrdersShipped |
Examples:
🚨 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.
=GORILLA_BIZSALESHIST("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", , , "2023-12-01", "2023-12-21")Gets All BIZSALESHIST datapoints for B00YD545CC, including B2B datapoints for the US marketplace between Dec 1, 2023 and Dec 21, 2023.
=GORILLA_BIZSALESHIST("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", 21)Gets All BIZSALESHIST datapoints for B00YD545CC, including B2B datapoints for the US marketplace within the last 21 days starting from current date.
=GORILLA_BIZSALESHIST("TOY STORE", "This Week", A2:A10, "US", , "ALL")Gets All BIZSALESHIST datapoints for 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_BIZSALESHIST("TOY STORE", "This Month", "IPHN3724", , , "UnitsOrdered")Gets BIZSALESHIST ‘UnitsOrdered’ datapoint for ‘IPHN3724’ for all Marketplaces within this month.
=GORILLA_BIZSALESHIST("TOY STORE", "Same Day Last Month", "IPHN3724", "US")Gets All BIZSALESHIST datapoints for ‘IPHN3724’, including B2B datapoints for the US marketplace the same day last month.
=GORILLA_BIZSALESHIST("TOY STORE", "This Year")Gets All BIZSALESHIST datapoints for 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.