Skip to main content
DataDoe HubHub
Data Scheme

Every Amazon table. One data layer.

131 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

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
Modification channels

How to modify data on Amazon?

Go beyond read-only access. Use DataDoe Actions to let AI agents and integrations update listings, manage orders, and control ads through MCP or the REST API.

Actions

Let AI agents act on your Amazon account through DataDoe: update listings, cancel orders, confirm shipments, and manage ads. Every Action runs through MCP or the REST API and is monitored and auditable.

Read Actions documentation
Data management

How to control your data?

Some tables are part of the default dataset and are always enabled. Tables outside the default dataset must be enabled in Settings > Data before DataDoe collects them for your organization.

Data settings

Turn tables on or off to control what DataDoe collects and what counts toward your row billing. See row counts per table and disable what you don't use.

Open Data settings
Browse the catalog

Scheme explorer

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

All tables

Amazon Seller Central

  • Account Status Changed Notifications (amazon_notifications_account_status_changed) — Near real-time Amazon SP-API ACCOUNT_STATUS_CHANGED notifications for seller account health and performance status changes.
  • Any Offer Changed Notifications (amazon_notifications_any_offer_changed) — Near real-time Amazon SP-API ANY_OFFER_CHANGED notifications for competitive offer and Buy Box changes.
  • AWD Inbound Shipment Line Items (amazon_awd_inbound_shipment_line_items) — AWD inbound shipment line items by shipment id and line item number.
  • AWD Inbound Shipments (amazon_awd_inbound_shipments) — AWD inbound shipments by shipment id.
  • AWD Outbound Orders (amazon_awd_outbound_orders) — AWD outbound orders: inventory leaving AWD for a destination channel, one row per order id. Not amazon_awd_replenishment_orders (AWD to FBA) and not amazon_awd_inbound_shipments. Shipments are amazon_awd_outbound_shipments. Product arrays are separate stages; do not add them.
  • AWD Outbound Shipment Packages (amazon_awd_outbound_shipment_packages) — AWD outbound distribution packages exploded from the order and from each shipment. One row per package configuration. Filter package_source before summing; the same configuration can appear in more than one source array.
  • AWD Outbound Shipments (amazon_awd_outbound_shipments) — AWD outbound shipments for an amazon_awd_outbound_orders row, with origin and destination addresses. One row per shipment id. Quantities on this row are this shipment only.
  • AWD Replenishment Order Line Items (amazon_awd_replenishment_order_line_items) — AWD replenishment order line items by order id and line item number.
  • AWD Replenishment Orders (amazon_awd_replenishment_orders) — AWD replenishment orders by order id.
  • B2B Any Offer Changed Notifications (amazon_notifications_b2b_any_offer_changed) — Near real-time Amazon SP-API B2B_ANY_OFFER_CHANGED notifications for B2B competitive offer changes.
  • Brand Analytics Search Terms (Daily) (amazon_brand_analytics_search_terms_daily) — Daily marketplace Brand Analytics search terms: top clicked ASINs by customer keyword and department, with search frequency rank, click share, and conversion share. Shares are 0-1 fractions. Marketplace-wide, so clicked ASINs are often competitors. For your own ASIN search query performance use amazon_child_product_organic_search_ranks_per_week or amazon_child_product_organic_search_ranks_per_month. Data can lag; use MAX(date).
  • Brand Analytics Search Terms (Monthly) (amazon_brand_analytics_search_terms_monthly) — Monthly marketplace Brand Analytics search terms: top clicked ASINs by customer keyword and department, with search frequency rank, click share, and conversion share. Shares are 0-1 fractions. Marketplace-wide, so clicked ASINs are often competitors. For your own ASIN search query performance use amazon_child_product_organic_search_ranks_per_week or amazon_child_product_organic_search_ranks_per_month. Data can lag; use MAX(date).
  • Brand Analytics Search Terms (Weekly) (amazon_brand_analytics_search_terms_weekly) — Weekly marketplace Brand Analytics search terms: top clicked ASINs by customer keyword and department, with search frequency rank, click share, and conversion share. Shares are 0-1 fractions. Marketplace-wide, so clicked ASINs are often competitors. For your own ASIN search query performance use amazon_child_product_organic_search_ranks_per_week or amazon_child_product_organic_search_ranks_per_month. Data can lag; use MAX(date).
  • Branded Item Content Change Notifications (amazon_notifications_branded_item_content_change) — Near real-time Amazon SP-API BRANDED_ITEM_CONTENT_CHANGE notifications for A+ content changes on brand-registered ASINs.
  • Cost of Goods Sold (COGS) (amazon_cogs) — Detailed data about cost of goods sold (COGS) per SKU. COGS are managed by the user via form in the Sellers & Vendors page.
  • Coupon Performance (amazon_coupon_performance) — Seller and vendor coupon performance, one row per coupon and ASIN. Includes clips, redemptions, budget, and the ASIN discount. Campaign and coupon totals repeat on every ASIN row. Vendor rows carry campaign, vendor code, and Subscribe and Save; sales is seller coupon revenue. Filter on start_date_time. Join amazon_promotions on promotions_api_mapping_id.
  • Detail Page Traffic Event Notifications (amazon_notifications_detail_page_traffic_event) — Near real-time Amazon SP-API DETAIL_PAGE_TRAFFIC_EVENT notifications for detail page traffic events.
  • FBA Inbound Shipments (amazon_fba_inbound_shipments) — FBA inbound shipment line items from inbound plans with shipment status, destination and source addresses, and plan metadata.
  • FBA Inventory Availability Changes Notifications (amazon_notifications_fba_inventory_availability_changes) — Near real-time Amazon SP-API FBA_INVENTORY_AVAILABILITY_CHANGES notifications for FBA inventory availability changes.
  • FBA Inventory by ASIN & Country (amazon_fba_inventory_by_asin_by_country) — Daily inventory data snapshot for all FBA listings per country.
  • FBA Inventory Health (amazon_fba_inventory_health) — Consolidated daily FBA inventory health snapshot across sales windows (7, 30, 60, and 90 days), inbound shipment statuses (working, received, and shipped), estimated storage and long-term storage fees, aged and excess units, and recommended actions. One row per SKU and date; not additive across dates. inv_age_0_to_90_days already includes inv_age_0_to_30_days, inv_age_31_to_60_days, and inv_age_61_to_90_days. The planning-report-sourced columns are not available in the MX marketplace.
  • FBA Ledger Details (amazon_fba_ledger_details) — Daily FBA ledger details with per-event inventory movements, references, and reconciliation quantities.
  • FBA Ledger Summary (amazon_fba_ledger_summary) — Daily FBA ledger summary by fulfillment center. Quantities are signed: receipts and customer returns increase inventory, customer shipments and disposals decrease it. starting_warehouse_balance plus the movement columns equals ending_warehouse_balance for that location. Do not sum locations without grouping by fnsku.
  • FBA Long-Term Storage Fee Charges (amazon_fba_long_term_storage_fees) — Daily long-term FBA storage fee charges with historical data.
  • FBA Outbound Shipment Status Notifications (amazon_notifications_fba_outbound_shipment_status) — Near real-time Amazon SP-API FBA_OUTBOUND_SHIPMENT_STATUS notifications for FBA outbound shipment status updates.
  • FBA Overage Fee Charges (amazon_fba_overage_fees) — Daily overage fee charges based on FBA storage usage limits.
  • FBA Recommended Removals (amazon_fba_removal_recommended) — Recommended FBA removal quantities by SKU with sellable and unsellable inventory age buckets.
  • FBA Reimbursements (amazon_fba_reimbursements) — Daily FBA reimbursements with historical data.
  • FBA Removal Orders (amazon_fba_removal_orders) — FBA removal order line items with quantities, fees, and status.
  • FBA Removal Shipments (amazon_fba_removal_shipments) — FBA removal shipment details linked to removal orders.
  • FBA Replacement Shipments (amazon_fba_replacement_shipments) — FBA replacement shipments with original and replacement order references.
  • FBA Restock Recommendations (amazon_fba_restock_recommendations) — FBA restock recommendations with inventory levels, sales velocity, and replenishment guidance stored as daily snapshots.
  • FBA Shipments (amazon_fba_shipments) — Amazon-fulfilled shipment line items with order, item, pricing, and shipping address details.
  • FBA Storage Fee Charges (amazon_fba_storage_fees) — Daily FBA storage fee charges with historical data.
  • FBA Stranded Inventory (amazon_fba_stranded_inventory) — FBA stranded inventory that is in Amazon fulfillment centers but not available for sale, with recommended actions, status, and quantities. Updated daily by replacing the full snapshot.
  • Fee Promotion Notifications (amazon_notifications_fee_promotion) — Near real-time Amazon SP-API FEE_PROMOTION notifications for Amazon fee promotion events.
  • Item Inventory Event Change Notifications (amazon_notifications_item_inventory_event_change) — Near real-time Amazon SP-API ITEM_INVENTORY_EVENT_CHANGE notifications for item inventory event changes.
  • Item Offers (amazon_item_offers) — Competitive offers (Buy Box, seller offers, listing/shipping/landed price) by ASIN and item condition.
  • Item Product Type Change Notifications (amazon_notifications_item_product_type_change) — Near real-time Amazon SP-API ITEM_PRODUCT_TYPE_CHANGE notifications for listing product type definition changes.
  • Item Sales Event Change Notifications (amazon_notifications_item_sales_event_change) — Near real-time Amazon SP-API ITEM_SALES_EVENT_CHANGE notifications for item sales event changes.
  • Listings (amazon_listings_with_cogs) — Current listing snapshot per SKU, including price, FBA inventory, and Amazon Warehousing and Distribution (AWD) inventory. FBA available, reserved, inbound, and pending-removal quantities are separate buckets; fba_inventory_supply_at_fba is the FBA total when Amazon sends it, so do not add the buckets to it. AWD quantities are not FBA.
  • Listings (Raw JSON) (amazon_listings_raw) — Raw listings payload per SKU and marketplace. Recommended for advanced use cases. For most use cases, use the "amazon_listings_with_cogs" table instead. For AI agents: each row from this table has a lot of data, consider downloading it to file and not directly to the context.
  • Listings Item Issues Change Notifications (amazon_notifications_listings_item_issues_change) — Near real-time Amazon SP-API LISTINGS_ITEM_ISSUES_CHANGE notifications for listing quality and issue changes.
  • Listings Item MFN Quantity Change Notifications (amazon_notifications_listings_item_mfn_quantity_change) — Near real-time Amazon SP-API LISTINGS_ITEM_MFN_QUANTITY_CHANGE notifications for MFN listing quantity changes.
  • Listings Item Status Change Notifications (amazon_notifications_listings_item_status_change) — Near real-time Amazon SP-API LISTINGS_ITEM_STATUS_CHANGE notifications for listing status changes.
  • Market Basket Co-Purchase (Monthly) (amazon_market_basket_by_child_asin) — Monthly Brand Analytics market basket report of products frequently bought together. One row per child ASIN and co-purchased ASIN. The co-purchased ASIN can belong to another brand. purchased_with_combination_score is a 0-1 share of multi-item orders.
  • Order Change Notifications (amazon_notifications_order_change) — Near real-time Amazon SP-API ORDER_CHANGE notifications for order status and buyer-requested changes.
  • Order Details PII (amazon_orders_details) — Order-level customer and shipping PII details. An extension of `amazon_order_items_with_cogs` table.
  • Order Line Items (amazon_order_items_with_cogs) — Log of all orders per order id and order item. Aggregate this table to get order level data and sales per product or date.
  • Pricing Health Notifications (amazon_notifications_pricing_health) — Near real-time Amazon SP-API PRICING_HEALTH notifications for Featured Offer ineligibility caused by an uncompetitive price.
  • Product Catalog by ASIN (amazon_products_by_child_asin) — Catalog Items snapshot per child ASIN and marketplace: title, brand, bullets, description, browse node, and best seller rank. amazon_product_type is PARENT, CHILD, or SINGLE. For the catalog product type template and raw JSON attributes, classifications, images, and sales ranks, use amazon_products_raw.
  • Product Catalog by ASIN (Raw JSON) (amazon_products_raw) — Raw Catalog Items payload per child ASIN and marketplace: attributes, classifications, dimensions, identifiers, images, sales ranks, summaries, and relationships. amazon_product_type is PARENT, CHILD, or SINGLE; product_type is the Amazon product type template. Prefer amazon_products_by_child_asin for titles, bullets, and best seller rank. Rows are large; download them to a file instead of loading them into context.
  • Profit by Date (amazon_profit_by_date) — Daily profit and cost breakdown from shipped orders, settlement fees, COGS and ads spend. Prefer this table for account-level P&L instead of calculating manually from other tables. Target and search-term columns are separate Amazon Ads attribution summaries; their estimated profits are not included in account profit and must not be added together. Ads include Sponsored Products, Sponsored Brands, Sponsored Display, Sponsored Television and Amazon DSP. sponsored_tv_ad_spend isolates Television spend already included once in ad_spend and profit. Television has no SKU attribution. Amazon DSP spend is DSP totalCost and DSP ad sales, orders and units include promoted ASINs plus brand halo, consistent with Sponsored Brands and Sponsored Display sales. Unallocated and account-level fees and ads spend land here, including all DSP spend, so ad_spend can exceed SUM(amazon_profit_by_sku_and_date.ad_spend). Do not expect this profit to equal SUM(amazon_profit_by_sku_and_date.profit). Columns from average_sales_per_order_item through order_item_session_percentage_b2b are Amazon daily account totals from Sales and Traffic, filled for seller accounts only, and are not sums of per-ASIN rows. total_sessions, total_page_views, avg_buybox_percentage and their B2B and B2C variants also use the daily account totals, and fall back to child ASIN rows when the day has no account total. Columns starting with asin_ are per child ASIN Sales and Traffic values summed for the day.
  • Profit by SKU & Date (amazon_profit_by_sku_and_date) — Daily profit and cost breakdown per SKU and child ASIN from shipped orders, settlement fees, COGS and ad spend. Prefer this table for SKU and child-ASIN profit drill-down instead of calculating manually from other tables. Sponsored Products and Sponsored Display use reported advertised-product spend, sales and orders. Display units include all click-attributed purchases, not just the promoted product. Sponsored Brands contributes estimated spend but no same-SKU conversions. Amazon DSP (estimated spend) contributes promoted-ASIN sales, orders and units. Sponsored Brands spend uses eligible ad-creative ASINs, with same-day ad cost rescaled to campaign cost. Remaining spend uses campaign purchased-product shares. Without purchased-product data, it uses Seller Central sales, orders and sessions, or an even split among known campaign ASINs. Sales and orders allocate campaign totals by purchased-product shares, with the same fallback signals. ASIN spend and sales are split across available SKUs by same-day order-sales shares; orders use order-count shares. A zero total uses an even split for that measure. With no SKU rows, sku is null. Campaigns without any ASIN signal remain account-only. Amazon DSP line item spend is allocated by each ASIN's share of total product sales (including brand halo) on that day. Without positive sales, it uses purchases, then an even split among reported ASINs. Spend and promoted sales use same-day SKU order-sales shares; promoted orders and units use order-count shares. A zero total uses an even split for that measure. With no SKU rows, sku is null. Line items with no ASIN conversion rows remain account-only. Sponsored Television is account-only because its campaign report has no product allocation. Missing or delayed estimates can understate SKU ad spend and overstate SKU profit. Use amazon_profit_by_date for account-level P&L; SUM of SKU profit is not the account profit number.
  • Promotion Items (amazon_promotion_items) — Item-level promotion configuration for ITEMS selections, including per-ASIN/SKU benefits and budgets.
  • Promotion Performance (amazon_promotion_performance) — Seller and vendor promotion performance for Best Deal, Lightning Deal, Price Discount, and related deal types. One row per promotion and ASIN. Glance views, units, funding, and revenue at promotion level repeat on every ASIN row; use the product_ columns for the ASIN. amount_spent is vendor funding. Seller revenue matches Seller Central sales. Configuration lives on amazon_promotions.
  • Promotions (amazon_promotions) — Promotion configuration per promotion, including schedule, benefit, budget, fees, and selection metadata. Complements amazon_promotion_performance, which contains historical performance metrics.
  • Repeat Purchase Performance (amazon_repeat_purchase_report) — Monthly Brand Analytics repeat purchase report per child ASIN for Brand Registry sellers and vendors. One row per child ASIN and month. repeat_customers_score_total and repeat_purchase_revenue_score_total are 0-1 rates. Repeat revenue is ordered revenue and excludes returns.
  • Replenishment Metrics by Date (SnS) (amazon_replenishment_metrics_by_date) — Amazon Subscribe & Save PERFORMANCE metrics by calendar day. Date is the metric aggregation day, not order date or ship date. total_subscriptions_revenue is SnS program revenue for that day; Amazon does not label it as ordered or shipped sales. shipped_subscription_units is the shipped-units metric. revenue_penetration is SnS program revenue as a percentage of total product revenue.
  • Replenishment Metrics by SKU & Date (amazon_replenishment_metrics_by_sku_and_date) — Amazon Subscribe & Save PERFORMANCE metrics by SKU and calendar day. Date is the metric aggregation day, not order date or ship date. total_subscriptions_revenue is SnS program revenue for that SKU and day; Amazon does not label it as ordered or shipped sales. shipped_subscription_units is the shipped-units metric. revenue_penetration is SnS program revenue as a percentage of total product revenue for that offer.
  • Replenishment Offers (amazon_replenishment_offers) — Current Amazon Subscribe & Save offer snapshot by SKU (eligibility, configuration, inventory, subscriptions). Not a sales time series; use the replenishment metrics tables for SnS revenue and shipped units.
  • Returns (FBA & FBM) (amazon_returns) — Physical return events, not payout refunds. FBA rows are items received at a fulfillment center; date is return/receipt date. FBM rows are return requests by return-request date. quantity is returned units. fnsku and fba_customer_comments are FBA only. product_name is the name on the returns report (FBA product-name, FBM item-name). amazon_return_detailed_disposition is FBA only (SELLABLE, CUSTOMER_DAMAGED, DEFECTIVE, etc.). cogs_* is unit cost as of the return date, times quantity. For payout refunds use amazon_settlements_with_cogs where settlement_type is REFUND.
  • Sales & Traffic by ASIN & Date (amazon_sales_and_traffic_with_cogs) — [deprecated, see `issues` for more details] Sales and traffic metrics per child ASIN and date from Amazon sales & traffic business report. Ordered columns are orders placed; shipped columns are units Amazon has shipped. B2B columns are the Amazon Business subset of the matching total. Sessions are 24-hour visits, not page views. Percentages are 0-100. Data may be delayed by up to 14 days. If you do not explicitly need data from this table use the `amazon_order_items_with_cogs` table instead. For traffic use amazon_profit_by_sku_and_date per child ASIN and amazon_profit_by_date per day; both carry the traffic columns of this table.
  • Search Engagement by ASIN (Monthly) (amazon_child_product_search_performance_per_month) — Monthly Search Catalog Performance per child ASIN (GET_BRAND_ANALYTICS_SEARCH_CATALOG_PERFORMANCE_REPORT). Impressions, clicks, cart adds, and purchases from search results, including sponsored results. search_click_rate is clicks divided by impressions. search_conversion_rate is purchases divided by clicks. Both rates are 0-1 fractions (Amazon examples are 0.1 and 0.05). Not Search Query Performance; that is amazon_child_product_organic_search_ranks_per_week and amazon_child_product_organic_search_ranks_per_month.
  • Search Query Performance (SQP) by ASIN (Monthly) (amazon_child_product_organic_search_ranks_per_month) — Monthly Search Query Performance (SQP) per child ASIN and search query (GET_BRAND_ANALYTICS_SEARCH_QUERY_PERFORMANCE_REPORT). child_asin_* columns are this ASIN. search_query_total_* and search_query_volume are the whole query and repeat on every ASIN row. Rates follow Amazon schema examples of 0–1. Only configured SQP ASINs are included. Not amazon_child_product_search_performance_per_month (catalog-level search engagement).
  • Search Query Performance (SQP) by ASIN (Weekly) (amazon_child_product_organic_search_ranks_per_week) — Weekly Search Query Performance (SQP) per child ASIN and search query (GET_BRAND_ANALYTICS_SEARCH_QUERY_PERFORMANCE_REPORT). child_asin_* columns are this ASIN. search_query_total_* and search_query_volume are the whole query and repeat on every ASIN row. Rates follow Amazon schema examples of 0–1. Only configured SQP ASINs are included.
  • Seller Account Health Metrics (amazon_seller_performance) — Seller Central Account Health from GET_V2_SELLER_PERFORMANCE_REPORT. The latest date is the current snapshot; Amazon does not return history for older requested dates. Column windows are 7 days, 14 days, 30 days, 60 days, or 6 months. *_value and *_target_* columns are rates. *_count columns are counts. *_status is the health status. seller_account_health_rating_6m_score is the Account Health Rating score (0–1000), not a percentage. Amazon Account Health rate for the window in the column name. Same scale as the matching target column. A rate, not a count. Do not recompute it from the count columns.
  • Seller Feedback (amazon_seller_feedback) — Negative and neutral (one to three stars) feedback left for the seller by buyers, including star rating, comments, and optional seller response.
  • Sellers & Vendors Context (amazon_sellers_and_vendors_context) — Lookup of DataDoe Amazon accounts for Seller Central, Vendor Central, Amazon Ads, and Amazon DSP. One row per connection, plus one row per Amazon DSP advertiser mapped to a seller or vendor on a shared agency Ads account. A DSP-only agency seat is not its own seller. seller_or_vendor_id equals connection_context_id and is not unique: one context can have a Seller Central row, an Amazon Ads row, and one row per DSP advertiser. Join Seller Central and Vendor Central facts on sp_connection_id or vendor_connection_id. Attribute DSP facts on organization_id, store_id, ads_dsp_connection_id, and dsp_advertiser_id.
  • Settlements & P&L Components (amazon_settlements_with_cogs) — Financial events from Amazon Finances. date is the marketplace-local date of the winning transaction posted time (America/Los_Angeles for US and CA). Once released it matches Transaction Release Date; while still deferred it is the local date of the deferred posting, and it can be one day earlier than the UTC posted timestamp near midnight. transaction_posted_date matches the Amazon Transaction report date/time column and is earlier than date for deferred orders. transaction_release_date matches Transaction Release Date and equals date once released. shipping_promotion_rebate is the order shipping promotion, a rebate to the customer and not an Amazon fee; promotion_fee holds the same values and is kept for backward compatibility. settlement_type REFUND is a money event, not a warehouse return. ORDER rows use order-date COGS; REFUND rows use return-receipt-date COGS (0 when no return). COGS is stored negative. All columns other than "total" express a single type of cost/fee/income. Expenses are negative values (standardize this when comparing with other tables). total_non_principal_amount is total minus item_price in the payout sign. total_fees holds the same value and will be removed on 2026-10-31. marketplace_facilitator_vat / refund_marketplace_facilitator_vat are MarketplaceFacilitatorVAT-* ItemWithheldTax lines (EU/UK); US MarketplaceFacilitatorTax-* stays in item_withheld_tax / refund_item_withheld_tax. fba_inbound_transportation_fee and fba_inbound_transportation_program_fee are ex-VAT base amounts; when Finances lands VAT-inclusive gross on other-transaction inbound rows (UK/EU), the integrated view splits gross/1.20 into the fee column and the remainder into item_tax. Settlement-report FBAFees Base/Tax triples are already ex-VAT on the fee column. There is no dedicated Lightning Deal Fee column because Finances does not distinguish Lightning from Best Deal; those amounts are in deal_participation_fee. Refund Customer Return - Not Received is not available from Finances. Merchant-fulfilled Buy Shipping label fees (LabmanLabelPurchase / LabmanLabelReturn / LabmanLabelChargeBack) attach to the order SKU when that order has a single SKU.
  • Shipment Tracking Milestone Changed Notifications (amazon_notifications_shipment_tracking_milestone_changed) — Near real-time Amazon SP-API SHIPMENT_TRACKING_MILESTONE_CHANGED notifications for Amazon Tracking API shipment milestone updates.
  • Transaction Update Notifications (amazon_notifications_transaction_update) — Near real-time Amazon SP-API TRANSACTION_UPDATE notifications for financial transaction updates.

