Google Sheets Functions

• Marketplace and Country Codes
• How to use the Universal Search Bar
• How to Use COGS Feature
• 1.Seller Central Data/Functions
  • GORILLA_ASINLIST() – Get list of ASINs from your marketplace
  • GORILLA_ASINSTATUS() – Get the active or inactive status of the ASIN
  • GORILLA_BIZCONVERSION() – Display conversion related data from business reports
  • GORILLA_BIZCONVERSIONHIST() – Daily historical conversions data from business reports
  • GORILLA_BIZPERFORMANCE() – Percentage your offer is featured in the buy box
  • GORILLA_BIZPERFORMANCEHIST() – Daily historical data of seller performance from business reports
  • GORILLA_BIZSALES() – Get sales data from business reports
  • GORILLA_BIZSALESHIST() – Daily historical values of the sales data from business reports
  • GORILLA_BIZSESSIONS() – Sessions data from business reports
  • GORILLA_BIZSESSIONSHIST() – Displays daily historical sessions data from business reports
  • GORILLA_BUYBOXOFFERS() – Get list of sellers competing for the buy box
  • GORILLA_BUYBOXPRICE() – Get the current winning buy box price
  • GORILLA_BUYBOXSELLERS() – Show the number of sellers competing for buybox for a given product.
  • GORILLA_BUYBOXWINNER() – See if you are winning the buy box
  • GORILLA_BUYBOXWINNERFULL() – Show the Buy Box winner details for the selected products.
  • GORILLA_CATEGORY() – Get categories product is listed under
  • GORILLA_CHARGETOTAL() – Get financials breakdown of sales & charges related to sale of product
  • GORILLA_CHARGETYPE() – Returns list of line item names for all “charges” to Amazon account when related to sales
  • GORILLA_COGSTOTAL() – Display total COGS if COGS has been entered via your Gorilla ROI account
  • GORILLA_COMPETITIVEPRICE() – Get competitive price
  • GORILLA_COSTCURRENT() – Get the current or latest product costs for any date
  • GORILLA_COSTDUMP() – Get the AVG, MIN, MAX, FIRST, LAST product costs for any period
  • GORILLA_FEESESTIMATE() – Get estimated fees for product
  • GORILLA_FEETOTAL() – Get financials breakdown of all fees related to sale of product
  • GORILLA_FEETYPE() – Return list of line item names associated as fees to Amazon account
  • GORILLA_FINANCES() – Get sales, charges and fees for any period using payments report data
  • GORILLA_GROSSPROFIT() – Get gross profit of unit solds for any set of periods
  • GORILLA_IMAGES() – Get image URLs of the product and listing
  • GORILLA_INBOUNDSHIP() – Load inbound shipment data
  • GORILLA_INBOUNDSHIPITEMS() – Get inbound shipment data by SKU
  • GORILLA_INVENTORY() – Get quantity and status of inventory
  • GORILLA_INVENTORYAGE() – Get the inventory age for a given SKU or ASIN
  • GORILLA_INVENTORYHEALTH() – Get detailed inventory metrics
  • GORILLA_INVENTORYHIST() – Show inventory history of products.
  • GORILLA_INVENTORYLEDGER() – Dump end-to-end inventory reconciliation capability
  • GORILLA_INVENTORYRECEIVED() – Get inventory received and check shipment data
  • GORILLA_INVENTORYRESTOCK() – Get inventory restock data based on the restock reports
  • GORILLA_ISFBA() – Check if a SKU or ASIN is FBA or FBM or both
  • GORILLA_LOWESTPRICE() – Get lowest price in the Amazon buy box
  • GORILLA_MANAGEORDER() – Get list of orders and order details for SKU or ASIN
  • GORILLA_MYPRICE() – Get the seller price for the SKU or ASIN
  • GORILLA_OOS() – Show Out Of Stock days
  • GORILLA_OOSRATE() – Show Out Of Stock days as a percentage
  • GORILLA_ORDERSCOUNT() – Get the number of orders sold between any time period
  • GORILLA_ORDERSCOUNTHIST() – Get daily historical orders sold
  • GORILLA_PRODUCT() – Get product info such as title, brand, weight, color
  • GORILLA_PRODIDCONV() – Convert between any product ID to another product ID in the Amazon system
  • GORILLA_PROFITLOSS() – Get detailed financials to build profit loss statement for the account or by SKU/ASIN
  • GORILLA_PROFITLOSSORDERS() – See the profit per orders
  • GORILLA_RANKHIST() – Get historical BSR for products
  • GORILLA_RANKING() – Get BSR for products
  • GORILLA_RATINGS() – Get average review rating for product
  • GORILLA_RATINGSCOUNT() – Get number of ratings for product
  • GORILLA_RECONCILEREFUNDS() – Shows units purchased vs refunded
  • GORILLA_REFUNDSCOUNT() – Get total number of units refunded between any time period
  • GORILLA_REFUNDSORDER() – Display orders that were refunded across any time period
  • GORILLA_REFUNDSPCT() – Get total value of units refunded between any time period
  • GORILLA_REFUNDSTOTAL() – Get total value of units refunded between any time period
  • GORILLA_REMOVALS() – Get FBA Recommended Removals Data
  • GORILLA_REMOVALSDETAILS() – Get details from Removal Orders.
  • GORILLA_REVIEW() – Get full review details of a product
  • GORILLA_REVIEWCOUNT() – Get number of reviews of a product
  • GORILLA_REVIEWSFILTER() – Get number of reviews between any time period
  • GORILLA_SALESCOUNT() – Gets the quantity of orders sold between any period
  • GORILLA_SALESCOUNTHIST() – Gets the historical number of units ordered between any period.
  • GORILLA_SALESTAX() – Get total sales and taxes collected by Amazon or owed by the seller
  • GORILLA_SALESTOTAL() – Get total sales local currency amount between any time period
  • GORILLA_SALESTOTALHIST() – Get local currency amount of sales history for a given period
  • GORILLA_SELLERFEEDBACK() – Dump negative and neutral feedback (one to three stars) from buyers who rated the seller’s performance.
  • GORILLA_SETTLEMENT() – Get the list of settlement IDs
  • GORILLA_SETTLEMENTDETAILS() – Get the details of what is included in a settlement transaction
  • GORILLA_SKUASIN() – Convert SKU to ASIN OR ASIN to SKU
  • GORILLA_SKUASINPARENT() – Get the parent SKU or ASIN based on a child SKU or ASIN
  • GORILLA_SKUFNSKU() – Convert SKU or ASIN to FNSKU and vice versa
  • GORILLA_SKULIST() – Get the list of SKUs from your account
  • GORILLA_SKUSTATUS() – Get the active or inactive status of the SKU
  • GORILLA_SNSFORECAST() – Get Subscribe and Save forecast reports
  • GORILLA_SNSPERFORMANCE() – Get Subscribe and Save performance report data
  • GORILLA_STORAGEFEES() – Get your Amazon storage fees report
