Skip to main content
All Collections
Google Sheets Functions

Google Sheets Functions

Articles to help you with our Google Sheets custom functions.

226 articles
Market Data Plan Functions
GORILLA_ASINLIST() – Get the list of ASINs under your account.
GORILLA_ASINSTATUS() – Get the active & inactive status of the ASINs
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_INBOUNDSHIPAWD() - Dump AWD inbound shipments data
GORILLA_INBOUNDSHIPITEMS() – Get inbound shipment data by SKU
GORILLA_INBOUNDSHIPITEMSAWD() - Dump AWD inbound shipment items data
GORILLA_INVENTORY() – Get quantity and status of inventory
GORILLA_INVENTORYAGE() – Get the inventory age for a given SKU or ASIN
GORILLA_INVENTORYAWD() – Get inventory data from AWD for given sku
GORILLA_INVENTORYHEALTH() – Get detailed inventory metrics
GORILLA_INVENTORYHIST() – Show inventory history of products.
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 number of units ordered 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
Ads Data Plan Functions
GORILLA_ADIDCONV() – Seamlessly Convert Sponsored Products ID to another.
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
GORILLA_SDCAMPAIGNLIST() – Get Sponsored Display campaign list
GORILLA_SDGROUPLIST() – Get Sponsored Display group list
GORILLA_SDHIGHACOSCAMPAIGN() – Sponsored Display campaign with high acos
GORILLA_SDHIGHACOSGROUP() – Sponsored Display group with high acos
GORILLA_SDNOSALESCAMPAIGN() – Shows all Sponsored Display campaign that has clicks, but no sales
GORILLA_SDNOSALESGROUP() – Shows all Sponsored Display group that has clicks, but no sales
GORILLA_SDORDERSCAMPAIGN() – Get total orders of Sponsored Display campaigns between any period.
GORILLA_SDORDERSCAMPAIGNHIST() – Sponsored Orders display Campaign History
GORILLA_SDORDERSGROUP() – Get total orders of Sponsored Display group between any period.
GORILLA_SDORDERSGROUPHIST() – Sponsored Orders Display Group History.
GORILLA_SDORDERSPROD() – Get total orders of Sponsored Display products between any period.
GORILLA_SDORDERSPRODHIST() – Sponsored Display Orders Product History.
GORILLA_SDOVERVIEW() – Get total overview of the data for Sponsored Display
GORILLA_SDOVERVIEWHIST() – Get daily total overview of the data for Sponsored Display
GORILLA_SDPERFORMCAMPAIGN() – Get total perform of Sponsored Display campaigns between any period.
GORILLA_SDPERFORMCAMPAIGNHIST() – Sponsored Display Perform Campaign History.
GORILLA_SDPERFORMGROUP() – Get total perform of Sponsored Display group between any period.
GORILLA_SDPERFORMGROUPHIST() – Sponsored Display Perform Group History.
GORILLA_SDPERFORMPROD() – Get total perform of Sponsored Display products between any period.
GORILLA_SDPERFORMPRODHIST() – Sponsored Display Perform Product History.
GORILLA_SDPRODLIST() – Get Sponsored Display product list
GORILLA_SDSALESCAMPAIGN() – Get total sales of Sponsored Display campaigns between any period.
GORILLA_SDSALESCAMPAIGNHIST() – Sponsored Display Sales Campaign History.
GORILLA_SDSALESGROUP() – Get total sales of Sponsored Display group between any period.
GORILLA_SDSALESGROUPHIST() – Sponsored Display Sales Group History.
GORILLA_SDSALESPROD() – Get total sales of Sponsored Display products between any period
GORILLA_SDSALESPRODHIST() – Sponsored Display Sales Product History.
GORILLA_SDSPENDCAMPAIGN() – Get total advertising spend of campaign between any period
GORILLA_SDSPENDCAMPAIGNHIST() – Sponsored Display Spend Campaign History
GORILLA_SDSPENDGROUP() – Get total Sponsored Display spend of adgroup between any period
GORILLA_SDSPENDGROUPHIST() – Sponsored Display Spend Group History
GORILLA_SDSPENDPROD() – Get total Sponsored Display spend of product between any period.
GORILLA_SDSPENDPRODHIST() – Sponsored Display Spend Product History.
GORILLA_SDSTATS() – Sponsored Display Stats
GORILLA_SDUNITSCAMPAIGN() – Get total units of Sponsored Display campaigns between any period
GORILLA_SDUNITSCAMPAIGNHIST() – Sponsored Display Units Campaign History
GORILLA_SDUNITSGROUP() – Get total units of Sponsored Display group between any period.
GORILLA_SDUNITSGROUPHIST() – Sponsored Display Units Group History
GORILLA_SDUNITSPROD() – Get total units of Sponsored Display products between any period
GORILLA_SDUNITSPRODHIST() – Sponsored Display Units Product History
GORILLA_SPCAMPAIGNLIST() – Get advertising campaign list
GORILLA_SPGROUPLIST() – Get advertising group list
GORILLA_SPHIGHACOSCAMPAIGN() – Advertising campaign with high acos
GORILLA_SPHIGHACOSGROUP() – Advertising group with high acos
GORILLA_SPHIGHACOSSEARCHTERM() – Advertising search term with high acos
GORILLA_SPKEYWORDLIST() - Get advertising keyword list
GORILLA_SPNOSALESCAMPAIGN() – Shows all ads campaign that has clicks, but no sales
GORILLA_SPNOSALESGROUP() – Shows all ads group that has clicks, but no sales
GORILLA_SPNOSALESKEYWORD() – Shows all ads keywords that has clicks, but no sales
GORILLA_SPORDERSCAMPAIGN() – Get total orders of advertised campaigns between any period
GORILLA_SPORDERSCAMPAIGNHIST() – Advertising Orders Campaign History
GORILLA_SPORDERSGROUP() – Get total orders of advertised group between any period
GORILLA_SPORDERSGROUPHIST() – Advertising Orders Group History
GORILLA_SPORDERSKEYWORD() – Get total orders of advertised keyword between any period
GORILLA_SPORDERSKEYWORDHIST() – Advertising Order Keyword History
GORILLA_SPORDERSPROD() – Get total orders of advertised products between any period
GORILLA_SPORDERSPRODHIST() – Advertising Orders Product History
GORILLA_SPOVERVIEW() – Get total overview of the data for advertising
GORILLA_SPOVERVIEWHIST() – Get daily total overview of the data for advertising
GORILLA_SPPERFORMCAMPAIGN() – Get total perform of advertised campaigns between any period
GORILLA_SPPERFORMCAMPAIGNHIST() – Advertising Perform Campaign History
GORILLA_SPPERFORMGROUP() – Get total perform of advertised group between any period
GORILLA_SPPERFORMGROUPHIST() – Advertising Perform Group History
GORILLA_SPPERFORMKEYWORD() – Get total perform of advertised keyword between any period
GORILLA_SPPERFORMKEYWORDHIST() – Advertising Perform Keyword History
GORILLA_SPPERFORMPROD() – Get total perform of advertised products between any period
GORILLA_SPPERFORMPRODHIST() – Advertising Perform Product History
GORILLA_SPPRODLIST() – Get advertising product list
GORILLA_SPSALESCAMPAIGN() – Get total sales of advertised campaigns between any period
GORILLA_SPSALESCAMPAIGNHIST() – Advertising Sales Campaign History
GORILLA_SPSALESGROUP() – Get total sales of advertised group between any period
GORILLA_SPSALESGROUPHIST() – Advertising Sales Group History
GORILLA_SPSALESKEYWORD() – Get total sales of advertised keyword between any period
GORILLA_SPSALESKEYWORDHIST() – Advertising Sales Keyword History.
GORILLA_SPSALESPROD() – Get total sales of advertised products between any period
GORILLA_SPSALESPRODHIST() – Advertising Sales Product History
GORILLA_SPSPENDCAMPAIGN() – Get total advertising spend of campaign between any period
GORILLA_SPSPENDCAMPAIGNHIST() – Advertising Spend Campaign History
GORILLA_SPSPENDGROUP() – Get total advertising spend of adgroup between any period
GORILLA_SPSPENDGROUPHIST() – Advertising Spend Group History
GORILLA_SPSPENDKEYWORD() – Get total advertising spend of keywords between any period
GORILLA_SPSPENDKEYWORDHIST() – Advertising Spend Keyword History
GORILLA_SPSPENDPROD() – Get total advertising spend of product between any period
GORILLA_SPSPENDPRODHIST() – Advertising Spend Product History
GORILLA_SPSTATS() – Get Advertising Stats
GORILLA_SPUNITSCAMPAIGN() – Get total units of advertised campaigns between any period
GORILLA_SPUNITSCAMPAIGNHIST() – Advertising Units Campaign History
GORILLA_SPUNITSGROUP() – Get total units of advertised group between any period
GORILLA_SPUNITSGROUPHIST() – Advertising Units Group History
GORILLA_SPUNITSKEYWORD() – Get total units of advertised keyword between any period
GORILLA_SPUNITSKEYWORDHIST() – Advertising Units Keyword History
GORILLA_SPUNITSPROD() – Get total units of advertised products between any period
GORILLA_SPUNITSPRODHIST() – Advertising Units Product History