Amazon Vendor Central

  • Brand Analytics Search Terms (Daily) (amazon_brand_analytics_search_terms_daily) — Daily marketplace Brand Analytics search terms: top clicked ASINs by customer keyword and department, with search frequency rank, click share, and conversion share. Shares are 0-1 fractions. Marketplace-wide, so clicked ASINs are often competitors. For your own ASIN search query performance use amazon_child_product_organic_search_ranks_per_week or amazon_child_product_organic_search_ranks_per_month. Data can lag; use MAX(date).
  • Brand Analytics Search Terms (Monthly) (amazon_brand_analytics_search_terms_monthly) — Monthly marketplace Brand Analytics search terms: top clicked ASINs by customer keyword and department, with search frequency rank, click share, and conversion share. Shares are 0-1 fractions. Marketplace-wide, so clicked ASINs are often competitors. For your own ASIN search query performance use amazon_child_product_organic_search_ranks_per_week or amazon_child_product_organic_search_ranks_per_month. Data can lag; use MAX(date).
  • Brand Analytics Search Terms (Weekly) (amazon_brand_analytics_search_terms_weekly) — Weekly marketplace Brand Analytics search terms: top clicked ASINs by customer keyword and department, with search frequency rank, click share, and conversion share. Shares are 0-1 fractions. Marketplace-wide, so clicked ASINs are often competitors. For your own ASIN search query performance use amazon_child_product_organic_search_ranks_per_week or amazon_child_product_organic_search_ranks_per_month. Data can lag; use MAX(date).
  • Coupon Performance (amazon_coupon_performance) — Seller and vendor coupon performance, one row per coupon and ASIN. Includes clips, redemptions, budget, and the ASIN discount. Campaign and coupon totals repeat on every ASIN row. Vendor rows carry campaign, vendor code, and Subscribe and Save; sales is seller coupon revenue. Filter on start_date_time. Join amazon_promotions on promotions_api_mapping_id.
  • Detail Page Traffic Event Notifications (amazon_notifications_detail_page_traffic_event) — Near real-time Amazon SP-API DETAIL_PAGE_TRAFFIC_EVENT notifications for detail page traffic events.
  • Invoice Items (amazon_invoice_items) — Invoice line items for Vendor Central. One row per line. Goods, services, and other charges, with matched quantity, price and quantity variances, and ASIN, SKU, UPC, EAN, or ISBN identifiers. Join amazon_invoices on invoice_identifier. date is the UTC day of the parent invoice issue date.
  • Invoices (amazon_invoices) — Accounts payable invoice headers for Vendor Central. One row per invoice. invoice_status is IN_PROGRESS, REJECTED, PARTIALLY_PAID, PARTIALLY_DEDUCTED, PAID, or DEDUCTED. invoice_type is AP_INVENTORY or OTHER. Join amazon_invoice_items on invoice_identifier. date is the UTC day of issue_date.
  • Item Inventory Event Change Notifications (amazon_notifications_item_inventory_event_change) — Near real-time Amazon SP-API ITEM_INVENTORY_EVENT_CHANGE notifications for item inventory event changes.
  • Item Sales Event Change Notifications (amazon_notifications_item_sales_event_change) — Near real-time Amazon SP-API ITEM_SALES_EVENT_CHANGE notifications for item sales event changes.
  • Listings Item Issues Change Notifications (amazon_notifications_listings_item_issues_change) — Near real-time Amazon SP-API LISTINGS_ITEM_ISSUES_CHANGE notifications for listing quality and issue changes.
  • Market Basket Co-Purchase (Monthly) (amazon_market_basket_by_child_asin) — Monthly Brand Analytics market basket report of products frequently bought together. One row per child ASIN and co-purchased ASIN. The co-purchased ASIN can belong to another brand. purchased_with_combination_score is a 0-1 share of multi-item orders.
  • Product Catalog by ASIN (amazon_products_by_child_asin) — Catalog Items snapshot per child ASIN and marketplace: title, brand, bullets, description, browse node, and best seller rank. amazon_product_type is PARENT, CHILD, or SINGLE. For the catalog product type template and raw JSON attributes, classifications, images, and sales ranks, use amazon_products_raw.
  • Product Catalog by ASIN (Raw JSON) (amazon_products_raw) — Raw Catalog Items payload per child ASIN and marketplace: attributes, classifications, dimensions, identifiers, images, sales ranks, summaries, and relationships. amazon_product_type is PARENT, CHILD, or SINGLE; product_type is the Amazon product type template. Prefer amazon_products_by_child_asin for titles, bullets, and best seller rank. Rows are large; download them to a file instead of loading them into context.
  • Promotion Performance (amazon_promotion_performance) — Seller and vendor promotion performance for Best Deal, Lightning Deal, Price Discount, and related deal types. One row per promotion and ASIN. Glance views, units, funding, and revenue at promotion level repeat on every ASIN row; use the product_ columns for the ASIN. amount_spent is vendor funding. Seller revenue matches Seller Central sales. Configuration lives on amazon_promotions.
  • Real-Time Inventory by ASIN & Hour (amazon_vendor_real_time_inventory) — Hourly highly available inventory per ASIN (GET_VENDOR_REAL_TIME_INVENTORY_REPORT). Units Amazon can still sell, not on-hand sellable inventory from the daily table.
  • Real-Time Sales by ASIN & Hour (amazon_vendor_real_time_sales) — Hourly units and revenue ordered by Amazon customers per ASIN (GET_VENDOR_REAL_TIME_SALES_REPORT). Not Amazon-to-vendor purchase-order quantity. Not the daily manufacturing_retail_ordered_units series.
  • Real-Time Traffic by ASIN & Hour (amazon_vendor_real_time_traffic) — Hourly detail-page views per ASIN (GET_VENDOR_REAL_TIME_TRAFFIC_REPORT). All customer views of the detail page, not the daily glance_views column (Featured Offer wins only).
  • Repeat Purchase Performance (amazon_repeat_purchase_report) — Monthly Brand Analytics repeat purchase report per child ASIN for Brand Registry sellers and vendors. One row per child ASIN and month. repeat_customers_score_total and repeat_purchase_revenue_score_total are 0-1 rates. Repeat revenue is ordered revenue and excludes returns.
  • Sales, Traffic & Inventory by ASIN & Date (amazon_vendor_sales_traffic_and_inventory_by_child_and_date) — Daily sales, traffic and inventory metrics per child ASIN. Columns prefixed manufacturing_retail_ are Amazon manufacturing-view metrics for all ASINs the vendor manufactures. Columns prefixed sourcing_retail_ are Amazon sourcing-view metrics for ASINs this vendor sourced directly to Amazon (distributor view). DataDoe fetches both views and joins them onto one ASIN-day; the prefixes are overlapping views, not two independent facts and not additive — never sum them or revenue and units double-count. Shipped units/revenue often match because Amazon returns the same shippedOrders in both views; matching is expected, not a copied row. Ordered units/revenue exist only under manufacturing. Contra-COGS is typically populated only under sourcing. Use manufacturing_retail_ for glance views, customer-ordered units/revenue (retail demand, not purchase orders), and net PPM. Use sourcing_retail_ for purchase-order fill metrics (vendor_confirmation_rate, received_fill_rate) and contra-COGS. Amazon-to-vendor purchase-order quantity is amazon_vendor_purchase_orders.ordered_quantity. Either prefix alone is valid for shipped revenue/COGS — pick one view per analysis, not both. Shipped COGS, shipped revenue, contra-COGS, and Net PPM measure Amazon retail economics, not the vendor's own product margin. net_pure_product_margin is a convenience alias of manufacturing_retail_net_ppm (both read manufacturing net_ppm); do not cross-check them as independent series. On-hand, aged, unhealthy, in-transit, and open purchase-order units are end-of-period snapshots and are not additive across days.
  • Sellers & Vendors Context (amazon_sellers_and_vendors_context) — Lookup of DataDoe Amazon accounts for Seller Central, Vendor Central, Amazon Ads, and Amazon DSP. One row per connection, plus one row per Amazon DSP advertiser mapped to a seller or vendor on a shared agency Ads account. A DSP-only agency seat is not its own seller. seller_or_vendor_id equals connection_context_id and is not unique: one context can have a Seller Central row, an Amazon Ads row, and one row per DSP advertiser. Join Seller Central and Vendor Central facts on sp_connection_id or vendor_connection_id. Attribute DSP facts on organization_id, store_id, ads_dsp_connection_id, and dsp_advertiser_id.
  • Shipment Tracking Milestone Changed Notifications (amazon_notifications_shipment_tracking_milestone_changed) — Near real-time Amazon SP-API SHIPMENT_TRACKING_MILESTONE_CHANGED notifications for Amazon Tracking API shipment milestone updates.
  • Vendor Codes (amazon_vendor_codes) — Vendor codes assigned by Amazon, uploaded per ASIN or SKU. Each row has exactly one of child_asin or sku set.
  • Vendor Direct Fulfillment Orders (amazon_vendor_df_orders) — Vendor Direct Fulfillment order line items (vendor ships to the customer). One row per line item with order header fields repeated. purchase_order_number is the DF purchase order; customer_order_number is the shopper order.
  • Vendor Direct Fulfillment Orders PII (amazon_vendor_df_orders_pii) — Vendor Direct Fulfillment customer and shipping PII. One row per purchase order. Join amazon_vendor_df_orders on purchase_order_number. Restricted and off by default.
  • Vendor Listings (amazon_vendor_listings) — Vendor Central listings from the Listings Items API, one row per connection, marketplace, vendor code, and SKU. Cost price is what Amazon pays the vendor. Offers and fulfillment availability are not published for vendors.
  • Vendor Purchase Order Status (amazon_vendor_purchase_orders_status) — Vendor Retail Procurement purchase order item status (getPurchaseOrdersStatus). One row per line item, same grain as amazon_vendor_purchase_orders (purchase_order_number and item_sequence_number). Holds vendor acknowledgement and Amazon fulfillment-center receiving. ordered_quantity is Amazon-to-vendor PO quantity, not customer retail demand (manufacturing_retail_ordered_units). Rows appear after the matching purchase order is synced.
  • Vendor Purchase Orders (amazon_vendor_purchase_orders) — Vendor Retail Procurement purchase order line items. One row per line item with purchase order header fields repeated. ordered_quantity is Amazon-to-vendor PO quantity, not customer retail demand (manufacturing_retail_ordered_units). Acknowledgement and Amazon fulfillment-center received quantity are on amazon_vendor_purchase_orders_status.
  • Vendor Shipments (amazon_vendor_shipments) — WePay/collect Vendor Retail Procurement shipments (submitted or requested for routing; does not include shipments created in Vendor Central). One row per shipment with nested purchase orders, containers, and status details. Amazon does not return shipments created only in Vendor Central (Orders > Shipments / appointments).
  • Weekly Customer Demand (amazon_vendor_forecasting) — Weekly forward customer-demand forecast per child ASIN from Amazon Vendor Forecasting. Amazon exposes only the latest forecast per request; DataDoe stores each fetch as a snapshot keyed by date (forecast generation date). Each snapshot has about twelve forward weeks (start_forecasting_date/end_forecasting_date); the same week can appear on multiple dates — filter to MAX(date) per child_asin and week for the current forecast. Rows are not additive across date snapshots.

