# Amazon Reports

Under Reports you may download various reports. With some reports you will have the option to limit or - expand -, respectively, the result.

Importing the reports into Excel & Co.

These reports contain CSV files separated by a comma. In order 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. into Excel. Please go to the Advance Settings and choose the comma as the decimal separator and the dot for thousands separator. Please check this thread for additional help.

AMALYTIX Screenshot

Reports can also be scheduled and delivered via email ...

AMALYTIX Screenshot

or per FTP:

AMALYTIX Screenshot

Reports can also scheduled and just stored within AMALYTIX. Choose "AMALYTIX" has the distribution channel in this case.

You can see the list of all scheduled reports below:

AMALYTIX Screenshot

The following will show which report contains which fields:

# Product List (long)

The report Product List (long) contains the following fields at the time the report was created:

  • Favorite
  • ASIN (child)
  • Marketplace
  • Tags
  • ASIN (parent)
  • Buybox list price
  • Buybox offer price
  • Buybox seller Id
  • Buybox seller name
  • Buybox fulfillment type
  • FBA inventory
  • Brand name
  • URL image
  • Product title
  • Buybox yes/no
  • Seller count
  • Lowest price
  • FBA lowest price
  • FBM lowest price
  • Reviews: Parent count
  • Reviews: Rating parent
  • Reviews: Child count
  • Reviews: Child count
  • Reviews: 1 star count
  • Reviews: 2 stars count
  • Reviews: 3 stars count
  • Reviews: 4 stars count
  • Reviews: 5 stars count
  • Listing quality index
  • Bestseller rank main category
  • Bestseller rank category name
  • Images count
  • HD images count
  • Product description
  • Bullet point 1
  • Bullet point 2
  • Bullet point 3
  • Bullet point 4
  • Bullet point 5
  • Ordered units last 30 days count
  • Orders last 30 days count
  • Order profit last 30 days
  • Rebates last 30 days count
  • Rebate profits last 30 days
  • Average returns last 60 days count
  • Actual offer price (FBM)
  • Actual offer price (FBA)
  • Sessions last 30 days
  • Average conversion rate last 30 days
  • SKUs count
  • Currency

# Product List (short)

