GORILLA_SALESTOTALHIST() – Get local currency amount of sales history for a given period

Sample Usage =GORILLA_SALESTOTALHIST(“TOY STORE”) =GORILLA_SALESTOTALHIST(“TOY STORE”, “B00YD545CC”) =GORILLA_SALESTOTALHIST(“TOY STORE”, A1:A20) =GORILLA_SALESTOTALHIST(“TOY STORE”, A1:A10, “US”, “ALL”, “EXCLUDE”, 60) =GORILLA_SALESTOTALHIST(“TOY STORE”, A1:A10, “US”, “ALL”, “EXCLUDE”, 60, , ,”Yes”) =GORILLA_SALESTOTALHIST(“TOY STORE”, A1:A10, “DE”, “Canceled”, “EXCLUDE”, , “2020-01-01”, “2020-03-12”) Syntax Description Description: Get local currency amount of sales history for a given period GORILLA_SALESTOTALHIST(Seller ID, [sku], [marketplace], [status], [mcf],…

GORILLA_SALESCOUNTHIST() – Gets the historical number of units ordered between any period.

Sample Usage =GORILLA_SALESCOUNTHIST(“TOY STORE”) =GORILLA_SALESCOUNTHIST(“TOY STORE”, “B00YD545CC”) =GORILLA_SALESCOUNTHIST(“TOY STORE”, A1:A20) =GORILLA_SALESCOUNTHIST(“TOY STORE”, A1:A10, “US”, “ALL”, “EXCLUDE”, 60) =GORILLA_SALESCOUNTHIST(“TOY STORE”, A1:A10, “US”, “ALL”, “EXCLUDE”, 60, , ,”YES”) =GORILLA_SALESCOUNTHIST(“TOY STORE”, A1:A10, “DE”, “CANCELED”, “EXCLUDE”, , “2022-01-01”, “2022-03-15”) Syntax Description Description: Gets the historical number of units ordered between any period. Syntax: GORILLA_SALESCOUNTHIST(Seller ID, [sku], [marketplace], [status], [mcf],…

GORILLA_RANKHIST() – Get historical BSR for products

Sample Usage =GORILLA_RANKHIST(“TOY STORE”, “last 30 days”, A2:A100) =GORILLA_RANKHIST(“TOY STORE”, “custom”, A2:A5, “US”, “top”, “2022-06-01”, “2022-06-30”) =GORILLA_RANKHIST(“TOY STORE”, “this month”, “B00YD545CC”, “JP”, “child”) Syntax Description Description: Get the daily historical BSR (Best Seller Rank) over any time period for a single or range of sku’s. Only works for single marketplaces at a time. Not “ALL”….

GORILLA_ORDERSCOUNTHIST() – Get daily historical orders sold

Sample Usage =GORILLA_ORDERSCOUNTHIST(“TOY STORE”) =GORILLA_ORDERSCOUNTHIST(“TOY STORE”, “B00YD545CC”) =GORILLA_ORDERSCOUNTHIST(“TOY STORE”, A1:A20) =GORILLA_ORDERSCOUNTHIST(“TOY STORE”, A1:A10, “US”, “ALL”, “EXCLUDE”, 60) =GORILLA_ORDERSCOUNTHIST(“TOY STORE”, A1:A10, “US”, “ALL”, “EXCLUDE”, 60, , ,”Yes”) =GORILLA_ORDERSCOUNTHIST(“TOY STORE”, A1:A10, “DE”, “Canceled”, “EXCLUDE”, , “2022-01-01”, “2022-03-12”) Syntax Description Description: Get number of orders history for a given period or number of days going back. =GORILLA_ORDERSCOUNTHIST(Seller ID,…

GORILLA_INVENTORYHIST() – Show inventory history of products.

Sample Usage =GORILLA_INVENTORYHIST(“TOY STORE”, “last 14 days”, D2, “US”, “fulfillable”) =GORILLA_INVENTORYHIST(“TOY STORE”, “last 3 months”, “B00YD545CC”, “UK”, “transfer”) =GORILLA_INVENTORYHIST(“TOY STORE”, “custom”, A1:A10, “ALL”, “inbound”, “2019-12-01”, “2019-12-12”, “yes”) Syntax Description Description: Show inventory history of products. Syntax: GORILLA_INVENTORYHIST(Seller ID, period, sku, [marketplace], [status], [start date], [end date], [transpose], [header]) Seller ID – REQUIREDEnter the seller ID…

GORILLA_BIZCONVERSIONHIST() – Daily historical conversions data from business reports

Sample Usage =GORILLA_BIZCONVERSIONHIST(“TOY STORE”, “Custom”, “B00YD545CC”, “US”, “INCLUDE”, “ALL”, , , “2023-12-01”, “2023-12-21”) =GORILLA_BIZCONVERSIONHIST(“TOY STORE”, “Custom”, “B00YD545CC”, “US”, “INCLUDE”, “ALL”, 21) =GORILLA_BIZCONVERSIONHIST(“TOY STORE”, “This Week”, A2:A10, “US”, , “ALL”) =GORILLA_BIZCONVERSIONHIST(“TOY STORE”, “This Month”, “IPHN3724”, , , “UnitSessionPercentage”) =GORILLA_BIZCONVERSIONHIST(“TOY STORE”, “Same Day Last Month”, “IPHN3724”, “US”) =GORILLA_BIZCONVERSIONHIST(“TOY STORE”, “This Year”) Screenshot of Output Syntax Description Description:…

GORILLA_BIZPERFORMANCEHIST() – Daily historical data of seller performance from business reports

Sample Usage =GORILLA_BIZPERFORMANCEHIST(“TOY STORE”, “Custom”, “B00YD545CC”, “US”, “INCLUDE”, “ALL”, , , “2023-12-01”, “2023-12-21”) =GORILLA_BIZPERFORMANCEHIST(“TOY STORE”, “Custom”, “B00YD545CC”, “US”, “INCLUDE”, “ALL”, 21) =GORILLA_BIZPERFORMANCEHIST(“TOY STORE”, “This Week”, A2:A10, “US”, , “ALL”) =GORILLA_BIZPERFORMANCEHIST(“TOY STORE”, “This Month”, “IPHN3724”, , , “BuyBoxPercentage”) =GORILLA_BIZPERFORMANCEHIST(“TOY STORE”, “Same Day Last Month”, “IPHN3724”, “US”) =GORILLA_BIZPERFORMANCEHIST(“TOY STORE”, “This Year”) Screenshot of Output Syntax Description: Description:…

GORILLA_BIZSALESHIST() – Daily historical values of the sales data from business reports

Sample Usage =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:…

GORILLA_BIZSESSIONSHIST() – Displays daily historical sessions data from business reports

Sample Usage =GORILLA_BIZSESSIONSHIST(“TOY STORE”, “Custom”, “B00YD545CC”, “US”, “INCLUDE”, “ALL”, , , “2023-12-01”, “2023-12-21”) =GORILLA_BIZSESSIONSHIST(“TOY STORE”, “Custom”, “B00YD545CC”, “US”, “INCLUDE”, “ALL”, 21) =GORILLA_BIZSESSIONSHIST(“TOY STORE”, “This Week”, A2:A10, “US”, , “ALL”) =GORILLA_BIZSESSIONSHIST(“TOY STORE”, “This Month”, “IPHN3724”, , , “TotalPageViews”) =GORILLA_BIZSESSIONSHIST(“TOY STORE”, “Same Day Last Month”, “IPHN3724”, “US”) =GORILLA_BIZSESSIONSHIST(“TOY STORE”, “This Year”) Output Screenshot Syntax Description: Description: Displays…