Skip to main content

DataDoe data sources

DataDoe fetches Seller Central and Vendor Central data from the Amazon Selling Partner API (SP-API) (opens in a new tab). We cover most reports and a curated selection of endpoints.

DataDoe fetches Amazon Ads data from the Amazon Ads API (opens in a new tab). We cover all Ads API reports and a curated selection of endpoints and exports.

The full list of tables, columns and refresh cadences is in our interactive Data Scheme.

Included data

Across Seller Central, Vendor Central, and Amazon Ads, DataDoe covers:

  • Sales & traffic: orders, ASIN-level sales, sessions, page views, conversion.
  • Search Query Performance (SQP): weekly and monthly search-term performance for Seller Central ASINs you choose. Vendor Central does not support SQP. See Search Query Performance (SQP).
  • Inventory: Fulfillment by Amazon (FBA) inventory by ASIN and country, restock signals, stranded units.
  • Advertising: Sponsored Products, Sponsored Brands, Sponsored Display, Sponsored Television, Amazon DSP performance, search terms, keyword reports.
  • Finance: settlements, fees, reimbursements, account profit by date and profit by SKU.
  • Catalog: listings, attributes, browse nodes.
  • Vendor: vendor sales, inventory, terms.

Vendor manufacturing vs sourcing

Vendor Retail Analytics exposes two overlapping Amazon views, not two halves of the same sale:

  • Manufacturing (manufacturing_retail_*): ASINs manufactured by the vendor, regardless of who sourced them to Amazon.
  • Sourcing (sourcing_retail_*): ASINs sourced directly from this vendor to Amazon (the vendor as distributor).

Do not add manufacturing and sourcing together. Some metrics, including glance views, exist only on manufacturing.

Shipped COGS is the price Amazon paid the vendor (Amazon's cost / the vendor's Amazon revenue). Shipped revenue is Amazon's customer retail. Contra-COGS is Amazon's estimate of vendor-funded terms (co-op), not actual remittance deductions. Net PPM and net pure product margin are Amazon's margin on the vendor's products, not the vendor's own manufacturing margin.

See the Data Scheme table Sales, Traffic & Inventory by ASIN & Date. DataDoe also publishes catalog totals by day, and weekly and monthly tables for each ASIN and for the catalog. Weekly periods start on Sunday. Monthly periods start on day 1. Inventory on those tables is an end-of-period snapshot. Amazon keeps about eight weeks and 24 months of inventory, which is shorter than the sales history.

Vendor sales by customer country

The Geo Sales by ASIN & Date table splits shipped units and customer revenue by Vendor connection, view, ASIN, day and customer country. It uses Amazon's Geo Sales report. Shipped units are not ordered units. This dataset does not reproduce all-accounts, cross-marketplace Retail Analytics. Choose SOURCING or MANUFACTURING in vendor_view before summing. The country rows split sales already included in the matching connection totals.

Country fields answer different questions:

  • customer_country_code identifies the shipment destination
  • marketplace_country_code identifies the Vendor connection's Amazon marketplace
  • vendor_code is an uploaded product label for that connection

To find shipments from a Germany Vendor connection to customers in Italy, keep the Germany connection and filter customer_country_code to IT. In an Export, add a column filter for customer_country_code. In BigQuery or an AI query, use that column in the query filter. Choosing the Italy marketplace selects Italy connections and does not select Italian destinations on the Germany connection.

The table does not identify the warehouse country or show inventory by Amazon store. Amazon does not allow inventory metrics in Geo Sales requests. An empty customer country stays empty rather than being replaced by the connection country. Compare totals using the same view, dates, metric and currency.

See the per-table breakdown in the Data Scheme.

Some metrics are enhanced by COGS you upload for your Sellers or Vendors.

Why DataDoe curates endpoints

Amazon's SP-API (opens in a new tab) and Ads API (opens in a new tab) expose hundreds of endpoints. Many overlap, are deprecated, or return raw shapes that need heavy post-processing before they are useful. DataDoe picks the endpoints and reports that map to real seller and agency workflows, normalises them into a clean schema, and joins related data, such as orders and settlements, ads and sales, and listings and inventory.

Request more data sources

We continuously add new sources and features. You can request new data sources through our contact form (opens in a new tab).