Skip to content

Save Big with Our Seller Data & Advertising Data Bundle

Gorilla ROI

Products
- Amazon to Sheets Connector
  Auto load seller central data into Google Sheets
  
  Reimbursements Data Plan
  Easily discover and recover more money from Amazon
  
  Amazon Template Package
  Visually appealing ready-made templates
Why Us?
Templates
Pricing
Resources
- LEARN
  
  Install Instructions
  
  Documentation
  
  Spreadsheet Functions
  
  Data Points Supported
  
  Contact Us
  
  FREE TOOLS & SHEETS
  
  Revenue Forecaster
  
  Amazon FBA Calculator
  
  Amazon Sales Tracker
  
  Inventory Spreadsheet
  
  Seller Fees Spreadsheet
  
  TRY SELF DEMO
  
  Free FBA Spreadsheets
  
  Our Income Reports
  
  Amazon Seller Blog
Sign In

Advertising Data Launch Promo. 75% Off Ads Data Plan until May 31.

How to use the Universal Search Bar

Search

Google Sheets Functions

How to use the Universal Search Bar
Marketplace and Country Codes
How to Use COGS Feature
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 products 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 products 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_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_BUYBOXWINNER() – See if you are winning the buy box
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 ASIN
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_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 lowest 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_PRODIDCONV() – Convert between any product ID to another product ID in the Amazon system
GORILLA_PRODUCT() – Get product info such as title, brand, weight, color
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_REFUNDSTOTAL() – Get total value of units refunded between any time period
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
GORILLA_REMOVALS() – Get FBA Recommended Removals Data
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 orders sold between any period
GORILLA_SALESCOUNTHIST() – Gets the historical number of orders sold 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_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

Home
Docs
Google Sheets Functions
How to use the Universal Search Bar

How to use the Universal Search Bar

To use the Universal Search Bar, click here, then type in any of your concerns in the search bar

OR

You can use it through any web page that shows it.

SEARCH BAR 1 Gorilla ROI

Once you have typed in on a concern, you may choose which filter option would you like to use.

Post – Blog posts from the website
Doc – Documentation results (Functions)
Page – Articles from the website

POST

POST Gorilla ROI

DOC

Doc Gorilla ROI

PAGE

Page Gorilla ROI

Still stuck? How can we help?

Updated on September 1, 2023

Doc navigation

Marketplace and Country Codes →

How can we help?

Name

Email

subject

message

PRODUCTS

Amazon Connector
Reimbursement Data
Amazon Spreadsheet Pack
White-Glove Setup

Pricing
My Account

LEARN

Test Live Demo
Data We Support
Install Instructions
Spreadsheet Functions
Videos, Docs & Tutorials

RESOURCES

Amazon Templates
FBA Revenue Calculator
Amazon Seller Blog
Our Income Reports
Revenue Calculator
Free Amazon Spreadsheets
Biggest Amazon Sellers

TUTORIALS

Amazon Seller Fees Guide
Amazon Inventory Management System
Amazon Fee Calculator
Amazon Spreadsheets
Amazon Sales Tracker

COMPANY

About Us
Contact Us
Security & Compliance
Terms of Service
Privacy Policy
My Account

© 2023 Gorilla ROI - All Rights Reserved

Products
- Amazon to Sheets Connector
  
  Reimbursement Data Plan
  
  Amazon Template Package
  
  LIVE DEMO
Why Us?
Templates
Pricing
Resources
- LEARN
  
  Install Instructions
  
  Documentation
  
  Spreadsheet Functions
  
  Data Points Supported
  
  Contact Us
  
  FREE TOOLS & SHEETS
  
  Revenue Forecaster
  
  Amazon FBA Calculator
  
  Amazon Sales Tracker
  
  Inventory Spreadsheet
  
  Seller Fees Spreadsheet
  
  TRY SELF DEMO
  
  Free FBA Spreadsheets
  
  Our Income Reports
  
  Amazon Seller Blog
Sign In
TRY LIVE DEMO