• 2.Advertising Data/Functions
  • GORILLA_ADCAMPAIGNLIST() – Get advertising campaign list
  • GORILLA_ADGROUPLIST() – Get advertising group list
  • GORILLA_ADHIGHACOSCAMPAIGN() – Advertising campaign with high acos
  • GORILLA_ADHIGHACOSGROUP() – Advertising group with high acos
  • GORILLA_ADHIGHACOSSEARCHTERM() – Advertising search term with high acos
  • GORILLA_ADIDCONV() – Convert between any ad data ID to another ID in the Amazon system
  • GORILLA_ADKEYWORDLIST() – Get advertising keyword list
  • GORILLA_ADNOSALESCAMPAIGN() – Shows all ads campaign that has clicks, but no sales
  • GORILLA_ADNOSALESGROUP() – Shows all ads group that has clicks, but no sales
  • GORILLA_ADNOSALESKEYWORD() – Shows all ads keywords that has clicks, but no sales
  • GORILLA_ADORDERSCAMPAIGN() – Get total orders of advertised campaigns between any period
  • GORILLA_ADORDERSCAMPAIGNHIST() – Advertising Orders Campaign History
  • GORILLA_ADORDERSGROUP() – Get total orders of advertised group between any period
  • GORILLA_ADORDERSGROUPHIST() – Advertising Orders Group History
  • GORILLA_ADORDERSKEYWORD() – Get total orders of advertised keyword between any period
  • GORILLA_ADORDERSKEYWORDHIST() – Advertising Order Keyword History
  • GORILLA_ADORDERSPROD() – Get total orders of advertised products between any period
  • GORILLA_ADORDERSPRODHIST() – Advertising Orders Product History
  • GORILLA_ADOVERVIEW() – Get total overview of the data for advertising
  • GORILLA_ADOVERVIEWHIST() – Get daily total overview of the data for advertising
  • GORILLA_ADPERFORMCAMPAIGN() – Get total perform of advertised campaigns between any period
  • GORILLA_ADPERFORMCAMPAIGNHIST() – Advertising Perform Campaign History
  • GORILLA_ADPERFORMGROUP() – Get total perform of advertised group between any period
  • GORILLA_ADPERFORMGROUPHIST() – Advertising Perform Group History
  • GORILLA_ADPERFORMKEYWORD() – Get total perform of advertised keyword between any period
  • GORILLA_ADPERFORMKEYWORDHIST() – Advertising Perform Keyword History
  • GORILLA_ADPERFORMPROD() – Get total perform of advertised products between any period
  • GORILLA_ADPERFORMPRODHIST() – Advertising Perform Product History
  • GORILLA_ADPRODLIST() – Get advertising product list
  • GORILLA_ADSALESCAMPAIGN() – Get total sales of advertised campaigns between any period
  • GORILLA_ADSALESCAMPAIGNHIST() – Advertising Sales Campaign History
  • GORILLA_ADSALESGROUP() – Get total sales of advertised group between any period
  • GORILLA_ADSALESGROUPHIST() – Advertising Sales Group History
  • GORILLA_ADSALESKEYWORD() – Get total sales of advertised keyword between any period
  • GORILLA_ADSALESKEYWORDHIST() – Advertising Sales Keyword History.
  • GORILLA_ADSALESPROD() – Get total sales of advertised products between any period
  • GORILLA_ADSALESPRODHIST() – Advertising Sales Product History
  • GORILLA_ADSPENDCAMPAIGN() – Get total advertising spend of campaign between any period
  • GORILLA_ADSPENDCAMPAIGNHIST() – Advertising Spend Campaign History
  • GORILLA_ADSPENDGROUP() – Get total advertising spend of adgroup between any period
  • GORILLA_ADSPENDGROUPHIST() – Advertising Spend Group History
  • GORILLA_ADSPENDKEYWORD() – Get total advertising spend of keywords between any period
  • GORILLA_ADSPENDKEYWORDHIST() – Advertising Spend Keyword History
  • GORILLA_ADSPENDPROD() – Get total advertising spend of product between any period
  • GORILLA_ADSPENDPRODHIST() – Advertising Spend Product History
  • GORILLA_ADSTATS() – Get Advertising Stats
  • GORILLA_ADUNITSCAMPAIGN() – Get total units of advertised campaigns between any period
  • GORILLA_ADUNITSCAMPAIGNHIST() – Advertising Units Campaign History
  • GORILLA_ADUNITSGROUP() – Get total units of advertised group between any period
  • GORILLA_ADUNITSGROUPHIST() – Advertising Units Group History
  • GORILLA_ADUNITSKEYWORD() – Get total units of advertised keyword between any period
  • GORILLA_ADUNITSKEYWORDHIST() – Advertising Units Keyword History
  • GORILLA_ADUNITSPROD() – Get total units of advertised products between any period
  • GORILLA_ADUNITSPRODHIST() – Advertising Units Product History
  • GORILLA_SBCAMPAIGNLIST() – Get advertising Brand campaign list
  • GORILLA_SBGROUPLIST() – Get advertising Brand group list
  • GORILLA_SBHIGHACOSCAMPAIGN() – Get Advertising Brand campaign with high acos
  • GORILLA_SBHIGHACOSGROUP() – Get Advertising Brand group with high acos
  • GORILLA_SBHIGHACOSKEYWORD() – Get Advertising Brand keyword with high acos
  • GORILLA_SBHIGHACOSSEARCHTERM() – Get Advertising Brand search term with high acos
  • GORILLA_SBKEYWORDLIST() – Get advertising brand keyword list
  • GORILLA_SBNEGATIVEKEYWORDLIST() – Get advertising Brand negative keyword list
  • GORILLA_SBNOSALESCAMPAIGN() – Shows all ads Brand campaign that has clicks, but no sales
  • GORILLA_SBNOSALESGROUP() – Shows all ads Brand group that has clicks, but no sales
  • GORILLA_SBNOSALESKEYWORD() – Shows all ads Brand keywords that has clicks, but no sales
  • GORILLA_SBNOSALESSEARCHTERM() – Shows all ads Brand search term that has clicks, but no sales
  • GORILLA_SBORDERSCAMPAIGN() – Get total orders of advertised Brand campaigns between any period
  • GORILLA_SBORDERSCAMPAIGNHIST() – Get Advertising Orders Brand Campaign History
  • GORILLA_SBORDERSGROUP() – Get total orders of advertised Brand group between any period
  • GORILLA_SBORDERSGROUPHIST() – Get Advertising Orders Brand Group History
  • GORILLA_SBORDERSKEYWORD() – Get total orders of advertised Brand keyword between any period
  • GORILLA_SBORDERSKEYWORDHIST() – Get Advertising Order Brand Keyword History
  • GORILLA_SBOVERVIEW() – Get total brand overview of the data for advertising
  • GORILLA_SBOVERVIEWHIST() – Get daily total Brand overview of the data for advertising
  • GORILLA_SBPERFORMCAMPAIGN() – Get total perform of advertised Brand campaigns between any period
  • GORILLA_SBPERFORMCAMPAIGNHIST() – Get Advertising Brand Perform Campaign History
  • GORILLA_SBPERFORMGROUP() – Get total perform of advertised Brand group between any period
  • GORILLA_SBPERFORMGROUPHIST() – Get Advertising Brand Perform Group History
  • GORILLA_SBPERFORMKEYWORD() – Get total perform of advertised Brand keyword between any period
  • GORILLA_SBPERFORMKEYWORDHIST() – Get Advertising Brand Perform Keyword History
  • GORILLA_SBSALESCAMPAIGN() – Get total sales of advertised Brand campaigns between any period
  • GORILLA_SBSALESCAMPAIGNHIST() – Get Advertising Brand Sales Campaign History
  • GORILLA_SBSALESGROUP() – Get total sales of advertised Brand group between any period
  • GORILLA_SBSALESGROUPHIST() – Get Advertising Brand Sales Group History
  • GORILLA_SBSALESKEYWORD() – Get total sales of advertised Brand keyword between any period
  • GORILLA_SBSALESKEYWORDHIST() – Get Advertising Brand Sales Keyword History
  • GORILLA_SBSPENDCAMPAIGN() – Get total advertising Brand spend of campaign between any period
  • GORILLA_SBSPENDCAMPAIGNHIST() – Get advertising Brand Spend Campaign History
  • GORILLA_SBSPENDGROUP() – Get total advertising Brand spend of adgroup between any period
  • GORILLA_SBSPENDGROUPHIST() – Get advertising Brand Spend Group History
  • GORILLA_SBSPENDKEYWORD() – Get total advertising Brand spend of keywords between any period
  • GORILLA_SBSPENDKEYWORDHIST() – Get Advertising Brand Spend Keyword History
  • GORILLA_SBSTATS() – Advertising Brand Stats
  • GORILLA_SBSTATSNEGATIVEKEYWORD() – Get advertising Brand stats negative keyword list
  • GORILLA_SBUNITSCAMPAIGN() – Get total units of advertised Brand campaigns between any period
  • GORILLA_SBUNITSCAMPAIGNHIST() – Get Advertising Brand Units Campaign History
  • GORILLA_SBUNITSGROUP() – Get total units of advertised Brand group between any period
  • GORILLA_SBUNITSGROUPHIST() – Get Advertising Brand Units Group History
  • GORILLA_SBUNITSKEYWORD() – Get total units of advertised Brand keyword between any period
  • GORILLA_SBUNITSKEYWORDHIST() – Get Advertising Brand Units Keyword History
• 3.Reimbursements Data/Functions
  • GORILLA_REIMBURSEDETAILS() – Display reimbursement report and individual details
  • GORILLA_REIMBURSEINVENTORY() – Display reimbursement inventory data
  • GORILLA_REIMBURSEREPLACE() – Find orders Amazon replaced and refunded
  • GORILLA_REIMBURSERETURNS() – Display reimbursement returns data