Column Definition Chart
Available Columns | Description | Feature Availability | ||
Windows app | Web app | Web app Pro | ||
Amazon Link | Link to Amazon product page | Yes | Yes | Yes |
Amazon Seller | Returns whether Amazon is a current competing seller on listing. More Information | Limited | Yes | |
Amazon Seller InStock Rate 30d | % of time Amazon was a competing seller on listing in last 30 days | Yes | ||
Amazon Seller InStock Rate 90d | % of time Amazon was a competing seller on listing in last 90 days | Yes | ||
Amazon Seller InStock Rate 180d | % of time Amazon was a competing seller on listing in last 180 days | Yes | ||
ASIN | ASIN identifier of product | Yes | Yes | Yes |
Avg Buybox 30d | Average BuyBox sell price on listing in the last 30 days | Yes | ||
Avg Buybox 90d | Average BuyBox sell price on listing in the last 90 days | Yes | ||
Avg Buybox 180d | Average BuyBox sell price on listing in the last 180 days | Yes | ||
Avg Sales Rank 30d | Average Sales Rank on listing in the last 30 days | Yes | ||
Avg Sales Rank 90d | Average Sales Rank on listing in the last 90 days | Yes | ||
Avg Sales Rank 180d | Average Sales Rank on listing in the last 180 days | Yes | ||
B2B Sales Rank | Sales Rank as it relates only to Amazon Business purchases | BPO Only | BPO Only | |
B2B Sales Rank Growth | Growth in B2B Sales Rank expressed as HIGH, MEDIUM, LOW | BPO Only | BPO Only | |
Brand | Brand name of product | Yes | Yes | Yes |
Brand You Offer | Indicates whether the BPO product is sold by a brand you have a history of selling | BPO Only | BPO Only | |
Buy Box Landed | Active BuyBox sell price on listing + buyer’s shipping charge (if any) | Yes | Yes | Yes |
BuyBox Contention | Number of FBA offers that are competing for and are rotating on the Buybox | Yes | Yes | Yes |
Buyer Industry | Industry the Buyer is in that made a request for Amazon to sell this product. | BPO Only | BPO Only | |
CamelCC | CamelCamelCamel.com link showing sell price history chart | Yes | Yes | Yes |
Category | The name of a product category, such as Sporting Goods, to which a product belongs to. Column name changed from “Product Group” to “Category” 10/2022. | Yes | Yes | Yes |
Category You Offer | Indicates whether the BPO product is sold in an Amazon Category that you have a history of selling in | BPO Only | BPO Only | |
Color | Color of product | Yes | Yes | Yes |
Cost | Unit cost of purchasing the product from your supplier, also known as cost of goods sold (COGS). The app gets this data from your supplier sheet and uses it to calculate Profit calculations. This cell can be edited for custom calculations. Column name changed from “Purchase Price” to “Cost” 10/2022. | Yes | Yes | Yes |
Cost Sub Total | Total fees charged by Amazon. Referral Fee + Variable Closing Fee + Fulfillment Subtotal (FBA fees, if applicable) | Yes | Yes | Yes |
Custom Notes | Add your notes about a product into the grid for any product. Notes are automatically saved | Yes | Yes | Yes |
Date Buyer Requested | Date the Buyer made the request for Amazon to sell a product that does not currently have an Amazon listing | BPO Only | BPO Only | |
EAN | EAN of product | BPO Only | BPO Only | |
Est Sales | Estimated number of products that are sold on a listing on a monthly basis. Est Sales are shared by all sellers sharing the BuyBox. See BuyBox Contention | Yes | Yes | Yes |
Favorites | Add/Remove products to your custom Favorites lists. Solid star represents a product already added to a Favorites list | Yes | Yes | |
Fulfillment Subtotal | Sum of Amazon FBA fulfillment fees | Yes | Yes | Yes |
Inbound Shipping Estimate | Cost of shipping the product (ie: to an Amazon fulfillment center). Added as an optional cost in “Additional Expenses” screen. Expressed as an average cost per lb. assumption which is applied to all products | Yes | Yes | Yes |
ISBN | ISBN of product | BPO Only | BPO Only | |
Is Hazmat | Indicates whether Amazon classifies product as Hazardous / Dangerous Goods | Yes | Yes | |
Is Top Level Category | Indicates if the Category of the product is a top level category. This is relevant when analyzing sales as sub-category products are generally not ranked in the top level category due to lack of sales. See Category. | Yes | Yes | |
Keepa | Keepa link showing historical sell price and sales velocity chart | Yes | Yes | Yes |
Last Run | Date and time the product was last processed by the app. Results can be refreshed in the app by using the Refresh feature | Yes | Yes | |
Lowest FBA | Lowest FBA fulfilled sell price on a product listing. Column name changed from “Low New FBA Price” to “Lowest FBA” 10/2022. | Yes | Yes | Yes |
Lowest FBM | Lowest merchant fulfilled sell price + shipping (if applicable) on a product listing. Column name changed from “Low New Mfn Price” to “Lowest FBM” 10/2022. | Yes | Yes | Yes |
Lowest Price Last Week | The lowest sell price on a BPO product listing over the last 7 days | BPO Only | BPO Only | |
Lowest Sales Rank 30d | Lowest Sales Rank on listing in the last 30 days | Yes | ||
Lowest Sales Rank 90d | Lowest Sales Rank on listing in the last 90 days | Yes | ||
Lowest Sales Rank 180d | Lowest Sales Rank on listing in the last 180 days | Yes | ||
Manufacturer | Manufacturer of product | Yes | Yes | Yes |
Margin % | Profit Margin % = Profit / Sell Price | Yes | Yes | Yes |
Model | Model of product | Yes | Yes | Yes |
New FBA Offers | Number of FBA sellers on product listing. Column name changed from “New FBA Num Offers” to “New FBA Offers” 10/2022. | Yes | Yes | Yes |
New FBM Offers | Number of merchant fulfilled sellers on product listing. Column name changed from “New MFN Num Offers” to “New FBA Offers” 10/2022. | Yes | Yes | Yes |
Package Dimensions | Package Length x Width x Height | Yes | Yes | Yes |
Package Quantity | Quantity of product packs sold together in one bundle. Used for multi-pack calculations. This cell can be edited for custom calculations | Yes | Yes | Yes |
Package Weight | Package weight. Important for shipping cost | Yes | Yes | Yes |
Page Views | Volume of product Page Views expressed as HIGH, MEDIUM, LOW | BPO Only | BPO Only | |
Parent ASIN | The parent ASIN for a listing with variations | Yes | Yes | Yes |
Part Number | Part number of product | Yes | Yes | Yes |
Product ID | Shows the UPC, EAN, ASIN or ISBN from your supplier sheet that was used to match the product to Amazon. Useful for reconciling results to original product on the supplier sheet | Yes | Yes | Yes |
Product Performance | Product Performance expressed as HIGH, MEDIUM, LOW | BPO Only | BPO Only | |
Profit | Profit on each unit sale. Sell Price minus all costs associated with selling on Amazon ie: shipping, taxes, additional fees (if applicable) | Yes | Yes | Yes |
Rating | Average customer review rating on listing | Limited | Yes | |
Referral Fee | Amazon FBA fee charged to seller. For more information on FBA Fees visit Selling on Amazon Fee Schedule | Yes | Yes | Yes |
Reviews | Number of customer reviews on listing | Limited | Yes | |
ROI | Return on Investment (ROI) = Profit / Cost | Yes | Yes | Yes |
Sales Rank | Indicates how well a product is selling within its product category. The lower the number, the better the product has sold | Yes | Yes | Yes |
Sales Rank Drops 30d | The number of Sales Rank “drops” recorded on historical chart in last 30 days. Sales Rank drops correspond to sales but are only a directional guide since sales velocity, inventory changes, chart coverage, etc., all plays a role. | Yes | ||
Sales Rank Drops 90d | The number of Sales Rank “drops” recorded on historical chart in last 90 days. Sales Rank drops correspond to sales but are only a directional guide since sales velocity, inventory changes, chart coverage, etc., all plays a role. | Yes | ||
Sales Rank Drops 180d | The number of Sales Rank “drops” recorded on historical chart in last 180 days. Sales Rank drops correspond to sales but are only a directional guide since sales velocity, inventory changes, chart coverage, etc., all plays a role. | Yes | ||
Sell Price | Assumed sell price of product. FBA fees & Profit calculations are based on this price. App will assume sell price to either a) Low FBA Price or b) Low FBM Price (if no FBA fulfilled sellers exist on listing). This cell can be edited for custom calculations | Yes | Yes | Yes |
Seller Proceeds | Gross profit before cost of goods sold. Sell price – Cost Subtotal | Yes | Yes | Yes |
Sub Category | Sub Category of product | Yes | Yes | |
Title | Title of the product’s Amazon listing | Yes | Yes | Yes |
Total Offers | Total number of FBA and MFN sellers on listing | Yes | Yes | Yes |
UPC | UPC of product | Yes | Yes | |
Variable Closing Fee | Amazon FBA fee charged to seller. For more information on FBA Fees visit Selling on Amazon Fee Schedule | Yes | Yes | Yes |
Variation Count | Number of variations associated with product | Yes | ||
VAT % | VAT % used to calculate VAT $. This cell can be edited for custom % calculations | Yes | Yes | Yes |
VAT $ | VAT tax applied per settings in Additional Expenses settings | Yes | Yes | Yes |