The report splits into a few primary data points:
Columns A to H - General data about the listing :
- SKU
- Product name
- Vendor name
- Fulfilment Channel
- ASIN
- Reprice
- Repricing Method
- Repricing Strategy
Columns I to Q - General data about Listing quantities:
- Estimated Remaining Days of Coverage - metric is calculated by Fulfillable quantity/ 30d velocity.
- Estimated Inbound Days Of Coverage - metric is calculated by (inbound stock quantity) / 30d velocity
- Fulfillable quantity
- Total Inbound quantity
- Inbound Receiving Quantity - number of units you have for a SKU that have not yet been received at an Amazon fulfillment center for processing
- Inbound Shipped Quantity - number of units you have for a SKU in an inbound shipment that you have notified Amazon about
- Inbound Working Quantity - number of units you have for a SKU in an inbound shipment
- Warehouse Inventory - amount of inventory in Amazon warehouses
- Reserved Quantity - number of units you have for a SKU in Amazon fulfillment centers that are currently being picked, packed, and shipped
Columns R to V - Velocity data is calculated by (Sold quantity in the last X days)/X days:
- Velocity Last 7 Days
- Velocity Last 30 Days
- Velocity Last 60 Days
- Velocity Last 90 Days
- Velocity Change - Change in velocity compared to previous dates
Columns W to AA - General data about past stock and remaining stock:
- Days in stock last 7 days
- Days in stock last 30 days
- Days in stock last 60 days
- Days in stock last 90 days
- Estimated out of stock date - Estimate for when the listing will go out of stock
Columns AB to AF - Changes in sold price and price average per X days:
- Price sold change (%)
- Average price of items sold last 7 days
- Average price of items sold last 30 days
- Average price of items sold last 60 days
- Average price of items sold last 90 days
Columns AG to AK - Changes in profit and profit average per X days:
- Profit change(%)
- Average daily profit last 7 days
- Average daily profit last 30 days
- Average daily profit last 60 days
- Average daily profit last 90 days
Columns AL to AQ - Changes and Average Buy Box share per X days:
- Buy Box change (%)
- Average Buy Box Share last 24 hours
- Average Buy Box Share last 7 hours
- Average Buy Box Share last 30 hours
- Average Buy Box Share last 60 hours
- Average Buy Box Share last 90 hours
Columns AR to AU - General information about current listing prices:
- Price Position - describes where the current listed price is: floor, ceiling or in between
- Floor price
- Ceiling price
- Listing current price
Columns AV to AW - Amazon as competition data:
- Amazon Competition Last 30 days - how many days has Amazon competed with the current listing
- Amazon Buy Box share Last 30 days - Amazon's Buy Box share average as competition
Columns AX to BA - Total profit per X days:
- Profit Last 7 Days
- Profit Last 30 Days
- Profit Last 60 Days
- Profit Last 90 Days
Columns BB to BE - Number of orders in the last X days:
- Ordered items last 7 Days
- Ordered items last 30 Days
- Ordered items last 60 Days
- Ordered items last 90 Days
Columns BF to BI - Total sales in the last X days:
- Sales last 7 Days
- Sales last 30 Days
- Sales last 60 Days
- Sales last 90 Days
Columns BJ to BM - Profit margin % in the last X days:
- Profit Margin last 7 Days (%)
- Profit Margin last 30 Days (%)
- Profit Margin last 60 Days (%)
- Profit Margin last 90 Days (%)
Columns BN to BP - Average Buy Box price in the last X days:
- Average Buy Box Price last 24 hours
- Average Buy Box Price last 7 hours
- Average Buy Box Price last 30 hours
Columns BQ to BT - Average Sales Rank in the last X days:
- Average Sales Rank last 7 Days
- Average Sales Rank last 30 Days
- Average Sales Rank last 60 Days
- Average Sales Rank last 90 Days
Column BU - Minimum Buy Box price in the last 30 days
Columns BV to CL - More general information regarding the listing:
- Inventory Product Cost
- Est. Referral Fee (%)
- Est. Fulfillment Cost
- Shipping Price On Amazon
- Comment
- Vendor Part Number
- EAN - International Article Number
- UPC - Universal Product Code
- ISBN - International Standard Book Number
- Brand
- Lead Time In Days
- Minimum Advertised Price
- Activate MAP Masking - Is MAP masking activated for the listing
- Units In Pack
- Minimum Quantity For Order
- Days Of Coverage
- Parent SKU
Comments
0 comments
Please sign in to leave a comment.