The report Product List (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.

  • Favorite
  • ASIN (child)
  • Marketplace
  • Tags
  • ASIN (parent)
  • Buybox list price
  • Buybox offer price
  • Buybox seller Id
  • Buybox seller name
  • Buybox fulfillment type
  • FBA inventory
  • Brand name
  • Product title
  • Buybox yes/no
  • Seller count
  • Lowest price
  • FBA lowest price
  • FBM lowest price
  • Reviews: Parent count
  • Reviews: Rating parent
  • Reviews: Child count
  • Reviews: Child count
  • Listing quality index
  • Bestseller rank main category
  • Bestseller rank category name
  • Ordered units last 30 days count
  • Orders last 30 days count
  • Profit orders last 30 days count
  • Rebates last 30 days count
  • Profit rebates last 30days count
  • Average returns last 60 days count
  • Actual offer price (FBM)
  • Actual offer price (FBA)
  • Sessions last 30 days
  • Average conversion rate last 30 days
  • SKUs count
  • Currency

# FBA Inventory Report

This report contains the fields of page FBA Inventory:

  • Favorite
  • ASIN (child)
  • Marketplace
  • Tags
  • ASIN (parent)
  • Brand
  • Product title
  • FBA inventory
  • Minimum inventory
  • Minimum range
  • Inventory range (min)
  • Inventory range (max)
  • Inventory range 30 days
  • Sales last 7 days
  • Sales last 30 days
  • Sales last 60 days
  • Sales last 90 days
  • Long-term storage fee (EUR)
  • Long-term storage units
  • Currency

# Watchlist (long)

This report contains the fields:

  • Currency
  • Favorite
  • 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
  • Image Count
  • Image Hi-Res Count
  • Description
  • Bullet Point 1
  • Bullet Point 2
  • Bullet Point 3
  • Bullet Point 4
  • Bullet Point 5

# Watchlist (short)

This report contains the fields:

  • Currency
  • Favorite
  • 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

# Period Comparison

The report Period Comparison makes it possible to compare significant product constants for a given time period and the previous period of the same length. The report can compare the following parameters:

  • Marketplace
  • Date from
  • Date until

The following fields are then returned.

  • Favorite
  • ASIN (child)
  • Marketplace
  • Tags
  • ASIN (parent)
  • Brand
  • Product title
  • Actual period: Profit
  • Actual period: Orders count
  • Actual period: Order units count
  • Actual period: Sessions
  • Actual period: Average conversion rate
  • Actual period: Average best seller ranking
  • Actual period: Average Buybox price
  • Previous period: Profit
  • Previous period: Orders count
  • Previous period: Order units count
  • Previous period: Sessions
  • Previous period: Average conversion rate
  • Previous period: Average best seller ranking
  • Previous period: Average Buybox price
  • Currency

# Orders

The report Orders can process the following parameters:

  • Marketplace
  • Date from
  • Date until

The following fields are then returned. If an order contains two posts, two lines are delivered in the result and the order number is the same.

  • Marketplace
  • Order number
  • Date / Time
  • Status
  • Prime yes/no
  • Fulfillment type
  • Customer name
  • Address street
  • Address zip code
  • Address city
  • Address country
  • Customer e-mail address
  • Order sum before rebates
  • Rebate value
  • Order sum after rebates
  • Order posts ID
  • Order posts product title
  • Order posts product count
  • Order posts product ASIN
  • Order posts product SKU
  • Order posts product price
  • Order posts rebate
  • Currency

# Keywords

The report Keywords can process the following parameters:

  • Marketplace
  • Date from
  • Date until

The following fields are then returned.

  • Date
  • Marketplace
  • ASIN
  • Keyword
  • Position
  • Tags
  • Product title
  • Product Brand
  • Product Tags
  • Search Volume
  • Product List

# Alerts

The report Alerts can process the following parameters:

  • Marketplace
  • Date from
  • Date until

The following fields are then returned.

  • ASIN
  • Product Brand
  • Product Title
  • Marketplace
  • Alert type
  • Date created
  • Alert meta
  • Notified
  • Hidden

# Seller Prices

The report Seller Prices 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

# Refunds

The report Refunds can process the following parameters:

  • Date from
  • Date until

The following fields are then returned.

  • Refund posted date
  • Refund created at
  • Refund Order-Id
  • Refund order ship date
  • ASIN (child)
  • SKU
  • Product Title
  • Refund amount
  • Refund currency
  • Refund type
  • Refund fulfillment
  • Refund received date
  • Amazon Case Id
  • Reimbursement date
  • Reimbursement amount
  • Reimbursement currency
  • Reimbursement case ID
  • Reimbursement reason
  • Return date
  • Return disposition
  • Return reason
  • Return customer comments

# Reviews

The report Reviews can process the following parameters:

  • Marketplace
  • Date from
  • Date until

The following fields are then returned.

  • 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
  • Review deleted
  • Review Number Of Comments

# Customer questions

The report Questions can process the following parameters:

  • Marketplace
  • Date from
  • Date until

The following fields are then returned.

  • 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

# Vendor Products

The report Vendor Products can process the following parameters:

  • Marketplace

The following fields are then returned.

  • Image URL
  • Image Count
  • Image Hi-Res Count
  • Product Title
  • Description
  • Bullet Points
  • Url
  • ASIN
  • ASIN (parent)
  • EAN
  • UPC
  • SKU
  • Buybox Price
  • Product Group
  • Category
  • Subcategory
  • Marketplace
  • Replenishment Code
  • Brand Code
  • Brand name
  • Binding
  • Color
  • Revenues 30d
  • Sales 30d
  • Buybox
  • Number of Reviews
  • Average Rating
  • Number of Sellers
  • LQI total value
  • Bestseller Rank
  • Add-on product
  • Pantry product
  • Has Bestseller Badge
  • Prime Only
  • Has Amazon Choice Badge
  • Description type
  • Free Replacements 30d
  • Units Returned 30d
  • Sales Change 14d
  • Units Shipped Last Year
  • Shipped COGS Last Year
  • Cost Received
  • Sell-Through Rate
  • Tags
  • Amazon Price
  • Lowest Prime Price
  • Lowest FBM Price
  • Buybox Seller Name
  • Vendor Price
  • Margin Amazon
  • Vendor Cost
  • Margin Vendor
  • Currency
  • Is Hidden
  • Last Updated at

# Vendor Price

The report Vendor Price can process the following parameters:

  • Marketplace

The following fields are then returned.

  • ASIN
  • Marketplace
  • Currency
  • Image URL
  • Brand name
  • Brand Code
  • ASIN (parent)
  • SKU
  • EAN
  • Tags
  • Is Hidden
  • Product Title
  • Product Group
  • Category
  • Subcategory
  • Replenishment Code
  • Buybox
  • Buybox Seller Name
  • Buybox Price
  • Amazon Price
  • Amazon Has Offer
  • Amazon Margin
  • Recommended Price
  • Amazon Buying Price
  • Buybox Vs RRP
  • Amazon vs RRP
  • Lowest FBA Price
  • Lowest FBA Vs RRP
  • Lowest FBM Price
  • Lowest FBM Vs RRP
  • Last Updated at

# Vendor Inventory (by days)

The report Vendor Inventory (by days) can process the following parameters:

  • Marketplace
  • Date from
  • Date until

The following fields are then returned.

  • ASIN
  • Marketplace
  • Currency
  • Brand name
  • Brand Code
  • SKU
  • Units at Amazon
  • Sellable Cost
  • Unsellable Units
  • Unsellable Cost
  • Units Received
  • Open PO Units
  • Units Returned
  • Replenishment Code
  • EAN
  • UPC
  • ASIN (parent)
  • Cost Received
  • Sell-Through Rate
  • Aged 90d Sellable Inventory
  • Aged 90d Sellable Units
  • Reporting Date

# Vendor Inventory (current)

The report Vendor Inventory (current) can process the following parameters:

  • Marketplace

The following fields are then returned.

  • ASIN
  • Marketplace
  • Currency
  • Image URL
  • Brand name
  • Brand Code
  • SKU
  • Units at Amazon
  • Unsellable Units
  • Open PO Units
  • Replenishment Code
  • EAN
  • ASIN (parent)
  • Sell-Through Rate
  • Aged 90d Sellable Inventory
  • Aged 90d Sellable Units
  • Tags
  • Is Hidden
  • Product Title
  • Product Group
  • Category
  • Subcategory
  • Sales 7d
  • Sales per day
  • Duration
  • Return Rate
  • Last Updated at

# Vendor Sales

The report Vendor Sales can process the following parameters:

  • Marketplace
  • Date from
  • Date until

The following fields are then returned.

  • ASIN
  • Marketplace
  • Currency
  • ASIN (parent)
  • Product title
  • Brand name
  • Brand Code
  • SKU
  • EAN
  • UPC
  • Units Shipped
  • Units Shipped Last Year
  • Free Replacements
  • Shipped COGS
  • Shipped COGS Last Year
  • Units Returned
  • Repl. OOS
  • Lost Buybox Price
  • Average Sales Price
  • Reporting Date

# Financial Events

The report Financial Events can process the following parameters:

  • Marketplace
  • Date from
  • Date until

The following fields are then returned.

  • 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