Amazon Reports
Overview reports
Under Reports, you may download various reports. For some reports, you can limit or expand the result using filters.
Importing the reports into Excel & Co. These reports contain CSV files separated by a comma. To import them into Excel, we recommend the following path: Data -> From Text | Character Set: UTF-8 | Separator: Comma
We use the comma as the decimal separator. US customers need to change this setting when importing our CSV files, e.g., Excel. Please go to the Advanced Settings and choose the comma as the decimal separator and the dot for the thousands separator. Please check this thread for additional help.
Scheduled reports
You can also schedule recurring reports so they will be automatically executed in the future, e.g. on a monthly, weekly or daily basis.
You can decide if you want to get those reports via email or via FTP.
E-Mail delivery:
FTP delivery:
Reports can also scheduled and just stored within AMALYTIX. Choose "AMALYTIX" as the distribution channel in this case.
You can see the list of all scheduled reports under Scheduled reports.
Types
- Seller Seller products (long)
- Seller Seller products (short)
- Seller FBA inventory report
- Seller Customer returns (FBA)
- Seller Customer returns (FBA)
- Seller Vendor Watchlist products (long)
- Seller Vendor Watchlist products (short)
- Seller Orders report
- Seller Orders per day
- Seller Performance time comparison
- Seller Vendor Keywords
- Seller Vendor SERP
- Seller Vendor Alerts
- Seller Seller list (Seller products)
- Seller Vendor Seller list (Watchlist)
- Seller Vendor Reviews
- Seller Vendor Questions
- Seller Seller feedback
- Vendor Vendor products
- Vendor Vendor inventory (weekly)
- Vendor Vendor sales
- Vendor Vendor orders
- Seller Session and conversion data (by days)
- Seller Financial events
- Seller Vendor Product Ratings
- Seller Vendor GPSR Issues
The following will show which report contains which fields:
Seller products (long)
The report Seller products (long) contains the following fields at the time the report was created:
- Currency
- ASIN (child)
- Marketplace
- SKUs
- EAN
- Tags
- ASIN (parent)
- Buybox sales price value
- Buybox sellerId
- Buybox sellerName
- Buybox fullfillmentTypeBuybox
- Total inventory level FBA
- Brand name
- Product Title
- Seller has the buybox
- Sellers count
- Sellers lowest price
- Sellers lowest price FBA
- Sellers lowers price FBM
- Reviews: Number of reviews parent
- Reviews: Average rating parent
- Reviews: Number of reviews child
- Reviews: Average rating child
- LQI total value
- Bestseller rank top category value
- Bestseller rank top category name
- Bestseller rank subcategory value
- Bestseller rank subcategory name
- Orders revenues sum last 28 days
- Average refund rate last 60 days
- Sessions last 28 days
- Average conversion rate last 28 days
- Number of SKUs
- Description type
- Availability
- Profitability
- Profitability in percent
- Content Protection Status
- Snapshot Match Title
- Snapshot Match Keywords
- Snapshot Match Brand Store ID
- Snapshot Match Number of Variations
- Snapshot Match Bulletpoints
- Snapshot Match Description
- Recommended Retail Price
- Has Base Price
- Image URL
- Reviews: Number of reviews parent 1 star
- Reviews: Number of reviews parent 2 star
- Reviews: Number of reviews parent 3 star
- Reviews: Number of reviews parent 4 star
- Reviews: Number of reviews parent 5 star
- Reviews: Number of reviews child 1 star
- Reviews: Number of reviews child 2 star
- Reviews: Number of reviews child 3 star
- Reviews: Number of reviews child 4 star
- Reviews: Number of reviews child 5 star
- Image Count
- Video Count
- Image Hi-Res Count
- Description
- Generic Keywords
- Generic Keywords (Bytes)
- Bullet Point 1
- Bullet Point 2
- Bullet Point 3
- Bullet Point 4
- Bullet Point 5
Seller products (short)
The report Seller products (short) corresponds to a short version of the long list without the fields product description, URL image, attributes, and details concerning the reviews for x stars.
- Currency
- ASIN (child)
- Marketplace
- SKUs
- EAN
- Tags
- ASIN (parent)
- Buybox sales price value
- Buybox sellerId
- Buybox sellerName
- Buybox fullfillmentTypeBuybox
- Total inventory level FBA
- Brand name
- Product Title
- Seller has the buybox
- Sellers count
- Sellers lowest price
- Sellers lowest price FBA
- Sellers lowers price FBM
- Reviews: Number of reviews parent
- Reviews: Average rating parent
- Reviews: Number of reviews child
- Reviews: Average rating child
- LQI total value
- Bestseller rank top category value
- Bestseller rank top category name
- Bestseller rank subcategory value
- Bestseller rank subcategory name
- Orders revenues sum last 28 days
- Average refund rate last 60 days
- Sessions last 28 days
- Average conversion rate last 28 days
- Number of SKUs
- Description type
- Availability
- Profitability
- Profitability in percent
- Content Protection Status
- Snapshot Match Title
- Snapshot Match Keywords
- Snapshot Match Brand Store ID
- Snapshot Match Number of Variations
- Snapshot Match Bulletpoints
- Snapshot Match Description
- Recommended Retail Price
- Has Base Price
Seller Products Histores (daily data)
- Date
- Market
- ASIN
- Tags
- Status
- Revenues
- Sales
- Page Views
- Sessions
- Conversion Rate
- Buybox
- Buybox Price
- Buybox Seller Name
- Seller Has Buybox
- Buybox Percentage
- Bestseller Rank
- Average Rating
- Number of Reviews
- Top Reviews Local Average Rating
- LQI
- Currency
FBA Inventory Report
This report contains the fields of page FBA Inventory:
- SKU
- Product hidden
- ASIN (child)
- Region
- Marketplace
- Tags
- ASIN (parent)
- Brand name
- Product Title
- Total inventory level FBA
- In-Market inventory level FBA
- Inbound Working Quantity
- Inbound Shipped Quantity
- Inbound Receiving Quantity
- Reserved Quantity
- Amazon recommendation
- Minimum inventory level
- Minimum inventory lead time
- Duration min
- Duration max
- Duration 30d
- Sales last 7 days
- Sales last 30 days
- Sales last 60 days
- Sales last 90 days
- Long-term storage fee 6 Mo (EUR)
- Long-term storage fee 6 Mo (quantity)
- Long-term storage fee 12 Mo (EUR)
- Long-term storage fee 12 Mo (quantity)
- Age < 90
- Age 91-180
- Age 181-270
- Age 271-365
- Age 365+
- Longest side
- Median side
- Shortest side
- Measurement units
- Weight
- Weight units
- Item volume
- Volume units
- Average quantity on hand
- Average quantity pending removal
- Estimated total item volume
- Estimated monthly storage fee
- Currency
- Inventory Value
Customer returns (FBA)
This report contains the fields:
- ASIN (child)
- SKU
- FNSKU
- Product title
- Customer return date
- Order Id
- Quantity
- Disposition
- Reason
- Return status
- License Plate Number
- Customer Comment
- Seller ID
Watchlist products (long)
This report contains the fields:
- Marketplace
- ASIN (child)
- ASIN (parent)
- Currency
- EAN
- Tags
- Buybox Price
- Buybox sales price value
- Buybox sellerId
- Buybox sellerName
- Buybox fullfillmentTypeBuybox
- Brand name
- Product Title
- Seller has the buybox
- Sellers count
- Sellers lowest price
- Lowest price FBA
- Lowers price FBM
- Number of Reviews
- Average Rating
- Star rating for the child ASIN
- Number of star ratings for the child ASIN
- LQI total value
- Bestseller rank top category value
- Bestseller rank top category name
- Bestseller rank subcategory value
- Bestseller rank subcategory name
- Description type
- Amazon has Offer
- Amazon has Buybox
- Amazon Price
- Availability
- Sales Estimate
- Has Addon Options
- Addon Options ASINs
- Addon Options Count
- Recommended Retail Price
- Image Count
- Image Hi-Res Count
- Has 360 degree image
- Brand Story (A+)
- Description
- Generic Keywords
- Generic Keywords (Bytes)
- Bullet Point 1
- Bullet Point 2
- Bullet Point 3
- Bullet Point 4
- Bullet Point 5
- Snapshot Match Title
- Snapshot Match Bulletpoints
- Snapshot Match Keywords
- Snapshot Match Description
- Snapshot Match Brand Store ID
- Snapshot Match Number of Variations
Watchlist products (short)
This report contains the fields:
- Currency
- Product hidden
- ASIN (child)
- EAN
- Marketplace
- Tags
- ASIN (parent)
- Buybox list price value
- Buybox sales price value
- Buybox sellerId
- Buybox sellerName
- Buybox fullfillmentTypeBuybox
- Brand name
- Product Title
- Seller has the buybox
- Sellers count
- Sellers lowest price
- Sellers lowest price FBA
- Sellers lowers price FBM
- Reviews: Number of reviews parent
- Reviews: Average rating parent
- Reviews: Number of reviews child
- Reviews: Average rating child
- LQI total value
- Bestseller rank top category value
- Bestseller rank top category name
- Bestseller rank subcategory value
- Bestseller rank subcategory name
- Add-on product
- Pantry product
- Description type
- Amazon has Offer
- Amazon has Buybox
- Amazon Price
- Availability
- Sales Estimate
- Has Addon Options
- Addon Options ASINs
- Addon Options Count
- Recommended Retail Price
Performance time comparison
The report Performance time comparison makes it possible to compare significant product constants for a given time and the previous period of the same length. The report can compare the following parameters:
- Currency
- Product hidden
- ASIN (child)
- Marketplace
- Tags
- ASIN (parent)
- Brand name
- Product Title
- Current period: Revenues
- Current period: Number of orders
- Current period: Sum of quantities
- Current period: Sessions
- Current period: Average conversion rate
- Current period: Average bestseller rank
- Current period: Average Buybox price
- Previous period: Revenues
- Previous period: Number of orders
- Previous period: Sum of quantities
- Previous period: Sessions
- Previous period: Average conversion rate
- Previous period: Average bestseller rank
- Previous period: Average Buybox price
Orders
- Marketplace
- Order Id
- DateTime
- Status
- Fulfillment
- Customer postal code
- Customer city
- Customer country
- Total order value before promotions
- Total promotions value
- Promotion name
- Total order value after promotions
- Order item product title
- Order item product quantity
- Order item product ASIN
- Order item product SKU
- Order item product price
- Order item product promotion
- Currency
- Is Business Order
Orders per day
This report contains a list of your revenues per day and fulfillment type.
- Date
- Marketplace
- Fulfillment
- Revenues
- Sum of orders
- Sum of quantities
Keywords
The report Keywords can process the following parameters:
- Keyword
- Marketplace
- Search Volume
- CPC
- Competition
- Last Updated
- SV Date
SERP
- Marketplace
- Keyword
- Keyword tags
- Week of year
- ASIN
- Product title
- Brand name
- Product List
- Product tags
- Product URL
- Page number
- Organic rank
- Total rank
- Organic
- Video
Alerts
The report Alerts can process the following parameters:
- ASIN
- Product Brand
- Product Title
- Marketplace
- Tags
- List
- Alert type
- Date created
- Alert meta
- Notified
- Hidden
Seller List (Seller products)
- Date
- ASIN
- Marketplace
- Seller Name
- Seller ID
- Price
- Shipping Price
- Currency
- Is Prime
- Is New Item
- Has Buybox
Seller List (Watchlist)
The report Seller List (Watchlist) can process the following parameters:
- Marketplace
- Date from
- Date until
The following fields are then returned:
- Date
- ASIN
- Marketplace
- Seller Name
- Seller ID
- Price
- Shipping Price
- Currency
- Is Prime
- Is New Item
Reviews
- ASIN (child)
- ASIN (parent)
- SKU
- Review Url
- Review Author
- Review Author Url
- Review Title
- Review Text
- Review Date
- Review Notes
- Review Rating
- Verified
- Marketplace
- List
- Product Title
- Product Brand
- Product Rating
- Product Number of Reviews
- Product URL
- Review Status
- Vine Review
- Top review local
- Top review global
- Review deleted
- Review Number Of Comments
Customer questions
- ASIN (child)
- ASIN (parent)
- Question Url
- Question Text
- Question Date
- Question Status
- Marketplace
- List
- Product Title
- Product Brand
- Product URL
- Answer
- Answer Count
- Answer Author
- Answer Date
- Answer Seller
Keyword search volume
The following fields are returned:
- Keyword
- Marketplace
- Search volume
- CPC
- Competition
- Last updated
- SV201911
- SV201912 ...
Seller feedback
The report Seller feedback can process the following parameters:
- Marketplace
- Feedback Author
- Feedback Text
- Feedback Date
- Feedback Notes
- Feedback Comment
- Feedback Rating
- Feedback Status
Vendor Products
- Marketplace
- ASIN
- ASIN (parent)
- EAN
- UPC
- SKU
- Brand Code
- Brand name
- Tags
- Is Hidden
- Product Status
- Product Title
- Product Group
- Color
- Binding
- Revenues 30d
- Sales 30d
- Units Returned 30d
- Sales Change 14d
- Cost Received
- Buybox
- Amazon has Offer
- Amazon has Buybox
- Buybox Price
- Number of Sellers
- Amazon Price
- Recommended Retail Price
- Lowest Prime Price
- Lowest FBM Price
- Buybox Seller Name
- Availability
- Number of variations
- Net Pure Product Margin
- Has Bestseller Badge
- Has Amazon Choice Badge
- Has Addon Options
- Addon Options ASINs
- Addon Options Count
- Prime Only
- Is Virtual Bundle
- Category Path
- Top Level Category
- Detail Level Category
- Category
- Subcategory
- Bestseller Rank
- Number of Reviews
- Average Rating
- Star rating for the child ASIN
- Number of star ratings for the child ASIN
- Title length
- Title compliant
- Bullet Points
- Number of BulletPoints
- Generic Keywords
- Generic Keywords (Bytes)
- Description
- Description Length
- Brand Description
- Description type
- Aplus Comparison Table
- Brand Story (A+)
- Image URL
- Image Count
- Image Hi-Res Count
- Video Count
- Brand Store ID
- Snapshot Match Title
- Snapshot Match Bulletpoints
- Snapshot Match Keywords
- Snapshot Match Description
- Snapshot Match Brand Store ID
- Snapshot Match Number of Variations
- Content Protection Status
- LQI total value
- Vendor Price
- Vendor Cost
- Replenishment Code
- Sellable (units)
- Sellable (costs)
- Duration in days
- Sell through Rate
- Unsellable (units)
- Unsellable (cost)
- Unhealthy inventory (units)
- Unhealthy inventory (costs)
- Aged 90d Sellable Inventory
- Aged 90d Sellable Units
- Unfullf. ordered units
- Net received (units)
- Net received (costs)
- Ordered units
- Comment
- Currency
- Url
- Last Updated at
- Created at
- Last crawl date
Vendor Products Histores (daily data))
- Date
- Market
- ASIN
- Tags
- Status
- Shipped Units Sourcing
- Shipped COGS Sourcing
- Customer Returns Sourcing
- Shipped Units Manufacturing
- Shipped COGS Manufacturing
- Ordered Units Sourcing
- Ordered Revenues Manufacturing
- Customer Returns Manufacturing
- Procurable Product Out Of Stock Rate
- Glance Views
- Buybox
- Buybox Price
- Buybox Seller Name
- Amazon Has Buybox
- Bestseller Rank
- Average Rating
- Number of Reviews
- Top Reviews Local Average Rating
- LQI
- Currency
Vendor Inventory (weekly)
- ASIN
- Marketplace
- Currency
- Product Title
- Brand name
- Brand Code
- SKU
- EAN
- UPC
- ASIN (parent)
- Sellable (units)
- Sellable (costs)
- Sales 30 days
- Duration in days
- Sell through Rate
- Unsellable (units)
- Unsellable (cost)
- Unhealthy inventory (units)
- Unhealthy inventory (costs)
- Aged 90d Sellable Inventory
- Aged 90d Sellable Units
- Unfullf. ordered units
- Net received (units)
- Net received (costs)
- Ordered units
- Replenishment Code
- Distributor view
- Date
Vendor Sales
The report Vendor Sales can process the following parameters:
- ASIN
- Marketplace
- Currency
- ASIN (parent)
- Product Title
- Brand name
- Brand Code
- SKU
- EAN
- UPC
- Units Shipped
- Shipped COGS
- Units Returned
- Shipped Revenue
- Ordered Units
- Ordered Revenue
- Glance Views
- Conversion Rate
- Distributor view
- Reporting Date
Vendor Orders
- Vendor ID
- Market
- Order Number
- Order State
- Order Status
- Order Type
- Sequence number
- ASIN
- SKU
- Title
- sellingPartyId
- buyingPartyId
- shipToPartyId
- billToPartyId
- deliveryWindowStart
- deliveryWindowEnd
- Order Date
- Order state changed date
- Quantity
- Quantity measure
- Quantity unit size
- Quantity accepted
- Quantity accepted measure
- Quantity accepted unit size
- Quantity rejected
- Quantity rejected measure
- Quantity rejected unit size
- Quantity received
- Quantity received measure
- Quantity received unit size
- Cancelled received
- Cancelled received measure
- Cancelled received unit size
- Is back order allowed
- Net cost
- Net cost currency
- Total cost
- Total cost currency
- List price cost
- List price currency
- Confirmation status
- receive status
- Sales last 30 days
- Days of cover
- Inventory
- Product status
- Amazon has Offer
- Amazon has buybox
- Updated from Vendor Product
Session and conversion data (by days)
The report Session and conversion data (by days) can process the following parameters:
- Marketplace
- ASIN
- ASIN (parent)
- Product Title
- Date
- orderSessionPercentage
- totalOrderItems
- orderedProductSales
- unitSessionPercentage
- unitsOrdered
- buyboxPercentage
- pageViewsPercentage
- pageViews
- sessionPercentage
- sessions
- Currency
Financial Events
The report Financial Events can process the following parameters:
- Type 1 ("Refund" or "Shipment")
- Type 2 ("Charge" or "Fee")
- Type 3 (e.g. "Principal", "Commission", ...)
- Date
- Seller ID
- Market
- Order Id
- SKU
- Quantity Shipped
- Amount
- Currency
Product Ratings
- Marketplace
- ASIN
- Parent ASIN
- List Type
- Product Title
- Brand
- Tags
- Total Reviews
- Total Stars
- Total Reviews and Stars
- Average Rating Reviews
- Average Rating Stars
- Average Rating Total
- 1 Star Reviews
- 1 Star Stars
- 1 Star Reviews and Stars
- 2 Star Reviews
- 2 Star Stars
- 2 Star Reviews and Stars
- 3 Star Reviews
- 3 Star Stars
- 3 Star Reviews and Stars
- 4 Star Reviews
- 4 Star Stars
- 4 Star Reviews and Stars
- 5 Star Reviews
- 5 Star Stars
- 5 Star Reviews and Stars
- Last updated
Vouchers
- Type
- Market
- Marketplace ID
- Campaign ID
- Campaign Name
- Vendor Code
- Creation Date
- Last Updated Date
- Is Subscribe And Save
- Budget Type
- Total Clips
- Total Redemptions
- Coupon ID
- Merchant ID
- Name
- Website Message
- Start Date
- End Date
- Is Once Per Customer
- Customer Segment
- Clips
- Redemptions
- Budget
- Total Discount
- Budget Spent
- Budget Remaining
- Budget PercentageUsed
- Discount Type
- Discount Amount
- Sales
- Currency
Promotions
- Market
- Marketplace ID
- Promotion ID
- Promotion Name
- Merchant ID
- Promotion Type
- Status
- Creation Channel
- Glance Views
- Units Sold
- Revenue
- Currency
- Start Date
- End Date
- Created Date
- Last Updated Date
- Vendor Code
- Amount Spent
- Product Amount Spent
- Funding Agreement ID
- Product Name
GPSR Issues
- SKU
- Market
- ASIN
- Product Title
- Has Responsible Person Issue
- Has Manufacturer Info Issue
- Has Warning Safety Issue
- Has Compliance Media Issue
- PS01 Image
- PS02 Image
- PS03 Image
- PS04 Image
- PS05 Image
- PS06 Image