Google Sheet Formulas

Use our custom formulas to retrieve your data

Formula Name	Description
SKU LIST	Get the list of SKUs from your account
ASIN List	Get the list of ASINs from your account
Ad Spend	Get the total Ad spend for a SKU or ASIN between any period
BUYBOX COMPETITION	Get various Buy Box metrics for a given SKU or ASIN
CATEGORY	Get the category a product is listed under
CATEGORY RANK	Get the ranking of your product in its category
COGS	Get the total Cost of Goods Sold for a given period
COGS UNITCOST	Get the live COGS of your products
CONVERSIONS	Get percentage of units purchased relative to people who viewed the product
DIMENSIONS	Get the length, width and height dimensions of a product
FBA FEES	Get the estimated FBA fees for a product sale
IMAGES	Get image URLs of the product and listing
INBOUND SHIPMENTS	Get data on all your inbound shipments to Amazon
INVENTORY	Get your Amazon inventory quantities
MY PRICE	Get the seller price for a SKU or ASIN
ORDER COUNT	Get the number of orders sold between any time period
PRODUCT INFO	Get product info such as title, brand, weight and unit count
REFERRAL FEES	Get the estimated referral fees for a product sale
REFUND COUNT	Get the total number of orders refunded between any period
REFUND TOTAL	Get the total sum of refunds between any period
SALES	Get total sales or the number of units ordered between any period
SELLING FEES	Get the estimated FBA & Referral fees for a product sale
STORAGE FEES	Get your Amazon storage fees
SUMMARY REPORT	Get values shown on a monthly Amazon Summary report
TRAFFIC SHARE	Get product traffic as a percentage of total traffic
UNITS ORDERED	Get the total units ordered between any period

Formula Name	Description
SP AD REVENUE	Get revenue for sponsored product campaigns between any period
SP AD SPEND	Get spend for sponsored product campaigns between any period
SP HIGH ACOS	Get high acos stats from SP advertising
SP NO SALES	Identify campaigns with clicks and no sales
SP STATS	Get stats for your SP advertising between any period

Formula Name	Description
SB AD REVENUE	Get revenue for sponsored brands campaigns between any period
SB AD SPEND	Get spend for sponsored brands campaigns between any period
SB HIGH ACOS	Get high acos stats from SB advertising
SB NO SALES	Identify campaigns with clicks and no sales
SB STATS	Get stats for your SB advertising between any period

Formula Name	Description
SD AD REVENUE	Get revenue for sponsored display campaigns between any period
SD AD SPEND	Get spend for sponsored display campaigns between any period
SD HIGH ACOS	Get high acos stats from SD advertising
SD NO SALES	Identify campaigns with clicks and no sales
SD STATS	Get stats for your SD advertising between any period

Google Sheet Formulas

Advertising Formulas

Sponsored Product (SP)

Sponsored Brands (SB)

Sponsored Display (SD)

Getmydata

Contact Info

Learn More