Data Scheme

Every Amazon table. One data layer.

61 tables across Amazon Seller Central, Vendor Central, and Amazon Ads. Each one documented with refresh cadence, BigQuery name, and column schema. Access via Exports, Explorer, REST API, MCP, or direct BigQuery integration.

Access channels

How to access this data?

Use DataDoe in the way that fits your workflow. From business exports to direct integrations for technical teams or AI native solutions.

MCP (AI agents)

Quickly connect DataDoe to Claude or ChatGPT, or set up an advance AI Agent using professional tools.

Connect to MCP

DataDoe REST API

Build your own apps, dashboards, and automations. Work with your team or AI vibe coding tools, like Claude Code, Lovable or Replit.

Connect to the API

Direct BigQuery Integration

Best for technical teams that want the scheme available directly in their own BigQuery project for powerful BI and data warehouse workflows.

Connect to BigQuery

Or use simpler tools:

Exports

Create CSV, Excel, JSON or XML files for your data on one-time or recurring basis. Push this data directly to tools like Excel or Power BI. No programming required.

Open Exports

Explorer

Explorer allows for advanced preview of your data. Explore and analyze the data interactively inside DataDoe to inspect records, validate metrics, and understand the scheme before moving into exports or integrations.

Open Explorer

Browse the catalog

Scheme explorer

Search tables and columns, then pick a data source tab to browse the full scheme.

Every Amazon table. One data layer.

How to access this data?

Scheme explorer

Profit by DatePremium tables are our most advanced data sources. They provide a comprehensive source of information about your business.Continuous load

Profit by SKU & DatePremium tables are our most advanced data sources. They provide a comprehensive source of information about your business.Continuous load

AWD Inbound Shipment Line ItemsContinuous load

AWD Inbound ShipmentsContinuous load

AWD Replenishment Order Line ItemsContinuous load

AWD Replenishment OrdersContinuous load

Brand Analytics Search Terms (Daily)Initial 14dDaily 1d

Brand Analytics Search Terms (Monthly)Initial 365dMonthly 30d +30d

Brand Analytics Search Terms (Weekly)Initial 56dWeekly 7d +7d

Cost of Goods Sold (COGS)User managed

FBA Inbound ShipmentsContinuous load

FBA Inventory by ASIN & CountryDaily 1d

FBA Inventory HealthInitial 1dDaily 1d

FBA Ledger DetailsInitial 56dDaily 7d

FBA Ledger SummaryInitial 56dDaily 7d

FBA Long-Term Storage Fee ChargesInitial 730dDaily 30d

FBA Overage Fee ChargesInitial 1dDaily 1d

FBA ReimbursementsInitial 730dDaily 30d

FBA Storage Fee ChargesInitial AllDaily 1d

ListingsContinuous load

Listings (Raw JSON)Continuous load

Market Basket Co-Purchase (Monthly)Initial 365dWeekly 90d

Order Line ItemsInitial 730dDaily 28d

Organic Search Ranks by ASIN (Monthly)Initial 90d +30dMonthly 30d +30d

Organic Search Ranks by ASIN (Weekly)Initial 28dWeekly 7d +7d

Product Catalog by ASINContinuous load

Product Catalog by ASIN (Raw JSON)Continuous load

Repeat Purchase PerformanceInitial 365dWeekly 90d

Replenishment Metrics by DateContinuous load

Replenishment Metrics by SKU & DateContinuous load

Replenishment OffersContinuous load

Returns (FBA & FBM)Initial 60dDaily 60d

Sales & Traffic by ASIN & DateInitial 60dDaily 4dMonthly 30d +4d

Search Engagement by ASIN (Monthly)Initial 365dWeekly 90d

Seller Account Health MetricsDaily 1d

Sellers & Vendors Context

Settlements & P&L ComponentsContinuous load

Order Details PIIPremium tables are our most advanced data sources. They provide a comprehensive source of information about your business.Continuous loadPII