Amazon Ads

  • Ad Campaigns (raw) (amazon_ads_campaigns_raw) — Snapshots of Amazon Ads campaign configuration and settings. Rows are identified by campaign and ad product within each Organization, Store, and Ads Connection. State changes update the existing row. Includes archived, enabled, and paused campaigns. Snapshots are refreshed every 72 hours. Live entity state can be obtained using Actions.
  • Ad Creative Assets (amazon_ads_creative_assets) — Amazon Ads Creative Asset Library assets and versions. Rows are identified by creative asset ID and version.
  • Ad Entity History (amazon_ads_entity_history) — Change history events for Amazon Ads entities (campaigns, ad groups, ads, targets), such as state, bid, and budget changes.
  • Ad Group Performance (amazon_ads_by_ad_group_by_date) — Performance for ad groups in SPONSORED_BRANDS and SPONSORED_DISPLAY campaigns.
  • Ad Groups (raw) (amazon_ads_ad_groups_raw) — Snapshots of Amazon Ads ad group configuration and settings. Rows are identified by ad group and ad product. Includes archived, enabled, and paused ad groups. Snapshots are refreshed every 72 hours. Live entity state can be obtained using Actions.
  • Ad Performance by ASIN & Date (amazon_ads_performance_by_child_asin_and_date) — Ads performance by product, ad or campaign, and date for Sponsored Products, Sponsored Display, and Sponsored Brands. Multiple rows can exist for the same ASIN, SKU and date. Products and Display report advertised/promoted-product sales and orders; Display units include all click-attributed purchases. Brands ad_sales and ad_orders are estimated shares of campaign totals, including brand halo; Brands same-SKU columns, clicks and impressions are null. Sponsored Brands spend uses eligible ad-creative ASINs, with same-day ad cost rescaled to campaign cost. Remaining spend uses campaign purchased-product shares. Without purchased-product data, it uses Seller Central sales, orders and sessions, or an even split among known campaign ASINs. Sales and orders allocate campaign totals by purchased-product shares, with the same fallback signals. ASIN spend and sales are split across available SKUs by same-day order-sales shares; orders use order-count shares. A zero total uses an even split for that measure. With no SKU rows, sku is null. Campaigns without any ASIN signal remain account-only. Estimates can lag the campaign report and are revised as inputs arrive. Prefer amazon_ads_performance_by_campaign_by_date for total campaign data. Sponsored Television and Amazon DSP are not included here.
  • Ad Performance by Campaign & Date (amazon_ads_performance_by_campaign_by_date) — Ads performance per campaign and date for Sponsored Products, Sponsored Brands, Sponsored Display, and Sponsored Television. Use this table for total sponsored ads campaign spend and sales. ad_impressions and ad_clicks exclude invalid traffic; gross and invalid columns are the traffic-quality reconciliation. Amazon DSP is not included; use amazon_ads_dsp_performance_by_creative_by_date for Amazon DSP.
  • Ad Placement Performance (Sponsored Brands and Sponsored Products) (amazon_ads_placement_by_campaign_by_date) — Placement performance for SPONSORED_BRANDS and SPONSORED_PRODUCTS campaigns, including Amazon Business placement breakdown for Sponsored Products.
  • Ad Profit by Search Term and Date (amazon_ads_profit_by_search_term_and_date) — One row per reported shopper search term, parent target and click date for Sponsored Products and Brands. The report identifies the query and parent keyword or target but not the ASIN purchased for that query. Sponsored Products profit estimates inherit the parent target product mix and cost per same- or other-SKU sale. Sponsored Brands keeps spend, sales and keyword identity with null profit. Recent estimates are provisional and all estimates exclude refunds. Search-term totals overlap target totals and are not account P&L.
  • Ad Profit by Target and Date (amazon_ads_profit_by_target_and_date) — One row per target present in the collected reports and click date. Includes Sponsored Products keywords and product or automatic targets, Sponsored Brands product targets (excludes Brands keywords), and reported Display and Television targets. This is partial report coverage, not all account advertising. Spend and attributed sales are reported metrics. Sponsored Products COGS and fees are estimates from uploaded COGS, purchased ASINs, advertised-product mix and preceding 90 days of Seller Central ORDER settlements. For purchased ASINs with several SKUs, use shared unit costs or recent order quantities as weights within the seller connection. Accept purchased sales and units within max(2% of the target value, 0.01), and scale costs by target other-SKU sales / purchased sales. Other campaign types keep reported metrics but have null profit estimates. Refund costs are excluded and recent profit is provisional. This is an ad decision view; its profit does not add to amazon_profit_by_date.profit.
  • Ad Purchased Products (amazon_ads_purchased_products) — ASINs purchased after an ad click or view, including brand-halo ASINs that differ from the promoted ASIN. Sponsored Products, Sponsored Display, and Sponsored Brands. Not the advertised-product performance table (amazon_ads_performance_by_child_asin_and_date).
  • Ad Targets (raw) (amazon_ads_targets_raw) — Snapshots of Amazon Ads targeting configuration (keywords, product targets, audiences). Rows are identified by target and ad product. Includes archived, enabled, and paused targets. Snapshots are refreshed every 72 hours. Live entity state can be obtained using Actions.
  • Ads (raw) (amazon_ads_ads_raw) — Snapshots of Amazon Ads ad configuration and creative settings. Rows are identified by ad, ad product, and ad type. Includes archived, enabled, and paused ads. Snapshots are refreshed every 72 hours. Live entity state can be obtained using Actions.
  • Ads Attribution Performance by Ad Group (amazon_ads_attribution_performance_by_ad_group_by_date) — Amazon Attribution Performance by Ad Group: off-Amazon traffic measured by Amazon Attribution tags (14-day last-click), not Sponsored Ads conversion windows. Use this table for ad-group or campaign totals and for Brand Referral Bonus (brb_bonus_amount). Do not sum amazon_ads_attribution_performance_by_creative_by_date to this grain. BRB is present only for enrolled sellers and only at ad-group level. Rows with fewer than 10 lifetime clicks are masked (metrics 0).
  • Ads Attribution Performance by Creative (amazon_ads_attribution_performance_by_creative_by_date) — Amazon Attribution Performance by Creative: off-Amazon traffic measured by Amazon Attribution tags (14-day last-click), not Sponsored Ads conversion windows. One row per date, campaign, ad group, creative, and publisher. Use amazon_ads_attribution_performance_by_ad_group_by_date for totals and Brand Referral Bonus. Never sum creative rows up to ad-group or campaign level — Amazon masks rows with fewer than 10 lifetime clicks (metrics are 0) and creative totals will not match ad-group totals.
  • Ads Attribution Products (amazon_ads_attribution_products_by_date) — Amazon Attribution Products: off-Amazon traffic measured by Amazon Attribution tags (14-day last-click), not Sponsored Ads conversion windows. Top 100 products per campaign, always at ad-group grain. Use amazon_ads_attribution_performance_by_ad_group_by_date for totals and BRB. Rows with fewer than 10 lifetime clicks are masked (metrics 0). History is last 90 days.
  • Ads Brand Metrics (amazon_ads_brand_metrics) — Amazon Ads Brand Metrics: brand-level awareness, consideration, and sales indices plus the shopping funnel (branded searches, detail-page views, add-to-carts, brand customers, high-value customers, return on engagement), by brand, category node, computation date, and lookback. Indices are percentiles versus peers, not 0–1 rates. This is all on-Amazon shopping, not ad-attributed performance. Sparse — most metric columns are NULL for a given row. Columns ending in _category_median are the peer median. Columns ending in _category_top_performers or _category_performers are the average of the 95th–99th percentile of peers. Columns ending in _return_on_engagement, or containing _roe_, are return on engagement (currency), not rates.
  • AMS Budget Usage (amazon_ads_ams_budget_usage) — Amazon Marketing Stream budget consumption events from dataset budget-usage.
  • AMS Campaign Ad Groups (amazon_ads_ams_campaign_ad_groups) — Amazon Marketing Stream ad group configuration events from dataset ads-campaign-management-adgroups.
  • AMS Campaign Ads (amazon_ads_ams_campaign_ads) — Amazon Marketing Stream ad configuration events from dataset ads-campaign-management-ads.
  • AMS Campaign Diagnostics (amazon_ads_ams_campaign_diagnostics) — Amazon Marketing Stream campaign diagnostics recommendations from dataset sponsored-ads-campaign-diagnostics-recommendations.
  • AMS Campaign Targets (amazon_ads_ams_campaign_targets) — Amazon Marketing Stream targeting configuration events from dataset ads-campaign-management-targets.
  • AMS Campaigns (amazon_ads_ams_campaigns) — Amazon Marketing Stream campaign configuration events from dataset ads-campaign-management-campaigns.
  • AMS Conversion (amazon_ads_ams_conversion) — Amazon Marketing Stream near real-time conversion metrics for Sponsored Products, Sponsored Brands, and Sponsored Display. Click-attributed columns are named ad_attributed_*; view-through columns start with ad_view_attributed_. Same-SKU columns exclude brand halo. Windows are 1, 7, 14, and 30 days. The daily campaign table uses 7 days for Sponsored Products and 14 days for Sponsored Brands and Sponsored Display — do not add these hourly rows to that table.
  • AMS SB Clickstream (amazon_ads_ams_sb_clickstream) — Amazon Marketing Stream Sponsored Brands clickstream engagement metrics from dataset sb-clickstream.
  • AMS SB Rich Media (amazon_ads_ams_sb_rich_media) — Amazon Marketing Stream Sponsored Brands rich media / video engagement metrics.
  • AMS SP Budget Recommendations (amazon_ads_ams_sp_budget_recommendations) — Amazon Marketing Stream Sponsored Products budget recommendations. Missed sales, clicks, and impressions are Amazon estimates of what the campaign might have gained if it had not run out of budget, as a lower and upper bound, not a guarantee.
  • AMS Traffic (amazon_ads_ams_traffic) — Amazon Marketing Stream near real-time traffic metrics unified across Sponsored Products, Sponsored Brands, and Sponsored Display.
  • Bid-Boost Audience Performance (amazon_ads_audiences_by_date) — Bid-boost audience segment performance for Sponsored Products and Sponsored Brands. Grain is campaign + audience segment + date. Do not sum these metrics with campaign or ASIN ads views (double-count). DSP Audience (order / lineItem / segment) is a different report and is not included here. Canonical conversion metrics use 14-day attribution for SPONSORED_PRODUCTS and the unwindowed purchases/sales/unitsSoldClicks fields for SPONSORED_BRANDS.
  • DSP Bid Adjustments by Date (amazon_ads_dsp_bid_adjustments_by_date) — Amazon DSP bid adjustment rule activity per advertiser, date, line item, bid adjustment rule, and matched terms. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. Only line items that use bid adjustment rules have rows; the table is empty for advertisers without bid adjustments. ad_win_rate and ad_match_rate are rates: never sum them across rows.
  • DSP Brand Suitability (amazon_ads_dsp_brand_suitability) — Amazon DSP brand suitability: impressions per advertiser, order, line item, and report period, broken down by inventory tier, content category, or supply source. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. Rows are rolling 7-day summaries starting every day: never sum across different periods (summing all dates overcounts about 7 times); pick one period and one dsp_brand_suitability_dimension.
  • DSP Performance by Audience & Date (amazon_ads_dsp_performance_by_audience_by_date) — Amazon DSP performance per advertiser, date, order, line item, and audience segment. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. Amazon does not report sales, units, or brand halo metrics in this report; conversion columns cover promoted ASINs only. A line item can target several segments, so do not sum segment rows to get line item totals; use amazon_ads_dsp_performance_by_creative_by_date for totals.
  • DSP Performance by City & Date (amazon_ads_dsp_performance_by_city_by_date) — Amazon DSP performance per advertiser, date, order, line item, and city. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. city is a bare city name (for example Columbus) and is not unique across regions; the country is the marketplace country. Large table: always filter by date.
  • DSP Performance by Content (amazon_ads_dsp_performance_by_content) — Amazon DSP audio and video delivery (streaming TV, online video, audio) per advertiser, report period, order, line item, creative, supply source, and content (show title, rating, type, genre). Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. Impressions and cost per thousand impressions only: Amazon does not report cost totals or conversions in this report. Rows are rolling 7-day summaries starting every day: never sum across different periods (summing all dates overcounts about 7 times); pick one period.
  • DSP Performance by Creative & Date (amazon_ads_dsp_performance_by_creative_by_date) — Amazon DSP performance per advertiser, date, order, line item, and creative. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. Use this table for total Amazon DSP spend and sales; it is the DSP source of amazon_profit_by_date. ad_sales, ad_orders, and ad_units_sold include brand halo; the _promoted columns cover promoted ASINs only. Order and line item budgets repeat on every creative row, so do not sum them.
  • DSP Performance by Device & Date (amazon_ads_dsp_performance_by_device_by_date) — Amazon DSP performance per advertiser, date, order, line item, and device type. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. ad_sales includes brand halo; all other conversion columns cover promoted ASINs only, because Amazon does not report their brand halo totals in this report.
  • DSP Performance by Supply Source & Date (amazon_ads_dsp_performance_by_supply_source_by_date) — Amazon DSP performance per advertiser, date, and supply source (inventory exchange or publisher). Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. Advertiser level: there is no order or line item breakdown. ad_currency is null because Amazon does not return a currency in this report; monetary values are in the currency of the marketplace.
  • DSP Product Conversions by ASIN & Date (amazon_ads_dsp_performance_by_asin_by_date) — Amazon DSP product conversions per advertiser, date, order, line item, child ASIN, and conversion type. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. dsp_conversion_type PROMOTED rows are conversions of ASINs promoted by the line item; BRAND_HALO rows are conversions of other ASINs of the same brands. Sum PROMOTED and BRAND_HALO for total product sales as in the Amazon DSP console. Amazon reports no cost, impressions, or clicks at ASIN level; spend is in amazon_ads_dsp_performance_by_creative_by_date. Amazon limits the report to the top 500 ASINs of the past 65 days, so totals can be slightly below the creative table.
  • DSP Reach & Frequency (amazon_ads_dsp_reach_and_frequency) — Amazon DSP reach and average frequency per advertiser and report period. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. Each row summarizes one period (period_start_date to period_end_date): a 30-day window on the first fetch, then 1-day windows. Periods can overlap. Reach and frequency are not additive: never sum or average them across rows or periods; pick one period.
  • Keyword Targeting Performance (amazon_ads_targeting_by_campaign_by_date) — Keyword and product-target performance per target and date for Sponsored Products, Sponsored Brands, Sponsored Display, and Sponsored Television. ad_keyword is the target; the customer query that matched it is amazon_ads_search_terms_by_campaign_by_date.ad_search_term. Do not sum this table into campaign totals.
  • Negative Keywords (amazon_ads_negative_keywords) — Negative keywords that block traffic. Weekly snapshots. These rows have no spend or sales.
  • Prompt Ad Extension Performance (amazon_ads_prompt_ad_extensions_by_date) — Performance for Sponsored Products and Sponsored Brands prompt ad extensions per extension, ad, and date. Grain is creativeExtensionId + adId. Do not sum these metrics with campaign, ASIN, or ad-level ads views (double-count). Canonical conversion metrics use 14-day attribution.
  • Search Term Performance (Ads) (amazon_ads_search_terms_by_campaign_by_date) — Customer search queries that matched an advertised keyword or product target, for Sponsored Products and Sponsored Brands. ad_search_term is the shopper query; ad_keyword is the target it matched. Not Brand Analytics search terms and not Search Query Performance.
  • Sellers & Vendors Context (amazon_sellers_and_vendors_context) — Lookup of DataDoe Amazon accounts for Seller Central, Vendor Central, Amazon Ads, and Amazon DSP. One row per connection, plus one row per Amazon DSP advertiser mapped to a seller or vendor on a shared agency Ads account. A DSP-only agency seat is not its own seller. seller_or_vendor_id equals connection_context_id and is not unique: one context can have a Seller Central row, an Amazon Ads row, and one row per DSP advertiser. Join Seller Central and Vendor Central facts on sp_connection_id or vendor_connection_id. Attribute DSP facts on organization_id, store_id, ads_dsp_connection_id, and dsp_advertiser_id.
  • Sponsored Brands Ad Performance (amazon_ads_sponsored_brands_by_ad_by_date) — Sponsored Brands performance per ad and date. Attribution is 14 days. Same-SKU columns exclude brand halo. New-to-brand columns use a 12-month first-purchase lookback. Do not sum this table into campaign totals.
  • Video Ad Extension Performance (amazon_ads_video_ad_extensions_by_date) — Performance for Sponsored Products video ad extensions per extension, ad, and date. Grain is creativeExtensionId + adId. Do not sum these metrics with campaign, ASIN, or ad-level ads views (double-count). Canonical conversion metrics use 14-day attribution.